Error at the time of PO Prepayment reversal

(0) Share

Report

Posted on by imran ul haq

4,017

Hi All,

One of my user by mistake apply the full prepayment at the time of PO invoicing, now when i am trying to reverse the prepayment from the vendor master form, i am getting the following error:

"Account number for transaction type Prepayment application does not exist."

Now when i replicate the issue in test server and just for testing i put random account in the "Accounts in automatic transaction" under GL module and checked by reversing again i didn't found the lines on the form:

8078.2.jpg

Please suggest the solution.

Also after updating the "accounts in Automatic transaction" when i test the reversal for other PO, getting the same error:
"Account number for transaction type Prepayment application does not exist."

I am using AX 2012 R3 CU11 version.

Please advise, thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Imran Ul Haq,

I assume that you selected your vendor and made use of the reverse prepayment button in the invoice tab, right?

Do you know if the prepayment has actually been paid?

Does your ordinary prepayment process work as expected? That is can you record a prepayment, post the prepayment invoice, pay and apply the prepayment without any error?

If this is the case, the reversal should work the same way unless there is a bug in your system.

Best regards,

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Hi Ludwig Reinhard,

You are right from the vendor itself i am trying to reverse, but when i am clicking on the "reverse prepayment application" it is giving me the below error message:

Also i define the ledger account in "Accounts for automatic transaction" and that ledger account is also defined in the "Configure account structure".

Please advise how i can remove the error, thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Imran Ul Haq,

The only thing that you can try to do is ensuring that a prepayment account is setup in the inventory posting profile that posts with all account combinations and is not limited to specific vendors/categories.

If this does not overcome the issue, you need to get a developer involved to debug.

Best regards,

Ludwig

Was this reply helpful? Yes No
Muneeb 895 on at

Like (0)

Report

Dear Mr. Imran,

I was just going through the above conversation and I did the small change in AX by creating a general account for the Purchase Order Prepayment Posting profile as shown below,

I did multiple tests as detailed below with multiple Purchase Orders,

1. If the record that is highlighted in the above form exists, we can reverse the prepayment invoice without any issues (Which I did successfully)

2. If the record that is highlighted in the above form DOES NOT exist, we cannot reverse it and I am getting the same error as you have shared across.

This is something which I did randomly in AX, I am just sharing my findings, if that would somehow give you some idea in order to resolve the issue.

Sincerely,

Muneeb

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Dear Mr. Muneeb,

As i am categorizing my prepayment into two category and i cannot use "All" option, and the other two are defined already.

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Hi All,

Also here i have one question, as while reversing the prepayment i am getting the error and after closing the error message and reopen the prepayment reverse form i can not see the prepayment line in both the form of apply and reverse (Please refer the screenshot of my very first post) . Please suggest why it is like this, whether it get stored somewhere and from there i have to delete like the pending invoice.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Imran Ul Haq,

Can you check the PurchPrepayTable?

If a prepayment has been created it should show up in this table.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

imran ul haq 4,017 on at

Like (1)

Report

Hi Ludwig,

After doing some R&D we found this is the bug in our system (R3 CU11) and after applying the KB3183086, i am able to reverse the prepayment.

Was this reply helpful? Yes No