AP Payment Journal Settlement Table

(0) Share

Report

Posted on by daxin

Hello,

On the AP - Payment Journal - Lines - Settlement. I am trying to find the table that stores the Invoices that are marked for payment. This would help us so we can generate a report of the payments that are going to be processed and the corresponding invoices associated to the Vendor before posting. Thanks for your help.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello cvandy23,

I guess that you refer to the SpecTrans table.

Best regards,

Ludwig

Was this reply helpful? Yes No
daxin on at

Like (0)

Report

Hello,

Thank you for the reply, but this is not the correct table. The marked transactions do not appear in there. Any others you can think of?

Thanks,

Christina

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Christina,

This sounds strange. Have you market at least one transaction?

There is also the VendSettlement and VendTrans Table but the one that should hold the currently marked Transactions is the SpecTrans.

Would be great if you could double check and possibly attach some screenshots if this cannot be resolved.

Many thanks,

Ludwig

Was this reply helpful? Yes No
daxin on at

Like (0)

Report

Spec Trans did not show the marked transactions. Please try for yourself and you will see. I would think they are stored somewhere?? We create a new payment journal - add a line - then click on the settlement and select the settled transactions and then we want a report of that data so we know the details of what are paying the vendor to get final approval on. We are just unable to find these stored anywhere. Thanks!

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi cvandy23,

This is how it Looks in my Standard Environment:

1. spectrans table before marking a payment for settlement

2. create a payment Journal and mark an invoice for 500 eur to be paid

3. spectrans after having the payment marked

I am wondering whether you are using an add-on to Dynamics AX for making your payments, such as the solution from the ISV "AMC Banking" or any other third-party vendor? They often have their own logic and spectrans tables and circumvent the standard AX tables. Very often you can identify "their" tables by a 3-digit/-letter code used as prefix before the table.

Do you have any information on that?

Ludwig

Was this reply helpful? Yes No
Suggested answer

daxin on at

Like (0)

Report

Wonderful! It was because it was coming in that table with a negative, that's why he couldn't find the match. I really appreciate it :)

Was this reply helpful? Yes No