| | Item Cost Hierarchy is not followed in Sales Order Update if item quantity is zero or negative |
| Resolution |
Sage Engineering has reviewed and determined this to be working as designed.
When calculating the cost for an average cost item, the program will start by looking at the average cost of the item in the warehouse being relieved. If there are zero or negative items on hand in this warehouse, it can not calculate the actual cost being removed, so it goes to the hierarchy to assign an estimate. Item.last, item.standard, and then item.average. Stated another way, it does not use the AverageCost bucket in the IM_ItemWarehouse table. It calculates a cost from the QuantityOnHand and TotalWarehouseValue buckets.
DocLink: What is the Item Cost Hierarchy? Where does the Unit Cost on a Purchase Order in Sage 100 come from?
[BCB:155:Chat 100 US:ECB] |
| Defect ID | | 110827 Closed as Working as Designed |
| Steps to duplicate | | In ABC with module date of 05/31/2020
1. In Inventory Management, Main, Item Maintenance and look at item 4886-18-14-3 for warehouse 001 and drill down to quantity recap for current average cost (05/2020) and also note Last Cost and Average cost of the item.
2. In Sales Order, Main, Sales Order Entry, create a sales order for a quantity of 1 of the same item.
Note the cost of the item is the current average cost.
3. In Sales Invoice Data Entry process an Invoice for the Sales Order created in above step. Note the cost is still the warehouse average cost.
4. Print the sales journal, then gross profit report to note COGS amount, then update.
Note: The cost of goods amount calculated is the last cost which does not follow the Item Cost Hierarchy on KB 20910 |
|