Hello everyone, good afternoon:
can someone tell me how to get from the database to which accounts the requested requisitions entered
Hello everyone, good afternoon:
can someone tell me how to get from the database to which accounts the requested requisitions entered
Thanks
Hi David,
Yes the GL00100 has the same account index (ACTINDX) value as what is in the GL00105 (ACTINDX) and POP10210 (INVINDX) tables. I hope that helps.
Thanks,
excellent thank you very much.
Is this key related to the GL00100 table, is this correct in the ACTINDX field?
thanks
Hi David,
You can run a query on the POP10210 or build a smartlist from that table to populate the accounts that are on the requisition. The field that you would be looking for is the INVINDX in the POP10210 table. I hope that helps.
Thanks,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156