Hi All,
Nav 2009 R2, Jet Essentials
I have been asked to produce a report (more a data dump) that shows all Posted Sales Invoice Lines & all Posted Sales Credit Memo lines as Finance want to double check the figures & do some analysis at line level.
I assume there is no easy way to do this is the same report, so have created 2 reports - one based on NAV078 - Items Sold by Customer by Document - for the Sales Lines, the other almost identical but from Posted Sales Credit Memo Table.
Both reports have the values as a positive number as per there Nav Tables, the reports have been created using =NL("Table" - for one of the reports (preferably the Credit Memo) is there a way of converting the Line Amount to a negative so that the reports balance?
Otherwise is it an extra column outside of the report to manually adjust the values to a negative?
Thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Clipif,
Sure there are other solutions, but why not create one report using NL("Rows")?:
One NL("Rows","Sales Invoice Line",,…)
One NL("Rows","Sales Cr.Memo Line",,…)
Use NF's to retreive field-values and adjust the sign of the amount depending on the Document Type (in case of Credit Memo: NF(CellRef,"Amount")*-1).
To create a table-like report, create a pivottable that includes the data range of both the NL("Rows") + one row so replicated rows will be included.
See the attached file for a start of the report. As we don't use these tables there is no data…
Hope this helps?
Regards,
Gerard
Please sign in to leave a comment.