MS SQL KBA for Evolution

Our Logo

MS SQL: A few Pastel Evolution Data extracts

In order to use Pastel Evolution database data you will have to have access to SQL Server Management Studio or something like SQLEditor. Here is a list of a few scripts you can run. Deleting data is not recommended but also shown below:

This will select all GL Accounts that have no sub-accounts
Select distinct (SubAccOfLink) from Accounts where SubAccofLink > 0

This will update all the GL Account's CaseAcc field with a value of 1 when the account have no sub-accounts
update Accounts set CaseAcc = 1 where where SubAccofLink > 0

This will delete all the accounts where the accounts are sub-accounts
delete from Accounts where CaseAcc is null

1. The where statement can also use >, < and <> (not equalling) signs if it's not just a single record to be deleted
2. Remember to always backup before running any scripts

No Obligation Chat!

301 Moved Permanently

Moved Permanently

The document has moved here.

"Software4Business customised our Sage Evolution system, giving us full ERP functionality and complete control of every aspect" - NA Glass Pty Ltd.

We Are Here To Help

We know that you do not always have time to do your own work as well as Sage Evolution configuration, training and troubleshooting. Evolution might be user-friendly but being an administrator takes a bit more than what meets the eye. We know, and we dedicated thousands of hours learning the ins-and-outs. We know the front-end, back-end, programming code and triggers inside out. We can help you, that is what we are here for.

Strategic Reporting

We know you want to see income statements, balance sheets, make sure the TB balance and keep an eye on those ageings totals, but what if you need something more. Something like KPIs for your warehouse staff, or a monthly sales report that gives you budgets per customer and GL account. What if you want to segment your reps and products. How do you do that? We use our "secret" weapons combined with Excel-based reporting. Impossible becomes strategic.

Years Of Experience

With over 40+ years combined IT experience and 30 years with Sage, you can be sure to get the right solution, with the right answers and years of "know-how". Our experience shows in the lists of prestigious customers we have helped over the years. We can also help you. Martin Luther King, Jr. said that knowledge gives man power; We are adding this "without experience you have little control"

Ready When You Are

We would love to meet you and see how our solutions can help you "take back control". A meeting, demonstration or support with any of our highly skilled Sage Evolution consultants can be arranged.



Click here when you are ready!