Microsoft Dynamics GP

A collection of 251 posts

Microsoft Dynamics GP

Dynavistics acquire rights to Trinity (m-hance) source code

The news article linked below reveals that Dynavistics have acquired rights to develop the Myridas products that were acquired themselves by m-hance when they absorbed Trinity Computers during the m-hance acquisition run that achieved a 45% sales growth for the m-hance in 2012. Dynavistics Acquires the Right

Microsoft Dynamics GP

Enabling Dynamics GP Modules

It can be confusing where in the GP user interface that functionality in GP is enabled from. It can seem like there is no consistent place to go in order to enable functionality. In this post I’m quickly just going to show some examples and leave it at that…

Microsoft Dynamics GP

Solution to eConnect Requester SOP Transaction trigger not creating output records

eConnect uses a Document Requester system to allow database activity in GP to be tracked, say for the creation of sales orders. It also allows the database to be queried via the eConnect API, without any logging to output tables. Steve Endow has written up here on his blog, 8

Microsoft Dynamics GP

eConnect fails to update field ITMVNDTY (IV00103) from field PRIMVNDR (IV00102)

Why does eConnect not update the IV00103 ITMVNDTY field when changing the primary vendor, PRIMVNDR of IV00102? Table IV00102 item-site This table relates items to sites, including what stock is at each site and which primary default vendor should be used for that site. The default vendor is held

Microsoft Dynamics GP

Custom links example in Dynamics GP

A post on the Dynamics GP community forum reminded me of something I set up way back, custom links for linking to an item on a website from GP. Dynamics Community Forum for GP Custom Links Custom links are supported for a limited number of prompts within GP; * Chequebook * Credit

Microsoft Dynamics GP

Dynamics GP Fix “Amount Remaining” incorrect on receivables transaction payment apply

For the following Debtor, the GP client server connection was interrupted whilst payments were being applied. This left the apply in an inconstant state. Subsequently the payment was unapplied, leaving the “amount remaining” for the payment double what it should be. This is because removing the apply has “credited” the

Microsoft Dynamics GP

Custom eConnect XML Node–Procedure or function expects parameter, which was not supplied

Custom XML nodes error with parameters It is possible to run your own custom stored procedures from eConnect, by passing in parameters via a custom XML nodes. I have explained this technique in a previous post, there is more information on MSDN too: * This Blog: Using custom nodes in eConnect

Microsoft Dynamics GP

SalesPad Mobile Installer

I love the “View Update SQL” button on the SalesPad mobile server installer. This button generates the SQL that is about to be executed against your GP database into a notepad window for inspection. It was reassuring to see and understand what was about to be done to the database.

Microsoft Dynamics GP

Server drop down in Dynamics GP login not showing DSN connection 64bit machine

We have all been there, tired and forget that if the machine is running on 64bit, the WOW64 process is looking after you and the ODBC connection for GP needs setting up in the 32 bit version of the ODBC manager. This catches me out from time to time as

Microsoft Dynamics GP

Developing against Dynamics GP Multiple Bins, tables used

