Dynamics 365 Great Plains
Use SQL to generate a macro to create Vendor Items
On a recent project with a client to implement the Purchase Order Processing module, we needed to create a lot of vendor item numbers.…
Tag: vendor
Dynamics 365 Great Plains
SQL View to return most recent five purchase orders by vendor
I don’t recall when I wrote this SQL view, but I stumbled across it when I was looking for something else and thought it…
Dynamics 365 Great Plains
SQL Script to update vendor and customer email addresses
Back in August 2011 I posted a SQL script which transfers vendor email addresses from the INET1 to the Email Address field and today’s…
Dynamics 365 Great Plains
SQL Script to get all vendor purchasing accounts
I recently needed to select all assigned purchasing accounts for a particular vendor; this would include both the normal purchasing one on the Vendor…
Dynamics 365 Great Plains
“The vendor has an existing purchase order…” error message when using Integration Manager
I’ve recently been working with a client to implement Microsoft Dynamics GP and have been using Integration Manager to import the opening data. While…