Settled transactions are adjusted from later recalculation

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks!

Was this reply helpful? Yes No