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?
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (