The Purchase Line Items SmartList Builder setup is built to mimic the default Purchase Line Items SmartList/Excel Report in the Purchasing Series.
ID: POP_LINE
Name: Purchase Line Items
Tables Involved:
- Purchase Order Line
- Purchase Order Line History
- Purchase Order Work
- Purchase Order History
- PM Vendor Master File
- PM Vendor Master Summary
- RM Customer MSTR
- Customer Master Summary
- Item Master
Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.
Note:
These templates are designed to be a starting place for your reporting needs. While we try to make them as accurate as possible, we always recommend you check them with your data as we don’t guarantee their results. Differences in how data is entered and used in Microsoft Dynamics GP can produce different results with these templates.
