Example: Carton Charges Based on Item Quantity
This table displays the F4211 table after the system creates carton charges at shipment confirmation when the charge is based on item quantity.
Order Number |
Line Number |
Line Type |
Item Number |
Order Quantity |
Location |
Price |
Extended Price |
Price Override |
|---|---|---|---|---|---|---|---|---|
1 |
1.000 |
S |
Item A |
750 |
1.A.1 |
25.00 |
18,750 |
- |
1 |
1.010 |
CI |
7890 |
1 |
- |
0.00 |
0 |
1 |
1 |
1.020 |
CI |
8741 |
1 |
- |
0.00 |
0 |
1 |
1 |
1.030 |
CC |
7890 |
250 |
- |
5.00 |
1,250 |
- |
1 |
1.040 |
CC |
8741 |
750 |
- |
5.00 |
3,750 |
- |
1 |
2.000 |
S |
Item A |
250 |
1.B.1 |
25.00 |
6,250 |
- |
1 |
2.010 |
CI |
7890 |
1 |
- |
0.00 |
0 |
1 |
1 |
2.020 |
CC |
7890 |
250 |
- |
5.00 |
1,250 |
- |
1 |
2.030 |
CC |
8741 |
250 |
- |
5.00 |
1,250 |
- |
The CI (Carton Inventory) line type (a user-defined value) indicates that the carton is identical to the stock line type. A CI line type enables you to relieve the carton as inventory at sales update and to exclude the charge from the EDI Advanced Ship Notice Extraction process. The system writes these lines using the inventory-relief sales order version for carton-based quantities.
For the non-stock lines containing the carton charge, the system writes the lines using the inventory-relief sales order version for item-based quantities. After the system writes the sales order lines, the lines and parent lines are added to the F4080 table when you run the EDI Advanced Ship Notice Extraction program.
In this example, the Related Order Cross Reference table would appear as follows:
Related Order Set ID |
Related Order ID |
Order ID |
Product Code |
Order Number |
Order Line Number |
Item Number (Carton) |
|---|---|---|---|---|---|---|
1 |
1 |
1 |
42 |
1 |
1.000 |
- |
1 |
1 |
2 |
42 |
1 |
1.030 |
7890 |
1 |
1 |
3 |
42 |
1 |
1.040 |
8741 |
1 |
2 |
1 |
42 |
1 |
2.000 |
- |
1 |
2 |
2 |
42 |
1 |
2.020 |
7890 |
1 |
2 |
3 |
42 |
1 |
2.030 |
8741 |