Banner - Configure Custom Invoice Numbers for Unimarket Integration

  • Updated

Use this procedure to configure Banner, so invoices received from Unimarket use custom invoice numbers. This ensures invoice numbering remains consistent across Banner and Unimarket.

If you need more details or an example screenshot of the output, please contact the Unimarket Support team.

 

Purpose

Enable custom invoice numbering for Unimarket invoice feeds in Banner.

 

Limits & Notes

  • Each Unimarket feed requires a unique two‑letter code.
  • Changes take effect only for new invoices processed after configuration.
  • This setup does not retroactively update existing invoice numbers.

 

Prerequisites

  • Access to Banner forms FTMSDAT and FOMFSEQ
  • Knowledge of your institution’s main Chart of Accounts (COA)
  • A unique two‑letter code to identify the Unimarket feed (for example: UM, UI, or EI)

 

Steps

Step 1: Configure FTMSDAT

  • Open the Banner form FTMSDAT. The cursor opens in the Entity or Usage Code field.
  • Enter the following values:
FieldValue
Entity or Usage CodeFGBTRNI
Attribute CodeSYSTEM_ID
Optional Code Number 1EPROC_[your code] (example: EPROC_UM)
Optional Code Number 2(Leave blank)
Level(Leave blank)
COAMain Chart of Accounts
Active StatusChecked (Active)
Effective DateToday’s date
Termination Date(Leave blank)
Next Change Date(Leave blank)
Description or TitleUnimarket Invoice Feed
Short TitleAuto‑populates (or enter a custom value)
DataDS

 

  • Click Save.
  • Result: A confirmation message appears in the upper‑right corner indicating the record was saved successfully.

 

Step 2: Configure FOMFSEQ

  • Open the Banner form FOMFSEQ. The cursor opens in the System ID field.
  • Click Insert to create a new record.
  • Click the ellipse (⋯) next to System ID, to open the FOQSDLV search screen.
  • Locate and select the EPROC_[your code] record created in FTMSDAT, then click Select.
  • Back in FOMFSEQ, complete the following fields:

    FieldValue
    Document Number Prefix[your code] (example: UM)
    DescriptionUnimarket Feed (or your preferred description)

 

  • Click Save.
  • Result: A confirmation message verifies the record was saved successfully.

 

Results/Validation

  • Invoices received from Unimarket now generate custom invoice numbers using the configured prefix.
  • Invoice numbering is consistent between Banner and Unimarket.