Until recently, our customized "Invoice from Sales Order" populated the "Backordered" column with those items not being shipped when printed.
Because our inventory items are Lot Number specific, we would create additional lines for those items not yet out of production, and therefore not yet having Lot Numbers assigned to them.
For example, if the customer ordered 200 each of "X" and we only have 80 each in stock, we create 2 entry lines for this item on the SO; one with the 80 each of "X" with its assigned Lot Number being invoiced and shipped, and a 2nd line item with 120 each of "X" without a Lot Number as one will not yet have been assigned until after production and QC.
We would then generate an invoice (our customized "Invoice from Sales Order") and both line items for "X" will populate, and print accordingly.
Recently however, while the two line items still appear on screen for both the Sales Order and the Invoice, only those items actually being shipped print out (i.e. the line with 80 each of "X" prints on the invoice, but the 120 each of "X" that are backordered does not even though we are able to view all the information on the screen.
The result is that we are unable to clearly advise our customer what quantity is backordered on the invoice we are generating and issuing to them.
Does anyone have a solution to this?