Correction and return lines tied to an original order

When you tie Correction (CR) order lines or Return Merchandise (RM) order lines, including return order lines on non-RM orders, to an original order, data from the CR and RM order lines is stored in the OEELCR database table. All functions that support CR and RM order line creation update this table. These functions include the entry, copy, and Shopping List functions in Sales Order Entry, and Storeroom, which uses an SX.api call to create RM order lines in Distribution SX.e.

The data stored in the OEELCR table is used to track the CR and RM order lines that are attached to the original order line. These update occur to the OEELCR table:

When a CR or RM order line is added to the order, records are added.
When a tie is removed from a CR or RM order line in Sales Order Entry, all associated records are removed.
When an original order line with a tied CR or RM order line is canceled, all associated records are removed.
When an original order line with a tied CR or RM order line is sent to lost business, all associated records are removed.
When a CR or RM order line that is tied to an original order line is invoiced using the Sales Entry Invoice Processing Report, the report updates the table with the Journal number and Set number. These values are zero at order line creation to indicate that the CR or RM order line is in process.

Calculating the corrected price and unreturned quantity

The data in the OEELCR table is used to calculate the corrected price and the unreturned quantity of the product when you tie CR order lines or RM order lines, including return order lines on non-RM orders, to original order lines.

The corrected price is the price on the original order line including any price changes applied to the original price on previous CR orders. The corrected price reflects the unit and special cost pricing settings of the original order line settings.

Note: Because price changes on RM order lines are not tracked, RM order lines are not used to calculate the corrected price. We recommend that you use CR orders to apply price changes.

The unreturned quantity is the quantity purchased but not returned on an RM order or a return line on a non-RM order. The unreturned quantity is adjusted for the unit and special cost pricing on the CR or RM order line in Sales Order Entry.

The unreturned quantity calculated from OEELCR records may not equate to the quantity shipped minus the quantity returned because the quantity returned is calculated when a return line is entered. The unreturned quantity only includes returns that have been invoiced.

When a line on a CR or RM order line is tied to an original order line, the corrected price and unreturned quantity is calculated. The calculation is based on the original sales order line data and applicable CR and RM data from OEELCR records that are tied to the original sales order line. If the unreturned quantity is zero, an error occurs and you cannot continue.

Note: You cannot enter an RM line for a quantity greater than the original quantity less the quantity returned. Because the quantity returned is calculated when the RM line is entered and the logic to calculate the unreturned quantity only includes invoiced RM lines, a mismatch occurs when there is an un-invoiced RM line for the line currently being processed.

The corrected price and unreturned quantity update the Price and Quantity fields on the CR or RM order line. You cannot change the calculated unreturned quantity on a CR order line, but you can change the quantity on an RM order line.

You cannot tie a CR or RM order line, including a return line on a non-RM order, to the original order line if a CR order line is already tied to the original order line and it is open. An open order is one that is not invoiced or not canceled. If an open CR order line is tied to the original order line, an error message with the details of the open transaction is displayed so you can complete the open transaction and proceed with the current transaction.

You can tie a two lines from a CR order to the same original order line if you are performing a manual credit and rebill transaction.

You can tie a CR or RM order line, including a return line on a non-RM order, to the original order line if an open RM order line is already tied to the original order line but a warning occurs. Additionally, if you use the Event Manager oe-openrm event, operators are notified of the open RM condition. Serial products are the exception to open RM processing. You cannot tie a CR order line to an original order line that is already tied to an open RM line if these conditions are met:

The product is a serial product
The Return Reason specified on the order includes serial and credit and rebill processing
Serial tracking is enabled by the CR Order Credit/Rebill Processing option in SA Administrator Options

If you attempt to tie an open CR to the original line order, an error message with the details of the open RM transaction is displayed so you can complete that transaction and proceed with your current order.

You can view the information that is related to the CR and RM lines in the Order Lines grid, and the Return and Correction History views in Sales Order Inquiry-Line Detail. Details are also included on the Sales Order Master List Report.

Calculating credit discounts

A credit discount is an amount applied to Correction (CR) or Return Merchandise (RM) lines or orders to reduce the discount amount of the original invoice. When a credit discount is applied, a new scheduled payment is created for the amount of the original invoice minus the credit amount. Depending on your selection for the Allow Credit Discounts option in SA Administrator Options-Customers-Cash Receipts, the credit discount can be calculated in different ways.

Applying returns to uninvoiced orders

There are occasions when your customer returns an item on a Counter Sale order the same day, before the order is processed in the nightly Sales Entry Invoice Processing Report. You might also be asked to remove an item from a previously-phoned in Stock Order (SO). If your normal practice is to tie Return Merchandise (RM) orders or return lines on SO or CS orders to an invoice, you will encounter errors when you attempt to tie the RM to the order while it is still in Shipped stage (3). To enable this tie, you or a manager must have authorization security for the Allow Returns in Shipped Stage authorization point. With authorization, you can specify the original order number in place of the invoice number when you complete the Return Details window.