Dynamics Community Forum Thread Details

Inventory interim

Hi Team,

Please let me know from where i can check the ageing of "Inventory Interim Account".

Hi Aakash,

Thank you for your post in the Communities.

Do you want some report within the Inventory Subledger in regards to the Interim Account? Or are you referring more along the lines of the GL Inventory Interim? With the question, I'm not exactly from what point you are referring to.

I am in North America, so our Inventory Valuation Report is a bit different as it includes both expected cost and actual cost, but I seem to remember the World Wide Report has an option...although I don't know if you can print only the expected cost of the inventory valuation report.

Other than that, speaking from the Inventory subledger, I don't know if there is another report for this...which is perhaps the North America local database has an 'Inventory to GL Reconciliation' Report, where you can print by an 'As of Date', which shows columns such as... 'Received Not Invoiced' and 'Shipped Not Invoiced'. (See picture below) I am not sure if the localization you use has some other local report that shows that.

Otherwise, you'd need to review the GL Account's Inventory Interim account. You could use the COA and do a Limit Totals To filter for a specific as of date range to see net change ..31/12/19 (DD/MM/YY). Or you can use the Trial Balance to filter that GL Interim Inventory Account with an as of date. These are some options, I hope they work for you. Thank you again.
Bryan

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS