AA Smartlist with JE

(0) Share

Report

Posted on by Community Member

I am working to create a AA smartlist to review AA Open transactions with Vendor detail, and determine if the original payables transaction is voided

I've joined the AA Open Transaction with the Account Transactions, which provides all of the information except the piece that determine if the original payables transaction is voided.

Can you link this field?

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: AA Smartlist with JE

Hi!

Thank you for the prompt response. I tried linking the payables transactions, however the voided fields are returning blank fields in the smartlist. I ran the payables transactions in SQL to confirm the field does return a "YES" value.
Verified answer

Nattis 487 on at

Like (0)

Report

RE: AA Smartlist with JE

you need to link with PayablesTransactions view to AccountTransactions via

AccountTransactions.[Originating Document Number] or AccountTransactions.[Originating Control Number] and AccountTransactions.[Series]='Purchasing'

in this way, you can get the subledger info along with main ledger.