The following is a list of rules that can be used to calculate an item's weighted average cost:
An item's weighted average cost is reset every time the item reaches zero on hand.For the most part an item's weighted average cost is determined by its receiving history. Receiving and Invoicing directly affect calculated cost.Positive manual adjustments affect it. Transfers from another store affect it. When quantity is transferred from one store to another, its calculated cost is transferred with it.Sales and Physical Inventories do not affect weighted average cost directly.If the item has no history the Default Vendor Price is used.
If an item has an incorrect calculated cost one of the following will allow you to fix it:
Run ydiMaintenance.exe on the Yellow Dog Inventory application server to re-check cached costs. Because cost-calculation is slow, YDI pre-calculates costs for reporting purposes. Sometimes various adjustments made retro-actively (a physical inventory commit, for instance) can cause calculated costs to change, but the cache still has old values. You may need to run ydiMaintenance.exe multiple times. Each time ydiMaintenance runs it randomly checks a subset of recent costs to ensure that they are still correct.
Find and fix the Receipt(s) the item is in. Unless locked by employee rights or Invoicing a receipt can be edited after it is received. The Vendor Price on a receipt directly influences the item's weighted average cost.
Perform 2 manual adjustments. From the Inventory Items list find the item and click Adjust On Hand Quantity. Set the quantity to zero. After submitting, click Adjust On Hand Quantity again. This time set the Quantity to its original quantity, but also set its Item Cost to the correct cost. This will effectively reset the weighted average cost for that item going forward.
If the item has no history simply change its Vendor Price.
Reporting Explained: Inventory History Calculated Cost by Day Business Need: This report is helpful for users who want a report to show the calculated costs for items over a period. How it Works: An Inventory>History>Calculated Cost>By Day report ...
This video will demonstrate how to create Full Physical Physical Inventory Physical Inventory Yellow Dog Inventory gives you the ability to periodically check actual on-hand counts against the counts as reported by Yellow Dog Inventory, and then ...
When you open the Item Editor in Yellow Dog Inventory, you see the Calculated Cost field in the F&B and/or Retail Details tab: This is THE MOST RECENT calculated cost computed for this item, in ANY store. When you open the "Stores" tab from the ...
Creating a new item for Retail: Once logged into Yellow Dog navigate to Create New Item Select the Level and Vendor for the item you are creating, and the SKU will be automatically generated.(If the level or vendor do not exist already choose the ...
Yellow Dog Inventory version 377 introduces important changes to how the system calculates and reports the Default Vendor Cost. Where: Yellow Dog uses Default Vendor Cost in the following scenarios: The item’s calculated cost when your cost method is ...
This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...
This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...