Sage Construction & Real Estate

Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Renaming Cost Codes on existing jobs

Posted By FormerMember over 5 years ago

Hi,

Is there an upload for renaming the description of cost codes on existing jobs? For axample renaming all the 3-125 cost codes from "Pot Plants" to 3-125 "Plants" accross all jobs. Doing it manually / individually would take a while as there are about 4k to 5k records to be changed.

Cheers.

Parents

0 JustinL over 5 years ago

If you haven't figured this out yet, what you want to do can be easily accomplished with a SQL Update statement executed on the Job Cost Code table using MS Access. The whole thing could be done in less than five minutes.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 JustinL over 5 years ago

If you haven't figured this out yet, what you want to do can be easily accomplished with a SQL Update statement executed on the Job Cost Code table using MS Access. The whole thing could be done in less than five minutes.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage Construction & Real Estate

Renaming Cost Codes on existing jobs

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING