Hi Experts,
I have a client requirement that I would appreciate some input on.
The client would like to report Raw Material Consumption separately in their Chart of Accounts.
Currently, both production consumption and production output post through the same Inventory WIP G/L account configured in the Inventory Posting Setup.
Their desired outcome is:
-
Debit postings (raw material consumption into production) should post to G/L 514001 – Raw Materials Consumed.
-
Credit postings (production output/value leaving WIP) should post to G/L 516001 – WIP Clearing.
The design would also need to correctly handle all reversal scenarios (e.g. consumption reversals, output reversals, production order corrections, etc.), ensuring that reversing entries post back to the appropriate G/L accounts.
My questions are:
-
Has anyone successfully implemented a design like this in standard Business Central?
-
Is it logically feasible to split the Inventory WIP posting based solely on the posting direction (Debit vs Credit)?
-
Are there any hidden implications for costing, inventory valuation, Adjust Cost - Item Entries, or manufacturing reconciliation?
-
I presume it will also directly affect add-ons like Aptean Food & Beverage, particularly with the Shop Floor Production extension? If so, are there any extension-specific considerations?
Any guidance or recommendations would be greatly appreciated.

Report
All responses (
Answers (