Reporting Considerations in Orders

The Reporting Tool in OASIS makes a number of assumptions when working with orders. Some users may have business needs beyond what is described in this document. Customization of OASIS is possible, but the following assumptions are made for standard OASIS reports:

Bookings

Bookings reports may be run with the perspective of the customer (Sales Reporting) or the vendor (Purchases). In all cases, the order is considered "booked" in OASIS once the order is created. The order "entry date" identifies what day/month/year the order's values appear.

• Sales reporting (bookings)- only shows the customer sell price. Any margin is factored in, even when the report is run by manufacturer.
• Purchases (bookings)- only shows the vendor cost. Note: if the vendor under or over invoices for a product, OASIS will not adjust the profit margin for the order. It is the user's responsibility to identify the issue and apply the proper change order to OASIS.

For resell orders, bookings reports may vary. A customer-centric bookings report will show the sell price and order margin (in addition to any commission or overage). However, resell orders will only report the "cost" when run from the perspective of the vendor (with any commission or overage).

Backlog

Backlog is defined as booked orders that have not been fully invoiced and fully paid. If payment is not expected on an order because there is no profit (margin, commission, or overage) then it is removed from the backlog. Orders where no more payments are expected (and earrings were expected) should be corrected if the transaction in OASIS is not correct, and the order should be closed. A later report may be run to show orders closed where payment was expected.

Aged Invoices

Aged invoices are typically customer invoices created by the user. However, the report may be run to show the agency copy of invoices that are sent to the manufacturer. Invoices may be reported on the date of the invoice or on the expected date of payment.

Payables

There are vendor invoices to be paid by the user. Only the unpaid invoices will be shown on the report. The report may only be run by the invoice date.

Earnings Report

Earnings reporting is based on the date of the payment. The amount credited to a sales person is based on the terms of the PO at the time of payment and only for the items invoiced. Note: if the vendor does not invoice as expected by OASIS, then the earnings may be skewed for or against the salesperson.