CINCH Customer Documentation

Chapter 13_XML Identifiers

As part of the exchange of documents between two business partners, it is necessary to communicate certain information in a commonly agreed upon method. Ag Gateway, the entity that sets standards in the Agricultural e-community, has adopted GLN numbering system as the entity identification (Customer/Buyer, Vendor/Seller) standard. They have also adopted GTN numbering system, also know an AGIIS-Product Identifier, as the product identification standard. Since E-Markets, Cinch Document Exchange products will be routinely used to communicate transactions to partners, Cinch Document Exchange has been enhanced to allow the ability to enter GTN's, GLN's and DUNS identifiers as part of the master records. This chapter describes the changes made to support the setup of these XML Identifiers within Cinch.
This chapter contains the following sections:


Changes to Company Address Setup
Company Address Setup has been to modified with the addition of the access to the new Location Detail window. In order to export the company identifier in the AGIIS supported Buyer/Seller identifier, Location Detail has been created to support the entry of a GLN and DUNS number for the company.

  1. Open Company Address Setup

(Tools>Setup>Company>Company: Address button)


  1. Select Additional; Location Details to access Company Location Detail window.

  1.  

    1. GLN Number

      1. GLNs are 13 digits in length.

    2. DUNS Number

      1. Enter the DUNS or EBID number.

      2. DUNS are always numeric with at least 9 digits in length and the option for 4 more for a total of 13.

      3. EBID are 13 characters long and are alphanumeric.

    3. Save button when selected will save the changes on the window.

    4. Delete button when select will delete the selected record.


Changes to Vendor Address Maintenance
Vendor Address Maintenance has been to modified with the addition of the access to the new Location Detail window. In order to export Vendors in the AGIIS supported Buyer/Seller identifiers, Address Details has been created to support the entry of a GLN and DUNS number.

  1. Open Vendor Address Maintenance.

(Cards>Purchasing>Addresses)


  1. Select Additional; Address Details to access Address Details window.

  1.  

    1. GLN Number

      1. GLNs are 13 digits in length.

      2. System supports a single GLN number for each Dynamics Vendor Address.

      3. System allows the same GLN to be used on multiple Dynamics Vendor Address records.

    2. DUNS Number

      1. Enter the DUNS or EBID number.

        1. DUNS are always numeric with at least 9 digits in length and the option for 4 more for a total of 13.

        2. EBID are 13 characters long and are alphanumeric.

      2. System supports a single DUNS number for each Dynamics Vendor Address.

      3. System allows the same DUNS/EBID to be used on multiple Dynamics Vendor Address records.

    3. Save button when selected will save the changes on the window.

    4. Delete button when select will delete the selected record.


Changes to Customer Address Companion Entry
Customer Address Companion Entry has been modified with the addition of a GLN and DUNS number. This is to support the export of Customers in the AGIIS supported Buyer/Seller identifiers.

  1. Open Customer Address Companion Entry.

(Cards>Sales>Addresses: Additional>Address Extensions)


  1. GLN Number

    1. GLNs are 13 digits in length.

    2. System supports a single GLN number for each Dynamics Customer Address.

    3. System allows the same GLN to be used on multiple Dynamics Customer Address records.

  2. DUNS Number

    1. Enter the DUNS or EBID number.

      1. DUNS are always numeric with at least 9 digits in length and the option for 4 more for a total of 13.

      2. EBID are 13 characters long and are alphanumeric.

    2. System supports a single DUNS number for each Dynamics Customer Address.

    3. System allows the same DUNS/EBID to be used on multiple Dynamics Customer Address records.


Changes to Location Code COMP Entry
Location Code COMP Entry has been to modified with the addition of a GLN and DUNS number. This is to support the export of the Inventory Site in the AGIIS supported Buyer/Seller identifier.

  1. Open Location Code COMP Entry

(Cards>Inventory>Site opens the Site Maintenance; Additional>Location COMP Entry)


  1. GLN Number

    1. GLNs are 13 digits in length.

    2. System supports a single GLN number for each Dynamics Site.

    3. System allows the same GLN to be used on multiple Dynamics Site records.

  2. DUNS Number

    1. Enter the DUNS or EBID number.

      1. DUNS are always numeric with at least 9 digits in length and the option for 4 more for a total of 13.

      2. EBID are 13 characters long and are alphanumeric.

    2. System supports a single DUNS number for each Dynamics Site.

    3. System allows the same DUNS/EBID to be used on multiple Dynamics Site records.


Changes to Branch Maintenance
Branch Maintenance has been to modified with the addition of a GLN and DUNS number. This is to support the export of the Branch location in the AGIIS supported Buyer/Seller identifier.

  1. Open Branch Maintenance

