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

Parents
  • 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.

Reply
  • 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.

Children