{"id":19641,"date":"2026-07-02T12:09:11","date_gmt":"2026-07-02T12:09:11","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=19641"},"modified":"2026-10-05T07:02:54","modified_gmt":"2026-10-05T07:02:54","slug":"how-to-process-customer-returns-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-process-customer-returns-in-idempiere\/","title":{"rendered":"How to Process Customer Returns in iDempiere"},"content":{"rendered":"\n

The Customer Return window in iDempiere records returned products coming back into the warehouse from a customer. It is used in retail after a Customer RMA has been approved, such as damaged or wrong-item returns from a store or walk-in customer.<\/p>\n\n\n\n

Completing a Customer Return updates stock on hand, keeps traceability to the originating RMA, and enables the credit memo and inventory confirmation steps that follow.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Customer Return must reference a completed and approved Customer RMA.<\/li>\n\n\n\n
  • At least one return line is required before the document can be completed.<\/li>\n\n\n\n
  • Returned quantity cannot exceed the approved RMA line quantity.<\/li>\n\n\n\n
  • Inventory on hand updates only after the Customer Return is completed.<\/li>\n\n\n\n
  • Return invoice generation requires the Customer Return to be completed first.<\/li>\n\n\n\n
  • Pending Ship\/Receipt confirmations must be processed before completion, if required.<\/li>\n\n\n\n
  • Completed Customer Return documents are read-only and retain RMA traceability.<\/li>\n<\/ul>\n\n\n\n

    Configuration Steps<\/strong><\/h2>\n\n\n\n

    Step 1: Create the Customer Return Header<\/strong><\/h3>\n\n\n\n

    Create a new Customer Return, select the approved RMA, and confirm the Business Partner, Partner Location, and Warehouse are correctly populated from the RMA.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    RMA<\/td>30004<\/td>Approved Customer RMA this return fulfills<\/td><\/tr>
    Document Type<\/td>MM Customer Return<\/td>Identifies the transaction as a customer return<\/td><\/tr>
    Business Partner<\/td>ALPHA RETAIL SOLUTIONS<\/td>Customer returning the goods<\/td><\/tr>
    Partner Location<\/td>Chennai<\/td>Delivery\/return location of the Business Partner<\/td><\/tr>
    Warehouse<\/td>CDC Godown<\/td>Warehouse receiving the returned stock<\/td><\/tr>
    Freight Cost Rule<\/td>Freight Included<\/td>How freight cost is handled on the return<\/td><\/tr>
    Priority<\/td>Medium<\/td>Processing priority of the return document<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 2: Generate Return Lines from Shipment\/Receipt<\/strong><\/h3>\n\n\n\n

    Click Create Lines From on the Customer Return header, select the approved RMA and returned product, then click Create Lines from Shipment\/Receipt.<\/p>\n\n\n\n

    Step 3: Review the Customer Return Line<\/strong><\/h3>\n\n\n\n

    Open the Customer Return Line tab and verify the Product, Locator, Quantity, and RMA Line reference before proceeding.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Product<\/td>AASH-ATTA-5KG_Aashirvaad Atta \u2013 5kg<\/td>Returned inventory item<\/td><\/tr>
    Locator<\/td>Godown Locator<\/td>Warehouse location receiving the returned stock<\/td><\/tr>
    Quantity<\/td>3<\/td>Number of units received back into inventory<\/td><\/tr>
    UOM<\/td>Each<\/td>Unit of Measure for the returned quantity<\/td><\/tr>
    RMA Line<\/td>30004_10_3_AASH-ATTA-5KG<\/td>Reference to the approved Customer RMA line<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 4: Complete the Customer Return<\/strong><\/h3>\n\n\n\n

    Select Document Action \u2192 Complete. The Document Status changes to Completed and the document becomes read-only.<\/p>\n\n\n\n

    Note: <\/strong>Once completed, returned quantity (e.g. 3 units of Aashirvaad Atta \u2013 5kg) is added back to CDC Godown stock.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Step 5: Create Inventory Confirmation (Optional)<\/strong><\/h3>\n\n\n\n

    From Document Action, run Create Confirmation, choose the appropriate Confirmation Type, and click OK to generate the confirmation document.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Purpose<\/strong><\/td><\/tr><\/thead>
    Confirmation Type<\/td>Ship\/Receipt Confirm<\/td>Verifies the physical shipment\/receipt quantity<\/td><\/tr>
    Confirmation Type<\/td>Customer Confirmation<\/td>Confirms the return with the customer<\/td><\/tr>
    Confirmation Type<\/td>Pick\/QA Confirm<\/td>Records picking and quality inspection results<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 6: Generate Invoice from Receipt<\/strong><\/h3>\n\n\n\n

    Run Generate Invoice from Receipt, select the Price List, optionally set the Invoice Document No, then click OK to create the AR Credit Memo.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Price List<\/td>Standard Sales Price List<\/td>Price list used to value the credit memo<\/td><\/tr>
    Invoice Document No<\/td>1000001<\/td>Document number of the generated credit memo<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 7: Review the Generated Credit Memo<\/strong><\/h3>\n\n\n\n

    Open the Sales Invoice and Credit\/Debit Memo window, verify the invoice line, totals, and tax, then confirm the document is Posted.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Target Document Type<\/td>AR Credit Memo<\/td>Identifies the invoice as a customer credit memo<\/td><\/tr>
    Business Partner<\/td>ALPHA RETAIL SOLUTIONS<\/td>Customer being credited<\/td><\/tr>
    Price List<\/td>Standard Sales Price List<\/td>Price list applied to the credit memo<\/td><\/tr>
    Payment Rule<\/td>Mixed POS Payment<\/td>How the credit will be settled<\/td><\/tr>
    Total Lines<\/td>840.00<\/td>Line total before tax, in INR<\/td><\/tr>
    Grand Total<\/td>991.20<\/td>Total credit amount including CGST\/SGST, in INR<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
    Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
    No RMA available<\/td>Customer RMA has not been completed<\/td>Complete the Customer RMA before creating the Customer Return<\/td><\/tr>
    No return lines generated<\/td>Selected RMA has no approved return quantity<\/td>Verify the RMA contains approved quantities before Create Lines From<\/td><\/tr>
    Return quantity mismatch<\/td>Entered quantity exceeds approved RMA quantity<\/td>Match the return quantity to the approved RMA line<\/td><\/tr>
    Unable to complete document<\/td>No return line exists on the document<\/td>Add at least one return line before completing<\/td><\/tr>
    Confirmation pending error<\/td>Required Ship\/Receipt confirmation not processed<\/td>Process the pending confirmation before completing the return<\/td><\/tr>
    Invoice not generated<\/td>Customer Return not yet completed<\/td>Complete the Customer Return before running Generate Invoice from Receipt<\/td><\/tr>
    Incorrect tax on credit memo<\/td>Wrong Price List or product tax category<\/td>Verify the Price List and tax category configured on the product<\/td><\/tr>
    Locator not found<\/td>Warehouse locator not configured<\/td>Configure a locator for the warehouse before receiving the return<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Next Steps<\/strong><\/h2>\n\n\n\n
      \n
    • Customer Return Invoice (Credit Memo) posting and review.<\/li>\n\n\n\n
    • Customer refund processing, if applicable.<\/li>\n\n\n\n
    • Inventory confirmation review and closure.<\/li>\n\n\n\n
    • Financial posting verification.<\/li>\n\n\n\n
    • Return analysis and reporting.<\/li>\n<\/ul>\n\n\n\n