DRP (Dropshipment),
INO (Invoice Only),
INT (Intransit),
INV (Inventory), and
MSC (Miscellaneous) are the only line types supported at this time.
REC (Recurring) line types will be available in the future.
When you use the
INV line type, entries/updates are made in the Reservation Header (RES_HDR), Reservation Line (RES_LN), and the Inventory (INVT) tables for valid input files only. If the sales order line
Order Qty is changed to zero, then the reservation line is deleted. If no more reservation lines exist in the reservation, the RES_HDR is deleted as well. The SO line
Order Qty cannot be modified to a value that is less than the total issued quantity or total invoiced quantity for the line. If the sales order status is pending (SO_HDR. S_SO_STATUS_CD is
P) and MRP_SETTINGS.INCL_PEND_SO_FL is
Y, the planned reserved quantity (INVT.PLND_RES_QTY) is incremented, and reservation remains pending (RES_HDR.S_APPRVL_CD is
P). If the SO_HDR status is approved, the reserved quantity (INVT.RES_QTY) is updated and the planned reserved quantity is decreased (if previously pending), and reservation is changed to
Approved (RES_HDR.S_APPRVL_CD is
A). If the SO_HDR status is pending (SO_HDR. S_SO_STATUS_CD is
P) and MRP_SETTINGS. INCL_PEND_SO_FL is
N, neither the planned reserved quantity nor the reserved quantity in INVT are incremented; and a row is not inserted into RES_HDR. If the SO_HDR status is approved, a row is inserted into RES_HDR/RES_LN, and the reserved quantity (INVT.RES_QTY) is updated.
If you do not use a
Pricing Project, you must provide a valid
Warehouse ID in the input file for INV lines, or the record will be rejected.
The preprocessor allows the use of
Sales Abbreviation codes that are project substitutable, but you must include the
Project To Charge (CHG_PROJ_ID) for each Sales Order Line in the input file.