FX Realised Automation

• Foreign exchange (FX) realised documents are used to enter a correction on fully allocated purchase or sales documents where the currency outstanding balance is 0 but the base currency is not.

  Tip

  • If no tolerance is set in the Environment settings, a 5% tolerance will be assumed.

• The document type being used for FX realised automation must have Allow FX set.

• A FX gain or loss occurs due to Exchange rates fluctuating between the Document date and the Transfer date.

• There are two FX realised types available: sale or purchase, the process for running each type is the same however the parameters vary slightly with either customer or supplier fields being available.

---

How to view FX realised automations

Viewing FX realised automations

Select Document / Automations from the Settings section of the pulse menu -

Note

This is an example screen shot of the pulse menu.

Position of the menu items within pulse will vary according to available options and dependant on personal screen resolution.

or enter Automations in the Quick Launch Side Menu.

This will then show the Automations on the system where normal customisation of Sets can be used.

Tip

To modify the columns displayed, select in the top right of the page, then tick/untick the information you want to see or not.

Select FX realised automations from the list of Automations.

How to create a new FX Realised Automation

Create FX Realised Automation

If not already available, create a new Automation for the FX Realised Automation process.

1. Select Automations from Viewing FX Realised Automation above.

   

2. Select New.

   

   

   • Automation type: Select from the list of Automated Document types.

   • Description: This is defaulted to be the Automation type description. It should be overwritten if multiple automations are created for the same automation type.

   • From doc type: Select from the available Document type(s), the ones you wish to be included in the document(s) evaluated.

   • To doc type: Select all possible destination Document types for the automation.

   • Default: Select the Document type for the document(s) that will be created.

   • Trigger: This defines when the automation will be run e.g. Automatically upon posting means the automation will automatically run for the selected documents upon posting into the General Ledger.

     

3. Criteria Tab:

   

   • Date from: Leave this date blank if you want to select all available documents or enter a date to restrict documents to be greater than or equal to this date.

   • Date to: The date to will default but alternatively you can select the latest Document date that you wish to include for your FX realised document.

   • Legal Entities: Leave parameter blank to select all Legal Entities OR select Legal Entity(s) to restrict the FX realised automation.

   • Currency: Leave parameter blank to select all OR select Currency(s) to restrict the FX realised automation.

   • Suppliers or Customers: leave black to select all or select supplier(s) or customer(s) to restrict the FX realised automation.

   • Tolerance amount max: Leave blank if you want the parameter to default to the Environment settings or enter a max tolerance for the FX realised automation.

   • 'Submit': If this checkbox is ticked, the FX realised document will be automatically submitted for authorisation. If unticked, the documents will be created in a draft state.

4. Select Create.

   

How to run an FX realised automation

Running FX realised automations

1. Select the FX realised automation (sale or purchase) then press Run.

   

2. Enter the automation criteria.

   

   Note

   The only difference in parameters is that a Sales FX realised shows Customer and Purchase FX realised shows Supplier instead.

• Date from: Leave this date blank if you want to select all available documents or enter a date to restrict documents to be to greater than or equal to this date.

• Date to: The date to will default but alternatively you can select the latest Document date that you wish to include for your FX realised document.

• Legal Entities: Leave parameter blank to select all Legal Entities OR select Legal Entity(s) to restrict the FX realised automation.

• Currency: Leave parameter blank to select all OR select Currency(s) to restrict the FX realised automation.

• Suppliers or Customers: leave black to select all or select supplier(s) or customer(s) to restrict the FX realised automation.

• Tolerance amount max: Leave blank if you want the parameter to default to the Environment settings or enter a max tolerance for the FX realised automation.

• 'Submit': If this checkbox is ticked, the FX realised document will be automatically submitted for authorisation. If unticked, the documents will be created in a draft state.

3. Press Submit.

• The correction document will be created if necessary and can be found in the allocations tab in the invoice.

---

Updated May 2024