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)

Ivan Tsang 35 on at

Like (0)

Report

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

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

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

We run inventory closing in every month.

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

Like (0)

Report

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

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

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

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