I have a question and I'm looking for feedback from those who might be in the same situation or know of others dealing with this.
Here's my situation: I'm trying to move a distribution/manufacturing company from a manual set of books to the computer (yes, really!). This is no longer a small company (actually it's 3 different companies), there are over 2,500 different products.
The way things have worked so far: Orders are taken on a 2-part Packing Slip by hand. The packing slip is given to the warehouse where they try to fulfill the order. They write the quantities shipped on the packing slip and include the original with the shipment and send the copy to the front office for billing. If there's a backorder, another packing slip is written up with the backordered parts.
Now, trying to replicate that using Sage 50 is impossible. For one thing Packing Slips and Invoices are the same thing. That is, they show the same information in two different ways. I can only print a Sage packing slip with an invoice. This is impossible to do because we don't always know prices and/or shipping costs until after it is shipped. I thought of using Sales Orders as 'Packing Slips' because I can always modify the Sales Order report to say Packing Slip, but there are two problems with that: #1: Sales Orders don't create their own unique numbers; #2: Backorders become an issue because the Packing Slip (Sales Orders) would have the same packing slip number but I can get around that by closing the old order and creating a new one. I thought of using Quotes as Packing Slips because they generate their own numbers, but that has its own issues. The main one there is that we want to track 'Open' Orders. We could convert the Quotes to Sales Orders but what number to use? And what if we actually want to do a quote?
We can't be the only company that works this way, I'm wondering what others are doing? Let me know your thoughts or suggestions ...
Thanks!