Guidelines and Best Practices for Submitting a Change Request

Submit a Change Request to update your configurations. Configurations are central to the operations of Conexiom applications. The guidelines outlined below will help facilitate the onboarding process.

Basic Steps

Creating a change request is a matter using statements to set up a series of rules.  These rules are used to configure the trading partner so that the information from the original document is correctly transcribed into the digital document being created. For example, through this process,  you can define the ShipTo field in the digital version, based on the location of the ShipTo field in the original documents.

There are 2 recommended ways to submit a Change Request:

To submit a Global-level Change Request, i.e. one that will apply to all trading partners, Contact Support. Global-level Change Requests should only be submitted by individuals with a deep understanding of global logic and its application in change outcomes. 

Best Practices

When making a change request, there are a number of rules you should adhere to to ensure your statement is correctly interpreted by the Connection Developer handling the request. This is relevant with regards to context and formatting. 

Rules and Syntax

Each email or text request is written in a basic A-D-E format:

Ask

A request or short title:

  • Update to PO# format 

  • Change Ship to ID  

  • Update Notes as they are sent to wrong segment 

Details

The layout of the logic in the If, Then, Else basic format:

  • Remove all dashes “-” from the PO number 

  • If the document says “drop ship” beside the ship to address,
    Then set the ship to ID to “9999”
    Else use “0123” 

Example

Examples that show the desired change:

  • **Example** PO number should be “1234” not “1-23-4" 

  • **Example** PO 1234 should have ship to ID 9999 

 
Your statement should be phrased in the “IF, THEN, ELSE” formula:

IF

The condition

THEN

What Conexiom should do when the IF statement is met or is true

ELSE

What Conexiom should do if the IF statement is not met or is false

 
In addition to the If, Then, Else format, use quotation marks around specific values or text to differentiate those elements from the conditional if-then-else statement.

The words “If,” “Then,” and “Else” do not need to be used overtly, but the structure needs to be in place regardless of their actual appearance.

Primary Guidelines

  • Use Quotation Marks (ABC”) around all proper names of fields, cross reference tables, columns, and segments. 

  • Use asterisks around the word “Example” or “Note” to call out examples or notes:
    **Example** For the attached document, B12345, use line 4.

  • Use either the word “Extract” or “Remove” when you need to have characters scrubbed from the original data. These are often used to request the removal of special characters.

  • Use two returns between request sections. To do so, at the end of the first line, Click Enter twice.

  • Do not use any formatting common to word processors or email applications, such as Tabs, Bullets, Centering, etc. You can use slashes, dashes, spaces, and similar keyboard entries to communicate your intentions.

  • Use exact names of tables, columns, labels on the document, output file terms, etc. 

  • When applicable, state if the value is being set or used from a Header Level vs. a Line Level, such as with expected delivery dates. 

  • Try to be as specific as possible about where a value is to populate in the output file.  

Examples of Full Statements

Example 1

Use the following table to identify the Ship To ID based on the Ship To Address:

Input <ShipTo Address> Output <ShipTo ID>
123 Awesome Street 1234
345 Cool Avenue 3456

Else, generate a Ship To alert.

PO#9578 has a ShipTo Address of '345 Cool Avenue' so the ShipTo ID will be "3456". 

Example 2

The trading partner has changed their document layout recently.

Please update the mapping for this document. The quantity column has shifted right and the label has changed to “Total Qty.”

Example 3

If there is no value under the “Item” column on the document, then take the “Description” as the part number and do not fail the document.

Else, no action is needed. 

Example 4a

Step 1: Clean up Part Number 

If the part number has any dashes, slashes or periods, then remove these from the part number. 

Else, use the part number as is. 

If the part number on Line 1 of the PO is "123-09", it would become "12309". And, if the part number on Line 2 is "AB01567-A", it would become "AB01567A".

Example 4b

Step 2: Part Number Prefix 

If the cleaned-up part number does not start with “AB01”, then prefix “AB01” to the part number 

Else, use the part number from step 1. 

The Line 1 part number from 'Example 4a" becomes "AB0112309", and the Line 2 part number remains t"AB01567A". 

Formatting Guidelines

  • Use Quotation Marks ABCaround all proper names of fields, cross reference tables, columns, and segments. 

  • Use ** <NOTE> ** to call out examples or notes for the CD team member. 

  • Use two returned (enters) between request sections. 

  • Do NOT use any word or email formatting such as tabs, bullets etc. Use slashes, dashes, spaces, etc. instead. 

  • Use EXACT names for tables, columns, labels on the document, output file terms, etc.  

  • When applicable, state if the value is being set or used from a Header Level vs. a Line Level such as with expected delivery dates. 

  • Try to be as specific as possible about where a value is to populate in the output file.  

Additional Guidelines

  • When mentioning a cross-reference table, use the exact column heading as the reference; not the column number.

  • Use the word “Concatenate,” “Prefix,” or “Suffix” when you need the connection development team to merge or link two words or fields together into one value for the ERP system. (See Preferred Terms for Change Requests).

  • Use either the word “Extract” or “Remove” when you need to have characters scrubbed from the original data. These are often used to request the removal of special characters. (See Preferred Terms for Change Requests).

  • When a reference table is five items or fewer, it can be manually typed out into the map request. For any cross-reference tables that contains more than five rows, create a cross-reference table in the portal.

  • Provide examples in all requests, including the document number the example is taken from.

  • Describe the expected behavior from the change in all requests.

  • When reviewing example documents:

    • If the document is multiple pages be sure to review all pages.

    • If the customer provides more than one example, be sure to review all examples.

    • If you need to submit information in two different requests, make sure you indicate the requests are labelled “Part 1 of 2” and “Part 2 of 2” so that the Connection Development team works on them in the correct order.