CTX Disbursement Format

When generating ACH payments in CTX format or Disbursement Format with Disbursement Sub-type selected as CTX, the system allows sites to include a CTX EDI Reference ID Qualifier and associated CTX EDI Reference ID Information. This data is included in the payment file to provide vendors with the important remittance details, such as invoice numbers or customer account numbers. These fields are conditionally required based on the disbursement format selected on the vendor line. Proper configuration ensures that remittance information is passed correctly through the payment process into the EF ACH file.

The CTX EDI Reference ID Qualifier and CTX EDI Reference ID Information fields only available on the Accounting tab of the General Accounting Expense transaction, must be used only when the Disbursement Format on the associated Vendor Line is set to CTX or Disbursement Format with Disbursement Sub-type selected as CTX.

With the Disbursement Sub-type feature enabled, sites can define multiple disbursement formats that fall under a broader category. For example, in addition to the standard CTX format, formats like CTX1, CTX2, and so forth, can be configured and assigned the Disbursement Sub-type of CTX.

To ensure correct usage of CTX-specific fields, a configurable validation can be applied. This validation prevents users from populating the CTX EDI Reference ID Qualifier (RF_ID_QLFR) or Reference ID Information (RF_ID_INFO) unless the disbursement format is CTX or one of its defined sub-types.

Configurable Validation: To validate that the CTX EDI Reference ID Qualifier (RF_ID_QLFR) is not populated when the disbursement format is not part of the CTX group:

  • AMSStringUtil.strEqual(R_GEN_DOC_CTRLImpl.getDocControlInfo(this.getDOC_CD(), this.getSession()).getDOC_SUBTYP(), "GAX") && (DISB_FRMT !~ [ "CTX", "CTX1", "CTX2" ]) && !AMSStringUtil.strIsEmpty(RF_ID_QLFR)

Updating for new Disbursement Sub-type: If a new disbursement format (for example, CTX3) is introduced and mapped to CTX via Disbursement sub-type, update the formula accordingly:

  • AMSStringUtil.strEqual(R_GEN_DOC_CTRLImpl.getDocControlInfo(this.getDOC_CD(), this.getSession()).getDOC_SUBTYP(), "GAX") && (DISB_FRMT !~ [ "CTX", "CTX1", "CTX2", "CTX3" ]) && !AMSStringUtil.strIsEmpty(RF_ID_QLFR)

Applying the Same Logic to CTX EDI Reference ID Information: To validate that the CTX EDI Reference ID Information (RF_ID_INFO) using the same logic, simply replace RF_ID_QLFR with RF_ID_INFO in the formula.