Why AX ajust the cost of previous month's transation when i closed the current month inventory?

(1) Share

Report

Posted on by Ivan Tsang

In my case, we use the "Weighted average date" cost pinciple. The cost of current month's transactions are adjusted to the monthly weighted average cost(My understanding of the AX inventory closing). But i found ax also will adjust the cost of previous month's transation, is the standard behavior of AX? Please help, AX God...

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Ivan Tsang 35 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
ZvikaR 184 on at

Like (0)

Report
Copy link

Link copied!

did you close already previous month? the process will adjust everything to the previous closing

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ivan Tsang,

Is this the first close that you run?

Have you run the inventory close for November 2017?

For some additional info on what AX is doing when closing inventory, please have a look at the following site: http://fedotenko.info/

Best regards,

Ludwig

Was this reply helpful? Yes No
Ivan Tsang 35 on at

Like (0)

Report
Copy link

Link copied!

We run inventory closing in every month.

Was this reply helpful? Yes No
Ivan Tsang 35 on at

Like (0)

Report
Copy link

Link copied!

yes, we did inventory close for November 2017 before. Actually, we run inventory close process every month.

Was this reply helpful? Yes No
Ivan Tsang 35 on at

Like (1)

Report
Copy link

Link copied!

I found that ax will adjust the previous month's transactions if there is Bom transactions in previous month.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ivan Tsang,

Was this the underlying issue for the adjustment posting that you showed above and/or is there anything else open / not answered?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Ivan Tsang 35 on at

Like (1)

Report
Copy link

Link copied!

I finally found that ax will adjust the previous month transaction in following case:

1.Item A is physically receipt at 01 Nov.

2.User did an BOM journal in Nov, and item A is the bom line item, Item B is the finished Good. The physical cost of item A will transfert will transfer to item B.

3.User did inventory close at 30 Nov.

4.Item A is financally receip at 01 Dec.

5. When user did inventory clost at 31 Dec, system adjust the Bom journal receip cost of item B in Nov and adjust the all the Nov issue cost of item B. The adjustment voucher of inventory close is posted at 31 Dec.

Was this reply helpful? Yes No