on 12-21-2011 6:48 AM
HI Experts,
When we go to FBL5N we can see overdue of a particular customer (in redbox), my question is in which table and field it is going to sit.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mayank,
suppose the customer has over due Rs123 (in red box), when i am going to BSID where i can see the amount .
Dear Rahul1234,
What is your difficulty in putting the table BSID in se16n and excute the table and find out under which field, the value for overdue is updating?
Thanks & Regards,
Hegal K Charles
Edited by: Hegal . K . Charles on Dec 21, 2011 12:59 PM
Hello Hegal K Charles,
Value is there but how can I identify that this the the overdue amount. please tell
Edited by: Rahul1234 on Dec 21, 2011 8:37 AM
Select any customer code and run FBL5N.
You can see overdue (eg 123rs) if it exists for that customer code.
Now in se11 or se16n , select the table BSID.
Execute.
Input the Customer code and RUN.
Check under which field does this figure 123 come against the customer code.
Hope it is clear.
Hi Hegal K Charles,
You are right, but you are not getting my point.
I gone to fbl5n for a particular customer i got rs 123 is overdue (in redbox). ok
now i have gone to bsid table there in amount feild i am geting the amount rs 123 but how can i know by seeing in bsid that this amount is overdue??
Dear Rahul,
Table BSID is for open items once the item is cleared it moves to BSAD. Hence all the items appearing in BSID are over due items.
Mayank
Then in FBL5N why i am getting overdue (red box) in front of rs 123 not in other amount still all other amounts are also in bsid table.
Edited by: Rahul1234 on Dec 21, 2011 8:58 AM
Check BSID table.
Execute with following field:
Document Type-BLART
Currency-WAERS
Amount-WRBTR
Clearing-AUGDT (as BLANK)
Clrng doc.-AUGBL (as BLANK)
Posting Date-BUDAT
Baseline Date- ZFBDT
Payt Terms- ZTERM
Days 1- ZBD1T
Days 2- ZBD2T
Days net -ZBD3T
Check there that Posting Date-BUDAT should not be equal Baseline Date- ZFBDT
JP
Check whether table BSEG helps you.
if the system date > net due date , then it will be RED .
Seems like BSID will give the list of all open items , irrespective of whether it is due or not.
Dear friend,
Search before posting.
Hi Rahul1234,
check the forum before you post the thread you will find the answer.Check this below link it would be helpful
Pradeep
Hi
Please find the below link
Thanks
Dasaradha
Open Items of the customers are stored in table BSID. sum of the open items are shown in FBL5N.
You can check this table you will get the solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.