Chapter 4_NEW Customer_Vendor Combiner and Modifier Functionality - CINCH 18.55

CINCH has been updated to work with Microsoft Dynamics GP's Customer/Vendor Combiner and Modifier. (CIN-5112 & CIN-5182)
For more information on how to user Customer/Vendor Combiner and Modifier, please refer to the Microsoft Dynamics GP documentation.
This chapter contains the following sections:

Changes to Dynamics GP's Customer Combiner and Modifier to support CINCH
Changes to Dynamics GP's Vendor Combiner and Modifier to support CINCH

Changes to Dynamics GP's Customer Combiner and Modifier to support CINCH
Microsoft Dynamics GP's Customer Combiner and Modifier window does two things.

1. 1. 1. Combine a customer ID with another existing customer ID.
    2. Modify/change an existing customer ID to a new customer ID.

These two processes handle all Dynamics GP and third-party tables that included a CUSTNMBR field name. However, a few CINCH tables with a CUSTNMBR field will be updated due to primary key issues. Plus, CINCH has additional tables that contain customer numbers in fields named other than CUSTNMBR.

The following additional CINCH tables will be updated during the Customer Modifier and Combiner process.

Table Name	Field Name
IRASSOPSplitHDR	IROwnerID
IRASSOPSplitRPT	IROwnerIDArray_1 to IROwnerIDArray_20
IRASSplitMSTRHDR	IROwnerID, IRSplitDesc
IRASSplitMSTRLINE	IROwnerID
IRASXMLTransmitDTLHIST	STRGA255
IRSYEmailBatchLog	Master_ID
IRGNLSNonPosMSTR	CustVenID
IRGNSalesCtrPartnersRPT	IROwnerIDArray_1 to IROwnerIDArray_20
IRASBookingLINE	IROwnerID
IRASBookingLINEHIST	IROwnerID
IRASSplitMSTRDTL	IROwnerID
IRGNSalesCtrPartners	IROwnerID
IRGNSalesCtrPartnersVER	IROwnerID
IRASXRefCustomerLINE	CUSTNMBR
IRCSPortalLogin	CUSTNMBR
IRGNSalesCtrDelSubPrVER	CUSTNMBR
IRGNSalesCtrDelSubsVER	CUSTNMBR
IRASXRefVendorLINE	CUSTNMBR
IRGNSalesCtrDelSubs	CUSTNMBR
IRGNSalesCtrDelSubsPrice	CUSTNMBR
CF9CUST	CUSTNMBR
IRRMCustomerAddressCOMP	CUSTNMBR
IRRMCustomerCOMP	CUSTNMBR
IRRMCustomerLookupCOMP	CUSTNMBR
IRASCustTaxExemptMSTR	CUSTNMBR
IRRMCreditLimit1TPW	CUSTNMBR
IRCSSOPHDRCOMP	CUSTNMBR

Changes to Dynamics GP's Vendor Combiner and Modifier to support CINCH
Microsoft Dynamics GP's Vendor Combiner and Modifier window does two things.

Combine a current vendor ID with another existing vendor ID.
Modify/change an existing vendor ID to a new vendor ID.

These two processes handled all GP and third-party tables that included a VENDORID field name. However, a few CINCH tables with a VENDORID field will be updated due to primary key issues. Plus, CINCH has additional tables that contain vendor numbers in fields named other than VENDORID.

The following additional CINCH tables will be updated during the Vendor Modifier and Combiner process.

Table Name	Field Name
IRGNBargeHDRWORK	IROriginShipper
IRGNPurchCtrPartnersRPT	IROwnerIDArray_1 to IROwnerIDArray_20
IRGNSettlementSplitRpt	IROwnerIDArray_1 to IROwnerIDArray_20
IRPGEquityManualWork	Member
IRSYEmailBatchLog	Master_ID
IRGNAdvanceHIST	IRRemitToVendor
IRGNBargeHDRHIST	IROriginShipper
IRGNPurchCtrPartners	IROwnerID
IRGNPurchCtrPartnersVER	IROwnerID
IRGNSplitMSTRLINE	IROwnerID
IRGNAdvanceWORK	IRRemitToVendor
IRPMVendorCOMP	VENDORID
IRCSVendor1099MSTR	VENDORID
IRPMTransCOMP	VENDORID
IRPMLienholderDTL	VENDORID
IRGNSettlementSplitWH	VENDORID
IRGNLSNonPosMSTR	CustVenID