web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Voucher Transaction sh...
Microsoft Dynamics AX (Archived)

Voucher Transaction showing different amounts

(0) ShareShare
ReportReport
Posted on by neethukbabu 6

Dear All,

In Purchase Order Voucher transaction, amount is showing different if posting types are, "purchase, inventory receipts" and "purchase expenditure for product"  for one purchase order as attached. This is making problem in trail balance also. Can anybody help me to find out the issue?

TB-error.png

Regards,

Neethu K B

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Voucher Transaction showing different amounts

    Hi Neethu K B,

    Can you elaborate on this issue?

    It would be great if you could personalize the posting type and the account name into your form so that we can identify that info for all of your voucher lines.

    Many thanks,

    Ludwig

  • neethukbabu Profile Picture
    neethukbabu 6 on at
    RE: Voucher Transaction showing different amounts

    Dear Ludwig,

    The problem starts in Trail Balance, both debit and credit are not matching. So we checked the details and found mismatch in this Purchase Orders. Attaching as you required.

    1258.TB.png

    Regards,

    Neethu K B

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Voucher Transaction showing different amounts

    Hi Neethu K B,

    Thank you for sharing this information.

    From your screenprint above I cannot see that something is not matching.

    The total of your debit and credit transactions add up to zero.

    If I understand things correctly then you want to have a $0 Balance on account 505110, right?

    The offsetting effect of the balance that remains on this account can be found on account 435010 and 435020 that you seem to use for posting the packing slip and the invoice of the goods purchased.

    Do you know where the difference between $9620 and $9865.94 comes from?

    Is it related to a foreign currency purchase or a price difference that was recorded with the packing slip and vendor invoice?

    Best regards,

    Ludwig

  • neethukbabu Profile Picture
    neethukbabu 6 on at
    RE: Voucher Transaction showing different amounts

    Dear Ludwig,

    Sorry for the delay in reply. I was searching for the difference in amount $9620 and $9865.94.

    When I checked, some adjustment has happened for the items in that PO. Some profit or loss amount is showing.. I am checking on it.

    If you can suggest anything, it would be great.

    Regards,

    Neethu K B

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Voucher Transaction showing different amounts

    Hi Neethu KB,

    There are a couple of reasons why this difference might arise, such as for example

    - a moving average price adjustment (=> please check your item model group setup)

    - an inventory recalculation

    - some charges that are set up and posted on the item

    - a foreign currency issue.

    Please also check and check your packing slip voucher once more to ensure that everything is posted correctly there.

    Hope this helps.

    Best regards,

    Ludwig

  • neethukbabu Profile Picture
    neethukbabu 6 on at
    RE: Voucher Transaction showing different amounts

    Hi Ludwig,

    I checked the item model group, we are using weighted avg costing model. I found that financial cost amount is different from physical cost amount for that particular item. Because of that, amount is showing different in PO voucher transaction. Why financial cost amount is different?how i will solve this issue?

    Regards,

    Neethu K B

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Voucher Transaction showing different amounts

    Hi Neethu K B,

    - Can you provide more details about your PO, how it was entered, in which currency, with what kind of charges, etc. ?

    - Can you also check your item transactions and try to trace the transaction that has the cost price difference? The item transaction form provides you with a physical and financial voucher and hopefully gives you some additional insights?!

    - Do you make use of the costing sheet and surcharges for your cost of purchase? Can they be responsible for this?

    Best regards,

    Ludwig

  • neethukbabu Profile Picture
    neethukbabu 6 on at
    RE: Voucher Transaction showing different amounts

    Hi Ludwig,

    The purchase order is created to reverse the previous qty ( like credit note). The currency is used normal as AED and no other maintain charges.

    I have checked the transactions, also physical and financial vouchers also. I could not find out why both physical and financial cost amounts are different.

    We are using costing sheet, but no surcharges.

    Regards,

    Neethu K B

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Voucher Transaction showing different amounts

    Hi Neethu K B,

    Can you identify the difference if you investigate the accounting distributions by clicking the view distributions button?

    If you analyze the item transactions can you identify that an adjustment was recorded?

    In Addition, can you check whether you can identify the difference through the inventory transaction by making use of the inventory trace & cost explorer functionalities?

    Best regards,

    Ludwig

  • neethukbabu Profile Picture
    neethukbabu 6 on at
    RE: Voucher Transaction showing different amounts

    Hi Ludwig,

    There is no Accounting Distributions for that PO and i can see the adjustment. How this adjustment happened? Will this happen automatically?

    Because our packing slip amount value and invoice amount values are same. No other charges are allocated for that PO. Still why this adjustment amount?

    I have checked using cost explorer also, it is showing "issue open", so i cannot get into its depth. Now I am thing, will check with our Support Team.

    Regards,

    Neethu K B

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans