FTP Philips Forecast Report

Philips uses this report to manage resources.  The report pulls all hold and partial orders for a 90 day period allowing Philips to allot resources.

What is sent to Philips?

Only data for Philips brands is gathered and sent in the spreadsheet. The data includes:

• Quotes bid in the past 365 days - line level catalog numbers with quantity and totals
• Hold orders - line level catalog numbers with quantity and totals

An example file is shown below. Additionally, the file may be previewed for accuracy before sending to Philips.

Running the Report

To run the report, select the orders application in OASIS and select "FTP Philips Forecast Report" under the "Philips" menu:

A progress bar will likely show as the report is being created. The next window will be the internal OASIS email client (Send Message):

To review the report, double click on the bottom blue link in the bottom right hand "Attachments" area. The report will open in Microsoft Excel:

To send the report, just press the "Send" button.

Frequently Asked Questions

How do I know what was sent?

Open the Philips parent manufacturer entry in OASIS. The attachments tab will contain a copy of every report created and sent using this process.

How do I resend the report?

Each report created by OASIS is saved to the Philips parent manufacturer entry in OASIS. Simply open the "Philips" parent in OASIS, select the attachments tab and email the required report.