ORDER STATUS

Order Status information is refreshed on BIB NET nightly from the Michelin mainframe; therefore, an order entered today will not appear in Order Status until the next morning after the refresh. This information includes ordered, open, backordered, committed, scheduled, and shipped quantities for all existing orders regardless of whether the order originated in BIB NET or not.

There are six different views of order status information:

1. Order Status By Bill To - This view displays the ship to number, name, and quantities summed by ship to. Only ship to(s) with quantities to report will be shown.
2. Order Status By Ship To - This view displays the purchase order, order date, sales order and quantities summed by sales order number.
3. Order Status By PO - This view displays the sales order number, stock number(cpn or mspn), mspn description, and quantities summed by stock number.
4. Order Status By Shipment - This is a real time view of shipment information for a given purchase order or sales order. This view displays bill of lading number, sales order number, invoice number, ship date, shipping dc, carrier and shipped quantity summed by invoice number. You may also access this screen for a specific PO; however, a system limit has been set that will disallow this if you have more than 10 sales orders for that purchase order. If you are experiencing this limitation more often than not, please contact the help desk and report this as a problem; a review will be done to see if the limitation can be bumped up to a higher number.
5. Order Status By Michelin Sales Order - This is a real time view of a given sales order. This view displays stock number(cpn or mspn), mspn description, and quantities for the sales order summed by stock number. You cannot access this view directly from the search screen; but can proceed to this screen from other searches.
6. Download Order Portfolio - This is a real time download view of order status information in either Excel (XLS), CSV or XML format. The length of time to create this file will depend on the number and size of the orders. Additional details of this download feature are explained below.

Getting started with the Search Screen:

There are two different sections to the screen.

• The top section provides three options:
  • You may specify a specific purchase order number that belongs to your default ship to. You may go directly to the Order Status by Shipment screen by pressing the Shipment button. Orders placed today will only be visible using this option if an actual shipment has been made for the order today.
  • You may specify a specific purchase order number that belongs to your default ship to. You may go directly to the Order Status by PO screen by pressing the PO button. Orders placed today will not be visible using this option until the following day.
  • You may specify a specific sales order number that belongs to your default ship to. You may go directly to the Order Status by Michelin Sales Order screen by pressing the Order button. This option will allow you to get a real time view of your order even if it was placed today.

Note: The limiting criteria in the bottom section does not apply when using the buttons in the top section.

• The bottom section allows you to specify limiting criteria to be used when selecting the data for display.

  • STOCK NUMBER: If you are a cpn customer, you will be given the option to enter a cpn or mspn. If you want to enter an mspn, you will need to click the Use MSPN box; otherwise, it will be treated as a cpn. If you are not a cpn customer, you may only enter an mspn in the stock number field. If entered, the number will be validated.
  • FROM DATE and/or TO DATE: The date format is mm/dd/yy or yy-mm-dd. If both dates entered, the from date must be less than the to date.
  • SHIP TO/FAVORITES DROP DOWN LIST: If you have set up a favorites list for your userid, this will be a drop down list of your default ship to along with your favorite ship to(s). Favorites may be set up using the Favorites Maintenance Screen. If you have not set up favorites for your userid, this will be a drop down list of all ship to(s) for the bill to. Clicking on a specific number will change the ship to number in the ship to entry box. Note: this does not change your session ship to; it only limits the order status displays to that ship to.
  • SHIP TO: The ship to number is required when you press the ship to button; it does not apply when you press the bill to button. It will display the default ship to when the screen is initially displayed. You may change the ship to number by directly keying in another number or selecting a different ship to from the drop down list above. The number will be validated as a ship to within your bill to. Therefore, if using favorites, you still may enter a ship to that belongs to your bill to even if it is not in your favorites list.

Download Order Portfolio Details:

Downloads can be initiated in Excel (XLS), CSV or XML format, and are accessible throughout the given business day. Any downloaded file data will be cleared each night during daily batch processing.

Downloaded files are accessible to Users within the same business billing structure (ie. Ship To Users within same business structure are able to view/access downloads initiated by other Ship To Users within same billing structure; Bill To Users within same business structure are able to view/access downloads initiated by other Bill To Users within same billing structure).

By clicking either ‘XLS’, ‘CSV’ or ‘XML’, system will initiate file request. If navigating away from the page, the system will update upon return to the page to display if file is available for viewing. If remaining on page, click ‘Refresh’ periodically to update status of file request. Once file is available for viewing/saving, status message will display ‘Task Complete. Ready for Download’ – click this link to open and/or save file.

Data discrepancies (ie. loss of leading zero values, etc) can be avoided when saving CSV data into Excel by using the below process to first SAVE the file and then IMPORT the data.

1. Click on report link in Status Message field.
2. Select Save File and make sure it is saved as the .csv file.
3. Open MS-Excel as a new spreadsheet.
4. Click on the Data tab.
5. Click on the “From Text” icon.
6. Select the file just saved.
7. The Import Wizard screen will open. Select Delimited, then click on Next.
8. Select the comma option, then click on Next.
9. Highlight columns as needed and select TEXT format option. It is recommended that, at a minimum, the following fields should be formatted as TEXT columns:
   • ST CUST
   • STORE
   • MSPN
10. Click on Finish.
11. If the Import Data message box appears, click on OK.

Report will be parsed & imported into the spreadsheet and the leading zeroes will be displayed.

Avoid issues opening large XML files by using the below process to first SAVE the file.

1. RIGHT-Click on report link in the Status Message field.
2. Select ‘Save Link As’ (or some browser versions may display as ‘Save Target As’)
3. Save the file in location of your choice making sure file has the .xml extension

General BIB NET Help

BIB NET Help Index (Main Menu Functions)