You’re offline. This is a read only version of the page.
420
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…
Share
Report
All responses (
Answers (
