While I was looking at the problem raising In-Transit Transfers I needed to delete all orders with alpha numeric Document Numbers, but was getting an in use error on one of them:
I double checked to make sure the user was not really locking the record, and, as I’m not aware of an unlock method in Microsoft Dynamics GP itself, I made a quick trip to SQL.
The following query will show the…
Continue Reading Ian Grieve’s Article on their blog
Microsoft Dynamics GP In-Transit Transfer Document Locked
While I was looking at the problem raising In-Transit Transfers I needed to delete all orders with alpha numeric Document Numbers, but was getting an in use error on one of them: I double checked to make sure the user was not really locking the record, and, as I’m not aware of an unlock method in Microsoft Dynamics GP itself, I made a quick trip to SQL.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses