4313.1NEW:Add sub-contracting order and receiving transactions import excel template
Posted 2019-08-20 18:29:12
Add sub-contracting order and receiving transactions import excel template. We can input all details in excel, then import to system.
1. In sub-contracting order → Import button, select import excel template.
2. Sub-contracting order excel template required fields: sub-contracting order no./sub-contract order prefix, sales order number, style number, process code, color and size
Manufacturer and process should input manufacturer code and process code
Input sub-contracting order number (if any) or input sub-contracting order number prefix and let system generate the running number
If sub-contracting order perform multiple processes, use “;” as separated between process codes
Change size-1、size-2 to sales order style garment sizes, then input corresponding order quantity per each color/size
Colors & sizes must exist in sales order. If colors/sizes do not exist in sales order, system will not import the details.
If unit price are the same for different color & size, only need to input unit price on first line, leave color and size blank.
If unit price is per color, need to input color and unit price and leave size blank.
If unit price is per size, need to input size and unit price and leave color blank.
If unit price is per color and size, then need to input color, size and unit price.
3. Sub-contracting order receiving excel template required fields: sub-contracting order no., manufacturer, process, color and size
Attention: System cannot import the receiving transaction if manufacturer code or process do not input correctly, so
corresponding sub-contracting order cannot be found.
Above feature only applied to version JOS V184.108.40.206 or above.
If you cannot find this feature, please check your version first.
To check version number, click Help → About in main control panel.
If you want to upgrade to this version, please contact your Account Manager or send us on-line support call.