Open Item and Line Items are not matching

[Former Member]

Hi Gurus,

I ran the EFT for vendor #1600109 for payment on 10/18/07. If I run the vendor open items report (ZFI019) for today, it shows the balance net of the EFT that is $203,466 ( $263869 - EFT Value is $60,403).

When I ran the vendor line items display (FBL1N), it shows all the invoices including the invoices paid on the Oct 18 EFT $263,869 which is (2034,66+60,403).

User wants the open item report should tally the line item display.

I will assign good points.

Thanks for your help

Prashanth

[Former Member · Accepted solution]

II think you are running a custom program for your EFT. I dont know what does it stands for. Pl check the logic behind your Zprogram to check what value it brings in. FBL1N is a standard SAP program. May be you need to sit with a technical consultant to understand the program and make modifcation suitably.

[Former Member]

Hi Gurus,

Thanks for your help.

Prashanth

[former_member197269]

Hi Prashant,

Please check the logic used in the zprogram, for table BSIK (open items) & BSAK (closed items)

There must be some small correction needed.

Hope this helps.

[Former Member]

Hi Gurus,

EFT is working fine. But the Vendor Open item Report (Custom Report) and Vendor line item report (FBL1N) is different.

We are looking a balance for a vendor as on 15th where the balances are not matching between the reports but if i run FBL1N on 18th the balances are matching.

Clearning date is 18th

Posting Date is 15th.

Thanks

Prashanth

[Former Member]

Hi Gurus,

No, still both the reports are showing difference as i explained before.

Can you please let me know why there is a difference and how to solve the problem.

Thanks

Prashanth

[Former Member]

I guess the issue is around the due date.

if invoices are being paid on the 18th, if you run it today it will show as open.

In FBL1N you can change the open items at key date, if you change this to the 19th, they should balance.