cancel
Showing results for 
Search instead for 
Did you mean: 

Clear Single Payment for Two Invoices

Former Member
0 Kudos

Hi All,

I am working on lock box file.where iam geting the payment information of customer.File contains record type as '1' '2' '5' '6' '4' '7' '8' '9' .They already developed a program based on standard programs like :

RFEBLB00 Import Lockbox File

RFEBLB20 Lockbox: BAI Format Processing

RFEBLB00 Main Lockbox Program

RFEBBU01 Post Temporary Storage Data Call

RFEBBU00 Update Account Statement/Check Deposit Transaction

that program working for Single Payment for Single Invoice.It clear the invoice for Single Payment for Single Invoice.But when they are trying to run for Single Payment for Two Invoices then its not posting.How can i clear the Single Payment for Two Invoices .Is possible to clear the Single Payment for Two Invoices .Please do need ful help ASAP.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188826
Active Contributor
0 Kudos

Lock box uses standard clearing program that you use manually. Check for the error messages, if any. Standard feature shall clear one payment with more than one invoice, provided the necessary references of inovice numbers and the amount match exactly.

Former Member
0 Kudos

Hi Srihar,

Thanks for quick response.But iamnot able to clear single payment for double invoice using lockbox program.

You can see the lockbox file formate below :

Two invoice amount are : 00704 and 12422

Toatal Payment :13126 which is shown below.

100EARTHGRAINFCHICGOEFT0802086022

2EARTHGRAINFCHICGOEFT000000000040008000807

50010000030001080208EARTHGRAINFCHICGOEFT

600100100000131260612097562079900413674 5000336022 5000336022

40010016010011150S801 00000131260000000000 003448560 D20070704 1150

700100100300010802080010000013126

8001000003000108020800010000013126

9000008

T0000000008

After the excute the standrad program, The amount entered(7.04) is difference to the Total of Postings on Account(131.26) based on Payment Advice .so unable to clear amount.I spilted the record tyep 6 into two invoice.But unable to clear amount.Please suggest me to process.

Thanks

former_member188826
Active Contributor
0 Kudos

You are using BAI format, which has limitation to the number of invoices that can be cleared per payment. Changing to BAI2 format enables you to match one payment to multiple invoice references.

BAI2’ format transmissions split the check total into separate invoice references and associated payment amounts. Thus, within a large batch, BAI2 format files will allow a ”partially applied" status in which some identifiable payments within the check total will be matched and cleared, others will land on account. This achieves more ‘hits’ with less manual application required.

As a result, your 'hit rate' percentage of payment-to-invoice matching from each transmission is likely to be higher when using ‘BAI2’ rather than ‘BAI’ formats.

The BAI and BAI2 formats use the same record types and formats for Records 1, 2, 5, 7, 8, and 9. It is the 6 Record and 4 Record that hold the functional differences.

Former Member
0 Kudos

Hi Srihar,

Thanks for your response.Iam using BAI2 format.But iamnot able to clear the payment.Do u have any idea on payment advice tables

AVIK and AVIP tables.Is payment advise may affect on amount.Because The amount entered is difference to the Total of Postings on Account (AVIP) based on Payment Advice and pick the all open items related to Customer .Please do needful help.

Thanks

Former Member
0 Kudos

Hi SIrdhar,

Thanks for your response.Iam using BAI2 formate file. 'The amount entered(AVIK) is difference to the Total of Postings on Account (AVIP) based on Payment Advice and pick the all open items related to Customer ‘3005’ '.So unprocess the file.Do you have any idea on Payment advise tables AVIK and AVIP .Are these tables related to clear payment.Please do needful help.

Thanks