How to Configure Customer in iDempiere for Retail

Customer setup in iDempiere is managed through two windows: Business Partner Group and Business Partner. Together they maintain customer master records required for sales transactions, invoicing, taxation, payment handling, and pricing.

Business Value In retail, customer configuration supports three customer types: regular GST customers, institutional / corporate customers, and interstate IGST customers — each with distinct pricing, payment terms, and tax treatment.

Prerequisites

Before starting, ensure the following:

  • Initial Tenant Setup completed successfully
  • Organization structure configured
  • Price Lists configured and activated
  • Payment Terms configured
  • GST Tax configuration completed

Business Rules

  • Customer Name and Address should be maintained before using the customer in sales transactions.
  • Customer mobile numbers should be maintained consistently to reduce duplicate customer creation during retail billing operations.
  • Credit customers should be configured with appropriate Credit Limit and Payment Terms to support credit-based sales transactions.
  • When Credit Limit and Credit Status are configured, iDempiere validates customer outstanding balances during sales order processing.
  • GST customers should be maintained with valid Tax ID information for GST and IGST tax calculation.
  • Customer contact and location details should be maintained properly for billing, delivery, and communication purposes.
  • Business Partner Groups can be used to manage customer pricing and transaction behaviour through standard configuration.

Navigation

Two windows are used for customer configuration:

Business Partner Group:

Menu → Master Data Rules → Business Partner Group

Business Partner:

Menu → Master Data Rules → Business Partner

Step-by-Step Configuration

Step 1: Open Business Partner Group Window

The window lists all existing Business Partner Groups under the tenant.

Step 2: Create Retail Customer Group

Click New Record (+) and enter the following details:

FieldValue
Organization*
Search KeyRETAIL
NameRetail Customer
DescriptionRegular GST and retail customers
Price ListStandard Sales Price List
ActiveYes
DefaultYes

This group is used for regular GST and IGST retail customers. Setting it as Default automatically assigns retail sales pricing to new customers.

Step 3: Create Institutional Customer Group

Click New Record (+) and enter the following details:

FieldValue
Organization*
Search KeyINST
NameInstitutional Customer
DescriptionCorporate and institutional customers
Price ListWholesale Sales Price List
Credit Watch %80
ActiveYes

Used for corporate and bulk purchase customers. Supports wholesale pricing and credit-based transactions.

Step 4: Open Business Partner Window

Navigate to Menu → Master Data Rules → Business Partner. Click New Record (+) to create individual customer records.

Step 5: Configure Institutional Customer

Header Information

FieldValue
Search Key1000000
Business Partner GroupInstitutional Customer
NameIndian Bank
Name 2Chennai Regional Office
CustomerYes
Credit StatusNo Credit Check
Credit Limit100000.00
Tax ID33AAACI9998G1Z5
DescriptionBanking and financial institutional customer
URLhttps://www.indianbank.in
ActiveYes

Credit Management

Credit-based customers can be controlled using Credit Status, Credit Limit, Payment Rule, and Payment Term fields.

This configuration helps retail businesses manage institutional and credit customers separately from regular walk-in customers.

When the configured credit limit is exceeded, iDempiere validates the outstanding balance during sales order processing and restricts additional credit transactions based on the customer credit setup.

Customer Information

FieldValue
Invoice RuleImmediate
Payment RuleOn Credit
Delivery RuleAvailability
Delivery ViaDelivery
Price ListWholesale Sales Price List
Payment TermNet 30 Days

Institutional customers are used for bulk and credit-based sales transactions. Wholesale pricing is assigned by default through the Institutional Customer group.

Step 6: Configure GST Customer

Header Information

FieldValue
Search Key1000001
Business Partner GroupRetail Customer
NameKalyan Jewellers India Limited
Name 2Chennai Branch
CustomerYes
Credit StatusNo Credit Check
Credit Limit250000.00
Tax ID33AAACK5678Q1Z2
DescriptionJewellery retail GST customer
ActiveYes

Customer Information

FieldValue
Invoice RuleImmediate
Payment RuleCash
Delivery RuleAvailability
Delivery ViaPickup
Price ListStandard Sales Price List
Payment TermImmediate

Used for same-state GST billing transactions. CGST and SGST are applied during sales based on the customer GSTIN state code.

Step 7: Configure IGST Customer

Header Information

