So a common thing I get asked to do is re-coding of supplier codes in the accounts payable ledger, account codes in the general ledger, you get the idea. In fact this is easier to do with the Sage database than alot of systems because it does not enforce any business rules (referential integrity) in the database.

However the extracting, the transforming of data and then loading it back in again can be time consuming. That’s why I use the little tool which automates this and more importantly allows users with no SQL knowledge to do re-coding.

You simply specify a connection to the Sage Line 500 database (once done you can save the connection) and then you specify the command to extract the data (templates are provided).

Once this is done you can view the live data in a grid.

Then you can simply specify which columns you wish to change.

Then once this is done you can either add the data to the existing table or replace it.