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 ...
Business Need: This report is helpful for understanding an items current calculated cost. How it works: This report displays a single item’s current on hand valuation based on on-hand adjustments from receipts/invoices and physical inventories. When ...
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 serve as an introduction to Recipes? How to Create a Recipe A recipe is a group of items that are combined to be sold as a single item in the Point of Sale. While there is only one kind of Recipe you can create, the same recipe can ...
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 ...
You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...