Posted Payment Journal Become Double Paid

(0) Share

Report

Posted on by Adhha Adnan

420

Hi All,

I have a concern regarding Payment Journal, where we have posted a payment journal.

After posted, we notice that the payment had become double even though we only create 1 payment line in the payment journal.

These is the payment line that I'm referring to.

6076.Payment-journal.png

After checking found that, the payment have been touched multiple account. After confirm it, the payment supposedly debit to Vendor and Credit to Bank which not supposed to touch ledger at all.

8156.transaction-origin.png

Turn out this is manual transaction key in the payment journal.

How reverse the extra posted amount?

How to avoid manual line to charge multiple account?

Please advise.

Thanks

I have the same question (0)

All responses (12)

Answers (3)

Verified answer

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

Like (1)

Report

Hi Addha,

In my opinion, there is nothing wrong here. Check the journal if you have the same voucher number for both payment lines (first screenshot).

Related to the second form. This shows the ledger entries, vendor and bank updates. When you post a payment journal, then there is an impact on the vendor and bank. This always results in ledger transactions. If you don't want to have direct impact on the bank account, you can also use the bridge transactions option which can be specified on the Payment method.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Adhha Adnan,

I think that everything is ok with the voucher.

In your second screenprint you see the transactions recorded in GL (ledger) in AP (vendor) and in the banking module (bank).

To me this looks good.

Best regards,

Ludwig

Was this reply helpful? Yes No
Adhha Adnan 420 on at

Like (0)

Report

Hi,

Okay then, but in payment voucher print out. Its stated different thing. How do I check why in payment voucher got double paid ?

This is the payment voucher document.

Thanks

Was this reply helpful? Yes No
Adhha Adnan 420 on at

Like (0)

Report

Hi,

Okay then, but in payment voucher print out. Its stated different thing. How I check on this?

This is payment voucher document, show different thing.

Thanks

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning Adhha Adnan,

Is the payment voucher document that you shared the result of a customized document or is it a standard document?

If it is something adjusted then talk to your developer whether the report design is ok.

On the other hand, if this is a standard report then what you see might be related to a bug. I found some hints on LCS where a number of bugs and hotfixes are listed, such as the following one for AX2012R3 CU11:

KB 3140253Invoice and payment vouchers are duplicated when two batch job are executed on same statement at same time

In case your payment voucher is a standard document, I would recommend having a look at the hotfixes available on LCS to ensure that the result you see is not related to a system bug.

Best regards,

Ludwig

Was this reply helpful? Yes No
Adhha Adnan 420 on at

Like (0)

Report

Hi,

Its a standard document with customize design. We only customize the design only.

What when wrong?

Please help me out.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi Adhha,

You have to check or have someone to check if the tables are filled correctly. If this is a customized design, or shared the exact details what had been changed or check if there is a new table join which can cause duplicate records. It might be related to this report only.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Adhha Adnan,

Please double check that the design customization is not responsible for this duplication in the report.

Do you still have the old standard MS design available and can you compare the different reports (MS standard vs. your custom designed report)?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

real_ashwin 1,225 on at

Like (0)

Report

Nothing wrong with AX must be customization issue on report.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Adhha Adnan,

Did you make some progress here and have you been able to get this figured out/resolved?

Would be great if you could keep us updated.

Best regards,

Ludwig

Was this reply helpful? Yes No