Down payment query

[Former Member]

hi,

Do down payment requests entered through FBA1 (Transaction type-A, Special GL indicater-F) show up in FBL5N report?

I have one credit item of $1000 showing as open item in FBL5N.

And if I go in BSID table it shows two open itemsof $1000, one credit (which i am able to view in FBL5n) and other debit entered through FBA1.

In Aged Trial Balance report, it is setting off both line itmes and giving total as zero for that particular customer

User wants to know if there is open item in FBL5N then why it is not showing in Aged Trial Balance.. but in reality it is setting off which I was able to view when I debugged the report.

Actually it the DP request should not set off the amount, but it is doing for one custoerm and not doing for other...

Can anybody help

[Former Member · Accepted solution]

If it shows up as an open item then you need to run a clearing for that item. Also, check what the clearing is based on ie; reference field. Make sure both entries can be tied together with your automatic clearing definition so that clearing can be done.

pls assign points if helpful as a way to say thanks.

[Former Member · Accepted solution]

Hi Dave,

The thing I have 2 customers one is X and other Y. The initaial down payment was made by them. Now user has entered dp request for both customer and both appears as open in FBL5N.

Now if I go to Aged trial balance report, in X customer it shows intial dp payment as open which it should show and in Y customer the dp is getting set off against the dp request (i found by debugging the report)which it should as it show open item in the Aged trial balance report.

Do you have any idea about this

thanks

[Former Member · Accepted solution]

What is the code that is selecting the dp in your aged trial balance? It sounds as though the select is not correct.

[Former Member · Accepted solution]

Are you talking about tcode...it is customized one..

But there is nothing wrong with report becuase it was that it should not show the itme of cust X as open..

[Former Member · Accepted solution]

If it is showing as an open item in FBL5N then it is open. You must close it. Your report must show what is really open and what is really closed. BSID are open and BSAD are closed. If your items are in BSID theye are open. When they are in BSAD they are closed.

[Former Member · Accepted solution]

Hi Dave,

But a noted item i.e a downpayment request is being shown as an open item in BSID..how is that possible..

[Former Member · Accepted solution]

If your entries show open in BSID then and your report shows one as closed then you program logic is wrong. You need some debugging in your program.