You’re offline. This is a read only version of the page.
65
I'm new to GP (GP 2010) so please excuse me if my question is simple.
I'm creating a SmartList based on sales transactions.
How can I get the amount columns (e.g. Sales amount, Tax amount and Original Trx Amount) to display (and export) using their correct sign, i.e. Payments and Credit Journals to show as a negative?
In addition is there any column or reference number that gets attached to an invoices transaction to show which payment transaction was applied to it? Other accounting systems I've used record an allocation/applied reference number.
Cheers,
Ben
*This post is locked for comments
I have the same question (0)
GP Smart Lists allow minor modifications just as adding or dropping columns. Although, If you looking to have the data shown in a specific way that meet your business need, you could go for customization through creating an SQL view and use Crystal Reports, SSRS or Smart List builder to show the data.
Check the "SQL view with AR apply detail" on Victoria Yudin blog
Share
Report
All responses (
Answers (
