Report Writer - Adding a Table

(0) Share

Report

Posted on by Kirk Alexander

412

Apologies for asking the ageless question…

We have been asked to add the SOP ITEM NUMBER to the GP Aged Trial Balance. Client uses SOP, but 99% of their invoices only have one line item. We understand that we might miss one from time to time, but that is acceptable.

Our roadblock is that we have been unable to add the SOP30300 / SOP_LINE_HIST / Sales Transactions Amounts History table to the existing Sales ATB report. Is this going to be impossible? (Report Writer only allows a single one-to-many table relationship?)

If it’s impossible, we can write a SQL script, and direct them to Excel for the ATB, but we’d prefer them not have to jump from GP to Excel, etc. We’re open to other ideas…

Your thoughts are MUCH VALUED! Thank you…

Categories:

Microsoft Dynamics GP