Vendor does not exist Issue when creating the Vendor Payment Journal

Finance and Operations/AX Developer Forum
1

Hi,

I am facing the below issue while trying to create the Payment Journal for the Vendor.

Account Payable → Journals → Payments → Payment Journals

When I open the Payment Journal and go to lines, and when I select the ‘Vendor Account’ from the “Account” dropdown, I am getting the below errors:

Error: “Vendor AAA does not exist” OR “The value “XXX” in the field ‘Vendor Account’ is not found in the table ‘Vendors’”

PFA snapshot of the errors

7178.Issue1.jpg

AND

5611.Issue2.jpg
5611.Issue2.jpg861×383 70 KB

I am unable to figure out what could be the issue as the Vendor does exist in AX. Moreover this issue is coming for a specific vendor and NOT for all vendors i.e. if I am selecting some other vendor, I am able to create the payment journal.

Can anyone please help me resolve this issue as I am clueless as what could be the issue.

Sincerely,

Muneeb

2

Which line of code did throw the error?

3

Hello Martin,

Thank you.

Please find the below snapshot the containing the error details and the code that is throwing the error.

3223.ActualRootCauseforVendorNotFoundError_1.jpg
3223.ActualRootCauseforVendorNotFoundError_1.jpg1173×486 147 KB

My findings might not be related to the actual root cause but what I saw, I have specified in the above snapshot while I was debugging. And it is giving the error for the vendor account # for which it is unable to fetch the record using the above select statement as shown in the above statement.

Sincerely,

Muneeb

4

If it’s true that

select firstOnly vendTable where vendTable.AccountNum == '0796'

doesn’t return anything, it must mean that such a vendor doesn’t actually exist in VendTable.

5

I have double checked many times and the record “0796” is PRESENT in ‘VendTable’.

I have double checked by browsing the table as well as by going to the database.

Sincerely,

Muneeb

6

Then please test the select statement again - run it in a job. If you do it in the right company, it must work (and therefore this is not the cause).

7

Hi Muneeb,

I have the same error. Do you remember the solution for this? I am trying to enter vendor id in AP invoice journal lines and the error message with different vendor ID is popping up. Please help!