{"id":18661,"date":"2026-05-29T11:12:55","date_gmt":"2026-05-29T11:12:55","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18661"},"modified":"2026-06-08T10:05:52","modified_gmt":"2026-06-08T10:05:52","slug":"how-to-configure-sales-rep-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-sales-rep-in-idempiere\/","title":{"rendered":"How to Configure Sales Rep in iDempiere"},"content":{"rendered":"\n

Learn how Sales Representatives are managed in iDempiere Distribution Management. Configure Business Partners as Sales Reps and track their sales orders, invoices, and performance through the Sales Rep Info window.<\/p>\n\n\n\n

Introduction<\/strong><\/h2>\n\n\n\n

In distribution businesses, sales representatives play a critical role in managing customer relationships, generating orders, and driving revenue across different sales territories. iDempiere simplifies Sales Representative management by allowing existing Business Partner records to be designated as Sales Reps through a simple configuration setting. Once enabled, the Sales Rep Info window provides a centralized, read-only view of all sales transactions linked to the representative, including Sales Orders and Invoices. This enables distributors to monitor sales performance, analyze revenue contributions, and gain valuable insights into sales activities without navigating multiple transaction screens.<\/p>\n\n\n\n

Business Rules<\/h2>\n\n\n\n
    \n
  • A Sales Rep is not created through a dedicated window. It is defined by enabling the Sales Rep checkbox on an existing Business Partner record.<\/li>\n\n\n\n
  • The Sales Rep Info window is read-only – no records can be created or edited there directly.<\/li>\n\n\n\n
  • All contact Changes to Sales Rep details must always be made in the Business Partner window, not in the Sales Rep window (phone, email) is maintained in the Business Partner record and reflected automatically in the Sales Rep window.<\/li>\n\n\n\n
  • Deactivate the Business Partner record (uncheck Active) to remove the Sales Rep from transactions – do not delete the record.
    <\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n

    Before configuring a Sales Rep, ensure the following are in place:<\/p>\n\n\n\n

      \n
    • Initial Tenant Setup completed successfully<\/li>\n\n\n\n
    • The individual to be designated as a Sales Rep already has a Business Partner record<\/li>\n\n\n\n
    • Organization structure is fully configured<\/li>\n\n\n\n
    • Logged in with a role that has access to the Business Partner window<\/li>\n\n\n\n
    • The Business Partner record is Active before enabling the Sales Rep flag<\/li>\n<\/ul>\n\n\n\n

      How a Sales Rep Is Configured<\/strong><\/h2>\n\n\n\n

      A Sales Rep is created entirely within the Business Partner window. There is no separate creation form in the Sales Rep window \u2014 that window is read-only and only displays records that were promoted from Business Partner.<\/p>\n\n\n\n

      The process is:<\/p>\n\n\n\n

        \n
      • Open the Business Partner record for the person being designated as a Sales Rep<\/li>\n\n\n\n
      • Locate the Sales Rep checkbox on the Business Partner form<\/li>\n\n\n\n
      • Check the Sales Rep checkbox and save the record<\/li>\n\n\n\n
      • iDempiere automatically makes this Business Partner available in the Sales Rep window<\/li>\n<\/ul>\n\n\n\n
        Note:<\/strong> Do not attempt to create Sales Rep records directly in the Sales Rep window. Records there are auto-populated by iDempiere based on the Sales Rep checkbox in Business Partner. Manual creation from that window is not the correct approach.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Navigation<\/strong><\/h2>\n\n\n\n

        Step 1: Open the Business Partner Window<\/strong><\/h3>\n\n\n\n

        Navigate to the Business Partner window:<\/p>\n\n\n\n

        Menu \u2192 Partner Relations \u2192 Business Partner<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n
        Note:<\/strong> Use the iDempiere menu search bar and type ‘Business Partner’ to locate the window quickly.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step 2: Open or Create the Business Partner Record<\/strong><\/h3>\n\n\n\n

        Search for the existing Business Partner record for the person you want to designate as a Sales Rep. If no record exists, create one first by clicking New Record: New Record ( + )<\/p>\n\n\n\n

        Business Partner – Field Reference<\/strong><\/h2>\n\n\n\n

        When configuring a Business Partner who will serve as a Sales Rep, the following fields are relevant. The Sales Rep checkbox is the critical field that triggers the Sales Rep registration:<\/p>\n\n\n\n

        Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
        Tenant<\/td>The client this record belongs to. Set automatically based on login context.<\/td><\/tr>
        Organization<\/td>The organization scope of this Business Partner. Use * to share across all organizations.<\/td><\/tr>
        Search Key<\/td>Unique short code used to identify this Business Partner across the system.<\/td><\/tr>
        Name<\/td>Full name of the Business Partner. This name will appear as the Sales Rep name on all transactions.<\/td><\/tr>
        Description<\/td>Additional notes or context about this Business Partner \/ Sales Rep.<\/td><\/tr>
        Active<\/td>Must be checked for this record to be available for selection on documents.<\/td><\/tr>
        Sales Rep<\/td>THE KEY FIELD. When checked and saved, this Business Partner is automatically registered as a Sales Rep and appears in the Sales Rep window.<\/td><\/tr>
        Employee<\/td>Check if this person is also an internal employee. Can be enabled alongside Sales Rep.<\/td><\/tr>
        Customer<\/td>Check if this Business Partner is also a customer. Independent of the Sales Rep flag.<\/td><\/tr>
        Vendor<\/td>Check if this Business Partner is also a vendor. Independent of the Sales Rep flag.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Warning<\/strong> The Sales Rep checkbox and the Active checkbox must both be enabled for the record to appear correctly in the Sales Rep window and be selectable on Sales Orders and Invoices.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step-by-Step Configuration<\/strong><\/h2>\n\n\n\n

        Step 3: Enter Business Partner Details<\/strong><\/h3>\n\n\n\n

        Fill in the required Business Partner fields. The example below shows a retail store associate being set up as a Sales Rep:<\/p>\n\n\n\n

        Field<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
        Tenant<\/td>RetailCo (auto-populated)<\/td><\/tr>
        Organization<\/td>*<\/td><\/tr>
        Search Key<\/td>SREP001<\/td><\/tr>
        Name<\/td>Store Associate \u2014 Main Branch<\/td><\/tr>
        Description<\/td>Front-line retail sales representative at the main store location<\/td><\/tr>
        Active<\/td>Yes (checked)<\/td><\/tr>
        Sales Rep<\/td>Yes (checked) \u2014 this is what registers the record as a Sales Rep<\/td><\/tr>
        Employee<\/td>Yes (checked) \u2014 if this person is an internal staff member<\/td><\/tr>
        Customer<\/td>No<\/td><\/tr>
        Vendor<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step 4: Save the Business Partner Record<\/strong><\/h3>\n\n\n\n

        After enabling the Sales Rep checkbox, save the Business Partner record:<\/p>\n\n\n\n

        Save ( Alt + S or toolbar Save button )<\/p>\n\n\n\n

        Important<\/strong> Once saved, iDempiere automatically registers this Business Partner as a Sales Representative. The record is now visible in the Sales Rep window under Menu \u2192 Partner Relations \u2192 Sales Rep, and is available for selection on Sales Orders and Invoices.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step 5: Verify in the Sales Rep Window<\/strong><\/h3>\n\n\n\n

        To confirm the record has been registered, navigate to the Sales Rep window:<\/p>\n\n\n\n

        Menu \u2192 Partner Relations \u2192 Sales Rep<\/p>\n\n\n\n

        The Business Partner you just configured should now appear in the list. The Sales Rep window is read-only no editing is done here. All configuration changes must be made in the Business Partner window.<\/p>\n\n\n\n

        Note<\/strong> If the record does not appear immediately in the Sales Rep window, run a Cache Reset from the System menu and log in again to refresh all lookup caches.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        The Sales Rep Window<\/strong><\/h2>\n\n\n\n

        The Sales Rep window under Partner Relations is a read-only reference screen. It displays all Business Partners that have the Sales Rep checkbox enabled. The window itself shows the core identity fields inherited from the Business Partner record:<\/p>\n\n\n\n

        Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
        Tenant<\/td>The client this Sales Rep belongs to<\/td><\/tr>
        Organization<\/td>Organization scope of the Sales Rep record<\/td><\/tr>
        Trx Organization<\/td>Transacting organization used when this rep is assigned to documents<\/td><\/tr>
        Name<\/td>Display name shown on Sales Orders, Invoices, and reports<\/td><\/tr>
        Description<\/td>Business notes inherited from the Business Partner record<\/td><\/tr>
        Active<\/td>Reflects the Active status of the parent Business Partner<\/td><\/tr>
        Business Partner<\/td>Reference back to the originating Business Partner record<\/td><\/tr>
        Partner Location<\/td>Physical or postal address of the Business Partner<\/td><\/tr>
        Phone<\/td>Contact phone number of the Sales Rep<\/td><\/tr>
        Fax<\/td>Fax number if applicable<\/td><\/tr>
        EMail Address<\/td>Email address for notifications and correspondence<\/td><\/tr>
        Supervisor<\/td>Direct supervisor or manager linked through Business Partner<\/td><\/tr>
        Birthday<\/td>Date of birth for HR reference purposes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Note<\/strong>: All of these fields are maintained in the Business Partner window. If any field needs to be updated such as phone number, email, or supervisor open the Business Partner record directly and edit it there. Changes are reflected in the Sales Rep window automatically.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Sales Rep Info Screen and Tabs<\/strong><\/h2>\n\n\n\n

        Once a Sales Rep is registered, the Sales Rep Info screen provides a consolidated view of all transactional data associated with that representative. The screen is read-only and pulls data in real time from operational documents.<\/p>\n\n\n\n

        Sales Rep Info is used to:<\/p>\n\n\n\n

          \n
        • Review sales activity by individual sales representatives<\/li>\n\n\n\n
        • Track order and invoice history across all channels<\/li>\n\n\n\n
        • Analyze performance and revenue contribution<\/li>\n\n\n\n
        • Support sales management and period-end reporting<\/li>\n<\/ul>\n\n\n\n

          Tab: Orders<\/strong><\/h3>\n\n\n\n

          The Orders tab displays all Sales Orders that have been assigned to this Sales Representative. The data updates automatically as order statuses change.<\/p>\n\n\n\n

          This tab helps users to:<\/p>\n\n\n\n

            \n
          • View all orders created or owned by the sales rep<\/li>\n\n\n\n
          • Track order status \u2014 drafted, in progress, completed, or closed<\/li>\n\n\n\n
          • Identify open or pending sales opportunities<\/li>\n\n\n\n
          • Analyze order volume and trends by period<\/li>\n<\/ul>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Key Fields \u2014 Orders Tab<\/strong><\/h3>\n\n\n\n
            Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
            Document No<\/td>Unique Sales Order reference number<\/td><\/tr>
            Order Date<\/td>Date the Sales Order was created<\/td><\/tr>
            Business Partner<\/td>Customer who placed the order<\/td><\/tr>
            Grand Total<\/td>Total order value including taxes<\/td><\/tr>
            Doc Status<\/td>Workflow status: Drafted, In Progress, Completed, Closed, Voided<\/td><\/tr>
            Warehouse<\/td>Fulfillment warehouse assigned to this order<\/td><\/tr>
            Currency<\/td>Transaction currency used on the order<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

            Tab: Order Lines<\/strong><\/h3>\n\n\n\n

            The Order Line tab shows individual line items from all Sales Orders associated with this Sales Rep. This view supports product-level performance analysis.<\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Key Fields \u2014 Order Lines Tab<\/strong><\/h3>\n\n\n\n
            Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
            Document No<\/td>Parent Sales Order reference number<\/td><\/tr>
            Line No<\/td>Sequential line number within the Sales Order<\/td><\/tr>
            Product<\/td>Product or service sold on this line<\/td><\/tr>
            Quantity<\/td>Number of units ordered<\/td><\/tr>
            Unit Price<\/td>Agreed price per unit before tax<\/td><\/tr>
            Line Amount<\/td>Total value for this line (Quantity x Unit Price)<\/td><\/tr>
            UOM<\/td>Unit of Measure (e.g., Each, Box, Kg)<\/td><\/tr>
            Warehouse<\/td>Fulfillment warehouse for this specific line<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

            Tab: Invoices<\/strong><\/h3>\n\n\n\n

            The Invoices tab shows all Accounts Receivable invoices linked to this Sales Representative. Invoices are displayed based on the sales rep assigned to the document, ensuring accurate revenue attribution.<\/p>\n\n\n\n

            This tab provides insight into:<\/p>\n\n\n\n

              \n
            • Invoiced sales generated by the sales rep<\/li>\n\n\n\n
            • Invoice amounts and dates<\/li>\n\n\n\n
            • Document completion and posting status<\/li>\n\n\n\n
            • Revenue realization against orders<\/li>\n<\/ul>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              Key Fields \u2014 Invoices Tab<\/strong><\/h3>\n\n\n\n
              Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
              Document No<\/td>Unique Invoice reference number<\/td><\/tr>
              Invoice Date<\/td>Date the invoice was raised and posted<\/td><\/tr>
              Business Partner<\/td>Customer billed on this invoice<\/td><\/tr>
              Grand Total<\/td>Total invoice amount including taxes<\/td><\/tr>
              Doc Status<\/td>Invoice status: Drafted, Completed, Reversed, Voided<\/td><\/tr>
              Payment Term<\/td>Agreed payment terms for this invoice<\/td><\/tr>
              Currency<\/td>Transaction currency used on the invoice<\/td><\/tr>
              Is Paid<\/td>Indicates whether the invoice has been fully settled<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              Tab: Invoice Lines<\/strong><\/h3>\n\n\n\n

              The Invoice Line tab provides a granular view of every individual product line across all invoices associated with this Sales Rep. This is the most detailed level of revenue attribution available.<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              Key Fields \u2014 Invoice Lines Tab<\/strong><\/h3>\n\n\n\n
              Field<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
              Document No<\/td>Parent Invoice reference number<\/td><\/tr>
              Line No<\/td>Sequential line number within the Invoice<\/td><\/tr>
              Product<\/td>Product or service invoiced on this line<\/td><\/tr>
              Quantity<\/td>Quantity of units invoiced<\/td><\/tr>
              Unit Price<\/td>Price per unit at the time of invoicing<\/td><\/tr>
              Line Amount<\/td>Total invoiced value for this line<\/td><\/tr>
              Tax Amount<\/td>Tax applied to this specific line<\/td><\/tr>
              UOM<\/td>Unit of Measure for the invoiced product<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

              How Orders and Invoices Work Together<\/strong><\/h2>\n\n\n\n

              Sales Rep Info connects orders and invoices to present a complete sales lifecycle view. Orders represent sales commitments while invoices represent realized revenue. By reviewing both tabs together, users can:<\/p>\n\n\n\n

                \n
              • Compare orders vs invoicing \u2014 <\/strong>identify the gap between committed sales and billed amounts<\/li>\n\n\n\n
              • Identify delays in billing \u2014 <\/strong>flag orders that are completed but not yet invoiced<\/li>\n\n\n\n
              • Evaluate conversion \u2014 <\/strong>measure the rate at which orders successfully convert to invoices<\/li>\n\n\n\n
              • <\/li>\n<\/ul>\n\n\n\n

                Validation<\/strong><\/h2>\n\n\n\n

                After enabling the Sales Rep flag on a Business Partner, verify the following:<\/p>\n\n\n\n

                  \n
                • The Business Partner record is saved with Sales Rep = Yes and Active = Yes<\/li>\n\n\n\n
                • The record appears in the Sales Rep window under Menu \u2192 Partner Relations \u2192 Sales Rep<\/li>\n\n\n\n
                • The Sales Rep is available in the lookup on a new Sales Order<\/li>\n\n\n\n
                • The Sales Rep field is auto-inherited on the Invoice generated from that Sales Order<\/li>\n\n\n\n
                • The Orders tab in Sales Rep Info displays the correct Sales Orders<\/li>\n\n\n\n
                • The Invoices tab reflects completed invoices attributed to this representative<\/li>\n\n\n\n
                • If the record is not visible, Cache Reset resolves the display issue<\/li>\n<\/ul>\n\n\n\n

                  Common Issues<\/strong><\/h2>\n\n\n\n
                  Issue<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
                  Sales Rep does not appear in Sales Rep window after saving<\/td>Confirm the Sales Rep checkbox is checked and the record is Active. Run Cache Reset and log in again.<\/td><\/tr>
                  Sales Rep not available in Sales Order lookup<\/td>Verify Active = Yes on the Business Partner and the Organization = * or matches the transaction org.<\/td><\/tr>
                  Sales Rep window shows the record but it cannot be edited<\/td>Correct behaviour – the Sales Rep window is read-only. All edits must be made in the Business Partner window.<\/td><\/tr>
                  Unchecking Sales Rep removes the record from the Sales Rep window<\/td>Expected behaviour. Re-enable the checkbox in Business Partner to restore the record.<\/td><\/tr>
                  Orders tab shows no records for a valid Sales Rep<\/td>Ensure the Sales Rep field is populated on the relevant Sales Orders before completing them.<\/td><\/tr>
                  Invoices tab is empty despite completed orders<\/td>Confirm that the Invoice inherits the Sales Rep from the originating Sales Order.<\/td><\/tr>
                  Changes to phone or email not reflected in Sales Rep window<\/td>Update the fields on the Business Partner record directly. The Sales Rep window reflects Business Partner data automatically.<\/td><\/tr>
                  Cache Reset required after each new Sales Rep<\/td>This is normal behaviour for lookup cache refresh in iDempiere. Run via System \u2192 Cache Reset.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                  Best Practices<\/strong><\/h2>\n\n\n\n

                  Always configure via Business Partner: <\/strong>Never attempt to create Sales Rep records from the Sales Rep window. The correct entry point is always the Business Partner record.<\/p>\n\n\n\n

                  Check Active before enabling Sales Rep: <\/strong>Ensure the Business Partner is Active before enabling the Sales Rep flag to avoid orphaned or inaccessible records.<\/p>\n\n\n\n

                  Keep contact details current: <\/strong>Phone, Email, and Supervisor fields on the Business Partner feed directly into the Sales Rep window.<\/p>\n\n\n\n

                  Periodic review: <\/strong>Before period-end closing, review the Invoices and Orders tabs in Sales Rep Info to confirm commission data has accumulated correctly.<\/p>\n\n\n\n

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

                  After configuring Sales Representatives via Business Partner, continue with:<\/p>\n\n\n\n

                    \n
                  • Price List Configuration \u2014 <\/strong>define retail and wholesale price lists applied by Sales Reps during order entry<\/li>\n\n\n\n
                  • Sales Order Document Type \u2014 <\/strong>configure document types for standard retail sales, returns, and wholesale orders<\/li>\n\n\n\n
                  • Payment Term Configuration \u2014 <\/strong>set up payment terms applied to invoices generated through the Sales Rep workflow<\/li>\n\n\n\n
                  • Commission Configuration \u2014 <\/strong>set up commission rules referencing Sales Rep Search Keys for automated commission calculation<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                    Learn how Sales Representatives are managed in iDempiere Distribution Management. Configure Business Partners as Sales Reps and track their sales […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18661","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18661"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18661\/revisions"}],"predecessor-version":[{"id":18779,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18661\/revisions\/18779"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}