Skip to Content
0
May 13, 2008 at 03:46 PM

Lockbox G/L Journal 1

107 Views

We are in ECC 6.0 with New GL Activated.

We are implementing the lockbox process, BAI2 format, and we have completed the test fase in Quality and transported to production.

When the user processed the first two files in production, he didn't get the Cash Journal:

Debit = G/L Bank Account

Credit = A/R Clearing Account

The system create (as expected) the journals for AR Application:

Debit = A/R Clearing Account

Credit = A/R

We executed the transaction FLB2 with the following parameters:

Procedure = lockbox

Input record format = BAI2

Invoice numbers = 3

Enhanced Invoice No Check = selected

Algthm: checks with advice = 001

The user executed the same file in Quality and everything worked properly.

We have compared configration and security but we cannot find the reason of the problem.

Do you have any idea what should I check to find the reason of the problem and fix it?

Thank you very much!

Rafael

We have found the problem:

We have a validation rule to check for line item text for documents posted using FB50, FV50, FBVB, FBS1 and FB01 (FB01 to catch the transactions without text from F-02).

When the postings are done throu lockbox import (FLB2) it uses FB01 to do posting in the posting area 1 (Dr Bank/Cr Ar Clearing), the transaction errors out as we do not pass the text in the lockbox input file.

Algthm: checks without advice = 001.

Solution:

Eliminate FB01 from the validation rule.

Edited by: Rafael Bermudez on May 13, 2008 11:56 PM