web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Closing - Sa...
Microsoft Dynamics AX (Archived)

Inventory Closing - Sales order Consumption accounts difference

(0) ShareShare
ReportReport
Posted on by Tareq Sabri 70

Dear All,

 I did inventory closing for 30/09/2009.I checked the my total sales cost by running the gross margin by customer report.

when I checked the GL the two numbers was not different.

I checked the adjustment created by the closing I noticed that there are some transactions in July and August adjusted, and this was the difference.

My understanding was if the month is closed so then no adjustment can be done for the old transactions.

Please advice for the same

 

Thank you  very much,

Tareq Sabri

tsabri@inc.com.kw

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,173 Super User 2026 Season 1 on at

    Hi Tareq,

    I don't understand your question completely. What do you mean by "the two numbers was not different"?

    When the inventory is closed, you cannot make postings on inventory with a posting date before the closing date. But only inventory transactions that can completely settled are closed. So if you have e.g. produced 10 pieces of an item and sold ony 4 of them; the transactions are not closed. In October you can make a new correction to the production order resulting in a different cost-price of an item. The produced 10 will get a new costprice by an adjustment. With the inventory recalculation the 4 sold items will get another cost as well. Even if the transactions were created in a closed period.

  • Tareq Sabri Profile Picture
    Tareq Sabri 70 on at

    Thank you very much; an answer for your question actully I meant "was Different", but by mistake I added "not" :)

     I understod what you said; I will give the following scenario just to make sure I understand the cycle.

    I have ended my production orders for September.......... I did inventory closing for September............ when I check the settelment transaction I can see some sales orders related to July and August has been adjusted.

    is this becuase of the new average cost calculated in September, so the system is affecting all the sales orders related to that specific item? if this is correct? so my cost of good sold account will alwayes be changed, right?

    then how can I get the exact cost of good sold each month, please advice.

     

     

    Thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,173 Super User 2026 Season 1 on at

    Hi Tareq,

    It is not completely clear what transaction history is in your database. The recalculation process is depending on various transactions and parameter settings. But I can confirm that you can find some settlement transactions on previous months.

    There is a whitepaper available for Cost Managment in AX2009 on customersource. If you don't have access I can mail the document to you. It will explain in detail the recalculation process with consequeces on specific parameter settings. It also describes the possibility of marking transaction which overrides the costing method for bringing costs from a specific receipt to a specific issue.

    https://mbs.microsoft.com/customersource/documentation/whitepapers/ax2009_costmanagement.htm?printpage=false

    If you have questions after reading this document, do not hesitate to reply again. I have about eight years experience with the inventory closing and adjustment in AX versions and faced some weird situations.

    regards,

    André

  • Community Member Profile Picture
    Community Member on at

    Dear Andre' Arnaud de Calavon,

    I would like to ask you a question about Inventory Recalculation.

    I have an issue related to COGS account. After run Recalculation, I checked and compare COGS account with Sales order - issue, there are difference amount.

    I opened Inventory transaction -> filter by Sales Order -> export to excel and sum total ->  compare "cost amount + Adjustment" difference with COGS account.

    I did checked following steps:

    - Check Inventory posting profile: Only Sales Order - issue has been set to COGS account

    - Check ledger transaction: No manual transaction in COGS account

    - Check Inventory journal: No movement journal have offset account is COGS

    - When i checked Inventory transaction -> filter by Sales Order -> export to excel and sum total ->  compare "cost amount" without "adjustment" : this amount is equal total amount COGS without Recalculation voucher.

    -> The difference amount is in "Recalculation voucher", but I don't know why this amount is not equal in COGS account and Sales order - isssue

    Total amount in recalculation voucher of COGS is more than total "Adjustment" amount of Sales Order

    Do you have any experience on this, please share with me.

    Thank you

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans