Hi all,
I've got a problem with my Customers On Hold Report....
The report contains a lot of unnecessary entries, such as customers who have already gone to liquidation.
Because of this, the report is unnecessarily long.
I just want to see customers who are still in business but currently on hold.
how can I make a change??
Please help...
Best regards
Kay
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
Customers On Hold Report
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Customers On Hold Report
You could filter out those that have gone into liquidation.
Assuming you use the Account Status field to indicate those that are in liquidation what I would do is to write a filter.
Where Accounts Status is not equal to 3-Liquidation.
Apply this filter to hid all the customers in liquidation then run your report and you will get the ones that are on hold but not in liquidation.
Assuming you use the Account Status field to indicate those that are in liquidation what I would do is to write a filter.
Where Accounts Status is not equal to 3-Liquidation.
Apply this filter to hid all the customers in liquidation then run your report and you will get the ones that are on hold but not in liquidation.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Google [Bot] and 1 guest