Sales invoice report

Spacejam1976

Hello,

I have to modify the posted sales invoice report. For every sales invoice line I need to show the serial no from item ledger entry. I have filled a temp table with the serial nos . I have added a new integer dataitem under the salesinvline dataitem to loop through the table and display the data. The serial nos are displayed correct but the total amount at the botto is multiplied by the number of lines I have in my temp table. Do u guys know how I could sort it out? Cheers

Wisa123

You are working on 2009 Classic i guess?

Spacejam1976

I'm working on nav 2013.

that is the report result

skulla

I faced similar problem recently adding another data item to display serial no. Was causing an issue so I stored the serial no. In text field and added that to the report by adding a new row in the report.