RA Pricing Logic

As return authorization records are created, the system uses historical information such as invoice and serial master and history records, and current information  such as the customer default price level and currency, to find the correct prices to be used on the RA.  The system then automatically suggests these prices during processing.  The system calculated prices can be accepted or changed as required based on the individual ra line that is being processed. 

There are two different pricing fields that are stored for each RA line.  These are the Return Value and the Replace Value.

      Return Value:  The Return Value field stores the price (in the currency being used for the RA) that should be used when issuing a credit memo to the customer for the returned item.

      Replace Value:  The Replace Value field stores the price (again in the currency being used for the RA) that should be used when issuing a replacement sales order to the customer for the item being returned.  The Replace Value field is only used when you dispose of an RA using the Replace Option, or when you Cross Ship a replacement item to the customer using the Cross Shipment Option.

The Logic used to determine the correct price during RA Entry is based on both system parameter settings and on how the ra was entered.

RA Line is Associated with a Serial Record.

If the RA Line was created by selecting a specific Serial Number, the system uses the price stored in the Serial record for both the return and the replace value of the ra line.  These prices are rounded to 2 decimals.

RA Line is Associated with an Invoice Line.

If the RA was created using an invoice line, the system will have the information from the invoice line and the serial record available at the time the ra is created.

In this case the pricing logic used by the system is as follows.

1.  Locate the invoice line item associated with the ra line.  If found, use the transact price rounded to 2 decimals for both the return and the replace value of the ra line.

2.  If the system parameter RAUTOPRC is set to Y, the system looks up the last sale price for the company and item combination being processed.  If the system finds a valid sales price, this price is used even if it is different from the line item price associated with the return.  If the system does not find a valid last sales price for the company and item, a 0 is returned by the system, and the operator must manually specify the return and replace values to be used.  Note:  The RAUTOPRC option is normally used when you sell inventory that declines in value over time.  Examples might include computer equipment or other items that may decrease in price rapidly over time.  This option allows you to use the last and normally lowest price charged to the customer when processing a credit or replacement sales order.

RA Line is Not Associated with an Invoice Line

If the RA is not associated with a specific invoice line, or serial record, the system will not have the information from the invoice line and serial record available at the time the ra is created.  In this case, the following logic is used to determine the return and replacement price suggested by the system.

1.  The system tries to find the last sales price for the company and item combination being processed.  It does this regardless of how the RAUTOPRC parameter is set.   If the return value is not 0, the last sales price is used.

2.  If no last sales price is found (or it is 0), the system calculates the price for the item using the company default price level, and the ra currency. It then returns this price.  At this point, the system checks the RAUTOPRC parameter.  If it is set to N, the price calculated in steps 1 and 2 is used.

3.  If the RAUTOPRC parameter is set to Y (meaning you wish to force the most recent price), the system then tries to find the last sales price again.  This value is then returned even if 0 and is loaded into both the return and the replace value fields.

More:

RA Statistical Information