(Cards>Cinch Sales>Branches)


  1. GLN Number

    1. GLNs are 13 digits in length.

    2. System supports a single GLN number for each Cinch Branch.

    3. System allows the same GLN to be used on multiple Cinch Branch records.

  2. DUNS Number

    1. Enter the DUNS or EBID number.

      1. DUNS are always numeric with at least 9 digits in length and the option for 4 more for a total of 13.

      2. EBID are 13 characters long and are alphanumeric.

    2. System supports a single DUNS number for each Cinch Branch.

    3. System allows the same DUNS/EBID to be used on multiple Cinch Branch records.


Changes to Item Extension Maintenance
Item Extension Maintenance has been to modified with the addition of the AGIIS Product ID (GTIN) number. This is to support the export of items in the AGIIS supported product identifier.

  1. Open Item Extension Maintenance

(Cards>Inventory>Item; Additional>Item Extensions)


  1. AGIIS Product ID (GTIN)

    1. GLNs are 14 digits in length.

    2. System support a single GTIN number for each Dynamics Item master record.

    3. System will allow the same GTIN to be used on multiple Dynamics Item master records.





Appendix
This section lists the new windows and reports added to this release. Based on the Microsoft Dynamics GP security model, access will need to be determined per security task.
New Tables added to this release are also listed below.
New Windows

Module: Sales

Area: Cards/Setup

Display Name

Form Name

IRASGreenbookItemEntry

Greenbook Item Entry

IRASGreenbookItemLookup

Greenbook Item Lookup

IRASGreenbookMaintenance

Greenbook HazMat Maintenance

IRASRegionLookup

Territory Region Lookup

IRASRegionMaintenance

Territory Region Maintenance

IRASReportingCostAdjustmentSetup

Reporting Cost Adjustment Setup

IRASCountyLookup

County Lookup

IRASStateLookup

State Lookup

IRIVPriceListMaint

Price List Maintenance

IRASStateRegionMaintenance

State Region Maintenance

IRASABLARSetup

ABL Accounts Receivable Setup

IRASABLMaintenance

Asset Based Lending Master Entity Setup

IRASABLTermsCustomer

Terms Customer Setup

IRASABLVendorMDASetup

Vendor MDA Setup

IRPMAddressCOMPMaintenance

Address Details

IRSYLocationCOMPMaintenance

Company Location Details

IRASAssetBasedLendingLookup

Asset Based Lending Lookup

 

 

Module: Sales

Area: Transactions

Display Name

Form Name

IRASNoteApply

Loan Plan Apply

IRASReportingCostAdjustmentInquiry

Reporting Cost Adjustment Inquiry

IRASReportingCostAdjustmentInquiryDetail

Reporting Cost Adjustment Inquiry Detail

IRASReportingCostAdjustmentItemEntry

Reporting Cost Adjustment Item Entry

IRASReportingCostAdjustmentLookup

Cost Adjustment Lookup

IRASReportingCostAdjustmentManualEntry

Reporting Cost Adjustment Manual Entry

IRGNPurchaseLoadLookup

Purchase Load Order Lookup

IRPOLineLookup

PO Line Lookup

IRGNContractApply

Contract Apply

 

 

Module: Sales

Area: Routines/Utilites

Display Name

Form Name

IRASReportingCostAdjustmentBatchProcessing

Reporting Cost Adjustment Calculation Processing

IRASSalesHISTMaint

Sales History Address Maint

 

 



New Reports

Module: Grain

Report Name

IRASRebateItemCostAdjDtlRpt

IRASRebateItemCostAdjLineDtlRpt

IRCSGreenbookHazMatForm

IRCSGreenbookHazMatHist

IRCSGreenbookWPForm

 

 

 

 



New Tables

 

Table Name

IRASCostAdjustmentDetail

IRASCostAdjustmentItem

IRASCostAdjustmentMSTR

IRASCostAdjustmentRate

IRASCostAdjustmentRegion

IRASGreenbookActiveIngrd

IRASGreenbookItemMSTR

IRASGreenbookItemTEMP

IRASGreenbookMSTR

IRASTerritoryRegionDTL

IRASTerritoryRegionMSTR

IRASStateRegionMSTR

IRIVPriceListTEMP

IRASGreenbookMSTRLOG

IRPMAddressCOMP

IRSYLocationCOMP

IRASShipNoticeHDR

IRASShipNoticeLINE

IRASShipNoticeRef

IRASABLCustomer

IRASABLMSTR

IRASABLVendor

IRRMCustomerLookupCOMP

IRGNContractApplyTEMP

IRASCostAdjustmentRebatesReceived

 

 


Changes that may affect Reports or Data

 

Report and Data

Bill of Lading Report (IRCSBOLBlankSales) – when Greenbook is enabled the Cinch Hazardous Description from the Greenbook HazMat Maintenance instead of the standard Hazardous ID description setup on the Item Extension.

Due to the changes made on how Wt and Grade to Govern values are stored, Purch Contract User Defined Prompts (General Setup>Additional>User Defined) will need to be reset after the upgrade.

 

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.