This is similar to what I expect to be doing, though I'm already mapping to a SQL DB, so I can just create some other tables for this purpose.
I think what is causing me the most confusion is how to store this stuff in a way that's easy to write out from the mapper, yet still easy to query via SQL, since the pack slips are probably going to be created in Bartender. I can make it work - I just have days when I suspect I'm making things twice as hard as they need be, and I need a reality check. :) Travis- ----- Original Message ----- From: "Michael Mattias/LS" <[email protected]> To: [email protected] Sent: Thursday, April 11, 2013 3:48:52 PM Subject: Re: [EDI-L] Re: Required customer data >that we must print a very tightly controlled pack slip format (due to it being >drop-ship). I have this same 'packing slip for drop ship' requirement for one of my clients, too. What we did was figure out a little Jet (aka "Microsoft Access") database table he could use as input to his "packing slip print" routine (LabelView or BIQuery or some kind of report writer with which my client is pretty handy ) and I just mapped that database as an extra output from the input '850'. (The other ouputs being an ERP interface file from which sales orders are imported and a UPS manifesting table which is imported into Worldship). Note this data is ONLY what is needed to "create packing slip." The actual 'turnaround' data used for the ASN was mapped into our normal repository. It works THERE. Michael C. Mattias Tal Systems Inc. Racine WI [email protected] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
