Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 2 matches
- 29 Jan 2018, 11:47
- Forum: Sage 50 Report Designer
- Topic: Customer Retention Report
- Replies: 4
- Views: 3171
Re: Customer Retention Report
The issue is that your report also refers to invoice items, as such the data set you are getting returned form all the joins includes a record for each item as well as each invoice. If you go into joins and remove the invoice_items table then your report will work. Hi Thanks for this. I assume that...
- 29 Jan 2018, 10:59
- Forum: Sage 50 Report Designer
- Topic: Customer Retention Report
- Replies: 4
- Views: 3171
Customer Retention Report
Hi I'm trying to build a simple report that will show the number of invoices created per customer to give us some idea of our customer retention. I am using the countunique(INVOICE.INVOICE_NUMBER) expression but it seems to count the number of invoice items not the number of invoices. For example If...