Hi All,
I have an issue for Product Receipt and Purchase Invoice for Purchase Return. The Purchase price in PO is $5,987.8 but when the Product Receipt created, AX pick up the moving average cost per unit (in this case $4,347.24) at the time of recording instead of PO price. The issue is the total AP Temporary (AP Temp) not zero due the diff of PO price and moving average cost. The diff is $1,640.56. My user want to get the Total of AP temp become zero. Is there any setup or work around we could do to fit this requirement?
Following is the scenario:
1) Product Receipt entries:
Dr. AP Temp $5,987.8 -->posting type: Purchase,Accrual
Dr. AP Temp $4,347.24 --> posting type: Purchase expenditure, un-invoiced
Cr. AP Temp $5,987.8 --> posting type: Purchase expenditure, un-invoiced
Cr. Inventory $4,347.24 --> posting type: Product receipt
2) Purchase Invoice entries:
Dr. Accounts Payable 6,406.95 -->posting type: Vendor balance
Dr. AP Temp 5,987.8 -->posting type: Purchase expenditure, un-invoiced
Dr. Inventory 4,347.24 -->posting type: Product receipt
Dr. AP Temp 4,347.24 -->posting type: Purchase expenditure for product
Cr. GST -419.15 -->posting type: Sales Tax
Cr. Inventory -4,347.24 -->posting type: Purchase, inventory receipt
Cr. AP Temp -4,347.24 -->posting type: Purchase expenditure, un-invoiced
Cr. AP Temp -5,987.8 -->posting type: Purchase, accrual
Cr. AP Temp -5,987.8 -->posting type: Purchase expenditure for product
Thanks.
3290000000 | SGD | -5987.8 | -5987.8 | Purchase expenditure, un-invoiced | ||
1670000001 | SGD | -4347.24 | -4347.24 | Product receipt | ||
3290000000 | SGD | 4347.24 | 4347.24 | Purchase expenditure, un-invoiced | ||
3290000000 | SGD | 5987.8 | 5987.8 | Purchase, accrual |
*This post is locked for comments
Hi Heiko,
Thanks for sharing. From what I know, AX 2009 doesn't have Moving average method. I have been using the Marking function for some time. It confirms that Moving average not allow to marking any transactions in AX 2012. For my case, I've got the solution already. It's because of the GL accounts that I was configured for the Product Receipt. Since the Product Receipt using the floating value and AX 2012 has 2 new posting type Purchase Expenditure un-invoiced and Purchase expenditure for Product. So in this case, I have to setup the correct GL accounts instead using 1 GL account for the 2 posting type I mentioned.
Regards,
Grace
Wow, thanks Grace, that´s a major change between AX2009 and 2012. We are still on 2009 and reading your post i am kind of happy about. Sorry if i created confusion, but honestly i didn`t expect that to be changed and i right now i even can`t see the improvement by that change.
In 2009 it works exactly like it is described here: download.microsoft.com/.../microsoftdynamicsax2009costmanagementwhitepaper.pdf
Short abstract:
Marking
In Microsoft Dynamics AX 2009, marking behaves as a cost marker, ensuring that the cost of a
specific receipt is brought forward to a specific issue. Marking will set aside any cost flow assumption
(weighted average, FIFO, LIFO) that is set up on the cost object. This behavior is obtained by the
Inventory close job that closes and adjusts marked records in the InventTrans table as its first task.
The second task is to query and to find all unmarked transactions in the InventTrans table and to
settle those according to the cost flow assumption.
Hi Heiko,
I tried that marking and create negative qty in the same PO but it was not working. For information, moving average not allow to do the marking. You may refer to this link technet.microsoft.com/.../hh597235.aspx
Regards,
Grace
Yes is does. At least i did not encounter problems with it.
By marking 2 or more inventory transactions you basically exclude them from beeing treated like it is specified in the the inventory model group
Hello Heiko,
Does marking work for a moving average inventory valuation?
Ludwig
Creating a new PO (Line) means that AX does not recognize the relation between the original receipt and the Return.
If really necessary to create a new line you should mark the 2 inventory transactions. The marking will exclude the 2 lines from the regular moving average calculation and treat them 1:1.
In your case if i understood correctly (material was received but not yet invoiced for that PO?) i think the easiest way would have been to use the same PO line again with a negative receipt quantity. Doing so AX should recognize that it has to be the same value as the same lot id will be used.
Hi Mohammad Matloob,
I am sucessfully run the inventory closing but no adjustment created for this returned order. This method not working for me. I think I should change the GL account for Purchase Expenditure Un-Invoiced as this is the way AX calculates the moving average price which is correct.
Regards,
Grace
Hi Mohammad Matloob,
As mentioned, I'm using Moving Average. From what I read in Microsoft white paper, this method not require to run the Inventory closing.
Thanks.
Regards,
Grace
Hi Grace,
Not sure if inventory closing can be processed for one single item as inventory closing means to close all inventory module transactions occurred during the period.
Inventory closing is a recommended step to be performed monthly whether weighted average method is used or FIFO LIFO is used, it used to adjust all items where system has left some difference in control accounts as well as recalculation of item cost.
Regards
Mohammad Matloob
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156