Question

Updating Historical Costs of Inventory Attached to Sales

  • 5 June 2023
  • 1 reply
  • 66 views

We have a process where we produce WIP stock items from various raw material stock items via production orders. We then produce packaged finished goods from the WIP items plus a few more components via production orders. 

 

If an error were to occur, such as an improperly costed raw material found its way into the WIP item, that flows through to our sales orders on finished goods and COGS is incorrect. I have experience other ERPs where this is an issue and this is how it has been handled:

 

  1. Reverse sales orders to reverse GL entries to Sales/COS etc
  2. Reverse production orders to reverse impact to various produced items, whether WIP or FG
  3. Make corrections to materials
  4. Repeat steps 2 and 1 to arrive at the correct amounts.

Obviously this is important for order/item margin analysis, but am I missing any unique ways of handling this in Acumatica? I could envision an inventory adjustment but that won’t reflect on the order/item level, simply on the GL/financial statement level. 


1 reply

Userlevel 7
Badge +3

With in the standard product there are no short cuts to correcting a costing entry which you want to affect the Sales and Production order.

We do have an enhancement on the near term roadmap to make the reversal of Production Batch easier by providing a “Reverse” button on the Production Transaction screens. 

I realize this doesn’t help you now - but wanted to provide some good news to offset the bad.

Perhaps someone here on the community has a nice Customization Package which streamlines the steps you listed.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved