RE: Making a Ship Note based on more than one Sales Order

--
Fred Mitchell
Concise Consulting Ltd.
Newcastle upon Tyne, England
http://www.concise-consult.demon.co.uk

-----Original Message-----
From: owner-jbausers-l@midrange.com [mailto:owner-jbausers-l@midrange.com]On Behalf Of Mike Von Stein
Sent: 11 July 2000 05:14
To: JBAUSERS-L@midrange.com
Subject: Making a Ship Note based on more than one Sales Order

We are currently implementing JBA and I don't have a lot of experience with it.   Please accept my apologies if this question is too basic...

 

We have a customer who demands that we ship against multiple orders using only 1 packing slip and 1 invoice.  (I.e.*only* 1 packing slip and 1 invoice per Bill of Lading)

 

Currently the way we have (manually) done this in the past is to use MS Excel and make the packing list with a matrix at the bottom showing the part #, qty, and PO # that the qty applies to.  For example:

 

*** Outstanding PO's:

Part Num        PO    Qty

P100               P1      100

P100                P2        50 

P200                P2        75

 

*** Packing List & Invoice

Part Num     Qty

P100            150

P200            75

(The Outstanding PO table shown above would be listed at the bottom of this packing list.)

 

If we would ship the exact qty shown above with JBA it would be under 2 ship notes, because we have to start with the sales order.   We could use daily invoice consolidation to roll it up, but that assumes we only have 1 truck per day, otherwise we would violate their 'one shipment, one invoice' policy.

 

If anyone has any tips on how to do this, I would really appreciate it.

 

Thanks in advance,

Mike Von Stein

Findlex Corporation