Dynamics 365 BC Expected Cost Posting

Expected Cost Posting – to post the receipt/shipment value of inventory to the GL
In Inventory Posting Setup- you would assign an Inventory Account Interim for the received/shipped inventory that is not invoiced.  The account can be the same GL Account at the inventory account, but if you make it different, then it is easier to validate back to in reporting.


The other area to setup is COGS Account (Interim) for the Shipped value and Invt. Accrual Acc. (Interim) in the General Posting Setup



Once the accounts are setup – you will select Expected Cost Posting in the Inventory setup



This will ask you to run the Adjust Cost - Item Entries (make sure the Post to G/L is selected.  This will update all the values to account for Expected.



Then you can run the Inventory to G/L Reconcile report.  The first columns in yellow will report this way – even with Expected Cost Posting turned off.  Then the next 4 columns are with Expected Cost turned on.  The total of these columns should balance back to the Chart of accounts for the interim accounts (but only if separate accounts)


The posting on receipt is as follows -
Debit Inventory Interim
Credit Inventory Accrual Interim
This is reversed out when the actual invoice posting takes place.
The posting for shipping is –
Credit inventory Interim
Debit COGS Interim
This is reversed out then the actual invoice posting takes place.
The important part about doing Expected Cost Posting is that once it is turned on then it needs to stay selected – otherwise postings will get stuck.