Finance | Project Operations, Human Resources, ...

Inventory accounting in reporting currency

(1) Share

Report

Posted on by Ahmet DALICI

Hello;

A new feature was published in 09 of september in 2020 about "Inventory accounting in reporting currency".

What are the details of the feature.

I want to calc Inventory cost for reporting currency. and I want to adjust the cost of an invent Trans for reporting currency..

Can I use this feature for Inventory recalculation / adjustment and closing?

Thanks

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Ahmet,

As far as i know, This feature was added in Nov 2020 not in Sep. With this feature Selected set of inventory related scenarios are supported so I am not sure if that will support inventory recalculation in reporting currency. You need to enable this feature on your Test environment and check that.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Ahmet,

You have to reach out to MS if you want to enable this feature.

There is not much information provided apart from what is stated in the feature management notes:

This feature changes the accounting practice for inventory related events in regards to reporting currency in General ledger. In this feature, a selected set of scenarios are supported.

Historically inventory events has been accounted in the sequence

Transaction currency -> Accounting currency -> Reporting currency

By applying this feature the sequence change so inventory events are being accounted.

Transaction currency -> Accounting currency

Transaction currency -> Reporting currency

This is achieved by introducing a triangulation from Accounting currency to Transactions currency which is used to compute Reporting currency amount on inventory events.

In addition the offset postings of accruals occurring as part of invoice will now use the original exchange rate applied and the spot rate.

The best thing is to contact MS if you urgently need this feature.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ahmet DALICI 40 on at

Like (0)

Report

Hi Junaid;

our developer team completed necessary actions to activate. and I can see to enable this feature.

I tested inventTrans records for reporting cost. But I couldn't see any change in InventTrans table.

Was this reply helpful? Yes No
Ahmet DALICI 40 on at

Like (0)

Report

Hi Junaid;

our developer team completed necessary actions to activate. and I can see to enable this feature.

I tested inventTrans records for reporting cost. But I couldn't see any change in InventTrans table.

Was this reply helpful? Yes No
Suggested answer

tabarret on at

Like (1)

Report

Hello Ahmet,

The information below was provided by the Microsoft Product group:

Please be aware that this feature is not to support inventory valuations in dual currency. This feature ensures that the interim accounts in reporting currency in the product receipt can be cleared when the invoice is posted. Please refer to the illustration below. It impacts the purchase order and production order. But system still does not maintain the historical inventory value in the reporting currencies, it still relies on the inventory value in accounting currency to do the conversion when you sell the item.

Was this reply helpful? Yes No
IgnacioMadrid 30 on at

Like (0)

Report
is there any news on this topic?

Was this reply helpful? Yes No