Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor cash discount o...
Microsoft Dynamics AX (Archived)

Vendor cash discount of Charge

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

When posting a Payment journal, I got an error message of "The transactions on voucher TFIG-140000002 do not balance as per 22.12.2016. (accounting currency: 200,00 - reporting currency: 200,00)".

6825.1.png

The 200€ difference is the cash discount for Charge (Line level). Could you please advice me:

1. what I should do in order to post the journal successfully?

2. what setup I should do in order to exclude charges from cash discounts?

My AX version is 2012R3CU9.

Thanks a lot in advance!

S.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi Ludwig & Crispin,

    @Ludwig:

    Can you record some invoices with different charge codes that debit either a ledger account or an item and then try to pay the invoice?

    I still get the error msg after trying this.

    I think the issue is with how AX handling Cash discount for Charges.

    If "Discount offset account" = Accounts on the invoice lines, there's an error msg when posting payment journal.

    If "Discount offset account" = Use Main account for vendor discounts, it's OK to post the payment journal. However, the account AX chose to post Offset account is the VAT receivable account instead of the account assigned in "Discount offset account". Here is the screenshot of the Cash discount code & Cash discount voucher:

    3644.2.png

    Oh, and I have only the demo system to learn AX, no Live system. So I can't apply any hotfixes.

    @Crispin: Yes, there are main accounts at those places.

    S.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi S.,

    I had a look at LCS and found several hotfixes.

    Yet, I am not absolutely sure which one might fit here.

    To rule out that this is an issue of the charge setup, can you test in a demo System whether the charge setup is responsible for this behavior?

    That is, can you record some invoices with different charge codes that debit either a ledger account or an item and then try to pay the invoice?

    If you still get the error message then it might be due to a system bug and I would recommend that you contact the MS support to send you the right hotfix.

    If you can post the payment without any issue in your demo system then compare the charge code setup with the one that has been made in LIVE.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi Crispin & Ludwig,

    Thanks so much for your replies.

    @Crispin: Yes, there's a Vendor posting profile connected to a main account.

    -

    @Ludwig: 

    By "Charge" I meant e.g. Freight.

    a) The cash discount form in the AP module under Setup/payment/cash discount. Is a main account setup there?.

    I don't use Main account for the Cash discount code. Instead, the code is setup with "Discount offset accounts" of Accounts on the invoice line.

    b) GL/Setup/sales tax/ledgerposting Groups. Do you have a vendor cash discount setup?

    Yes, there is an account for that.

    If this does not help, can you let us know whether this is the first time that you receive this error message?

    It's OK to post a payment journal with cash discount when the invoice doesn't include any charge. But when the invoice does include charge, this error message will pop up, so - yes, this is the 1st time I got this error msg for this case.

    S.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi Serene,

    By charge you mean cash discount is that right?

    Can you check the following setups

    a) The cash discount form in the AP module under Setup/payment/cash discount. Is a main account setup there?

    b) GL/Setup/sales tax/ledgerposting Groups. Do you have a vendor cash discount setup?

    If this does not help, can you let us know whether this is the first time that you receive this error message?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi Ludwig,

    Many thanks for your reply.

    I want both scenarios:

    - In question 1: Yes, cash discount is posted for Charge.

    - In question 2: Cash discount excludes charge.

    The PO form is to show the Item & Charge amounts. And yes, the payment is for that PO.

    S.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor cash discount of Charge

    Hi S.,

    Do you want to have the cash discount posted or do you want to just record the net payment amount?

    Why does the screenprint above show the PO form. Isn't it that you recorded the payment for that PO?

    Best regards,

    Ludwig

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans