Recommendations for Process Flow for product quotes, sales orders, sales invoices etc..

SOLVED

I'm the new IT guy at a young company using Sage 50 business. I don't think we are using the Sage software correctly as we are not tracking inventory and are not keeping up with partial deliveries etc. We are a lumber yard basically. Can anyone shine light on how and when we should be using the quotes, orders, and invoices?

Here's our process:

  1. Prepare a Quote for a building package
  2. Obtain down payment on quoted package
  3. Convert the Quote to an Invoice and record down payment on invoice.
  4. Deliver materials or partial materials and collect balance of payment.

This simple use of Sage has worked okay but we are growing and I want to make sure we are using Sage to the fullest. We are not tracking inventory. Also it may be a month between the time a package is sold and the materials actually ship if the builder is behind. How do we track this inventory in limbo?

Issues we want to improve on:

  1. Track inventory
  2. Keep up with when we make a partial delivery and when it's fulfilled.

I simple explanation of what happens when, as far as inventory control and fulfillment. Should we be using the Sales Orders? If so when and why?

A step by step guide would be awesome!

Thanks in advance for any help.

  • +1
    verified answer

    You kind of have the right idea. Always create a Sales Quote. Then, when you are certain the Sales Quote will become an actual order, create a Sales Order. If you need to order materials to fulfill the Sales Order, you can create a Purchase Order and enter the Sales Order on the Purchase Order so that the Purchase Order and the Sales Order are tied together (for inventory purposes). Process any deposit received by the customer. I usually process the deposit and mark it as a "prepayment" so that it is recorded against the customer's A/R account without being tied to income yet. When the materials are ready to be delivered to the customer, open the Sales Order and create an invoice from the Sales Order. You will need to print one copy of the invoice in order to automatically assign an invoice number to it. Then view "Receive Money" and click on the customer deposit. Change the screen so that it is no longer a prepayment (which will zero out the payment amount - make sure you note the amount received)). Click on the Invoice tax and apply the amount received to the invoice. Close the Receive Money window and open the View Invoice window, click on the customer invoice. You will notice the deposit has been applied to the invoice. Print the invoice.

    Note that printing the invoice a second time will print "Duplicate Invoice" on the invoice. To disable this, you need to go into Forms, open/edit the specific invoice you are using, and delete the "box' on the template that prints the "Duplicate Invoice" from the template.

    I hope this helps. It is what I do for my clients. It seems to work well for them.

  • 0 in reply to mastertype

    I would like to piggy back on the original question.  Are the items/materials taken out of inventory when creating the Sales Order or does that only happen when the Invoice is actually created?