Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Exporting packing slip information in csv format
We are setting up a fulfillment house to ship our orders. We (and they) don't want to be using Netsuite in their warehouse, so we need a way to send them shipping instructions in some machine-readable format (ie, tab / comma separated or xls file). This would be sent daily, and should contain the same basic information as the packing slip (ie, select all fulfillments with a status of "picked", and export ship-to address, shipping type (UPS Ground / Fedex 2-day etc), list of items and quantities).
Can anyone give me any hints of how to do this? The main difficulty for me is that there is both per-fulfillment data and per-item data in the same file (e.g ship-to information followed by a list of items to go to that address), and I'm not sure how to achieve this.