Hello,
There's this on Suppress Freight and InvTotal (so not to repeat when there are multiples lines on an invoice)

if OnLastRecord = False then

Next({AR_InvoiceHistoryDetail.DetailSeqNo}) <> '000000' Else False

How do I modify it to also handle if the 1st record doesn't have 000000 but 000001 instead?

So it's ItemCodes and sometimes the same item repeats, hence using the DetailSeqNo (Line item no).

However it appears on some invoices the 1st line item starts with 000000 and some starts with 000001.

Why the original OnLastRecord doesn't always work.

The reason for the suppress is that there are header records and detail records so the header record repeats for every detail record. Just want to show it once on the 1st detail record of the header record.

Hope that made sense?

Example:
Invoice = 1
DetailSeqNo = 000000
Itemcode = X
DetailSeqNo = 000001
ItemCode = X
DetailSeqNo = 000002
ItemCode = Y

Invoice = 2
DetailSeqNo = 000001
ItemCode = Y
DetailSeqNo = 000002
ItemCode = Y
DetailSeqNo = 000003
ItemCode = Z

Invoice = 3
DetailSeqNo = 000000
ItemCode = X
DetailSeqNo = 000001
ItemCode = Y
DetailSeqNo = 000002
ItemCode = Z

WHY it did that, do not know but that's what's in the system (tables) and dealing with that.



And to properly total on Report Footer?

Please help.

Thank you

https://www.dropbox.com/s/o5rvhmj711zi0ca/Example.jpg?dl=0

https://www.dropbox.com/s/i3qg1v89jodgs83/Example-02.jpg?dl=0

The highlighted are the freight and invoice total per invoice and should only show once per invoice.

Edited by techsupport - 15 Jun 2018 at 6:02pm

Yes thank you

How to total at the end? Grand Total / Report Total when also hiding duplicates?

Ok thank you

It's on both

Header total - total invoiceamt, freightamt, discountamt <-- this looks to be correct
Detail total - item total <-- this is off
Maybe due to duplicate line records/

Edited by techsupport - 22 Jun 2018 at 9:58am

Yes, that is what I did.
When I export the report out and total the details, there's a discrepancy.

Exported and totaled: 4,852          36,137.27
Sum Detail On Report: 4,854          36,162.52

The Select Distinct Records did not make a difference.
I've tried the 2nd part and tried it again and that results in a very large difference for the totals than the above