Item Charge for item with moving average costing method

(0) Share

Report

Posted on by Community Member

Hi all,

I have a problem to assign purchase item charge to inventory value for item with moving average costing method. Currently I am using Microsoft Dynamics AX2012 R3 CU12.

For item with FIFO costing method, it is working well. I can assign purchase item charge to inventory value for the item. For item with Moving Average costing method, the purchase item charge goes to Stock Variance.

Is there anyone understands the problem?

Best Regards,

Tanto Widjaya

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

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

Like (0)

Report

Hi Tanto,

At which exact step do you assign the charges? Is it on the same order line available during posting the invoice, or do you allocate them afterwards? Please describe your process.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

I attach the item charge on PO Header then allocate it to PO Line. Afterwards, I do PO Receiving then PO Invoicing.

I check the posted invoice journal, the item charge value is not added to inventory cost but posted to Stock Variance account.

The item charge setup:

Debit = Item

Credit = Customer/Vendor

Best Regards,

Tanto Widjaya

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Do you have the 'Generate charges on product receipt' tick box ticked? (The one described here blogs.msdn.microsoft.com/.../post-misc-charges-at-time-of-product-receipt)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Terry,

Yes, I have ticked 'Generate charges on product receipt' tick box.

Step to duplicate:

1. Create new item, type: Product.

2. Item Models: MWA (Moving Average)

3. Create item charge

Code: ADMFEE

Debit Type: Item

Credit Type: Customer/Vendor

'Compare purchase order and invoice values' tick box: ticked

4. Create New Purchase Order and PO Line for the new item (Qty 1, Unit Price: 100)

5. Attach Item Charge to Purchase Order Header (Category: Fixed, charge value: 15)

6. Allocate item charge to purchase order line

7. Receive the PO

8. Create and Post PO Invoice

The result is inventory value amount 100 not 115. It should be 115.

Best Regards,

Tanto Widjaya

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tanto Widjaya,

The behavior that you see is what I would expect AX to do.

Please see the following site and note from MS:

[View:https://blogs.msdn.microsoft.com/axsupport/2012/10/13/answers-to-common-questions-about-moving-average-costing-in-microsoft-dynamics-ax-2012/:750:50]

4. How does the system handle purchase price variance where there are other misc. charges included in the receipt cost. Ex:Product Supplier charges 20.00 / unit Misc charge for trucking is 2.50 /unit

If the Misc. charges are posted as part of the invoice these will be seen as Material cost and proportional distributed like the value between Product receipt price and Invoice price.

In case the Misc. charge is posted after the Invoice it will be expensed to the price difference account

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi all,

I would like to thank you for all the responses and information provided. This really helped me.

Best Regards,

Tanto Widjaya

Was this reply helpful? Yes No