This feature is only available from Sage 200 Professional Spring 2018 version onwards.
The General Data Protection Regulation (GDPR) is the new European Union data protection law that will come into effect on the 25th May 2018. EU Regulations have direct effect in all EU Member States, meaning the GDPR will take precedence over any national laws.
It sets out businesses' responsibilities in relation to the personal data that they collect and hold, and also governs the processes businesses use for managing that personal data. Personal data can be defined as any data identifying or relating to an individual. Most businesses collect personal data from the minute they interact with an individual.
Get ready for GDPR
We've produced some guides and videos to help you get ready for the GDPR.
Find contact information in Sage 200
Individuals have a right to access their personal data and have it rectified or erased (the 'right to be forgotten') by a business. If an individual asks to check or remove their personal data, you can use the GDPR Contact Check report to help you find their details in Sage 200.
Open: Accounting System Manager > System Utilities > General Data Protection Regulation > GDPR Contact Check.
Enter all or part of the person's name to search for in the three search boxes (Search 1 - Search 3).
- You can search for the first, middle and last name.
Try searching for the surname first. If you get too many people in the results, search for the first and last name. Remember that there may be variations of a name in your data, e.g. "Thomas" and "Tom".
- You can enter a partial word, e.g. "Dav" will find both "Dave" and "David".
The report will show you where matching name details are stored in Sage 200.
- Customer names, contacts, and delivery addresses.
- Supplier name, contacts, and factor house contacts.
- Nominal account contacts for cost centres and departments, and VAT submission contacts.
- Bank accounts contacts.
- Stock control contacts on product groups, stock item records, and locations.
Sales order contacts for delivery and invoicing, and order taken by.
Note: Completed sales orders cannot be amended.
Purchase order contacts for delivery and invoicing, order originator and order taken by, delivery addresses (direct delivery).
Note: Completed purchase orders cannot be amended.
- Purchase order authorisation users specified for rules, out-of-office notifications, and alternative authorisers.
- Project Accounting resources, contacts for projects and project templates, contacts for project billing, and the project owner.
Manufacturing contact details on estimates, works orders, batch works orders.
Manufacturing System Manager employee details and prospects.
Note: Completed estimates and works orders cannot be amended.
Consider where else you might have entered details about individuals, such as:
- Analysis codes.
- The Postal name on quotations or pro forma invoices for prospect accounts.
- Memos on accounts; such as customer, supplier, or bank accounts.
- Any other fields which aren't labelled for names, but where you may have entered details about an individual.
Find old customer or supplier accounts
You can find customer and supplier accounts that you have not traded with for a long time, and use this to decide whether to delete their account. For example, you might check for all customers and suppliers that you haven't traded with in the last 7 years.
Open: Sales Ledger > Reports > Account Analysis > Customers With No Transactions From.
Open: Purchase Ledger > Reports > Account Analysis > Suppliers With No Transactions From.
- In the report criteria, set the date to check for transactions in No transactions from.
The report shows:
- All accounts that have no transactions since the specified date.
- The active status, whether the account is active or hidden.
- The last transaction date.
- The account balance.