Any idea why would the records get duplicated when I create a query of AR invoices in a month. If there are multiple lines in an invoice the invoice total is repeated instead of the value of each line that is coded to different GL account. Any help will be appreciated.