You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to Display Only Receipt/Transaction Number (Without Labels) in AR Statement Report

in Receivables & Collections

Hi all,

We have a requirement to customize the Generate Statement Report and display only the Receipt or Transaction number in Reference field (AR_STATEMENT_LINE_CLUSTERS table)

Seeded Report Path: /Shared Folders/Financials/Receivables/Receivables Balances/Generate Statement Report

Data Model Path: /Shared Folders/Financials/Receivables/Receivables Balances/Data Models/Statement Generation Data Model

Currently, in the seeded BIP report output, the Reference field shows labels along with the numbers, for example:

Check - Conversion: RCPT12345 for Payments , or

On Account: RCPT98765 for On-account receipts, or

Credit Memo: TESTINV123 for Credit Memo

However, the business requirement is to display only the transaction number (for example, RCPT12345 or RCPT98765 or TESTINV123) without any text prefixes or labels.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!