Need help on OE order entries

[NewCCTech]

Hello Everyone,

We are setting up an alternate system for user to use during the period we shut down our live system.

We have to make AR/AP/IC...of Alternate system have the same data as the live system at the ponit we shut down, but no AR, AP, Inventory, Sales changes will be allowed, only allow to take orders, my question is that in order to track the orders, we need to reset the Order Entries and start from 0, but what tables' data should I need to erase? I know I need to erase the data in OEORDD and OEORDH, but what else tables?

Thanks!

 

[Jay Converse]

All of them. Make an empty company and activate a new copy of OE.

 

[NewCCTech]

Thanks tuba2007!

we have made an new company and done data dump from live system and loading data to the new company, so all data from OE has been brought over too, can I just use SQL queries to delete all the records in all the tables of OE on SQL server?

Thanks!

 

[Jay Converse]

No. Use the SDK to deactivate OE, then re-activate it.

 

[NewCCTech]

Sorry tuba2007 for getting back so late!

I have never done this before, can you give me more details on how to deactivate OE, then re-activate it using SDK?

Thanks a lot!

 

[Jay Converse]

Do you have the SDK? Then run the Deactivate icon. If you don't have it, then you need to contact your Accpac consultant.