Show TOC
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.