Mass posting of collective invoice via MIRO / MRHR
The freight forwarder and other preferred vendors send out collective invoices weekly based on excel files containing about 200 entries. Currently Logistics verifies the invoice entries and accounts payable posts them manually via copy paste transaction.
For the items which are posted directly to a GL account I found the RFBIBL program which posts the items automatically based on the excel file.
However most of the items are referring to a purchase order line item and contain only the following information for PO number, line item number, quantity and amount.
Is there any program which runs based on these information and retrieves the account assignments from the purchase order line item and posts everything automatically?
Thank you very much for your information!