web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Consolidating Sales orders into a single invoice

(1) ShareShare
ReportReport
Posted on by 2
Hi,
 
What is the best way to consolidate multiple sales orders (either daily or weekly) into a Single invoice for the customer?
 
Thanks
I have the same question (0)
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    1,733 on at
    Consolidating Sales orders into a single invoice
    Hi,
     
    It is very well explained in this blog:
     
    You can setup Summary update parameters in the Accounts Receivable > Setup. Basis which system do the consolidation of Packing slips at the time of Invoice creation/posting.
     
    At the time of Invoicing, you will have the option to select summary update = "Automatic Summary" and based on criteria, it will consolidate the Sales orders.
     
    Please go through the blog and let me know for any further assistance.
     
    Summary of the above blog with help of AI and verified by me:
     
    Purpose
    The Summary update functionality lets you group multiple sales orders into a single document (confirmation, picking list, packing slip, or invoice) based on defined criteria.

    Setup Location
    • Found under Accounts receivable parameters > Summary update.
    • You can set Default values for summary update:
      1. None – Each sales order generates its own document.
      2. Invoice account – Orders with the same invoice account (and other criteria) are grouped.
      3. Order – Allows combining orders during confirmation/invoice.
      4. Automatic summary – Uses customer-specific setup to determine which documents are grouped automatically.

    Key Behaviors
    1. Invoice account option
      • Groups orders with the same invoice account.
      • Additional criteria (currency, method of payment, site, etc.) can further split invoices.
    2. Order option
      • You choose the reference order when posting.
      • Tolerance rules decide whether mismatched criteria stop the process (Error), are ignored (Accept), or give a warning.
    3. Automatic summary
      • Activated per customer record and per document type.
      • Automatically groups sales orders for that customer according to summary update criteria.
      • Delivery information can also be used as a split criterion.
         
     
    If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
     
    Regards,
    Neeraj Kumar
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 575

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 245 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 187 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans