Customer_Return_Line__c

Label: Customer Return Line

The customer return line describes the items that are the subject of the customer return. Each line is associated with a sales order line and displays details of the item master, the return action for the item master, shipping data and credit, fees and warranty information.

Field Name	Field Label	Created in Version	Description	Type	Default Value
Actual_Quantity_Returned__c	Actual Quantity Returned	Fall 2018	Total quantity received.	Number(18,4)	0
Actual_Value_of_Credit_Before_Fees__c	Actual Value of Credit Before Fees	Fall 2018	Actual value of credit for items that have a return action of Customer Credit. Calculated from the item quantities multiplied by the customer return unit prices. Formula: IF( ISPICKVAL( Return_Action__c , 'Customer Credit') , Actual_Quantity_Returned__c * Unit_Price__c , 0)	Currency(18,9)
Actual_Value_of_Credit_Minus_Fees__c	Actual Value of Credit Minus Fees	Fall 2018	Actual value of credit for items that have a return action of Customer Credit minus restocking fees minus other fees. Formula: IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), Actual_Quantity_Returned__c > 0) , ( Actual_Quantity_Returned__c * Unit_Price__c ) - Restocking__c - Other__c , 0)	Currency(18,9)
Actual_Value_of_Return_Items__c	Actual Value of Return Items	Fall 2019	Actual Quantity Returned x Unit Price Formula: Actual_Quantity_Returned__c * Unit_Price__c	Currency(18,9)
Already_Returned_Quantity__c	Already Returned	Spring 2019	The current quantity that has already been returned by the customer. Formula: Sales_Order_Line__r.Already_Returned__c	Number(18,4)
Already_Returned__c	DEPRECATED: Already Returned	Fall 2018	Deprecated field. The current quantity that has already returned by the customer.	Number(18,4)	0
Customer_Credit_Minus_NC_Items_and_Fees__c	Customer Credit Minus NC Items and Fees	Fall 2018	Actual value of the returned items minus the total return fees, minus the total value of Non Conforming (NC) items. Only customer return lines with a return action of Customer Credit will be included. Formula: IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), Actual_Quantity_Returned__c > 0) , ( ( Actual_Quantity_Returned__c - Quantity_of_Non_Conforming_Items__c ) * Unit_Price__c ) - Restocking__c - Other__c , 0)	Currency(18,9)
Customer_Return__c	Customer Return	Fall 2018	Looks up to: Customer_Return__c	MasterDetail
Customer_Warranty_Claim_Date__c	Customer Warranty Claim Date	Fall 2018	The date the customer submitted the warranty claim for a replacement or credit.	Date
Customer_Warranty_Claim_Granted__c	Customer Warranty Claim Granted	Fall 2018		Picklist: No Yes
Customer_Warranty_Claim_Resolution_Date__c	Customer Warranty Claim Resolution Date	Fall 2018	The date the customer warranty claim for a replacement or credit was resolved.	Date
Date_Returned__c	Date Returned	Fall 2018	Date on which the last of the returned items were received into the return warehouse.	Date
Expected_Extended_Price__c	Expected Extended Price	Fall 2018	The customer return unit price multiplied by the expected return quantity. Formula: To_Return__c * Unit_Price__c	Currency(18,9)
Expected_Value_of_Credit_Minus_Fees__c	Expected Value of Credit Minus Fees	Fall 2018	The expected value of the returned items minus the total return fees. Only customer return lines with a return action of Customer Credit will be rolled up. Customer return lines that are customer exchanges or repairs are not rolled up. Formula: IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), To_Return__c > 0) , ( To_Return__c * Unit_Price__c ) - Restocking__c - Other__c , 0)	Currency(18,9)
Inspected_Quantity_Accepted__c	Inspected Quantity Accepted	Fall 2019	The current quantity of items that have been accepted during inspection.	Number(18,4)	0
Inspection__c	Inspection	Fall 2018	Inspection options for the customer return. Defaults from the header. Line values can be changed. Editing is enabled by a custom setting.	Picklist: Inspection Required No Inspection Required No Inspection Required - Customer Scrapping Unused/Closed Box
Item_Description__c	Item Description	Fall 2018	Formula: Sales_Order_Line__r.Item_Description__c	Text
Item_Master__c	Item Master	Fall 2018	The Item Master this return line refers to. Looks up to: Item__c	Lookup
Item_Past_Returns_Date__c	Item Past Returns Date	Fall 2018	Based on your company returns policy, this field indicates if the item has passed the last return date.	Checkbox	true
Item_Shipped_Cost__c	Item Cost When Shipped	Fall 2019	The supplier cost of the item when it was shipped to the customer.	Currency(18,9)	0
Lot_Numbers_Shipped__c	Lot Numbers Shipped	Fall 2018		LongTextArea(32768)
Lot_Numbers_to_Return__c	Lot Numbers to Return	Fall 2018		LongTextArea(32768)
Other__c	Other	Fall 2018		Currency(18,9)	0
Quantity_Shipped__c	Quantity Shipped	Fall 2018	The quantity shipped on the associated sales order. Formula: Sales_Order_Line__r.Quantity_Shipped__c	Number(18,4)
Quantity_of_Non_Conforming_Items__c	Quantity of Non Conforming Items	Fall 2018	The total quantity of non conforming items at inspection.	Number(18,4)	0
Reason_for_Return__c	Reason for Return	Fall 2018	Reason for the customer return. The reason selected at header level will be the default for the customer return lines, but each line value can be changed individually.	Picklist: Item faulty Item not as expected Item not required
Restocking_And_Other_Fees_Sum__c	Restocking And Other Fees Sum	Fall 2018	Formula: Restocking__c + Other__c	Currency(18,9)
Restocking__c	Restocking	Fall 2018	A fee charged to the customer for accepting a return, either as a flat fee or percentage.	Currency(18,9)	0
Return_Action__c	Return Action	Fall 2018	The customers preferred action. The action selected at the header will be the default for the customer return lines. Each line action can be changed individually.	Picklist: Customer Credit Customer Exchange Repair
Sales_Order_Line__c	Sales Order Line	Fall 2018	The Sales Order line this return line refers to. Looks up to: Sales_Order_Line_Item__c	Lookup
Serial_Numbers_Shipped__c	Serial Numbers Shipped	Fall 2018		LongTextArea(32768)
Serial_Numbers_Status__c	Serial Numbers Status	Spring 2020	Indicates if all the required serial numbers have been entered on the customer return line, or if more serial numbers are required, or if no serial number required for the customer return item. Formula: IF( OR ( Item_Master__r.Serial_Number_Control__c, Item_Master__r.Inbound_Outbound_Serial_Number__c ), IF( OR ( ISNULL(Total_Serial_Numbers__c), Total_Serial_Numbers__c < To_Return__c ), IMAGE('/resource/SCMC__CustomerReturn/images/emptyCircle.png', $Label.SerialNumbersPending, 25, 30), IMAGE('/resource/SCMC__CustomerReturn/images/successCircle.png', $Label.SerialNumbersAllSelected, 25, 30) ), '' )	Text
Serial_Numbers_to_Return__c	Serial Numbers to Return	Fall 2018		LongTextArea(32768)
Shipping_Date__c	Shipping Date	Fall 2018	The date the items were shipped to the customer. Formula: NOW()	Date
Shipping__c	Shipping	Fall 2018	Defaults from the header. You can change the value at line level if required.	Picklist: Customer Arranging Shipping No Shipping Required - Customer Scrapping Shipment Arrangement Required
Status__c	Status	Fall 2018	Status of the customer return line. Updated by the system as the items progress through the customer returns process.	Picklist: Approved Inspected New Partially Received Received
Supplier_Warranty_Claim__c	Supplier Warranty Claim	Fall 2018	Has a warranty claim been filed with the original supplier.	Picklist: No Yes
To_Return__c	To Return	Fall 2018	The quantity expected to be returned by the customer.	Number(18,4)
Total_Serial_Numbers__c	Total Serial Numbers	Spring 2020	Total number of serial numbers added.	Number(10,0)	0
Unit_Price__c	Unit Price	Fall 2018	The unit price of the customer return line item. Derived from the sales order.	Currency(18,9)
Value_of_Non_Conforming_Items__c	Value of Non Conforming Items	Fall 2018	The quantity of non conforming items multiplied by their unit costs. Formula: Quantity_of_Non_Conforming_Items__c * Unit_Price__c	Currency(18,9)