MS SQL KBA for Evolution

Our Logo

Adding Accounts and SQL scripts

It happened various times that I added GL accounts to Pastel Evolution without necessarily adding additional lines to the following tables:

BUDGETS

ACCPREV

ACCBLNC

 

This script will add and delete all the necessary lines in a matter of seconds. Now the GL relink should be able to also do it but it normally takes very long. Rather use this script:

 

--begin transaction
--Insert into [AccBlnc] (masterSubLink, account_type) select accountlink, account_type from accounts where accounts.accountlink not in (select mastersublink from accblnc)

--Insert into AccPrev(LedgerLink) select accountlink from accounts where accounts.accountlink not in (select LedgerLink from AccPrev)

--Insert into Budgets(GLLink,AccType) select accountlink, Account_Type from accounts where accounts.accountlink not in (select GLLink from Budgets)

--Delete from AccBlnc where MasterSubLink not in (select accountlink from accounts)
--Delete from AccPrev where LedgerLink not in (select accountlink from accounts)
--Delete from Budgets where GLLink not in (select accountlink from accounts)
--rollback transaction

 

Now before you run the above script you will need to delete the -- at the beginning of each line.

You can also safely run the above script, as it would not change any data until you replace the last line "rollback transaction" to "commit transaction".

This script also comes in handy when you need to purge a GL year, but get data integrity errors.

Contact me for SQL consulting or professional Evolution development.

No Obligation Chat!

"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!