12-03-2007 5:17 AM
Hi,
Can any of you pls let me know , what the flow of data is in A/R process i mean for open items and cleared items.
1. If a open item is cleared will the document still be in BSIDand BSAD or BSAD only.
2. what is the link which we can use to tie the records in BSID and BSAD.
any help would be appreciated and points will be awarded.
Thanks
Priya
12-04-2007 4:30 AM
continuation from previous message.
in summary i want to calculate at any point for a Customer how much she/he owes and the breakup of invoices on the amount he/she owes.
12-03-2007 8:21 AM
...<i>1. If a open item is cleared will the document still be in BSIDand BSAD or BSAD only.</i> -> in BSAD (and BSEG with augbl and auddt filled) only
(look 2. partial payment; in this case there can be items in bsid and bsad)
<i>2. what is the link which we can use to tie the records in BSID and BSAD.</i>->possibly is a partly clearing: so if there' are 2 or more items in one document and 1 is paid the other not; link is the key bukrs belnr gjahr
A.
Message was edited by:
Andreas Mann
12-03-2007 8:27 AM
12-03-2007 9:13 AM
Hi Priya,
1.) If a open item is cleared then the item is moved to table BSAD and is deleted from table BSID. Table BSEG is cluster table for BSAD and BSID. which contains both cleared as well as open items.
2.) To get both cleared as well as open items for a given selection criteria you need to query both BSAD and BSID table based upon the clearing Date along with other selection crietria as per your requirement.
e.g. If you want to get open items for a particular company code on 20.11.2007 then you need to query these two tables in the following way :
Select Bukrs,.....
from BSID
into gt_BSID
where Bukrs eq p_bukrs
and .......
and <b>Budat LE P_OPEN.</b>
Select Bukrs,.....
from BSAD
appending corresponding fields of table gt_BSID
where Bukrs eq p_bukrs
and .......
and <b>Budat LE P_OPEN</b>
and <b>AUGDT GT P_OPEN</b>.
Here P_OPEN is the date on which you want to see the open items for a cust. As mentioned in this example it can be 20.11.2007
Please try this. Should help you, In case some more information is needed please revert back.
Regards.
Lalit kabra
12-04-2007 4:28 AM
Thanks everybody for the prompt answers, espeically Andreas/Lalit , before i close the topic as answered, i want to clarify one more aspect on this.
1. If it is a partial payment , will the BELNR be same for both the entries, i.e Original balance and the partial payment, i think it comes with two different BELNR, correct me if i am wrong
2. Also will the the invoice no and the BELNR be the same or different, this is becuase i want to list out all the transactions from BSID/BSAD all the open invoices and the balances paid such as down payments, partial payments etc.,
Thanks again
Priya
12-04-2007 7:13 AM
Hi Priya,
1.) Accounting Document Number BELNR would be differernt for bach transaction you make. whether it is partial payment or full paymnet.
2.) The Invoice no and Belnr is same in FI. The two documents can be related by a field called Clearing Document ( AUGBL) which is same for the two related documents.
The nature of payment can be checked with field DEBIT/CREDIT Indicator ( SHKZG).
Based upon the value in this field ( S or H ) you can come to know whether Payment has been made or some purchase has been done by the customer and then you can do the final calculation.
Hope this answers your questions.
Reward if helpful!
Regards,
Lalit Kabra
12-04-2007 4:30 AM
continuation from previous message.
in summary i want to calculate at any point for a Customer how much she/he owes and the breakup of invoices on the amount he/she owes.
12-07-2007 9:40 AM
Hi Priya,
hope this would have solved your problem.
Regards,
Lalit Kabra
Message was edited by:
Lalit Kabra
12-07-2007 10:34 AM
Hi Priya,
I am an ABAP consultant i cant explain wht u need but i can help u
with a link where u can find the doc related to ACCOUNTS RECEIVABLE
here is the link
http://www.mwr.navy.mil/mwrprgms/sap/accounts_receivable_july2005.pdf
I hope u can download this and gothrough once
hope this is helpful for u
Reward points if it is useful...
Regards,
Sreenivas
12-20-2007 8:07 PM
thanks , everybody for the help, i have assined points to all the relevant answers.
once again thanks