How to find MIRO invoices are fully paid ?

[nirmanijk]

Hi Guys,

Need some help to build logic for the following:

A logic to find whether the full invoice amount was paid after F110 is completed ( miro invoice ).

The purpose is to pass whether the invoice has been fully settled and the corresponding date to a vendor portal.

Appreciate a swift response 🙂

Thanks in advance

[Gustavo_Vazquez]

Hi Dona,

You could create a custom report which reads cleared Items (BSAK) in which the Invoice has got BKPF-AWTYP = RMRP. Then check in the Payment document if the Bank Item has been cleared or not (BSAS).

Another option is setup Liquidity Planner.

Kind Regards

[former_member767389]

Hi,

Pass the MIRO document to BKPF-AWKEY. Pick BKPF-BELNR(ignore the year with the document number) and GJAHR

Pass to table BSAK-BELNR and GJAHR if data exist it means document got cleared(BSAK-AUGBL,BSAK-AUGDT consider this fields to get clearing document number and clearing date) if not the document is still open item.