15
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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
