Can I change an Items Calculated Cost?

Can I change an Items Calculated Cost?




How do I set or change an item's average cost?

 

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.

    • Related Articles

    • Reporting Explained: Inventory History Calculated Cost By Day

      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 ...
    • Reporting Explained: Troubleshooting- Item On-Hand Calculated Cost

      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 ...
    • How do I Alias Items?

      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 ...
    • What are Recipes?

      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 ...
    • How do I create a Full Physical Inventory with a PA520?

      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 ...