Need help with back ordered quantities from sales orders

We are currently using Sage 100 and I will be the first to admit that we are probably nowhere close to using its full potential, so any input on processes or modules needed will be greatly appreciated. Here's my issue....

We are a manufacturing facility, so approximately 90% of our products are built to order. Here is an example of what I want to correct:

Customer orders 10 pcs of part A. At the time of scheduled delivery, we have 5 pcs ready to ship and need to back order the remaining 5 pcs.

In our sales order entry screen, we have five tabs: 1. Header  2. Address  3. Lines  4. Totals  5. Payment

Tab #3 is where the ordered items are entered under the following columns: Item code, ordered, back ordered, unit price and extension.

If i enter a qty of 5 in the back ordered column and reprint the order, it now reflects an ordered qty of 10, a shipped qty of 10 and a back order qty of 5.

How do we correct this?2308.00GARY D_SO_0256262_S_000.PDF

  • 0

    SO, order 10.

    Invoice the SO, override the quantity shipped to 5, and the BO quantity on the invoice should auto-calculate to 5. 

    Post, updating the SO with the BO quantity.

    Your PDF shows the full shipment, so credit the 5 that didn't go out, then fix the BO quantity after posting.

  • 0

    Either your form is displaying incorrect data (meaning someone adjusted the form code to display the wrong information under "shipped"  and "backordered") or you're actually marking the entire order shipped when it's not.

  • 0

    Something definitely wrong with your sales order form.  No way you could have shipped the complete order and still have an open sales order.  Also do not enter a back order quantity when creating the sales order. Let the system do that when you ship what you have.

  • 0 in reply to Kevin M

    I did a quick check and Sage100User and BigLouie are correct.  There is something wrong with your printout. 

    You can edit the BO quantity in a couple ways, but never exceeding the Ordered + Shipped (invoiced) quantity.

  • 0 in reply to BigLouie

    No, we aren't shipping the order complete and we can't print paperwork to show what is actually being shipped or delivered at that time. I'm not sure if you saw the PDF I uploaded, but the example shows "ordered-10  shipped-10  back order-5" when we want it to actually show "ordered-10  shipped-5  back order-5". I hope that makes sense and who knows, maybe this isn't possible without some other steps or function in Sage that we aren't using.

  • 0 in reply to David Gary

    Those numbers are impossible, unless your form is designed wrong.

    You print what is shipped from the Invoice, not the SO... so perhaps that is the issue.  If you need to set up something to print from the SO, you're looking at customizing the form.

  • 0 in reply to Kevin M

    So maybe our process is the problem? We create the sales order which has four copies: sales order, purchasing, shop and customer. When our drivers deliver to the customer, the customer signs the shop copy and keep their customer copy. After the shop copy is returned to our facility, it is matched with the sales order copy and at that point, the order is invoiced.

  • 0 in reply to David Gary

    The SO is not usually a shipping document. 

    Typically you invoice as things go out the door (where short shipments are known), and you print an invoice / packing list with what is included.

  • 0 in reply to David Gary

    Ship the sales order when the product leaves the building with the truck, and print the paperwork from the shipped document.  Do not post the invoice.  When the truck and paperwork returns confirm what was delivered and then post the invoice.  If the truck did not return, then move that invoice to a different batch before posting the paperwork for what was returned by drivers.