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 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 ...
Yellow Dog Inventory Troubleshooting: Email Invoice Processing – Error response received when processing unsupported file type Issue: User received the following unsuccessful processing response when sending an invoice for invoice staging: “The ...
What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...
What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...
Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...