Making a Ship Note based on more than one Sales Order -- SYSTEM21

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.