Operational procedure for shipping using packing slips.

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!

  • 0

    You must not be keeping track of inventory.  When I receive an order from a customer I enter the entire thing as a sales order.  I only create a packing slip for what's in stock, I can see the inventory as I create the packing slip.  The backordered items stay as a sales order in Sage.  Days later I can create another packing slip for the backordered items when they arrive.  

    I almost think you want to stick with the 2-part manual packing slips for shipping.  When it comes back from the shipping department you will need to enter it twice in Sage, once for the items shipped (invoice) and once for the items on backorder (sales order).  That is, until you have a system for tracking inventory.

  • 0 in reply to Jenn5353

    Hi Jenn

    Yes, you're right - we're not tracking inventory. Right now, we don't know what's in stock until someone tries to go fulfill an order. Or the order-taker knows from going to the warehouse and looking. Your system sounds like heaven to me, it's just getting there is the problem right now. I'm fighting major resistance to change and trying to earn trust from the owner who has been doing business like this since the 70's! Trust in the computer system, that is ... he hates computers! But he wants better control over inventory and over the accounting, so this is the way to go but it's an uphill climb.

    Just curious - what do you use for Sales Order numbers? A huge drawback about Sage when I first starting looking at this is its inability to use autonumbering for Sales Orders. Or am I missing a setting somewhere?

    Thanks for your input!

  • 0 in reply to Kirk Teeple

    I use the customer's purchase order number as the sales order number.  If there is no order number then create a system for one. Whatever works best for your company.

    1) use the person's name J.SMITH, or use J.SMITH-1, J.SMITH-2 for multiple orders by the same person

    2) use the date the order was placed 29NOV13, or use 29NOV13-1, 29NOV13-2 for multiple orders on the same day

    3) use a combination of date and initials (JS-291113)

    I understand your battle -- been there, done that.  I don't envy you.  

  • 0 in reply to Jenn5353

    Thanks a lot Jenn!

    Quickly - you said this in your first answer:

    "I only create a packing slip for what's in stock, I can see the inventory as I create the packing slip."

    How do you see inventory as you create the packing slip? I can see inventory when I create the sales order (as I'm entering the line items), but I can't see it when I'm creating the Packing Slip (aka Invoice).

  • 0 in reply to Kirk Teeple

    I don't know.  When I start typing in the part number a box comes up with part #, description and qty on hand.  This happens in quotes, sales orders and packing slips/invoices.  I'm not sure why yours doesn't come up that way.

  • 0 in reply to Jenn5353

    Oh ok. Then you don't 'convert' orders to invoices? You re-type part #'s?