How to configure portal expense claims in Sage X3

By | March 27, 2018

1. Setup variable to be updated.

configure portal expense claims

Note: Uncheck Expense notes

2. Setup Variable for a portal default value as well as the maximum allowable value to be claimed via the portal.

These can be configured as separate variables or can comprise the same variable.

Setup Variable for a portal default value

company or folder level inputs

Note: Check the Folder, The variable for the default and/or maximum values will usually be a company or folder level inputs

3. Input the default and maximum values.

Access either folder values or company values and input the default and the max values

Input the default and maximum values

4. Create an Expense code.

This will be the option available to the employee to select from via the portal.

Create an Expense code

Expense codes

Validity– If you intend to only allow this claim during a certain date.

Default Value– Default Portal Value must be linked to the variable created. If this is left blank there will be no default

Cap– Maximum Value must be linked to the variable created for this purpose. If this is left blank there will be no maximum applied (very dangerous to ignore!)

5. Add a Pay Preparation Variable.

This is required so as to advise X3 which already configured pay plan variables are available for use as portal expense claim variables.

Pay preparation variable

Pay list of variables

Note: Select LISEXS and click Variables tab. Add the variables to be updated hear.

6. Configure expense note transfer

This is required to link the applicable variables to the expense codes and also to advise which column in the portal updates the variable (eg. Quantity or Amount)

Expense note transfer

Configure expense note transfer

Note: In services select the code and In Variable code select the applicable variable. Only variables defined as pay preparation variables in the previous step will be available for selection here.

Update the variable in X3

Note: The data in Amount element column is displaying here. This tells X3 which value in the portal must update the variable in Sage X3.

configure portal expense claims