Microsoft Dynamics GP Release Notes

Release notes are displayed in descending order from the most recent release to the oldest. Known Issues are listed with the most recent release.

See TIBCO Scribe® Online Connector For Microsoft Dynamics GP for more information.

Note: To access any changes to metadata support, such as new operations, entities, or fields, reset metadata for the Connection. See Resetting Metadata.

 

 

April 23, 2018 Release

New And Noteworthy

TIBCO Scribe® has tested this version of the TIBCO Cloud™ Integration - Connect Connector for Microsoft Dynamics GP against Microsoft Dynamics GP 2018. TIBCO Scribe® has validated that Microsoft Dynamics GP features supported by the Connector for prior versions of Microsoft Dynamics GP continue to be supported for Microsoft Dynamics GP 2018.

Closed Issues

40268 / 62525

Added an index on the LastModifiedDateTime field to the ScribeNetChange table to handle large record sets that sometimes generated timeout errors. (Case # 56882)

56765

Updated Connector to recognize and connect to a Microsoft Dynamics GP HTTPS URL. (Case # 62321)

Note: HTTPS Connections are supported only for single tenant installations. Your GP Server and GP Web Services must be configured for HTTPS. (63254)

61223

Modified Microsoft Dynamics GP Connector views to include NOLOCK to help reduce performance issues in the Microsoft Dynamics GP environment. (Case # 63748)

Known Issues

SCMSGP-4

Summary: In some cases, when creating GL Transactions and setting the transaction ID using glGetNextJournalEntry; to get a number, generates errors similar to the following: (Case # 01767196)

Create Error: Error converting data type int to smallint

Workaround: Contact Support for Hotfix SCMSGP-1.

SCMSGP-5

Summary: Formula validation fails for the SalesPayment entity field named type with an error similar to the following: (Case # 01796756)

Unknown data type 'valuetype'

Workaround: Modify the GPMetadata.txt file in the Microsoft Dynamics GP Connector folder to change the datatype for Native name: PYMTTYPE</Description> from "ValueType" to "String". If you reset metadata, this change must be done again.

3692

Summary: The GPMetadataViews.sql script in the C:\Program Files (x86)\Scribe Software\TIBCO Scribe® Online Agent\Connectors\Scribe.Connector.GP directory on the server where the Connect on-premise agent is installed contains references to Microsoft Dynamics GP columns labeled ACTNUMBR_1 through ACTNUMBR_5. This script is used when configuring a Connection to Microsoft Dynamics GP to generate the metatdata for the Connection. If any one of the ACTNUMBR columns does not exist in the Microsoft Dynamics GP database, errors are generated when establishing or refreshing a Microsoft Dynamics GP Connection that are similar to the following: (Case # 39880, 41750, 42445, 46004, 46708)

Fatal error: Invalid column name ‘ACTNUMBR_5’.

Workaround: Contact Support for a modified version of the SQL script without the missing column names.

 

July 5, 2016 Release

New And Noteworthy

Closed Issues

8603 / 20020

Fixed support for case-sensitive databases.

8839 / 20007

Refreshing metadata resulted in the error " Invalid column name 'ACTNUMBR_5'. Invalid column name 'ACTNUMBR_5'." (Case # 59267)

8872 / 20011

Detecting and replacing the Microsoft Dynamics GP database name with a custom named version was not working when no target credentials were provided generating an Invalid Object name error. (Case # 59267)

 

June 17, 2014 Release

New And Noteworthy

Closed Issues

8603

Issue loading views in a case-sensitive databases (error: " MASTER_ID is not a valid field" ).

 

April 8, 2014 Release

New And Noteworthy

Added support for the following:

Change In Functionality

New Sales Invoice And Item Entities

This release of the Microsoft Dynamics GP GP Connector includes new entities that support both source and target operations. The new entities, listed below, supersede their existing counterparts, which had limited, source-only support. TIBCO Scribe® recommends you begin using the new entities immediately. While the original entities will remain available temporarily to allow converting existing maps to these new entities, they will be dropped in a future release of this connector.

Original Entity

New Entity

Invoice

SalesInvoice

InvoiceLine

SalesInvoiceLine

ItemCurrency

ItemCurrencyMaster

ItemMaster

SalesItem

Closed Issues

Fix for installing without Project Accounting enabled. You may now load metadata even if you have not installed the Project Accounting module.

 

December 27, 2013 Release

New And Noteworthy

Added support for a number of new entities for Accounts Payable and Receivable, General Ledger transactions, and Vendors

Closed Issues

There are no Closed Issues in this release.

 

August 30, 2013 Release

New And Noteworthy

Closed Issues

7812

TRY_CAST error on Preview for GP connector (Case # 53197)

Related Topics

Release Notes And Known Issues