Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Settled transactions a...
Microsoft Dynamics AX (Archived)

Settled transactions are adjusted from later recalculation

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi everybody,

I'm facing a problem on AX 2012 R2 version.

The scenario is the following. Item managed with physical value and weighed average by date (no financial closing active on transfer).

Some issue transactions (production line) have financial closure date 2016-03-31 (value not opened), but I can find that each later recalculation still adjusts the values. 

Is it a legitimate behavior? As far as I understood no adjustment should take place on settled transactions.

Consider too that: no manual adjustment was performed on any transaction neither any On-hand adjustment (costs), no marking has been set on these transactions.

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Settled transactions are adjusted from later recalculation

    Thanks!

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: AX2012 R2: settled transactions are adjusted from later recalculation

    Hi Federico,

    Inventory close (or recalculation) can adjust the value of issue transactions (even after they have been settled) if the value of the receipt transaction to which they are settled is changed.

    This can happen, for example, if a Charge is posted against a purchase order invoice, or if you sold an item which was created on a production order, where the financial value of the raw materials used in the production were was not known when the production order was ended.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 R2: settled transactions are adjusted from later recalculation

    Hi Andre,

    Thanks for answering:

    Yes that’s it. For financial closure date I refer to the field (InventTrans).DateClosed, which should be the date on which the system was able to fully settle the transaction along the closure.

    The source (principle) of the following adjustments is Weighted avg. date, the corresponding voucher is related to the Recalculations.

    Just more in detail the case:

    I have some issue transactions, which have been fully settled on 2016-03-31. Indeed on the corresponding InventSettlement table I can see a settlement for that date and the whole quantity with principle Weighted avg. date. In the following months ( my customer is running the closure and recalculation once a month), the Recalculations have created some settlements with model type Weighted avg. Date and corresponding value adjustments.

    It seems that even after the total settlement of a transaction, the system is going on adjusting the transaction value. Is it possible?

    Thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: AX2012 R2: settled transactions are adjusted from later recalculation

    Hi Federico,

    Can you describe the situation in more details? What exactly do you mean with the financial closure date? Where did you get this value? Is this the field on the inventory transactions form, tab Update, field group Settlement?

    If you look at the new adjusted values, what is the source transaction?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans