{"id":21352,"date":"2026-08-04T12:02:18","date_gmt":"2026-08-04T12:02:18","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21352"},"modified":"2026-08-20T08:37:09","modified_gmt":"2026-08-20T08:37:09","slug":"how-to-create-sales-orders-from-expense-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-create-sales-orders-from-expense-in-idempiere\/","title":{"rendered":"How to Create Sales Orders from Expense in iDempiere"},"content":{"rendered":"\n

Create Sales Orders from Expense is an iDempiere process that converts approved, billable Expense Report lines into customer Sales Orders. Retailers running installation, POS rollout, or field-service projects use it to recover travel and material costs from customers. It groups eligible expense lines by Business Partner and Project, then generates ready-to-invoice orders, keeping billing accurate and reducing manual data entry in retail project accounting.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-CreateSOFromExpense-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only expense lines marked as billable (Invoiced ) are converted into Sales Orders.<\/li>\n\n\n\n
  • Expense lines already linked to a Sales Order Line are skipped, preventing duplicate billing.<\/li>\n\n\n\n
  • Expense lines must belong to a processed (completed) Expense Report to qualify.<\/li>\n\n\n\n
  • Lines are grouped by Business Partner and Project.<\/li>\n\n\n\n
  • The customer must have at least one configured location, or the order cannot be created.<\/li>\n\n\n\n
  • Generated Sales Orders are left in Prepared status, ready for review and completion.<\/li>\n\n\n\n
  • The Business Partner and Date Range parameters are optional and narrow the selection scope.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Business Partner (customer) configured with a valid Business Partner Location.<\/li>\n\n\n\n
    • Expense Report entered, approved, and processed with billable lines (Invoiced).<\/li>\n\n\n\n
    • Project configured, if expenses are tracked and billed against a Project.<\/li>\n\n\n\n
    • Sales Document Type (On Credit Order) configured for the Organization.<\/li>\n\n\n\n
    • Price List and Warehouse configured for the customer or project.<\/li>\n\n\n\n
    • Sales Representative and Organization assigned to the transaction.<\/li>\n<\/ul>\n\n\n\n

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

      Menu \u2192 Partner Relation \u2192 Service \u2192 Create Sales Orders from Expense<\/p>\n\n\n\n

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

      Step 1: Confirm Expense Reports Are Processed<\/strong><\/h3>\n\n\n\n

      Open the Expense Report window, confirm the report status is Completed and each billable line has a Business Partner assigned.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-PartnerRelation-CreatesalesOrderfromExpense-1\"<\/figure>\n\n\n\n

      Step 2: Open the Create Sales Orders from Expense Window<\/strong><\/h3>\n\n\n\n

      Navigate to Business Partner Relations \u2192 Service \u2192 Create Sales Orders from Expense to open the parameter screen.<\/p>\n\n\n\n

      Step 3: Set Selection Parameters<\/strong><\/h3>\n\n\n\n

      Enter a Business Partner to restrict the run to one customer, or leave it blank to process all customers. Set the Expense Date From and To range.<\/p>\n\n\n\n

      Field Reference Table<\/strong><\/h2>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Business Partner<\/td>CHENNAI SUPPLIERS<\/td>Optional filter; limits the run to one customer’s expense lines.<\/td><\/tr>
      Expense Date (From)<\/td>07\/01\/2026<\/td>Start of the expense date range to include.<\/td><\/tr>
      Expense Date (To)<\/td>07\/21\/2026<\/td>End of the expense date range to include.<\/td><\/tr>
      Run as Job<\/td>Unchecked<\/td>When checked, runs the process in the background instead of immediately.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 4: Run the Process<\/strong><\/h3>\n\n\n\n

      Click Start. The process log shows the number of orders created, along with the date, amount, and a link to each new Sales Order.<\/p>\n\n\n\n

      Step 5: Review and Complete the Generated Sales Order<\/strong><\/h3>\n\n\n\n

      Click the order link in the log (for example, 60003), verify the lines and pricing, then complete the order and proceed to invoicing.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-PartnerRelation-CreatesalesOrderfromExpense-2\"<\/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 Sales Orders created<\/td>Expense lines not marked billable or report not processed<\/td>Mark lines Invoiced = Y and complete the Expense Report<\/td><\/tr>
      Process error on order creation<\/td>Customer has no Business Partner Location<\/td>Add a valid location to the customer record<\/td><\/tr>
      Orders split more than expected<\/td>Expense lines span multiple projects<\/td>Confirm project assignment on each expense line<\/td><\/tr>
      Wrong price on order line<\/td>Price List not aligned with Project or Customer<\/td>Verify the Price List configured for the project or customer<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Complete and invoice the generated Sales Order.<\/li>\n\n\n\n
      • Review Project Costing or Expense reports for reconciliation.<\/li>\n\n\n\n
      • Configure Sales Order to Invoice document flow if not already set up.<\/li>\n\n\n\n
      • Set up recurring Business Partner and Project filters for repeat billing cycles.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        Create Sales Orders from Expense is an iDempiere process that converts approved, billable Expense Report lines into customer Sales Orders. […]<\/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,78],"tags":[],"class_list":["post-21352","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-partner-relations","category-idempiere-sales"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21352","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=21352"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21352\/revisions"}],"predecessor-version":[{"id":27853,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21352\/revisions\/27853"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}