Hi there guys,
Can anyone tell me a how can i achieve a custom report with the following columns:
Sales Invoice Number | Date Issued | Customer Issued | Net Amount | Tax Amount | Total Amount
And at the end of the lines adds the amounts for totals.
Can this report be achievable through “custom reports”? Can i add more columns with custom fields of the customers?
ntrim
2
I’ve tried almost everything (I think) but no custom fields. Only this works for now:
SELECT reference, issuedate, customername FROM SalesInvoices
update:
SELECT reference AS Invoice, issuedate AS Date, customername AS Customer, balancedue AS Balance_Due FROM SalesInvoices ORDER BY issuedate, reference
no luck with “subtotal” or “total”.