Sage 100

Does anyone have any options available to update the company key referenced in the PL_JournalPDFLog file? I thought I saw something here a while ago but of course can't find it now.

SQL yes. Providex no. It might be easier to change the key/number in sy_company to what you want

@JimWoodhead ?

I'll check it out I don't think it'll be a big issue to write short program. are there other companies or is it just a one company

What's the Company key now and what you want to change it to

It's actually 3 companies I have to deal with. Old key 1 is now 16, old key 3 is now 15 and old key 5 is now 14. It's just over 4,000 records that I'm dealing with.

Thanks, Robert. It's Providex and unfortunately not as simple as changing the key in sy_company as there are other files where it's included. I know it affects user security and there's some surrogate file that would get messed up too for sure.

Are those the only records in the file?

Version 5.20.2.0

Yes

Also what version of sage 100?

Thank you!

I will email you in the morning with my results. It seems pretty straight forward.

How did it work out?

It worked great. Thank you!