For some of the SO that we invoiced, voucher doesn't show the COG. Is this because that we haven't closed the inventory as yet. We didn't set the cost price for these BoM i.e. cost price is zero - from the manage cost section of the released product.
I know that when the inventory is closed, the actual cost price of the item is applied - so COG is adjusted based on this. However, when we run the Inventory recalculation, would it not update the cost price and hence the COG?
Appreciate your help.
*This post is locked for comments
Hi inadir,
What problem are you having? Might be best to start a new question with your scenario.
Hi Ewills,
your problem is fixed ?
Thanks
Hi, first ensure that the following setups are done:
Item model group:
1. Post Physical inventory to Ledger - Check mark
2. Post Financial Inventory to ledger - Check mark
Inventory model group action pane:
1. Incude Physical value - Check mark - Which will consider the Physical values (Received not invoiced / Report as finished not ended) for arriving the Avg cost price.
Whenever an outbound entry is getting posted , such as; Sales packing slip/Sales Invoice, Purchase return/Purchase debit note, Transfer shipment and Movement journal with Negative Qty posting, system will pick the cost price from On-hand Inventory cost price field. If that is zero then it will pick the cost price from the "Price" field on the manage inventory tab. If both are zero then the cost price of the outbound entry will be zero.
Finally, all the cost prices will be adjusted according to the Inventory model (FIFO or LIFO,etc.,) based on the actual entry used for the consumption, by running the inventory recalculation/inventory closing process.
Hope this helps,
Shantanoo, Barry-Wehmiller International Resources
Hi, first check if in the item model groups the "post financial inventory" is flagged.
If yes the reasons I could think of are 2: these items are only received or production orders are not ended and on the item model group flag "include physical value" is deselected;
or you actually received / reported as finished these items with zero cost, you can check it also on the released product form, tab manage inventory, on-hand inventory and then "on hand" tab, field name cost price, or check the item transactions to see if they have zero cost.
Last thing when you run a recalculation or an inventory closing the cost price based on the selected costing model on the item model group gets recalculated and the cogs gets updated too.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156