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

Notifications

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) / will the inventory clo...
Microsoft Dynamics AX (Archived)

will the inventory close affecr the transaction which have been cost amount settled in previous period

(0) ShareShare
ReportReport
Posted on by Li Duke 12

currently we are doing the monthly inventory close based on FIFO. but we found something strange, that when we doing this month inventory close, it will update the transaction which occur very long time ago. from my understanding, each time inventory close should fix the cost amount settled  based on FIFO. it should already find the related in-transaction. then why the latest inventory close will update the old inventory close result?

can anyone provide clear logic about this?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    If the previous transaction was not closed fully by previous inventory close, it will still be considered for settlements. There is field on invent trans that will provide if it's fully settled or not. I think it's value open.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Li Duke,

    As Satish mentioned, if the 'old' transaction was not fully closed then it might be grabbed up in a later closing process.

    I would recommend having a look at the following post: fedotenko.info/.../

    It is already a bit older but still valid and gives you a deep insight into what is going on when closing inventory.

    Best regards,

    Ludwig

  • Li Duke Profile Picture
    Li Duke 12 on at

    Thx for your feedback, (and also thx for Satish Panwar).

    I check the value open for the related InventTrans table, and the it was No.

    And I also check the old data (before this Inventory close) it was also No.

    So I think that No means the value is closed, then why it was updated again?

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    I am not sure what field you mean.

    On closing settlement records are inserted in the table InventClosing and InventSettlement and for those adjusted amounts accounting entries are created.

    Open the Settlements form from the Closing and adjustment form.

    The settlements reference to the inventory transactions by the financial Lot-ID.

    When the inventory closing or recalculation is done ( see InventTransOrigin) the settlements/adjustments are stored in InventSettlement table and the InventSettlement.TransRecId == InventTrans.RecId.

    In Inventtrans: CostAmountSettled is the value of the transaction  settled by inventory close.

    When CostAmountPosted + CostAmountAdjustment = CostAmountSettled,  the transaction is fully settled for inventory value point of view, and Inventory close will not consider it again.

    Also see:

    docs.microsoft.com/.../trace-inventory-settlement-transactions

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Li Duke,

    After the inventory close is run and the transaction has been closed, I would expect that the value open field shows a 'No'.

    Do you have an older copy of your live system where the inventory value was not run and where you could compare the field values before and after running the inventory close?

    Best regards,

    Ludwig

  • Li Duke Profile Picture
    Li Duke 12 on at

    @Ludwig Reinhard

    Yes, you are right, I have a old data backup, so I can compare with the data before Inventory close and after.

    @magic1949

    CostAmountSettled CostAmountAdjustment CostAmountPosted

    -86.25                       0.05                               -86.30                      After Inventory Close

    -86.26                       0.04                               -86.30                      Before Inventory Close

    And be noticed that for the InventTrans table, the DateClosed is 2015-08-31, but the modifiedDateTime is 2019-07-29

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Li Duke,

    Thank you for sharing this information.

    In general, I don't see a problem with the cost amount adjustments of 0.04 and 0.05 respectively.

    Yet, what do those dates exactly mean and where did you see them?

    The 'DateClosed' is this the date when you see that the transaction was fully settled/closed or is this the date you run the inventory close?

    What is the modified date? Did you run another inventory close on this date or...?

    Can you also have a look at the cost explorer and the cost trace form that you can access from your inventory transactions?

    Those forms might give you more insights what has been settled on the different dates.

    Best regards,

    Ludwig

  • Li Duke Profile Picture
    Li Duke 12 on at

    The dataclosed and modifieddatetime was coming from the table InventTrans

    And actually I perform the Inventory close on 2019-07-29, that may be the reason cause the modifiedDateTime changed.

    (but why, I think that this transaction should be closed, and inventory close should not touch it)

    And for the Cost explorer form, it showes a tree like data, compare with the before inventory close and after, the only difference is the top one, and the different is the value of last two parts, before was 86.26/-86.26 and after was 86.25/-86.25.

    I could not find cost trace entry from transaction form.

  • Li Duke Profile Picture
    Li Duke 12 on at

    The DateClosed and modifiedDateTime are from the InventTrans table.

    As I perform the Inventory close on 2019-07-29, it cause the modifiedDateTime changed.

    (but why, it should be already closed and Inventory Close should not touch it)

    The cost explorer shows a tree like data, and almost everything is same when compare the before and after inventory close, the only difference is the first line last two value, before is 86.26/-86.26 and after is 86.25/-86.25

    And for trace is too many data, I just compare the first two level, no different. I will continue to look through.

  • Li Duke Profile Picture
    Li Duke 12 on at

    Actually, I have no idea how to check the trace data, the issue should have same quantity with Receipt just under it.

    So this should be one pair?

    But what's the meaning of the issue under this receipt? there were more than one issue, what's the meaning of this?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans