Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Wednesday, April 10, 2019

Dynamics GP: Deleting all document attachments for Payables Transactions

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.

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.


Business Central: Change Log feature

By Steve Endow Let's talk about the Business Central Change Log feature! Just Search for Change Log The Back Story While poki...