Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Adjustment in Financial Transaction AX 2012 R3

Posted on by 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

  • Verified answer
    pearl_jo Profile Picture
    pearl_jo 640 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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

  • pearl_jo Profile Picture
    pearl_jo 640 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    Dear Ludwig,

    Thank you for your reply.

    The posting type is price difference for moving average.

    Best regards,

    Johanna

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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

  • pearl_jo Profile Picture
    pearl_jo 640 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    Hi Zain,

    Thank you for your response.

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

    PO status is open order.

    Thanks,

    Johanna

  • Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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

  • pearl_jo Profile Picture
    pearl_jo 640 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    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

  • pearl_jo Profile Picture
    pearl_jo 640 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    Dear Mahmoud Hakim,

    Thank you for your response.

    I do not run inventory recalculation.

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at
    RE: Adjustment in Financial Transaction AX 2012 R3

    Have you run inventory recalculation?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans