Microsoft Great Plans and Microsoft SQL Server Expert (Great Plains/Dynamics Data Issue)
We are a rapidly growing provider of database infrastructure management and database support services. We help our clients with database administration, database monitoring and database support.
One of our customers has reached out to us asking for help with troubleshooting a specific data issue with their Great Plains application.
-- One of the finance staff was editing master payroll data for a specific user
-- Let’s call this user John Doe, ID = 1001
-- When editing, table UPR00100 (Payroll Master) was being updated
-- Specifically, John Doe’s title in UPR00100 changed
-- Next, the same staff began to enter a new user into Payroll Master
-- Let’s call this user Jane Smith, which was going to get a new ID issued, 1002
-- At this point, data in UPR00100 for John Doe was overridden with Jan Smith’s data, including ID 1001 was overridden with ID 1002
-- They were able to partially repair John Doe using Check Links
-- Explain how the above scenario could have happened.
-- We know exactly how and when database changed as we analyzed the SQL Server Log file using ApexLog but we don’t know how this could have happened from Great Plains perspective/interface.
If this project goes well, there is an opportunity to work remotely as an on-demand Great Plains/Dynamics expert on on-going basis.