Understanding the Sales Order Text Lines Purge Program

You use the Close Text Lines program (R42960) to delete specific information from the Sales Order/Purchasing Text Detail Lines table (F4314).

This purge checks the Sales Order Detail File table (F4211) and the Purchase Order Detail File table (F4311) for open detail lines with matching order type and order number combinations. The system performs these functions:

• If the system does not find matching records, it deletes the closed text lines from the F4314 table.

• If the system finds matching records, it deletes the closed text lines from the F4314 table only if the matching detail tables have a status of 999.

The R42960 program removes closed text lines only if all other lines on the order are closed. Order lines with a status other than 999 cannot be purged.

You can use the R42960 program to change the status of text lines to 999 (closed) on orders with no open detail lines. You use this program only if you have not set up the processing options for the Sales Update program (R42800) to purge text lines for closed orders.