Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

invoice field in BSID

Former Member
0 Kudos

Hi all,

My understanding for clearing invoice created in SD is that when the invoice are created they also hit BSID-XLBNR field. When we recieve payment then lockbox will clear open invoices based on this BSID-XLBNR field.

However somebody says that BSID is secondary index & i can not clear invoices through BSID. But I will need FI core table BSEG for this. He also said we dont get any info. through XLBNR.Can some body explain me the logic behind this invoice clearing.Because I dont know if I am missing some thing.

Thanks

Nik

6 REPLIES 6

andreas_mann3
Active Contributor
0 Kudos

general tcode for invoice clearing is:

a) manually by tcode FB05

b) per batch by tcode F.13

-> principle:

2 or more items are matched by some criteria:

-bukrs, kunnr, xblnr, wrbtr,...

and after clearing and posting itmes go from bsid to bsad and 2 fields of bseg are filled:

-augbl and augdt

hope that helps

Andreas

christine_evans
Active Contributor
0 Kudos

>

> Can some body explain me the logic behind this invoice clearing.Because I dont know if I am missing some thing.

> Nik

Defined in config. Ask your functional consultant how clearing is set up in your company. Though I don't see why you really need to know since clearing should be done through standard SAP transactions and shouldn't concern the Abaper unless they need to include the data in a report. You are surely not proposing to build a custom program to do clearing yourself manually?

0 Kudos

Yes we have to work on a custom progam for clearing.We actually want to clear invoices based on invoice list no. It looks very impractical to me. So to find the best solution I want to know clearing process.

Invoice list is grouping of invoices created in SD.

Edited by: Nik Wallace on Jun 24, 2008 5:25 PM

0 Kudos

If you need to build a custom clearing program you'll still need to find a SAP standard method of doing it; either a BAPI or function module (but I don't know of one offhand) or, failing this, a BDC that you will create from one of the clearing transactions mentioned further up.

You cannot wade in and start doing direct updates to SAP standard tables, which seems to be what you want to do.

0 Kudos

Actually we want to create a program which will post payment in lock box according to SAMNR -collective invoice field in BSID or BSEG.

I am a functional consultant . So i am not very sure can you please elaborate on this.

Edited by: Nik Wallace on Jun 24, 2008 5:44 PM

0 Kudos

>

> Actually we want to create a program which will post payment in lock box according to SAMNR -collective invoice field in BSID or BSEG.

>

> I am a functional consultant . So i am not very sure can you please elaborate on this.

>

> Edited by: Nik Wallace on Jun 24, 2008 5:44 PM

Well, I am only an Abaper. I don't recognise the process you describe but then how invoices get processed is a functional area and I wouldn't be involved unless I need to understand the data eg to write a report.

What I do know is that you do NOT do direct updates on SAP tables because the table relationships are more complicated than you think. When a SAP program posts a document records are created in multiple table eg BSEG which is a cluster table containing all FI line items, customer lines are created in BSID, GL code lines are created in BSIS, records for all lines which hold controlling objects are posted to controlling table COEP, records for all lines that hold special ledger objects are posted to the special ledger table whose name I forget etc etc. If you update one of these tables eg BSEG and not the others then your data will get out of sync, your system will get into a mess, and SAP could even stop supporting you.

If what you are doing is a standard SAP process, there should be a standard SAP program to carry it out. Ask in the appropriate forum. If there isn't, then you'll still need to find SAP standard ways of updating the database; there are BAPIs and standard programs available to post FI documents and there is always BDC.