I am at the implementation stage. I've been told NetSuite can not tally the total number of shipping cartons from the custom transaction field we added to the Sales Order, Picking List, Packing List custom forms etc, without NetSuite writing a specific script for us. Therefore my warehouse would have to manually count the number of shipping cartons and enter that in a field for Ozlink to pick up. Does that sound right? Ozlink/UPS needs to know the number of cartons being shipped per shipment and their weights/dimensions.
This is how they have us setting up our inventory:
For example: sku # 63269, inner carton of 12, master carton of 48
Item Number: Shipping Package:
63269
63269/12 63269/12
63269/48 63269/48
My NetSuite PM has created a formula that will calculate the number of cartons per sku line item, ie 96 ordered units equals 2 master cartons, but it can't tally up all ordered items, especially since we sometimes combine different skus inners into a master to minimize shipping costs. So I would have to manually add up the # of shipping cartons and fill that number in a different field altogether.
This can not be right. What are other distributors doing for shipping to customers?
Thanks,
Diane