Microsoft Dynamics GP

A collection of 251 posts

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

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,

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 is

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:

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

Microsoft Dynamics GP

soptypedatabase vs soptype in Dynamics GP SOPEntry Window

I was asked today why I’d just typed SOPTypeDatabase rather than SOPType when we were code reviewing a bit of code. In the SopEntry Window the there is a field SOPType, this shares its name with the database field soptype that defines what type an order is: Sales DocumentType

Microsoft Dynamics GP

Phantom stock allocations and Dynamics GP

Sometimes items in Dynamics GP inventory have a fake inventory allocation showing on them, where drilling into that allocation shows no documents are actually allocated to the item (using allocation enquiry window). from my experience, phantom inventory allocations in Dynamics GP are quite common. This happens quite frequently and support

Microsoft Dynamics GP

Dynamics GP - Customer combiner/modifier and table not found errors

The Customer Combiner and Modifier is a tool that allow a customer to be merged into another customer, including account balances and historical records. The source primary records are then deleted leaving one customer. The modifier just allows the "renaming" of a customer id. For the rest of

Microsoft Dynamics GP

Care naming database objects in Dynamics GP for custom GP Addins

A discussion on “The customer combiner” tool/form in Dynamics provokes thoughts on good practice in database field naming. However lets not start there, first instead let me take you through my current thinking. [more] Schemas Schemas are a container level within the object hierarchy of SQL server. Using SQL

Microsoft Dynamics GP

Adding process hold to a sales order processing document (SOP10104)

Sales order holds table This table holds the data relating to process holds on sales orders, the table is shared between work and historical transactions. Historical transactions will have a posting audit value in the TRXSORCE field, such as : SLSVT00054292 SLSTE00001743 Work transactions (live orders) will have blank TRXSORCE [more]

Microsoft Dynamics GP

-2% progress on Sales Work Checklinks

This was a strange one, reconciling Sales Work in Dynamics GP, the percentage started a 0% started going up then jumped to minus 2%! Truly bizarre!

Microsoft Dynamics GP

DEX_ROW_ID Dynamics GP column, integrations or Customisation

In this post we look at the dangers of choosing to use DEX_ROW_ID as a unique pointer to a record. Don’t use DEX_ROW_ID as a persistent row identifier Currently there is a project in progress to integrate Microsoft Dynamics GP with nopCommerce, an eCommerce web

Microsoft Dynamics GP

Fields: SELNGUOM, PRCHSUOM, UOFM -Dynamics GP Units of measure, a developer perspective

Developers new to ERP or GP can find units of measure a new concept to keep in mind when coding. For some it forms a mental barrier, which is a great pity as its all very simple really! Introduction Units of measure need to be recorded against both inbound and

Microsoft Dynamics GP

Cannot insert the value null into column Print_Phone_NumberGB

The above error occurred on our ecommerce to Dynamics GP integration, that makes use of eConnect to move the SOP website orders into GP. This is an integration that has been working for many years, yet this is the first time this error has occurred. Print_Phone_NumberGB was one

Microsoft Dynamics GP

Irish Tax Registration Number in Dynamics GP (continued)

The previous post GP2010 SP3 Enhanced Intrastats VAT number format wrong IE (Ireland) and others…identified an issue with the validation on the Tax Registration Number in the Intrastat Setup Window for Dynamics GP addresses. Ireland have introduced a new format for VAT numbers that allows two alpha characters, the

Microsoft Dynamics GP

Modal GP Add-in window launching Dex form causes backspace and tab weird characters - Microsoft Dynamics GP

I have found an issue when launching a Dexterity GP windows form from an addin form that is being shown modally. The launched Dexterity form generates funny characters when the backspace key is pressed and the Tab key does not work. For example, use this code from a button click

Microsoft Dynamics GP

Dynamics GP syContentPageXMLCache cannot find table

Also look at this related post: FP: Couldn’t close table! Dynamics GP Error Solution Frequently this dialog pops up on my dynamics GP, A remove range operation on table ‘syContentPageXMLCache’ cannot find the table It happens after leaving the PC overnight or for prolonged periods during the day. The

Microsoft Dynamics GP

Duplicate sticking sales order numbers in Dynamics GP

This is documentation of the issue we experienced with users entering sales orders getting the lines from another user who is also entering a sales order at the same time. This is a problem that we are no longer seeing with version 2013R2, although I have not yet investigated what

Microsoft Dynamics GP

Smart List, Excel cannot open file because file format or extension is not valid– Dynamics GP

Exporting from Dynamics GP Smart List to Excel can cause the following error on GP2013R2 upwards. Excel cannot open the file “xx.xlsx” because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format

Microsoft Dynamics GP

Check for User Messages(1) Dynamics GP Process Monitor

Since GP 2013 sometimes when checking in the GP process monitor, (Microsoft Dynamics GP>> Process Monitor), the message “Check for User Messages(1)” may be found in the process queue. The origin of this message is a new feature of GP that allows administrators to send messages to