Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Cost adjusments table for Dyn365FO

(0) ShareShare
ReportReport
Posted on by 8
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.
 
Hope someone can assist.
 
Med venlig hilsen
Peter
  • Verified answer
    Brittany Burke Profile Picture
    Brittany Burke 13 on at
    Cost adjusments table for Dyn365FO
    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. 

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans