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 Alias Items in Invoices EDI Receipts/Invoices and Return to Vendors EDI, or Electronic Data Interchange, is the transfer of data from one computer system to another. In Yellow Dog Inventory, EDI allows you to ...
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 ...
This article addresses frequently asked questions related to the Watchdog Report in Yellow Dog Inventory. General Questions Q: What is the Watchdog Report? A: The Watchdog Report scans your Yellow Dog database for errors and inconsistencies that ...
The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Where: The Watchdog report is located under Home > Watchdog or can be found under your saved reports 201 – ALR – CHECK Watchdog When: Use this ...
The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Why It Matters: Reviewing and resolving issues identified in the Watchdog report regularly—especially before physical inventory— allow you to ...
This article explains what to do if your forgot to start your event. It is intended for Concession clients who manage events through the Stand Sheets module. Issue Event was not started on time. Solution Adjust your event’s Start Date/Time to the ...
Main Page Overview <br> Right-Hand Buttons Bottom Buttons Learn more by checking out the Invoice Staging Guide Previous : Invoice Staging Workflows