Finance | Project Operations, Human Resources, ...

While posting the Movement Journal in negative quantity the cost amount is different.

(1) Share

Report

Posted on by Ankit Gupta

Hello,

While posting the Movement Journal in negative quantity the cost amount and the Physical & Financial cost amount are showing different. The Movement Journal was posted at 25 but why the physical and Financial Costs were appearing as 18,661? If I see the Physical Voucher also the amount was reflecting as 18,661. How this is happening? Also while recalculating the inventory the amount is getting adjusted (-18,661-25=-18,687) but the amount posted through movement journal is 25. As given below the physical voucher was also posted at 18,661 value. Please help me out on this issue.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

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

Like (0)

Report

Hi Community user,

In case of an inventory deduction, the system will not take the cost price from the journal line but will apply the cost as per inventory costing model. E.g. when you are using FIFO, it will initially use an average cost price known at that moment. When running the recalculation, it will apply the cost as per the chosen systematic and when needed it will post adjustments.

Was this reply helpful? Yes No
Ankit Gupta 18 on at

Like (0)

Report

Hello André,

Thank you for your response over this.

Can you please elaborate a bit little on this? Or show any example.

Actually, the fact is that while posting the Movement Journal in negative qty at -25.73 (Cost Amount) the physical voucher and financial voucher were getting affected as 18,661.06. And after recalculation of inventory the adjustment amount is standing at 18,835.33.

In particular item the item model was weighted average also I have checked all the setups but unable to find the effect that how this 18,661.06 was affecting while in item the cost is mentioned as 25.73. Critical issue.

Was this reply helpful? Yes No
Ankit Gupta 18 on at

Like (0)

Report

Hello,

I have found the issue that how the 18,861.06 is reflecting while posting the Movement journal. Till 31/08/23 we have ran the Inventory Value report and found that the Qty. and Amount was standing at 1 and 18,861.06 respectively as shown in the report below. How this can be revaluated? How this cost can be corrected? I have done recalculation but still it is getting transferred in the next month period i.e.,01/09/23. How to solve this?

Was this reply helpful? Yes No

Join the conversation

Community site session details

While posting the Movement Journal in negative quantity the cost amount is different.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

While posting the Movement Journal in negative quantity the cost amount is different.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates