GetByFilter Method (SoLine)

The GetByFilter() method retrieves all of the sales order line item records from the SO_Line table of the specified sales order.

A sales order is uniquely identified by the combination of the customer ID and purchase order ID.

The condition of the sales order state can be used to filter the sales order. For this overload of the method, the filter is based on the sales order state settings that have been saved for a user to the UI_Config table. Thus, a user ID is required to identify which sales orders to retrieve.

The settings in the Customer Filter window are:

• Complete sales orders: All required quantities of all items in the sales order have been recorded as shipped.
• Partial sales orders: Some item quantities but not all required quantities of all items in the sales order have been recorded as shipped.
• Open sales orders: No item quantities have been recorded as shipped.

One or more of the filter settings, or none, can be selected. If none of the filter settings are selected, then no state filter is applied to the sales order.

The GetByFilter() method retrieves all of the sales order line item records from the SO_Line table of the specified sales order.

A sales order is uniquely identified by the combination of the customer ID and purchase order ID.

The condition of the sales order state can be used to filter the sales order. For this overload of the method, the sales order can be filtered based on the sales order states.