* READ BEFORE USING *
NOTE: The drop ship addresses must be added in to netsuite on the customer record by the sales rep before the order is transformed.
Please * Duplicate * the template you want to use then fill out the following:
Column A / Row 1-4 / Customer Name, Customer PO (if app.), Estimate Number and Notes (if app.)
Column A / Row 8- ? / Name & Full Address for each dropship
Column B / Row 8-? / Edit sizes if needed
Column C-F / Row 7 / SKU Names
Column C-F / Row 8-? / Qtys per address
Additional SKUS: Highlight # of additional column(s) needed from C-H & right click > insert column(s), copy & paste one of the old columns into new column to continue format.
Additional Dropships: Highlight rows 48-58 & insert row(s) right click > insert row(s), copy & paste rows 48-58 into new rows to continue format.
To link your sheet when submitting an order:
Highlight the entire sheet
right click & choose: View more Cell Actions > Get Link to this range
That way the exact sheet will be linked and not the entire workbook.