How to Start a Web Service Project in SOAP UI

Web services can be a great and easy way to communicate with X3. Being an industry standard, web services allow easy communication between X3 and many outside systems. Using web services allow for real-time transactions and feedback. You will know instantly if your transaction was successfully processed or if an error occurred. SOAP UI software makes testing these services easy. The software replicates a third party product making it easier to identify issues. Templates can also be saved with parameters already defined, making running process quick. In this post, I’ll show you how to connect SOAP UI to X3 and begin a project.

First, you will need to get the web service URL from your X3. Do this by navigating to Administration > Administration > Web services > Classic SOAP Web Services. Highlight the URL, right click & copy the address for later.

Open your SOAP UI program. (If you need to download the program, go here: https://www.soapui.org/ ) In the top tool bar navigate to File > New SOAP Project

Give your project a name(i.e. Client name_X3 test folder). In the Initial WSDL field, paste the link copied from X3 and press “OK”.

At this point, the program will attempt to make a connection to X3

If successful, your project will now be listed on the left hand list of projects with a connection icon below it(two green arrows). If your connection was unsuccessful, check your URL from X3 and try connecting again

Click the “+” next to the connection to expand your process options. Click the “+” next to the process you’d like to run. In this example I chose “run” . Double click on “Request 1” to start a new run request

By double clicking a request, a template will pop up for you to edit

Replace the “?” with the relevant information.  codeLang = ENG ; poolAlias is the X3 folder you are working in; poolId can stay blank(delete the “?”); request config is the string from the image below(use this if you are using JSON formatting); publicName is the name of the web service created in X3

The information that populates the inputXML/ CDATA tag will differ depending on the web service you are running. In this case, the web service is expecting some input data(in brown text) and if successful, will return a defined output.

When you have your template filled in sufficiently navigate to the bottom of your work space window where there is a button that says “Auth”. SOAP UI needs to validate your X3 credentials

Add a new authorization

Choose “Basic”

Enter your X3 credentials & click “Authenticate Pre-emptively”

Press the green arrow at the top off the pop up window to run the request

The results will populate on the right side of the window. You may have to do some troubleshooting if you did not get the results you expected.

If there was an error, an error message will be at the bottom of the returned output

For more information or help with web services, please reach out to us at (412) 226-3086 or admin@rebdev.com

How to Re-synchronize Stock

Sometimes stock quantities can get out of sync from reality due to may factors. How will you know that this is your issue? Say you are trying to allocate stock to a sales order or are doing a stock change but the system is warning you that there is no quantity of that item. If you know there should be a quantity available, then your stock may be out of sync.

To solve this issue navigate to Stock > Utilities > Stock resynchronization and control

Choose a site, or click the “All sites” checkbox. Fill in a product/category or leave it blank to resync all then choose the relevant check boxes below & click “OK”

When the resync is complete, you will get a log file. At this point you can try the orginal transaction again.

Sometimes, this is enough to put the stock back in order but if not, you may need to take an extra step. Navigate to Stock > Utilities > Quantities entered resync

The process is complete when you get a log file. If you get errors, run the quantities resync again.

How-to Series: Adding an Endpoint in X3

This is a useful how-to for when you need to add a new endpoint to X3 whether you are setting up a new system or just need a new test folder. For this how-to, images will be referencing V12, but the steps can be replicated in most versions of X3.

  1. Navigate to Administration >Administration > Endpoints > Endpoints

2. Click the “Actions” button on the right hand side of the screen. in other versions you may skip this step to go to step 3

3. choose “New endpoint” from the right hand side

4. On this page you will need to define some parameters for you folder.

  • NAME/DESCRIPTION: The name/ description will appear when it is referenced on a page in X3.
  • APPLICATION: Choose the X3 ERP application which defines the type of software the endpoint refers to.
  • SERVER PARAMETERS: Server parameters define the connection your folder has.
    • X3 SOLUTION: For ERP endpoints, choose the X3 server(in this case it has been named SAGEX3 during set up) from a list.
    • SERVER FOLDER: The server folder defines the code the endpoint is connected to which can be typed into the field.
  • GROUPS: Define groups that have access to your new folder by using the magnify glass icon.

5. when you have this page filled in click save on the right side of the screen. log out, then back in and make sure you folder is available to access.

How-to Guide Series

Hello fellow Sage users/ code writers!

This is the first in a series of “how-tos” relating to using Sage X3 or using the 4GL language to make modifications to the system. While there is a knowledge base out there with excellent information, it’s sometimes difficult to navigate or get a straightforward solution.

The first in this series will begin with a How-to turn a function into a menu item and then place it in the navigation menu to access it.

  1. Navigate to Administration > Authoring > Pages: Menu Items

2. On the right hand menu, select “Create menu item”

3. Fill in the required fields and hit save. Do not assign the menu item to a specific endpoint

4. Now that you have a menu item, we can add it to the navigation menu. To do this, navigate to Administration > Authoring > Pages: Navigation pages

5. Choose “home”

6. Choose “Edit page content” from the right hand menu

7. Choose the module and submodule to place your menu item

8. Click the “Select menu item” under the Menu title

9. Search for the menu item you created, select it, then press the blue check in the upper right corner. The menu item should now be listed under the Menu title

10. Navigate back to the home page and then navigate to your menu item location. Sometimes you have to complete a couple extra steps if it doesn’t appear on the navigation menu.

11. Navigate to Development > Utilities > Dictionary > Validations: Site Function Profiles

12. A verification message will pop up warning that the process might take time to compete. Click yes to continue.

13. When this function has finished, log out of X3 and back in, Navigate to your menu item.