How to Create a Customer RMA in iDempiere

Introduction

Customer RMA (Return Material Authorization) is an iDempiere document used to process products returned by customers after a completed sales shipment.

It provides a controlled workflow for damaged or expired returns, maintaining traceability between the original shipment and the generated return order.

Completing a Customer RMA triggers the Create Order From RMA process, which generates a return Sales Order and directly impacts inventory and accounts receivable.

Business Rules

  • Customer RMA must reference an existing completed Customer Shipment.
  • Only products delivered in the selected shipment can be added as return lines.
  • RMA Type must be selected to identify the return reason (Damaged or Expired).
  • At least one RMA Line must exist before the document can be completed.
  • Movement Quantity on the return line cannot exceed the original shipped quantity.
  • The RMA must be in Completed status before running Create Order From RMA.
  • Generated return Sales Orders retain a reference link to the originating RMA.

Configuration Steps

Step 1: Create the Customer RMA Header

The header establishes the return document, links it to the originating shipment, and identifies the return reason through the RMA Type.

  • Open Customer RMA and click New Record.
  • Select Document Type, enter Name, select RMA Type, click the Shipment/Receipt lookup to choose the original shipment, and save.
FieldSample ValueDescription
Document No30003Auto-generated RMA reference number
NameDamaged Product ReturnDescriptive name for the return
Document TypeCustomer Return MaterialIdentifies this as a Customer RMA document
RMA TypeDamagedReason for the customer return; Damaged or Expired
Shipment/Receipt500002_06/25/2026Original shipment from which products were delivered
Business PartnerALPHA RETAIL SOLUTIONSCustomer initiating the return (auto-populated from shipment)
Sales RepresentativeHarish NatarajanSales representative responsible for the return
Amount1,400.00Total return value, auto-calculated from RMA Lines

Step 2: Select the Original Shipment

Selecting the correct shipment ensures only products actually delivered to the customer can be returned, maintaining full return traceability.

  • Click the Shipment/Receipt field lookup.
  • The Shipment Info window opens listing all customer shipments.
  • Filter by Business Partner or Movement Date if needed, select the correct shipment row, and confirm.
FieldSample ValueDescription
Business PartnerALPHA RETAIL SOLUTIONSFilter shipments by customer
Movement Date06/25/2026Date the original shipment was dispatched
Document No500002Shipment document number to select
Sales TransactionCheckedConfirms the shipment is a customer delivery

Step 3: Create RMA Lines

RMA Lines define which products and quantities are being returned. The Create lines from process pulls products directly from the selected shipment.

  • Click Create lines from. The Create lines from RMA window opens showing all product lines from the selected shipment.
  • Select the product row, enter Movement Quantity, and click Create lines from RMA.
FieldSample ValueDescription
Business PartnerALPHA RETAIL SOLUTIONSCustomer from the selected shipment
Line No10Shipment line number
ProductAASH-ATTA-5KG_Aashirvaad Atta – 5kgProduct available for return from the shipment
Quantity5.00Original quantity delivered in the shipment
Movement Quantity5Quantity the customer is returning; editable field

Step 4: Review RMA Lines

Reviewing the RMA Line tab confirms the returned product, quantities, pricing, and tax are correctly populated before the document is completed.

  • Open the RMA Line tab and verify each line. Confirm Product, Shipment/Receipt Line, Quantity, Amount, Tax, and Line Amount.
  • Line Amount is calculated automatically as Quantity × Amount.
FieldSample ValueDescription
Line No10Sequence number for the return line
Shipment/Receipt Line10_5_AASH-ATTA-5KG – 5kg_500002_06/25/2026Original shipment line reference
ProductAASH-ATTA-5KG_Aashirvaad Atta – 5kgReturned product
Quantity5Number of units being returned
Amount280.00Unit selling price of the returned product
TaxCGST/SGST 18%Tax derived from the product Tax Category
Line Amount1,400.00Calculated as Quantity × Amount (5 × 280)

Step 5: Execute Document Action

  • Click Document Action in the toolbar. The dropdown shows Complete, Prepare, and Void. Select the required action.
  • For standard processing, select Complete to finalize the RMA.
Document ActionResulting StatusWhen to Use
PrepareIn ProcessValidates the RMA and checks for errors without finalizing; useful for pre-completion review
CompleteCompletedFinalizes the RMA and enables the Create Order From RMA process; standard action for confirmed returns
VoidVoidedPermanently cancels the RMA; no return order can be generated; use when the return is no longer required

Step 6: Generate Return Sales Order

Create Order From RMA converts the completed RMA into a return Sales Order, enabling downstream processing such as return receipt and credit handling.

  • On the completed RMA, click Create Order From RMA.
  • The dialog confirms the RMA document is correct and completed.
  • Enable Run as Job if background processing is preferred, then click OK.
FieldValueDescription
PromptCreates an order based on this RMA Document. The RMA should be correct and completed.System confirmation before order creation
Run as JobUncheckedEnable to run the order generation as a background process

Step 7: Verify the Generated Sales Order

After order creation, the RMA header shows Order Created and the Order field is populated. Verifying the order confirms all return details were carried forward correctly.

  • Click the Order link on the completed RMA or open the Sales Order window and search for the generated order.
  • Verify Business Partner, Product, Quantity, Warehouse, Price List, and the RMA reference.
FieldExpected ValueDescription
Document No20004Auto-generated return Sales Order number
Business PartnerALPHA RETAIL SOLUTIONSCustomer from the originating RMA
WarehouseCDC GodownWarehouse receiving the returned goods
Price ListStandard Sales Price ListPrice list from the customer account
Product (Order Line)AASH-ATTA-5KG Aashirvaad Atta – 5kgProduct carried from the RMA line
Order (on RMA)20004_07/02/2026Reference shown on the completed RMA linking to the return order

Common Issues and Resolutions

IssueCauseResolution
Shipment not found in lookupShipment belongs to a different customerFilter by the correct Business Partner in the Shipment Info window.
No products in Create lines fromWrong shipment selectedReturn to the header and select the correct Shipment/Receipt.
Movement Quantity exceeds originalMore units entered than shippedSet Movement Quantity to the original shipped quantity or less.
Unable to complete RMANo RMA Lines addedAdd at least one return line using Create lines from before completing.
Create Order From RMA button absentRMA is not in Completed statusComplete the RMA using Document Action before generating the return order.
Line Amount is zero on RMA LineAmount field is empty or zeroVerify the unit price is populated; re-select the product if needed.
Tax not shown on RMA LineProduct Tax Category not configuredAssign the correct Tax Category to the product in Product Master.

Next Steps

  • Process the return Sales Order to receive goods back into the warehouse.
  • Generate a Customer Credit Memo or Credit Invoice for the returned amount.
  • Reconcile returned inventory using the Storage Detail report.
  • Update the customer account balance after credit processing.
  • Review return volumes periodically using RMA and return order reports.

Leave a Reply

Your email address will not be published. Required fields are marked *