R42600 - Sales Ledger Report
You generate the Sales Ledger Report program (R42600) to analyze sales history Depending on the version of the Sales Ledger Report that you select, you can analyze sales history in these ways:
By order (document) type, such as phone orders, blanket orders, COD orders, and credit orders.
By line type, such as stock sales, non-stock sales, freight, and miscellaneous charges.
By order status, such as shipped, backordered, or canceled.
By customer, salesperson, or order entry person.
By customer payment terms.
By price amounts.
In the order activity rules, you can specify the steps in the process where the system records entries to the S.O. Detail Ledger File table (F42199).
Because the F42199 table can contain multiple records for a single order detail line, you must specify either a next or last status code in the data selection for the Sales Ledger Report. If you do not specify a status code, the report can overstate historical sales information.
The most common reasons why information does not print on this report is:
You did not specify the correct status code in the processing options.
The order has one or more hold codes.
The system did not update the Sales Summary History File (F4229) table when you ran the Update Customer Sales program (R42800).
Verify that the processing options for the R42800 program are set to update records in the F4229 table.