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.

Microsoft Dynamics 365 Business Central: Links to Information and Resources

By Steve Endow

Last updated July 10, 2023     (272 resources)


There is so much information being published about Dynamics 365 Business Central that it's difficult to keep track of everything.  I am collecting links to information and resources here for my reference.  I will update this list regularly as I find new resources.

You can use this short URL to reference this post:  https://steveendow.link/bcresources

OR:  https://bit.ly/bcresources

Please feel free to send me additional resources!

I can be reached via DM on Twitter at https://twitter.com/steveendow  or via email at:  steveendow {at} gmail.

The most common eConnect error: The source was not found, but some or all event logs could not be searched

By Steve Endow

This is one of the most common eConnect errors that I continue to see with Dynamics GP customers.  It occurs when a new server is setup with eConnect, or when an integration is migrated to a new server where eConnect was just installed.

It is very simple to fix, but requires Local Admin rights on the machine running eConnect.


eConnect error:

Exception: The source was not found, but some or all event logs could not be searched.  To create the source, you need permission to read all event logs to make sure that the new source name is unique.  Inaccessible logs: Security.

Dynamics 365 Business Central April Upgrade Scheduling - Important Notes!

By Steve Endow

If you haven't read the post on the Business Central for Partners blog about "Scheduling your April 2019 Upgrade for Business Central", I recommend reading it thoroughly.

https://community.dynamics.com/business/b/businesscentraldevitpro/archive/2019/03/27/scheduling-your-spring-2019-upgrade-for-business-central


It has several very valuable points about enhancements to the Business Central version upgrade process.

Some of the key points are:

Beginning with the April '19 release, we will also send notifications for preview version availability, upgrade scheduling, extension validation, and upgrade failures.

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.

C# SqlException: Procedure or function has too many arguments specified

By Steve Endow

I've been fighting this error for years in my Data Access class. Only yesterday did I figure out the cause.

It's related to the design of my Data Access class, and specific cases where I need to make multiple calls to the database in a single method.

This is the error:

SqlException: Procedure or function has too many arguments specified

This is an example of a stored procedure call that leads up to the error.

Assembling SQL Parameters for a Stored Procedure

3 Fun Stories About Strings and C#

By Steve Endow

Whenever you work with data, an integration, or code, you will invariably work with strings. Usually lots of strings.

In some cases, every data field you work with will be a string. In other cases, you'll need to convert strings to numbers, dollars, or dates.  And sometimes you'll need to format strings, whether composing data into XML, formatting social security numbers, or working with different date formats.

In this video, I share 3 stories about working with strings in C# that I encountered recently on projects.

https://www.youtube.com/watch?v=VKF6bE1RqOk