Invoicing/Order Completion

This section describes how the customer purchase order information from a sales order is carried into the invoices that are created from the sales order.   This information applies to both the StreamV and the StreamII applications and it applies to all order types (i.e. Sales Orders and Shipper or Loaner orders), except for IFT orders, and to all programs that create invoice records from sales order information (this includes Order Completion, Vendor Ship Invoicing)

Type S Orders:  The following logic is used when a Type S sales order is processed in the StreamV or StreamII Systems.  This logic applies to all fulfillment methods (warehouse, special order, vendor shipments).

Field Name

Field

Field Name

Field

SOHEAD.PO_NO

60:28 (A30)

INVOICES.PO_NO

56:18 (A30)

SOHEAD.FULFILLMENT_PO

60:109 (A30)

INVOICES.FULFILLMENT_PO

56:133 (A30)

SOHEAD.PO_DATE

60:84 (Date)

INVOICES.PO_DATE

56:118 (Date)

SOLINE.PO_NO

61:121 (A30)

TRANSACT.PO_NO

58:74 (A30)

SOLINE.PO_LINE _NO

61:113 (N14.4)

TRANSACT.PO_LINE

58:122 (N14.4)

SOLINE.PO_PRICE

61:114 (N14.4)

TRANSACT.PO_PRICE

58:121 (N14.4)

SOLINE.PO_ITEM_NO

61:122 (A30)

TRANSACT.PO_ITEM_NO

58:110 (A30)

POLINE.PO_NO

101:6 (N8)

TRANSACT.HOUSE_PO_NO (internal use only vendor shipment lines only)

58:50 (N8)

POLINE.LINE

101:7 (N4)

TRANSACT.HOUSE_PO_LINE (internal use only vendor shipment lines only).

58:51 (N4)

Type L (Non-IFT) Orders: The following logic is used when a Type L (Loaner or Shipper) sales order is completed in the StreamV or StreamII Systems.  This logic applies to all fulfillment methods (warehouse, special order, vendor shipments), and type L orders EXCEPT for IFT orders which are described in a following section. 

The primary difference between type S and Type L orders is that completing a type L order does not result in a sale.  When a type L order is completed, records are created in the Pending file for the items and quantities shipped to the customer and the customer is not charged for the items.  The Pending records are used to record the shipment of the goods to the customer and track the outstanding items until the goods are returned by the customer, written off, or actually invoiced to the customer from the Pending file. 

Field Name

Field

Field Name

Field

SOHEAD.PO_NO

60:28 (A30)

INVOICES.PO_NO

56:18 (A30)

SOHEAD.FULFILLMENT_PO

60:109 (A30)

INVOICES.FULFILLMENT_PO

56:133 (A30)

SOHEAD.PO_DATE

60:84 (Date)

INVOICES.PO_DATE

56:118 (Date)

SOLINE.PO_NO

61:121 (A30)

TRANSACT.PO_NO

58:74 (A30)

SOLINE.PO_LINE _NO

61:113 (N14.4)

TRANSACT.PO_LINE

58:122 (N14.4)

SOLINE.PO_PRICE

61:114 (N14.4)

TRANSACT.PO_PRICE

58:121 (N14.4)

SOLINE.PO_ITEM_NO

61:122 (A30)

TRANSACT.PO_ITEM_NO

58:110 (A30)

POLINE.PO_NO

101:6 (N8)

TRANSACT.HOUSE_PO_NO (internal use only vendor shipment lines only)

58:50 (N8)

POLINE.LINE

101:7 (N4)

TRANSACT.HOUSE_PO_LINE (internal use only vendor shipment lines only).

58:51 (N4)

POLINE.PO_NO

101:6 (N8)

PENDING.PO_NO (internal use only vendor shipment lines only).

161:9 (A25)

POLINE.LINE

101:7 (N4)

PENDING.PO_LINE (internal use only vendor shipment lines only).

161:39 (N8)

Note:  Up until 7/27/06 the Transact PO_LINE field was being used both for internal and external PO line information (internal on vendor shipment orders, external on edi or manual orders).  It was being loaded with customer information on normal or warehouse orders and with internal information (system generated purchase order information) when an order line for a vendor shipment or an interfacility transfer was processed.

As of 8/15/06, the StreamV and StreamII systems use the house PO fields in each transact record to store the PO number of any internal purchase orders that are tied to the invoice line.  The transact house fields are loaded when Vendor Shipment orders, and Interfacility Transfers are processed by the invoicing programs.  The House PO information is not carried in the sales order lines as more than one internal purchase order line can point to a single sales order line.

Type L IFT Orders: The following logic is used when a Type L IFT (Interfacility Transfer) sales order is completed in the StreamV or StreamII Systems.  The Logic for an IFT order differs from other order types as IFT orders are used only for internal transfers of on hand inventory quantities between physically separate inventory locations.

 

Field Name

Field

Field Name

Field

SOHEAD.PO_NO

(Field is automatically loaded with PO used to create the SO by the IFT system)

60:28 (A30)

INVOICES.PO_NO

56:18 (A30)

Not supported (IFT SO is created from PO and FF PO field is not supported in PO entry

60:109 (A30)

INVOICES.FULFILLMENT_PO

56:133 (A30)

Not supported (see above).

60:84 (Date)

INVOICES.PO_DATE

56:118 (Date)

SOLINE.PO_NO

(Field is automatically loaded with PO used to create SO by IFT)

61:121 (A30)

TRANSACT.PO_NO

58:74 (A30)

SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT)

61:113 (N14.4)

TRANSACT.PO_LINE

58:122 (N14.4)

Not supported

61:114 (N14.4)

TRANSACT.PO_PRICE

58:121 (N14.4)

Not supported

61:122 (A30)

TRANSACT.PO_ITEM_NO

58:110 (A30)

SOLINE.PO_NO

(Field is automatically loaded with PO used to create SO by IFT)

101:6 (N8)

TRANSACT.HOUSE_PO_NO (internal use only)

58:50 (N8)

SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT)

101:7 (N4)

TRANSACT.HOUSE_PO_LINE (internal use only).

58:51 (N4)

SOLINE.PO_NO

(Field is automatically loaded with PO used to create SO by IFT)

101:6 (N8)

PENDING.PO_NO (internal use only.

161:9 (A25)

SOLINE.PO_LINE _NO (Field is automatically loaded with PO used to create SO by IFT)

101:7 (N4)

PENDING.PO_LINE (internal use only).

161:39 (N8)