FieldValue
Search Key1000005
Business Partner GroupRetail Customer
NameMarvel Enterprises
Name 2Bengaluru Trading Division
CustomerYes
Credit StatusNo Credit Check
Credit Limit125000.00
Tax ID29AAJFM4587L1Z2
DescriptionKarnataka based wholesale and trading customer
ActiveYes

Customer Information

FieldValue
Invoice RuleAfter Delivery
Payment RuleOn Credit
Delivery RuleAvailability
Delivery ViaDelivery
Price ListWholesale Sales Price List
Payment TermNet 30 Days

Used for interstate customer transactions. IGST is applied based on the customer GSTIN state code (29 = Karnataka).

Step 8: Configure Contact and Location Details

After saving the customer header, use the sub-tabs to add contact and address records.

Contact (User) Tab

Business Partner → Contact (User) tab → New Record (+)

FieldValue
NameVinay Kumar
Email Addresspurchase@marvelenterprises.in
Phone9876501234
PositionPurchase Executive
ActiveYes

Stores customer contact details used for invoices, transaction references, and communication.

Location Tab

Business Partner → Location tab → New Record (+)

FieldValue
NameBengaluru Office
AddressCommercial Street, Bengaluru, Karnataka – 560001
Ship AddressYes
Invoice AddressYes
Pay-FromYes
Remit-To AddressYes
ActiveYes
Tax Applicability The customer state in the Location record determines GST applicability. Same-state customers (Tamil Nadu) use CGST + SGST. Customers in other states use IGST.

Step 9: Save the Record

Click Save. The customer is now available for use across:

  • Sales Orders
  • POS Transactions
  • Customer Invoices
  • Shipment Transactions
  • Payment Processing

Field Reference

Business Partner Group Fields

  • Search Key Unique short code for the group (e.g., RETAIL, INST)
  • Name – Display name used in customer records
  • Price List – Default price list assigned to all customers in this group
  • Credit Watch % – Threshold percentage that triggers credit watch alerts
  • Default – Sets this group as the default for new customer records
  • Active – Makes the group available for use

Business Partner Fields

  • Search Key – Unique customer code used in transactions
  • Business Partner Group – Links the customer to a group for pricing and credit rules
  • Customer – Must be enabled — makes the record available in sales windows
  • Tax ID – Customer GSTIN — determines state code for tax calculation
  • Credit Status – Controls credit check behaviour during order processing
  • Credit Limit – Maximum outstanding balance allowed for the customer
  • Invoice Rule – Controls when invoices are generated (Immediate / After Delivery)
  • Payment Rule – Default payment method (Cash / On Credit)
  • Price List – Overrides the group price list for this specific customer
  • Payment Term – Default payment term applied to sales transactions

Configuration Summary

Customer TypeGroupTaxPayment
InstitutionalINSTCGST + SGSTOn Credit / Net 30
GST RetailRETAILCGST + SGSTCash / Immediate
IGST InterstateRETAILIGSTOn Credit / Net 30

Business Flow Overview

Business Partner Group (pricing + credit rules)

Business Partner / Customer record

Contact + Location (address → tax state determination)

Sales Order → POS Transaction

Customer Invoice (GST / IGST applied)

Shipment → Payment Processing

Common Issues

IssueResolution
Price List not visibleCreate and activate a Price List Version
Customer unavailable in salesEnable the Customer checkbox on the Business Partner record
Address not appearing on invoiceEnable Invoice Address on the Location record
Delivery address unavailableEnable Ship Address on the Location record
Credit transactions restrictedVerify Credit Limit and Credit Status values
Changes not reflected after saveRun Cache Reset and log in again

Best Practices

  • Use numeric Search Keys for Business Partners to maintain a consistent customer numbering sequence.
  • Always enable the Customer checkbox — records without it will not appear in sales windows.
  • Configure at least one active Location record with Invoice Address and Ship Address enabled.
  • Use Business Partner Groups to manage default pricing and credit rules instead of overriding configurations for individual customers.
  • Set Credit Watch % for institutional customer groups to monitor credit exposure before reaching the configured credit limit.

Next Steps

After completing Customer setup, continue with:

  • Sales Order Setup — raise orders against configured customers
  • POS Transactions — link customers to point-of-sale sessions
  • Customer Billing — generate invoices with correct GST / IGST
  • Payment Processing — apply payment terms and record receipts

Leave a Reply

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