During the SAP conversion, the commissions statements will be emailed in a pre-formatted file in the Microsoft Excel .xlsx file format. This file may be read directly by OASIS using the following steps:
- Create a payment
- Load the .xlsx file
- Reconcile (look for commission errors)
Loading the .xlsx file
Once the payment is created, the .xlsx file may be dragged and dropped on the payment. Alternatively, the "Load Invoices for Payment (from XLS)" maybe selected from the "Philips" menu on the payment:
The invoice and amount paid on the invoice will fill in as it did in the past when downloading directly front the server.