Wiki

Case Status
Log In

Wiki

 
Philips Connectivity (DCO)»Loading Philips XLSX pre-forma…
  • RSS Feed

Last modified on 1/4/2017 3:35 PM by User.

Tags:

Loading Philips XLSX pre-formatted file

Overview

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:

  1. Create a payment
  2. Load the .xlsx file
  3. Reconcile (look for commission errors)
  4. Post

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.