Hi. I am looking for a (or the) table where I can find the postings generated by inventory closing.
E.g. a sales orderline is invoiced. The vendor invoice is received afterwards and the product is now to another price. When we run the inventory closing the costdifference is allocated to the salesorder.
I am building a spreadsheet to compare the cost on the salesorder and the general ledger.
In Dyn365 there is a report called Customer / Item (Sorry, but the danish name is Kunde / Vare statistik). This report includes the sum of the original and the adjustment cost.
I am looking for either a standard report that I can export or download to Excel, A standard Odata table or a table that I can find and download via the Table Browser Caller for D365FO.
I there are other ways to find the informations, please advice me.
When you run inventory close, there is an adjustment report that you can generate right from the inventory closing form.
This report contains the following information and can be exported to excel:
You can also look at the inventory transactions (Inventory management > Inquiries and reports > Transactions) and pull in the adjustment amount to see the original total (financial cost) and the adjustment amount. The cost amount will be the total between original and adjustment.
All the adjustment that are created during inventory recalculation and close are housed on the Table: InventSettlement. You may need to use LotId (InventTransId) to combine the original transaction with the adjustment amounts, but this will give you the data you are looking for.
Please let me know if you have any follow up questions. Please accept the answer if this gives you the answer you need.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
33
Share
Report
All responses (
Answers (
