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.
Calculated cost in Yellow Dog Inventory is critically important because it serves as the foundation for financial accuracy and operational decision-making in inventory management. You’ll find the calculated cost of an item in many areas of Yellow ...
The calculated cost method FIFO (First In, First Out) is one of the available calculated cost methods in Yellow Dog Inventory. It’s important to choose the best calculated cost method for your business to ensure accurate, consistent, and ...
The calculated cost method Perpetual Weighted Average Cost is one of the available calculated cost methods in Yellow Dog Inventory. It’s important to choose the best calculated cost method for your business to ensure accurate, consistent, and ...
The calculated cost method Weighted Average Cost is one of the available calculated cost methods in Yellow Dog Inventory. It’s important to choose the best calculated cost method for your business to ensure accurate, consistent, and audit-compliant ...
Q: Why do inventory systems use calculated cost in reporting? A: Inventory systems like Yellow Dog use calculated cost in reporting (determined by your selected calculated cost method) to simplify inventory valuation and reduce the impact of ...
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...
What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...
The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...