This article gives one detailed and one summary example on how to create an Application Link to in its web interface to open a classic function in X3 on a specific record. It does not cover how to open the Read Only pages in X3 which is covered in the Sage Enterprise Intelligence (SEI) Users Guide.
Overview of process:
- X3 Preparation
- Decide which function you want to open (If there is an entry transaction, note it as well)
- SEI Preparation
- Determine which SEI process
- Confirm the SEI Process has a column for the field being used to Link To into X3
- Confirm field column has a Global Parameter in it, or assign one
- Determine worksheet to use
- Create the Application Link
- SEI Execution
- Open Worksheet, applying filters as desired
- Example Groups to location column to use Link To
- Left click on value
- Select Link To
- Select Application Link from list
- X3 opens to record (log in may be required)
Basic format of Application link:
http://FullyQualifiedDomainNameOfServer:X3Port/syracuse-main/html/main.html?url=/trans/x3/erp/FOLDERNAME/$sessions?f=FUNCTIONNAMEoptionalTildeandEntryTransactionName/2//M/ParameterName;
Examples:
Note: These steps are from SEI v8.1.0.14 and X3 v11 patch 4
Example #1 - Sales Order (Detailed)
- X3 Preparation
- Function = Sales Order (GESSOH) [Sales, Orders, Orders]
- Entry Transaction = ALL
- SEI Preparation
- SEI Process = Invoice Analysis
- Field used = SOHNUM_0 from SORDER table
- Column Group Heading = Order and Column Heading = Number
- Parameter used = OrderNumberSEI Preparation
- Create Application link
- Tip: Put the core piece of the link string in a text application for easy copy/paste into SEI’s window.
- http://x3v11p1svr.best.adinternal.com:8124/syracuse-main/html/main.html?url=/trans/x3/erp/SEED2/$sessions?f=GESSOH~ALL/2//M/
- see image comparison between template given above and resulting URL (obviously, your server name and probably folder will be different)
- Administration, Application links, New
- SEI Execution
Example#2 - Purchase Invoice (Summary):
- X3 Preparation
- Function = Purchase Invoice (GESPIH) [Purchasing, Invoices, Invoices]
- Entry Transaction = ALL
- SEI Preparation
- SEI Process = Purchase Invoices
- Field used = NUM_0 from PINVOICE table
- Column Group Heading = <blank> and Column Heading = Document no.
- Parameter used = DocumentNo
- Worksheet = Purchase Invoices
- Application Link = http://x3v11p1svr.best.adinternal.com:8124/syracuse-main/html/main.html?url=/trans/x3/erp/SEED2/$sessions?f=GESPIH~ALL/2//M/@DocumenDoc;
Troubleshooting tips:
The Application Link doesn’t appear in the Application Links list when I chose Link To
- The Global Parameter is misspelled
- The Global Parameter isn’t in the Process
When opening X3 I receive a “Resource not found” message
- There is an embedded space in the application link URL
- The Server’s name isn’t its Fully Qualified Domain Name (FQDN)
- There is a spelling mistake in the URL
(Special thanks to Scott Watts and Kristian Hill at RKL eSolutions for their insights.)