I'm trying to write an aged debt report. I have two important tables: the INVOICE HEADER table and the TRANSACTION DETAILS table. The HEADER table contains the unallocated / unpaid amount of the invoice and DETAILS contains the sales analysis information. The is a many-to-one relationship between DETAILS and HEADER lines. What I am aiming to do is create a report that can show the first analysis code from the DETAILS lines for each header.
Problem: Although I can eliminate these from printing by using groups based on the invoice header, any summary / subtotals added accumulates all instances of the HEADER unallocated totals - as a result, the total per account number is wrong - it adds up all the occurances of the match of multiple analysis lines to one header, giving a bogus total.
Is there any way to eliminate this? Ideally, I would like to call up only one analysis record from DETAILS, e.g. the first on it comes across as this would be enough to base my report splits upon.
Thanks for any help...
Problem: Although I can eliminate these from printing by using groups based on the invoice header, any summary / subtotals added accumulates all instances of the HEADER unallocated totals - as a result, the total per account number is wrong - it adds up all the occurances of the match of multiple analysis lines to one header, giving a bogus total.
Is there any way to eliminate this? Ideally, I would like to call up only one analysis record from DETAILS, e.g. the first on it comes across as this would be enough to base my report splits upon.
Thanks for any help...