Microsoft Dynamics GP

A collection of 241 posts

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 consumed. It

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

Microsoft Dynamics GP

Inactivity Auto Logout for Dynamics GP - part II

In part one of Inactivity Auto Logout for Dynamics GP, a Dynamics GP add-in was developed to auto logout on inactivity of the GP client. With GP 2013R2 came some new functionally to message users. That functionally breaks the auto logout. To read about the user messaging see the post,

Microsoft Dynamics GP

dexLabelProvider & LinkField explained

The dexLabelProvider is a component that implements IExtenderProvider, thus adding an extra property (LinkField) to label components dropped onto a DexUI form or forms that inherit from it. The provider is used by the DexUI form’s onPaint to draw a line between label (or linklabel) and control defined in

Microsoft Dynamics GP

Dynamics GP Power Tools–what will it not do?

If you are developing on top of Dynamics GP, or perhaps go to the many Dynamics GP conferences, or maybe just using search engines to find answers to your common GP problems, then you will have encountered David Musgrave (MVP). His work is pervasive in the Dynamics GP world and

Microsoft Dynamics GP

Visual Studio 2022 & Dynamics GP Addin Project Templates “install”

[Edit 2021-11-16] I have been maintaining the extension through to Visual Studio 2022 from VS2015 - i have updated this article a little for 2022 Lets face it, Visual Studio 2015 (VS2015) is here and it is awesome, thus drop what you are doing and start developing with it, right

Microsoft Dynamics GP

Mystery of Qty Allocated & field name ATYALLOC

In Dynamics GP the inventory quantity allocated has a field name of “ATYALLOC”. You can see it lurking in IV00102 table, as a decimal (19,5). . Why is is named ATYALLOC? A field typed day in and day out, I ponder each time it is why it was named so.

Microsoft Dynamics GP

GP2016, looking sweet in HTML5

Release date for GP2016, 1st May 2016 [updated 9th March 2016] It has now been officially announced that Microsoft GP2016 will be released on the 01 May 2016, see the details in Pam's Blog post Pam Misialek - Microsoft Dynamics GP 2016 is Coming in May The future

Microsoft Dynamics GP

Dynamics GP User Group for the UK, or not?

Today at m-hance customer day there was a session titled “Joining Information,New Microsoft GP User Group”, hosted by Andy Brown of m-hance. This session was short, at half hour with an open questions to the audience. The questions were on purpose seeing formative views along the lines: * Do the

Microsoft Dynamics GP

Checklinks taking too long (or its time to truncate history)

60GB database, works fine operationally except for the time checklinks and reconcile take to complete. They both take too long for the time available to run them. It is a pity that these can’t be ran over ranges or be more efficient/quick. Sales history has 7.2 million

Microsoft Dynamics GP

eConnect Requester Documents sourced from Custom table or Views

The eConnect Requester not only allows you to fetch GP native records, it can be configured to fetch data from custom user tables. Even more interesting is I have just discovered it works for SQL views too! This is useful for joins to other tables to bring back just what

Microsoft Dynamics GP

Document is being edited by a coworker and can’t be printed

The American language in Dynamics GP makes us chuckle. This message box is a wonderful variation on the message box “This transaction is being edited by another user”. We know of the “another user” table, but have never encountered the “coworker” table. The dialog box pops up when trying to