Item Quantity not Changing after Invoice

SOLVED

Is there a setting on the "item maintenance" that keeps the ordered quantity on the SO the same even though part of the line item was invoiced?  This is an example, we have a SO with 3 lines, line one has a quantity of 50, line two qty of 100 different item than line 1, and line 3 with qty of 150.  We invoiced line one for 50 and line 3 for 50.  When I pull up the SO now, line 1 is gone, which it should be, line 2 is showing qty of 100 open and shows on the print preview of the SO.  Line 3, we invoiced 50 but on the SO entry screen the line is still showing qty 150 ordered and on the print preview.  I thought once a qty is billed the ordered qty is changed to reflect it, we upgraded MAS in Nov of last year and I can't remember if this just started happening then. 

  • 0

    Sales Orders have Quantity Ordered, Quantity Shipped and Quantity Backordered.  Once you invoice off that sales order, and if you invoice the line complete, that line is removed from Sales Order Entry (as you explained above, line one is gone).  However, Line two (now the first line); shows 100 ordered and 100 backordered.  And Line Three (now the second line); shows 150 ordered, 50 shipped and 100 backordered.  In Item Maintenance the SO Quantity is zero and the "on Back Order" Quantity is 200.  Your printed Sales Order is customizable in Crystal reports.  Try creating a fresh form (default); and  it should show you all three elements.  On Order, Shipped Previously, and On Backorder.  Your form may be customized and someone choose to just print "Original Order Quantity" not the current remaining quantity to ship.

  • 0 in reply to StefanouM

    Thanks, but  I was worried that was the reason.  I found the field in the crystal report and there is a formula tied to the field.  Would I be correct in adjusting the formula to show the backordered quantity if the shipped qty does not equal the original ordered qty?

  • +1 in reply to jland47
    verified answer

    Yes, that is what you want.  On order lines with BO = 0, then Ordered less Shipped.  On orders with BO <> 0, then the BO Quantity.  

  • 0 in reply to StefanouM

    Ok, I used the suppress field function to suppress the field if the certain criteria was meet and it worked.  I couldn't figure out how to make the actual field a formula.