Set Default Number Format for Values in Uploaded or Downloaded Files

You can view the quantity values, such as order forecasts, commitments, replenishment requests, on-hands, minimum quantity, or maximum quantity in the number format and delimiter specified when uploading or downloading spreadsheets for vendor-managed inventory and supply collaboration business processes.

You can set the default number format and delimiter on the Manage Supply Chain Collaboration Settings page.

1. In the Setup and Maintenance work area, use the Manage Supply Chain Collaboration Settings task:

   • Offering: Manufacturing and Supply Chain Materials Management

   • Functional Area: Supply Chain Collaboration

   • Task: Manage Supply Chain Collaboration Settings

2. On the Manage Supply Chain Collaboration Settings page, on the Collaboration Planning tab or the Vendor-Managed Inventory tab, the File Settings section, set the default values for number format and delimiter. The options include:

   • Number format: Valid values are -1234.567 or User preference. If number format is set to User preference, the number format is determined by the individual user's preferred format, which is set in the Set Preferences work area, the General Preferences > Regional task.

   • Delimiter: Valid values are User preference, Comma, Tab, Semicolon, or Pipe. If delimiter is set to User preference, the delimiter is determined by the individual user's number format: If the number format uses a comma as the decimal separator, then the delimiter is a semicolon. If the number format uses a period as the decimal separator, then the delimiter is a comma.

3. Click Save and Close.