Residual items processing in FI

[Former Member]

Hi,

For my program, I have to check for fully paid customer invoices and send a flag to another system if it is fully paid. I have to check whether an invoice is closed with residual payments also, if residual items are present for an invoice I should not send the flag.

I'm quite new to FI, so please guide me:

1. How to check whether residual items are present for a closed invoice?

2. To test,how can I do an incoming payment with residual items? (I heard if we pay $80 for a $100 invoice using the residue option, SAP will close the invoice as a fully paid invoice and create another invoice for $20)

3. How will be the original invoice and the invoice created for the residual amounts be linked?

4. Can anyone provide me a link or document containing FI basics?

5.Can anyone provide me all FI related transactions and tables?

If anyone can guide me, it will be really helpful. Thanks.

Priya

[Former Member]

Hi priya,

Check the following links.

http://www.allsaplinks.com/tables.html

http://www.sapgenie.com/abap/tables.htm

http://www.sap-img.com/sap-download/sap-tables.zip

Also check the following link for FI

http://www.sapgenie.com/sapfunc/fi.htm

Regards

Praneeth

If helpful award points.

[Former Member]

Hi Priya

The first thing is SAP closed an invoice only if it's fully paid.

So if you have an invoice for $100, you'll be able to close it only if you post a payment for $100. If you can post a payment for only $80, the system won't close the invoice, only when the rest of payment'll be posted it'll be closed. In this case the system'll post a document for a partial payment.

So the situation'll be:

- The invoice is open

- A partial payment for £80 is posted.

Both these two documents are open so you can find them in BSID (Secondary Index for Customers) table.

The link between two document is created by fields REBZG,

REBZJ and REBZZ

If the number and fyscal year of invoice are 100 and 2006:

- Select the invoice:

DATA: INVOICE LIKE BSID.

SELECT * FROM BSID INTO INVOICE

WHERE BUKRS =

AND GJAHR = '2006'

AND BELNR = '0000000100'.

ENDSELECT.

- Select the partial payment

SELECT * FROM BSID WHERE BUKRS = INVOICE-BUKRS

AND KUNNR = INVOICE-KUNNR

AND REBZG = INVOICE-BELNR

AND REBZJ = INVOICE-GJAHR

AND REBZZ = INVOICE-BUZEI

ENDSELECT.

This is the situation if your company uses the standard partial payment, of course.

So you should ask how the company uses to manage the partial payment as it could use a not standard flow

Max

[Former Member]

What would the logic be for Residual payments