I would like to generate a SmartList within the Purchasing module that would list Freight for each purchasing transaction. I have looked through the Payables Transaction report columns and I cannot locate the DISTRIBUTION TYPE. Could someone offer some assistance on how is the best way to compile a report with this information for budget purposes...
Thanks,
Janean Brown
Hi Janean,
Unfortunately the Payables Transaction smartlist only shows header information about the transactions so you won't find distribution information using that smartlist.
If you have eOne smartlist builder you can download a smartlist that exposes Payables distributions by selecting "Tools > Smartlist Builder > Import" and choose import from web
Victoria Yudin also has excellent resources that could help you create a smartlist here https://victoriayudin.com/gp-reports/payables-sql-views/
Hope this helps
Thanks
Gavin
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,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156