Greetings -
Strange situation with one of my clients that I wanted to get some feedback on.
Somehow the IV00102 table (item qtys) has been significantly modified - they lost - BUYERID/item assignments, they lost purchasing and manufacturing leadtimes and they lost the make/buy codes. Basically, I am wondering if its possible to write back to a GPV8 - sql table from access or excel?
The client has several power users that have sa password and the ability to connect using access, excel, etc. In access can a user inadvertently update and write back to the table?
Or does the IV00102 only updated through application or query analzer?
Any thoughts would be appreciated.
Bron Tamulis, CPIM
Great Plains Mfg Consultant
Strange situation with one of my clients that I wanted to get some feedback on.
Somehow the IV00102 table (item qtys) has been significantly modified - they lost - BUYERID/item assignments, they lost purchasing and manufacturing leadtimes and they lost the make/buy codes. Basically, I am wondering if its possible to write back to a GPV8 - sql table from access or excel?
The client has several power users that have sa password and the ability to connect using access, excel, etc. In access can a user inadvertently update and write back to the table?
Or does the IV00102 only updated through application or query analzer?
Any thoughts would be appreciated.
Bron Tamulis, CPIM
Great Plains Mfg Consultant