Set up a calculated field for the APInvHed invoice amount, only include it if it’s the first invoice line…something like “if InvoiceLine=1 then InvoiceAmt Else 0.00”.
Had the BAQ open and just lost my Citrix connection - BAQ via browser is no bueno.
Do they want running total or something? Still not sure I’m understanding the issue as each of those lines has distinct items to support its uniqueness and keep it from being a duplicate IMO.
If the header is the issue then use the ext line amount and create a subtotal off that you would need to pull in any misc line/header items as well to provide matching totals for the invoice but I don’t get the intended usage and why the header amount is an issue.
Pretty sure the earlier messages said the BAQ needed all invoice line detail and header balance/total…and a dashboard was not acceptable.
If BAQ output is used downstream (Excel perhaps) the header values would be duped on each detail line…so if it’s conditionally calculated off line 1 only, the totals and balances should be correct as a whole.
Appreciate that you’re also trying to help I am as well, but without understand what they feel is DUPLICATE data and/or usage of data it becomes hard to provide a solution as there is no duplicate data from what you posted in you earlier post as a dataset chunk.
The header values are not DUPE records though. That would be 2 sets of data one being the Invoice Totals (Header Values) and other being Line Amounts (Detail Line Records) and placing them on one line does not make it a DUPLICATE record just makes it a line showing the amount of the invoice total shown that is represented by that line.
If used downstream then use data appropriately and use the header as a check to find missing (line/header misc/surcharge) item(s) not shown by the given line totals which would be the appropriate usage of a header total unless you(they) are wanting a net invoice total to check their line totals against.
I think understand the need/usage will provide answers here like @Mark_Wonsil alluded to earlier.
Unless I’m mistaken (not the first time today, won’t be last)…the issue was that the header level total and balance is duplicated on each output/detail line of the BAQ…