Statements O/S to Excel Help
Posted: 08 Mar 2018, 12:04
Hi Bruce,
Sage v24
When i export a basic customer Outstanding Statement via the Data To Excel function, i see each itemised line on the invoice with it's price.
what i am attempting to do is to produce an excel sheet that will show the Invoice/Credit number, Customer name, customer PO ref and the gross amount for that invoice/credit.
I have managed to include the customer order ref and the joins are in place.
When i preview the report i can see the data i want without each "TransactionItemised.ForeignAgedAmount"
i've literally removed all debit and credit fields and just left the "AUDIT_HEADER.FOREIGN_AGED_BALANCE" on the report and i'm still seeing the splits.
Any ideas?
Sage v24
When i export a basic customer Outstanding Statement via the Data To Excel function, i see each itemised line on the invoice with it's price.
what i am attempting to do is to produce an excel sheet that will show the Invoice/Credit number, Customer name, customer PO ref and the gross amount for that invoice/credit.
I have managed to include the customer order ref and the joins are in place.
When i preview the report i can see the data i want without each "TransactionItemised.ForeignAgedAmount"
i've literally removed all debit and credit fields and just left the "AUDIT_HEADER.FOREIGN_AGED_BALANCE" on the report and i'm still seeing the splits.
Any ideas?