Remove Requirements (Upload CSV to set Referenced Demands as Fully Shipped)
The Remove Requirements feature allows users to upload a CSV
file for updating the referenced Demands by setting the demands to Fully
Shipped. The Demands that are shipped are removed from the Plan the next time a
new Plan is processed. This helps in managing Demand fulfillment efficiently.
Prerequisites
- A user with SRMAdmin role can access the Remove Requirements page.
- The CSV file must be properly formatted.
CSV File Format
The CSV file must contain Demand data with these columns:
| Column Name | Description | Required? |
|---|---|---|
| AE | Accounting Entity | Yes |
| Customer | Customer ID | Yes |
| ShipTo | Ship-To Location ID | Yes |
| Item | Customer Item Number | Yes |
| CustomerOrderNumber | Customer Order Number | No |
| Ref1 | Reference Number 1 | At least one of Ref1, Ref2, Ref3 is required |
| Ref2 | Reference Number 2 | |
| Ref3 | Reference Number 3 |
The CSV delimiter can be:
- ; (semicolon)
- , (comma)
- | (pipe)
- \t (tab)
- : (colon)
Note:
- The system detects the correct deliniter automatically.
- At leaset one reference field (Ref1, Ref2, Ref3) must be populated for each line.