By Steve Endow
TOPIC: Microsoft Dynamics GP
I'm working with a customer to automate the import of Document Attachments into Dynamics GP.
As part of the testing process, we are having to clear out all of the test attachments that have been imported so that we can re-import them again.
In case it's of interest to anyone, here are some SQL scripts I created to delete out ALL document attachments for ALL payables transactions. You can modify the scripts to remove attachments for other record types.
Make sure to backup your company database before running any of these scripts.
If you find any mistakes or problems with these scripts, please let me know.
Steve Endow is a Microsoft MVP who works with Microsoft Dynamics 365 Business Central, Power Apps, Power Automate, Azure, .NET, and SQL Server
Dynamics 365 BC Resources List: http://bit.ly/bcresources
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Wednesday, April 10, 2019
Saturday, March 16, 2019
Troubleshooting a Dynamics GP SQL Posting Error
By Steve Endow
I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dynamics GP batch.
Here is a video discussing the error and our journey to identify the cause and resolve the issue.
I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dynamics GP batch.
Here is a video discussing the error and our journey to identify the cause and resolve the issue.
Subscribe to:
Posts (Atom)
Disable Two Factor Authentication on Business Central Demo Sandbox Environments
By Steve Endow I have created a Business Central SaaS demo sandbox tenant by following the steps outlined by Erik Hougaard in his video her...


-
By Steve Endow Last updated January 7, 2021 (207 resources) There is so much information being published about Dynamics 365 Business...
-
By Steve Endow If you've never done any NAV or Business Central development, but would like to, join me on this journey to learn how t...
-
By Steve Endow 1/23/2019 UPDATE: Version 1.20 released A user on the GPUG Open Forum asked if there was a way to export all of the do...
