SmartList Report - Distribution Type=Freight

(0) Share

Report

Posted on by Microsoft Dynamics ...

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

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Gavin 2,339 on at

Like (0)

Report

RE: SmartList Report - Distribution Type=Freight

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