Running Container Management Extraction

Select Container Management (G4118), Container Extraction.

To update the Container Transaction File (F41181), the R41189 program:

• Extracts information for items with line types that you have set up for full and empty containers.

• Verifies item cross-references.

• Retrieves preferences by customer and item to determine whether the customer pays a deposit or rental fee for containers and whether a customer is invoiced by the summary or transaction method.

• Calculates the scheduled invoice dates of orders.

• Updates the status of orders involving container transactions based on the processing options or the order activity rules.

The program stores container transaction information in the F41181 table so that the system can track container movements and invoicing separately from other systems. For example, when the JD Edwards EnterpriseOne Sales Order Management system moves sales order lines to the Sales Order History File table (F42119), the container transaction information remains intact in the F41181 table.

When the R41189 program reads a record that already exists in the F41181 table, it checks the status codes of the record in the Sales Order Detail File table to determine whether you have processed the record through the container billing programs. The R41189 program updates the record only if you have not already processed it through the container billing programs.

When you set the appropriate processing option for the R41189 program, the program produces a report indicating each of the records that were added to the F41181 table.