Identifying Duplicate Transactions

From the Useful SQL Scripts Series. Because Microsoft Dynamics GP is designed to have separate tables for WORK, OPEN and HISTORY transactions, there are times where it is possible for a transaction record to exist in more than one table.  This is usually the result of an error or interruption. These duplicate records become an issue when…

21

Releasing Stuck Batches and Transactions without exiting all Users

From the Useful SQL Scripts Series. When a system has a batch that is stuck as marked to post or a transaction that cannot be accessed as it says it is already being edited, the usual instructions are to exit all users from the system and then delete the contents of the activity tracking, and Dexterity session and lock tables. These…

14

General Articles & Links

This page contains links to application related articles and sites: Security Knowledge Base (KB) Articles Frequently asked questions about Advanced Security and about Field Level Security in Microsoft Dynamics GP and in Microsoft Great Plains (KB 894705)  Frequently asked questions about role-based security in Microsoft Dynamics GP 10.0 (KB 951229)   Frequently asked questions about the advanced SQL…

5