Improvements to Lockbox Processing

Scope of Functions

• Lockbox Detailed Statistical Report (RFEBLBR1)

After importing lockbox files, you can obtain more information on lockbox check postings by running report program RFEBLBR1 . There are three parts to this report:

• Lockbox posting summary for a given date

• Statistics on check posting status with user-defined "successful hit rate"

• Detailed information on general ledger and sub-ledger accounts postings, and residual items list.

You start this report program using transaction FOEBL1.

• Multiple deductions related to a single invoice

Deduction amounts used to be restricted to a single reason code passed on with the invoice clearing information in the BAI2 format. Using this enhancement, you can identify multiple deductions relating to a single invoice specifying a reason code for each deduction. These deductions are transferred to subposition items of the payment advice line item, and can be viewed and maintained in normal payment advice editing. The typical posting that results is one document line item per identified deduction.

Customer projects with prior Releases noted that customer line item postings could be made by repeatedly referencing the same invoice number in subsequent lines of the BAI2 data. This development will assist tying these postings togther logically to the same invoice number to which they relate. Functionally, the first invoice item in the BAI2 file must identify the payment associated with the invoice with additional deduction items, and not transferring a payment amount but only the deduction in the deduction amount field.

• Payment advice clearing enhancement for large open item customers

Performace in clearing and open item selection is poor if both the open list on the customer and the advice item list are large. This problem usually arises with customers who received large remittance information files, perhaps via EDI, which are then used to generate payment advice notes for clearing processing. It is not uncommon that whereas open-item selection lists might take only five minutes to appear in a manually executed clearing for such customers, clearing with such payment advice notes might take significantly longer or the process might time-out.

A flag can be set on the payment advice header to trigger a clearing search using indexes which allow the performance to return to the level of typical open item listing. As this is a problem that does not affect many customer accounts, it is not necessary to trigger optimization on all processing.