CINCH Customer Documentation

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
Microsoft Dynamics GP's Customer Combiner and Modifier window does two things.

  1.  

    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.

  1. Combine a current vendor ID with another existing vendor ID.

  2. 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



3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2013 - 2024 Cultura Technologies, LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.