Microsoft Dynamics AX (Archived)

Adjustment in Financial Transaction AX 2012 R3

(0) Share

Report

Posted on by pearl_jo

640

Dear all,

I am using AX 2012 R3 Cumulative Update 12.

I create Purchase Order with 1 item, Quantity = 10, unit price = 10000.

I add charge with value 1000.

After Post Purchase Invoice, I click Invoice > Lines > Inventory > Lot Transactions > Inventory > Transactions in Financial Voucher, why there is amount in adjustment with value -1000?

In other database, I try the same scenario and no adjustment value?

Why there is adjustment when I use charge in Purchase Order in my database?

Why there is no adjustment when I use charge in Purchase Order in my other database?

Please help. Thank you.

Best regards,

Johanna

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Have you run inventory recalculation?

Was this reply helpful? Yes No
pearl_jo 640 on at

Like (0)

Report

Dear Mahmoud Hakim,

Thank you for your response.

I do not run inventory recalculation.

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

Like (0)

Report

Hello Johanna,

Can you share details how you added the charge of 1000 and how the charge code that was used for adding the charge is setup?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
pearl_jo 640 on at

Like (0)

Report

Dear Ludwig,

Thank you for your response.

I add charge from Purchase Order Lines > Financials > Maintain Charges.

Charge Code is fixed category with Debit is Item and Credit is Ledger Account.

Was this reply helpful? Yes No
Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi Johanna,

Can you tell me which item model group you are using in the item attached to the PO?

What is the PO status in which you are adding the charges?

Regards,

Zain Mehmood

Was this reply helpful? Yes No
pearl_jo 640 on at

Like (0)

Report

Hi Zain,

Thank you for your response.

I am using MOV Item model group (Moving Average).

PO status is open order.

Thanks,

Johanna

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Johanna,

The -1000 adjustment amount... what posting type does it have attached?

I assume that this is related to your moving average price and that the -1000 amount captures the difference between your previous moving average price and the $11000 that you entered.

Would be great if you could double check that and possibly share a screenprint of the voucher with the posting types.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Zain Mehmood 4,187 Most Valuable Professional on at

Like (1)

Report

Hi Johanna,

This is what i thought, the inventory adjustment is due the item model group Moving average. You would have had issued some quantity of the item you are financially updating/invoicing through purchase order. When there's a difference between the cost of the inventory issued & the final cost of the inventory, system will post an inventory adjustment at the time of financial posting.

For more information about Moving average, please download this white paper www.microsoft.com/.../details.aspx

Thanks & Regards,

Zain Mehmood

Was this reply helpful? Yes No
pearl_jo 640 on at

Like (0)

Report

Dear Ludwig,

Thank you for your reply.

The posting type is price difference for moving average.

Best regards,

Johanna

Was this reply helpful? Yes No
Verified answer

pearl_jo 640 on at

Like (0)

Report

Dear Zain,

I have found that when my Item does not have Avail Physical, there is adjustment in financial transaction.

Thank you for your thought.

Best regards,

Johanna

Was this reply helpful? Yes No