{"id":21405,"date":"2026-08-04T12:03:10","date_gmt":"2026-08-04T12:03:10","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21405"},"modified":"2026-08-20T08:26:39","modified_gmt":"2026-08-20T08:26:39","slug":"how-to-configure-expenses-to-be-invoiced-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-expenses-to-be-invoiced-in-idempiere\/","title":{"rendered":"How to Configure Expenses (to be Invoiced) in iDempiere"},"content":{"rendered":"\n

The Expenses (to be Invoiced) window shows customer expense report lines that are ready to be billed. It is used when a store incurs a reimbursable cost on behalf of a customer, such as a delivery charge or a purchased item, and that cost must be recovered through a customer invoice. It directly affects accounts receivable, customer profitability reporting, and expense recovery accuracy.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Expensesto-be-invoiced-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only expense report lines marked Processed can move forward to invoicing.<\/li>\n\n\n\n
  • A line already marked Invoiced cannot be billed to the customer a second time.<\/li>\n\n\n\n
  • Expense Amount is recorded in the report currency and converted to accounting currency.<\/li>\n\n\n\n
  • Converted Amount reflects the expense value in the tenant’s base currency.<\/li>\n\n\n\n
  • Invoice Price and Price Invoiced remain zero until the customer invoice is generated.<\/li>\n\n\n\n
  • Each line ties back to a single Business Partner, Expense Report, and Line No.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Business Partner configured as a Customer with a valid Price List.<\/li>\n\n\n\n
    • Organization (store\/branch) configured and assigned to the user role.<\/li>\n\n\n\n
    • Expense Report created and lines entered with Product, Quantity, and Amount.<\/li>\n\n\n\n
    • Currency configured if the expense was recorded in a currency other than the base currency.<\/li>\n\n\n\n
    • Expense Report lines processed (Processed checkbox enabled) before invoicing.<\/li>\n<\/ul>\n\n\n\n

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

      Menu \u2192 Partner Relation \u2192 Service \u2192 Expenses (to be Invoiced)<\/p>\n\n\n\n

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

      Step 1: Select the Customer<\/strong><\/h3>\n\n\n\n

      Open the window, search by Search Key or Name (e.g., 1000021 \/ ALPHA RETAIL SOLUTIONS), and confirm the Customer checkbox and Price List are populated before proceeding to the detail record.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Search Key<\/td>1000021<\/td>Unique customer code used for quick lookup<\/td><\/tr>
      Name<\/td>ALPHA RETAIL SOLUTIONS<\/td>Legal or trading name of the customer<\/td><\/tr>
      Name 2<\/td>Retail Division<\/td>Additional identifier for the customer<\/td><\/tr>
      Customer<\/td>Checked<\/td>Confirms the partner is flagged as a customer<\/td><\/tr>
      Price List<\/td>Standard Sales Price List<\/td>Price list applied when invoicing<\/td><\/tr>
      Open Balance<\/td>-991.20<\/td>Current outstanding balance for this customer<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempeire-PartnerRelation-Expensesto-be-invoiced-1\"<\/figure>\n\n\n\n
      \"TenthPlanet-iDempeire-PartnerRelation-Expensesto-be-invoiced-2\"<\/figure>\n\n\n\n

      Step 2: Review the Expense Report Line<\/strong><\/h3>\n\n\n\n

      Open the Report Line tab, check Organization, Business Partner, Expense Report, Line No, and Expense Date. Confirm the Processed checkbox is enabled before continuing.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/td>Chennai Store<\/td>Store or branch that recorded the expense<\/td><\/tr>
      Business Partner<\/td>ALPHA RETAIL SOLUTIONS<\/td>Customer to be invoiced for the expense<\/td><\/tr>
      Expense Report<\/td>1000001_Ganesh Prabhu_07\/20\/2026<\/td>Source expense report containing this line<\/td><\/tr>
      Line No<\/td>10<\/td>Sequence number of the line in the report<\/td><\/tr>
      Expense Date<\/td>07\/20\/2026<\/td>Date the expense was incurred<\/td><\/tr>
      Processed<\/td>Checked<\/td>Confirms the line has completed processing<\/td><\/tr>
      Invoiced<\/td>Checked<\/td>Shows whether the line has already been billed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempeire-PartnerRelation-Expensesto-be-invoiced-3\"<\/figure>\n\n\n\n

      Step 3: Confirm Product and Quantity<\/strong><\/h3>\n\n\n\n

      Check the Product field for the correct item and confirm Quantity matches the units consumed or delivered for this expense line.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product<\/td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td>Item linked to the reimbursable expense<\/td><\/tr>
      Quantity<\/td>1<\/td>Units of the product being billed<\/td><\/tr>
      Sales Order Line<\/td>(blank)<\/td>Optional link to an existing sales order line<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 4: Verify Expense Amount and Currency<\/strong><\/h3>\n\n\n\n

      Review Expense Amount and Currency, then confirm Converted Amount matches the expected base-currency value for accurate invoicing.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Expense Amount<\/td>200.00<\/td>Original expense value in the recorded currency<\/td><\/tr>
      Currency<\/td>INR<\/td>Currency in which the expense was recorded<\/td><\/tr>
      Converted Amount<\/td>200.00<\/td>Expense value converted to base currency<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempeire-PartnerRelation-Expensesto-be-invoiced-4\"<\/figure>\n\n\n\n

      Step 5: Set Invoice Price and Price Invoiced<\/strong><\/h3>\n\n\n\n

      Enter the Invoice Price for the line, and use the calculator icon next to Price Invoiced to compute the amount that will appear on the customer invoice.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Invoice Price<\/td>0.00<\/td>Unit price applied when the invoice is created<\/td><\/tr>
      Price Invoiced<\/td>0.00<\/td>Amount already invoiced for this line<\/td><\/tr>
      Quantity Invoiced<\/td>0<\/td>Quantity already billed to the customer<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempeire-PartnerRelation-Expensesto-be-invoiced-5\"<\/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>
      Line does not appear for invoicing<\/td>Processed checkbox is not enabled<\/td>Complete processing on the Expense Report before invoicing<\/td><\/tr>
      Converted Amount incorrect<\/td>Currency rate not configured for the expense date<\/td>Update the currency conversion rate and recalculate the line<\/td><\/tr>
      Customer not found in search<\/td>Business Partner not flagged as Customer<\/td>Enable the Customer checkbox on the Business Partner record<\/td><\/tr>
      Expense line missing Product<\/td>Line was created without selecting a Product<\/td>Edit the Expense Report line and assign the correct Product<\/td><\/tr>
      Open Balance not updating<\/td>Customer invoice not yet posted<\/td>Complete and post the generated invoice, then refresh the Customer record<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Configure the Expense Type window to standardize reimbursable expense categories.<\/li>\n\n\n\n
      • Set up the Expense Report window for store staff to submit expenses consistently.<\/li>\n\n\n\n
      • Review the Invoice (Customer) window to confirm generated invoices post correctly.<\/li>\n\n\n\n
      • Check Currency Conversion Rate setup for stores handling multi-currency expenses.<\/li>\n<\/ul>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        The Expenses (to be Invoiced) window shows customer expense report lines that are ready to be billed. It is used […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,87],"tags":[],"class_list":["post-21405","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-partner-relations"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21405","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=21405"}],"version-history":[{"count":10,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21405\/revisions"}],"predecessor-version":[{"id":27838,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21405\/revisions\/27838"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}