Quick guide to data flow when working with Dynamics GP and multiple bins. Inventory levels As is normally the case, stock levels are maintained by IV00102, in fields QTYONHND (quantity on hand) and ATYALLOC (quantity allocated). When multiple bins is enabled (see post: TSQL determine inventory MultiBinning is enabled in

Microsoft Dynamics GP

Generating *SEQ (LNITEMSEQ etc) column values in Dynamics GP

How does LNITMSEQ work? There are sequence columns used to introduce order into rows within Dynamics GP. Examples are such as LNITMSEQ that identifies the line numbers of sales orders in SOP10200 and SOP30300. When new rows are appended to these tables, the sequence column value becomes 16384 * the line

Microsoft Dynamics GP

Dynamics GP Drop Shipping Sales invoices before purchase invoice with Shipment Notification Tool (SNT)

Hey- I’m going to let you into a little secret. No one talks much about this tool and it is difficult to find information on about it, I read about it some time back and suddenly found a need to use it. What is it? The Shipment Notification tool

Microsoft Dynamics GP

Limitations using Multiple Binning and a SQL script - Dynamics GP

Updated: 2017-11-27 by TW, to remove reference to schema in SQL script It seems that the priorities for bins can be entered against an item in the Item Site Default Bins window. The documentation says this is so the bins can be prioritised, for the order they are

Microsoft Dynamics GP

Microsoft Connect–stop whinging and contribute

“The software should just do that, or I wish it could do this..?” The site https://connect.microsoft.com is a feedback tool that can be used to submit feedback on Microsoft products. I know after chatting with some of the developers from the MS Dynamics products, that they look

Microsoft Dynamics GP

Find carriage return (cr) and line feed (lf) in NOTES fields of Dynamics GP

This is a Epson FX80 dot matrix printer. For those of us who remember RS232 driving these things using DOS or Turbo Pascal then you know that to make it move down a line, then a line feed ASCII character would need sending in the text stream, a char(10)

Microsoft Dynamics GP

Rate safety trip for ERP integrations

We have created an Ariba, Integration to Dynamics GP using cXML, eConnect and some .NET, through which customers can push purchase orders to Dynamics GP. The orders result SOP sales orders being created in GP. Tight integration with the supply chain partners comes with risks. What happened? Today one of

Microsoft Dynamics GP

eConnect Customer Requester Document–Missing ShipToName field

A new field for addresses, “Ship to Address Name” was added to GP2013 (much to my delight!). When making an eConnect requester document request through eConnect, this field was missing in the XML returned by eConnect. Using the stored procedure that generates the output, proves this field is missing from

Microsoft Dynamics GP

GP Database Maintenance Utility

Problem today with attempting to run the GP Database Maintenance utility, however it was only listing DYNAMICS and no other companies installed on the database server. I took a look at what the window was up to with the database, to see if permissions were an issue. The following SQL

Microsoft Dynamics GP

m~hance form NetSuite division to plug cloud SaaS gap

m~hance, one of the largest Dynamics GP partners in the UK, also providers of hosted Dynamics GP in the cloud, have announced a move that acknowledges the market direction of ERP delivery. They have committed to Cloud ERP with the creation of a new division named “HighCloud Solutions”. In

Microsoft Dynamics GP

TSQL determine inventory MultiBinning is enabled in Dynamics GP

Inventory Control Setup Table IV40100, field “ENABLEMULTIBIN” shows if the Dynamics GP company has multiple binning turned on or off (enabled or not). Use the following SQL to check the multiple bin status of a GP company: SELECT CASE WHEN ENABLEMULTIBIN = 1 THEN 'ENABLED' ELSE 'DISABLED'

Microsoft Dynamics GP

Installing/using/finding Professional Services Tools Library (PSTL)

I just couldn’t find the Professional Services Tools on Dynamics GP today & I admit that this is not the first time, so I’m blogging it to remember for next time. Dynamics.SET Couldn’t find any reference to a PSTL DIC in Dynamics.SET -so assumed it

Microsoft Dynamics GP

A way to automatically export formatted Excel files and send to customers

Email Excel files to customers from Dynamics GP More and more customers are requesting product feeds to be sent to them via email, using their own proprietary, highly formatted Excel documents. In addition these feeds need to be sent daily or alternatively when data contained inside them changes. The expectation

Microsoft Dynamics GP

Find invalid selling units of measure for Microsoft GP

SELECT IV00101.ITEMNMBR ,IV00101.UOMSCHDL ,IV00101.SELNGUOM ,IV40202.* FROM IV00101 LEFT JOIN IV40201 ON IV00101.UOMSCHDL = IV40201.UOMSCHDL LEFT JOIN IV40202 ON IV40201.UOMSCHDL = IV40202.UOMSCHDL AND IV40202.UOFM = IV00101.SELNGUOM WHERE iv40202.DEX_ROW_ID IS NULL AND IV00101.SELNGUOM != '' The above will find any selling unit

Microsoft Dynamics GP

Validating data after econnect integration in Dynamics GP

After ingesting a customer purchase order into GP to create a sales order, it is a biz requirement to check that the pricing provided by the customer matches that currently set up in GP pricing. This could be a tedious task for the sales user, drilling into each line of

Microsoft Dynamics GP

User connection to test or wrong company in Dynamics GP zDP_SY30000F_1

So you find that SQL monitor or profiling shows that every minute a user is access a company that you don’t expect to see accessing? How can this happen? This puzzled us for a little while today, we had a user accessing the test company, when we checked with