Microsoft Dynamics GP

A collection of 241 posts

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

Microsoft Dynamics GP

SQL Server 2012 SP2 Replication Log Reader error v.11.00.5058

After moving Dynamics GP to a newly built server, using a back up and restore strategy, the Dynamics GP SQL replication kept causing problems. The following message drowned the error logs of the server. I ended up rebuilding replication configuration entirely to solve the issue, but there may be some

Microsoft Dynamics GP

Automated restore of Live Company to Test Company in GP2013 CHANGES

Don’t be caught out by this change in the automated restore of test company database from live. This is something we do every Friday night on a scheduled SQL job, however since updating to GP2013 our test company is not working after the restore. Attempts to login are greeted

Microsoft Dynamics GP

GP2015 Warns of CAPS LOCK on login

Vaidhyanathan Mohan has observed the long missing caps lock warning has been added to GP2015 on the login form. See it for yourself on his blog GP 2015 – New Feature – Caps Lock On Message

Microsoft Dynamics GP

Selecting a Microsoft Dynamics GP Partner

This is a very difficult task. There are many factors that can go into choosing a Dynamics Partner. With so much to think about, on this page I have noted some things you might like to consider.

Microsoft Dynamics GP

Service Orientated Architecture & Dynamics GP–the future is bright

Andrew Hayward keynote the m-hance conference earlier in the year It being late December I’m reflecting on the year, one of the highlights for me was when I got the pleasure of a long chat, one to one, with Chad Sogge &Daryl Anderson and then a quick chat

Microsoft Dynamics GP

Buttons not persisting size in Dynamics GP add-in

Steve Endow, posted yesterday on Buttons mysteriously resize on VS Tools Dynamics GP Forms -- VST template bug?This could have a big impact as I’m now working against GP2013R2 and so I set about investigating the issue. Thanks to Steve for sending me a ZIP of his example,

Microsoft Dynamics GP

Find Custom SQL Triggers before Dynamics GP upgrade

Be aware that any custom created SQL triggers in the Dynamics GP database that have been created outside of Dynamics GP will be dropped at time of upgrade from one version of GP to another. Custom triggers are a technique SQL Server Admins might use to, for example default a

Microsoft Dynamics GP

GP web client 2015 is first class

Perfect Image “Customer” Day 2014 Perfect Image are a professional Dynamics GP partner based in NE England and I was kindly invited to attend their customer day today. They are working with Amazon Web Services to deliver GP in The Cloud and have numerous other competencies, check them out for

Microsoft Dynamics GP

Beware DEX_ROW_TS for data synchronisation

DEX_ROW_TS is a SQL server database field. It is found on sometables in Dynamics GP ERP system(since V10). The field contains a UTC timestamp that is “stamped” whenever that row in the database is changed, setting it to current time and date. A blog entry from David

Microsoft Dynamics GP

Implementing the Microsoft Dynamics GP Web Client–Book Review

ERP systems are migrating to the near zero deployment of web browser delivery and consumption. With Microsoft’s release of the GP Web Client, Dynamics GP is now no exception. Ian Grieve has produced a book that brings lucidity to the process of installing and configuring the GP Web Client