Real-World BUSINESS Problem

PROBLEM

I need to automatically create packing lists at the end of each day for
items ordered through our warehouse inventory control system. Each
packing list is related to a retail location. The packing list must be
printed so that order pickers can get the materials and package for
shipment to the locations. Each packing list must be archived
electronically.

RESOURCES

Data from the inventory control system and the retail location database.

Jay Blanchard wrote:
> PROBLEM
>
> I need to automatically create packing lists at the end of each day for
> items ordered through our warehouse inventory control system. Each
> packing list is related to a retail location. The packing list must be
> printed so that order pickers can get the materials and package for
> shipment to the locations. Each packing list must be archived
> electronically.
>
> RESOURCES
>
> Data from the inventory control system and the retail location database.

Hire a SAP consultancy to create a bespoke app for you. Their highly
paid (and therefore, I assume, competent) sales people tell me they're
the best choice for anything BUSINESS.

-Stut

--
http://stut.net/

Okay. All of the orders are in your database, correct?

1. Write a query that selects all of the days orders from 12:00am-11:59pm.
2. Create a form for the specific data and layout you want in your packing
slip.
3. In your loop for each record, send the data to a printer.
4. For your electronic copy you could:
4a. Leave the data as it is in your DB and just populate the slip upon
request.
4b. Inside the loop add a query to save only the slip data to a new table.

Since you already have all of the data it really shouldn't be very hard to
pull it out, populate your form, send each form to a printer, and populate
an electronic form on demand based on the input of an order number.


On 7/5/07, Jay Blanchard <jblanchard@pocket.com> wrote:
>
> PROBLEM
>
> I need to automatically create packing lists at the end of each day for
> items ordered through our warehouse inventory control system. Each
> packing list is related to a retail location. The packing list must be
> printed so that order pickers can get the materials and package for
> shipment to the locations. Each packing list must be archived
> electronically.
>
> RESOURCES
>
> Data from the inventory control system and the retail location database.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Jay Blanchard wrote:
> PROBLEM
>
> I need to automatically create packing lists at the end of each day for
> items ordered through our warehouse inventory control system. Each
> packing list is related to a retail location. The packing list must be
> printed so that order pickers can get the materials and package for
> shipment to the locations. Each packing list must be archived
> electronically.
>
> RESOURCES
>
> Data from the inventory control system and the retail location database.


Hey I remember doing something similar to this on my first day at Uni.....

This is not hard.... You could do this in numerous languages and PHP
would make it pretty quick. Python or Java would also be pretty good
choices as all three have pretty good PDF generation libs which could
make for nice printouts.

I really don't get what your problem is. Just approach this like any
other programming task and spec it out and break it down modularly and
the design will come naturally.

Col

Colin Guthrie wrote:
> Jay Blanchard wrote:
>> PROBLEM
>>
>> I need to automatically create packing lists at the end of each day for
>> items ordered through our warehouse inventory control system. Each
>> packing list is related to a retail location. The packing list must be
>> printed so that order pickers can get the materials and package for
>> shipment to the locations. Each packing list must be archived
>> electronically.
>>
>> RESOURCES
>>
>> Data from the inventory control system and the retail location database.
>
>
> Hey I remember doing something similar to this on my first day at Uni.....

Erm, woops. I went into rant mode before I'd parsed the author of the
original post ;)

Col