Quantum Ideas Portal
Welcome to the FIS Treasury and Risk Manager - Quantum Edition Aha! Ideas Portal.

By visiting this portal, you will be able to contribute towards the evolution of the Quantum solution through interactions with other Quantum users, FIS trusted partners and FIS staff from around the world. Each Portal User receives 5 votes. Each user is allowed 1 vote per idea. Votes are reset when an idea is in a final state i.e. Shipped (delivered in the product).

Users will receive weekly email updates that highlight new activity. Users will receive emails for their created ideas when:

  • Status changes

  • Comment changes

Be aware that when you post content, other community members will see your name. FIS is not responsible for content posted by other Aha! Ideas Portal Users.

Add a new idea Subscribe
Status Already exists
Created by Patrick Armstrong
Created on Nov 11, 2024

RELATED IDEAS

Enable Additional Query Filters for G/L Interface

The G/L Interface currently only allows you to filter by Date, Entity and Posting Source.

It would be helpful to be able to filter by Transaction Type, Instrument or Deal Number, as sometimes we need to select specific deals/line items which we need to export. Currently, we need to export all available line items, and then manually edit the interface file to add/remove the necessary line items.

  • Attach files
  • Patrick Armstrong
    Reply
    |     Jan 6, 2025

    The workaround you have proposed does not meet the requirement set out in the idea. The requirement is to enable the user to run the GL Interface query for specific deal parameters, for example, if they had an ad hoc requirement to export the accounting for only 'SI: Interest Rate Swap' deals. This is a valid scenario for us, if we are unwinding positions. The accounting for all other Transaction Types would be exported by the next AG Scheduler run of the query.

    The use of the GL Interface Mapping settings to DO NOT INTERFACE specific accounts, instruments, etc. means we would need to exclude ALL other Transaction Types for this ad hoc requirement, which is not practical. The use of DTL filters the contents of the export file, but this does not meet the requirement set out above.

  • Admin
    Phil Morton
    Reply
    |     Dec 31, 2024

    The GL Interface Mapping does allow specific Transaction Types / Instruments to be excluded from the Interface File by selecting ‘DO NOT INTERFACE’ on the Debit Account selection and Credit Account selection. This would be a static setting so apply to all Interface Runs using that mapping. The excluded items would be marked to never be interfaced.

    If you are Interfacing using a Data Transfer Location to output a File, then you could include validation to exclude specific items within the Template definition (that defines the format of the output file). Once the File has been generated for that Interface Run, it would not be possible to later initiate a new Interface run to pick up the excluded items.