Sales Warranty Returns Report overview

Sales > Reports > OE Reports > OEROW

Function acronym: OEROW

Use this report to assist in applying for credit using the Purchase Order Entry Return Merchandise (RM) transaction and locating the status of a particular product or warranty return.

Every product returned by your customer needs to be returned to inventory for resale, or returned to the vendor for credit to offset the original sale. Vendor returns must be tracked to be properly processed and sent to the vendor for eventual credit.

Only information for orders that have been processed through Sales Entry Invoice Processing Report are included with this report. If your SA Table Code Value Setup Return/Adjust Reason contains a stock, unavailable, or partial return type, the vendor return is assigned a Stage 0 (Not Returnable) and is not included on the Sales Warranty Returns Report.

You can print warranty returns with these Warranty Stages:
  • Stage 0: Not Returnable
  • Stage 1: Entered
  • Stage 2: Printed
  • Stage 3: Credit Applied For

If your SA Table Code Value Setup Return/Adjust Reason contains a vendor Return Type, the transaction is created in Sales Order Entry in Stage 1 (Entered). This stage includes all items that have been returned to you and are awaiting return to your vendor. When you generate the Sales Warranty Returns Report, you can set the report parameters to update to Stage 2 (Printed). The items that have been printed but not yet placed on a PO RM to the vendor represent the lag time in your internal processing. Sales Entry Invoice Processing Report updates the Unavailable balance inProduct Warehouse Product Setup.

You can also automatically create the PO RM when you run the Sales Warranty Returns Report. Select Yes for the Create PO-RM Order option, and PO RMs are created for Stock Orders (SO) or Counter Sales (CS) orders with return lines, or Return Merchandise (RM) orders that are in Warranty Stage 1 or 2.

These updates occur as the return is processed:

Function Process
Sales Order Entry Enter the sales return transaction (RM/CS/SO).

Customer Setup – On Order Balance decreased by the amount of the return, including addons, DATC, and taxes.
Sales Entry Invoice Processing Report

Process the return transaction (RM/CS/SO)

Customer Setup – Restock charge added to Period 1 balance. The Returns YTD balance is increased by the amount of the line item less the discount.

Product Warehouse Product Setup – Unavailable balance increased by the quantity of the return.

Sales Warranty Return Report – Return is in Stage 1 (Entered).
Purchase Order Entry

Enter the PO RM if it is not created automatically when you ran Sales Warranty Returns Report.

A stock order must be invoiced or paid to tie the PO RM to the sales RM.

This advances the Warranty Stage to 3 - Credit Applied For.
Vendor Invoice Center Entry

Cost the PO RM.

The Credit field must be set to Yes.

Vendor Setup – The Current Balance, Returns YTD, and RMA Balance fields are updated by the amount of the return. If your vendor is a foreign vendor, the foreign monetary equivalent appears beside the Current Balance field. The SA Currency Table Setup record is used for the conversion.

After the product is entered on a PO RM with a tie to the sales order number and line number, the stage code is updated to 3 (Credit Applied For). Purchase Order Entry gets the appropriate quantity from the Product Warehouse Product Setup Costs Unavailable quantity.

Products with a Vendor Return Type, specified inSA Table Code Value Setup, are included on the report. If a PO RM is entered for the return line, the purchase order and line number appear on the report. In this case, the warranty stage code is 3 (Credit Applied For). If the PO RM has been costed, Credited appears next to the purchase order number.

Ties between a PO RM and Sales Order Entry line items are made if the warranty stage is 2 (Reported) or 3 (Credit Applied For). If a PO RM is tied to a sales order line item, the PO information is included on the report. This report does not provide information for kit components.

The amount of outstanding RM is stored on the Vendor Entry Maintain Vendor Balances. The RM outstanding balances represent the credit that you have issued to your customer but have not received from your vendor.

It is displayed at the top of the Vendor Entry Cash Requirements Report and Vendor Entry Pay Invoices Due Report, so you know what returns are outstanding at any point in time. The outstanding Return Merchandise balance is an important figure to know, especially before you issue payments to your vendor.

Foreign Customers: All currency amounts appear in the foreign value.