Skip to Content
0
Former Member
Oct 19, 2011 at 10:10 AM

Report at line item level but also for document total for once only

9 Views

Dear all,

seek for your help for the following issue

There is a A/R invoice with 3 items

There is a report for retrieving the line item level data from inv1, user would also like to add a column to display the Document total , but the problem is, each line item will also display the Document total, any method to only display the corresponding Document total for once only?

Example, for AR invoice number 1234567:

Currently:

No. ItemCode Price Qty LineItemTotal DocumentTotal

1234567 Item-A 10 1 10 100

1234567 Item-B 50 1 50 100

1234567 Item-B 20 2 40 100

Requested to be presented as:

No. ItemCode Price Qty LineItemTotal DocumentTotal

1234567 Item-A 10 1 10 100

1234567 Item-B 50 1 50

1234567 Item-B 20 2 40

Thank you very much!!!