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.
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)
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
- Validated support for Microsoft Dynamics GP 2016.
- Added support for the Update operation for SalesInvoice entity.
- Added support for the Update operation for SalesOrder entity.
- Made the Tax Schedule editable on the SalesInvoiceLine and SalesOrderLine entities.
- Added support for the following new entities and operations:
- Batch entity supports creating batches of payables.
- SalesPayment entity - supports Query.
- GetNextSalesInvoiceNumber - supports Query and Lookup.
- GetNextSalesOrderNumber - supports Query and Lookup
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
- Added Multi-Tenant Support - You can now define distinct connections to each tenant in a multi-tenant Microsoft Dynamics GP environment.
- Added support for database names other than DYNAMICS - Scripts now retrieve the database name from the database if the database name is not the default (DYNAMICS).
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:
- Batch Processing - Batch operations that use large batch sizes may cause timeout errors. TIBCO Cloud™ Integration - Connect recommends decreasing the size of your batches to avoid these errors.
- New Entities, including:
- ItemClass
- ItemCurrencyMaster
- ItemVendor
- SalesInvoice
- SalesInvoiceDiscounts
- SalesInvoiceLine
- SalesItem
- SalesItemWarehouse
- SalesItemWarehouseBin
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
- Added support for deleting Sales Orders.
- Improved ability to track and use Last Modified Date.
Closed Issues
7812
TRY_CAST error on Preview for GP connector (Case # 53197)