FBL3N Open items

[Former Member]

Hi,

I have a requirement where for a G/L, i have to match the total for my report.

I will be taking all open items from the G/L and it should match with my report output. But it is not matching. The problem is in G/L account from FBL3N some accounts are shown as open, but i cannot find those entries in BSIS table, that entry exists in BSAS table, which is the cleared items table.

Can any one let me know how to sort this problem.

Thanks,

Raju

[former_member186491]

Hi Raju,

I guess, you may be giving "Open at Key Date" other than Current Date. Please note that Tables contain data as on current status while you can run FBL3N as per your deisred date.

Further, if you are witnessing that few entries are into BSAS, then you need to check within that table itself as to when those entries have been posted. Based on these two you can easily get why your data are not matching with the report-output.

Please cross-check that.

Thanks.

Kumar Saurav.

[Former Member]

Hi,

BSIS Table cintains Open Items, when ever you use retention payment or advance payment at that time payments used to be done in multiple installments.

e.g. If Vendor A to be paid 3000 in 3 installments,

1st installment of 1500-------> 2nd of 1000 -

---

> 3rd of 500

Intially BSIS will have 3000 Rs as open item and BSAS will have no entry

Once 1st installment will be cleared -

---

BSIS will have 1500 as open and also 1500 as cleared in BSAS table

2nd Installment cleared -

---

BSIS will have 500 open

-

---

BSAS will have 2 cleared line items1500 and 1000

3rd installment cleared -

---

BSIS Will have no entry

-

---

BSAS will have 3 cleared line items, 1500,1000 & 500.

So I think you need to get data and check entries in both the tables as once item gets cleared BSIS table will be updated or all entries will be removed from BSIS at the same time BSAS will have that entry with clearation details.

Please check, hope it helps.

Regards,

Umang Mehta

[Former Member]

Hi,

Thanks for your replies.

My problem is if the doc is cleared, then in FBL3N, you should not find it when you execute with open items. You should find only when you are executing with options cleared/all items as i am running FBL3N for the current date. But i can see the document whether i execute in any of the three modes. So how to find out this.

I have to execute FBL3N with open items option and my report for open items and the totals should match. But as in the above case as i am unable to find in BSIS and can find it when executing FBL3N with open items option, my totals are not matching.

Pls let me know how to solve this.

Thanks,

Raju

[Former Member]

Hi,

In you report if are selecting as on date open items, select records from BSIS directly.

And from BSAS, make selection as select records which is cleared after the given date.

i.e clearing date > as on date.

Thanks and regards,

Kannan N

[Former Member]

Hi,

Enhance the FBL3N Tcode Program.

In the Standard program export the final internal table and import the internal table in the customizing program and use it.

then the values will match Perfectly.

I did same thing for fagll03 tcode(GL Account open items).