Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How Moving Average method behave for Purchase Return?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • NishantM Profile Picture
    NishantM 22 on at
    How Moving Average method behave for Purchase Return?
    Hi Grace
     
    I have same issue in my current customer scenario. I am curious to know how did you overcome this problem?
     
    Regards,
    Shaan
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How Moving Average method behave for Purchase Return?

    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

  • Heiko Weber Profile Picture
    Heiko Weber on at
    RE: How Moving Average method behave for Purchase Return?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How Moving Average method behave for Purchase Return?

    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

  • Heiko Weber Profile Picture
    Heiko Weber on at
    RE: How Moving Average method behave for Purchase Return?

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How Moving Average method behave for Purchase Return?

    Hello Heiko,

    Does marking work for a moving average inventory valuation?

    Ludwig

  • Heiko Weber Profile Picture
    Heiko Weber on at
    RE: How Moving Average method behave for Purchase Return?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How Moving Average method behave for Purchase Return?

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How Moving Average method behave for Purchase Return?

    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

  • Suggested answer
    Matloob Profile Picture
    Matloob 781 on at
    RE: How Moving Average method behave for Purchase Return?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans