Expose the "Source" in a Transaction Distribution in FE NXT API

I have queries that utilize the source information from a transaction/distribution from the our on-premises FE, but now that we've moved to FE NXT I can't replicate the link from an invoice to a transaction. Can the transaction source information be exposed via the API? With the NXT interface there is a listing.

With NXT If I use General Ledger > Project > select a project > pick a month, then click on an account I get a screen that has the data I want. Post date, Transaction, Debit, Credit, Journal, Journal reference, Source type and Source number.

I'd like to be able to have that source data available for local database use.

Thank you,

Daniel

  • Daniel Maxwell
  • Jul 8 2025
General Ledger API
  • Attach files
  • Daniel Maxwell commented
    24 Sep 13:11

    In the Blackbaud on-premise solution we utilized the GL7TRANSACTIONS table column SOURCERECORDSID and the SOURCETYPE column. In our system the SOURCETYPE was 268 and the SOURCERECORDSID was the AP7INVOICESID from the table AP7INVOICES.

    I could really use the ability to use the API make the connection from a general ledger transaction distribution to the invoice that created it.

    Attachments Open full size

Related ideas