AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

Sales Order Details By Terms

March 17, 2015 by Tim Rodman

Acumatica Report Store: Sales Order Details By Terms

Sometimes it might be interesting to view your sales orders by the terms chosen on those orders. Getting an order from a customer is great, but did you agree to terms that will allow a few months to pass before you collect the cash?

This report, the Sales Order Details By Terms report, groups your sales order lines by terms, allowing you to see totals by term.

In order to build the report, I took the Sales Order Details By Customer (SO611000) report and made the following changes to it:

  1. Group by the Order Terms instead of by Customer
  2. The Line Total and Open Amount columns are shown in the Base Currency, not the Document Currency

Screenshots:

Acumatica Report Store: Sales Order Details By Terms

Acumatica Report Store: Sales Order Details By Terms

Acumatica Report Store: Sales Order Details By Terms

Acumatica Report Store: Sales Order Details By Terms

How to Download

This report is free and can be downloaded through Gumroad.com

Download Now

Filed Under: Acumatica Report Store Tagged With: Acumatica, Acumatica Blog, Acumatica Business Intelligence, Acumatica Learning, Acumatica Report Designer, Acumatica Report Writer, Acumatica Training

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 158: Garrett Rochell – Acumatica Upgades, especially with the Modern UI (Podcast) October 4, 2025
  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025
  • EP 157: acuCONNECT 2025 Preparation – Part 4 (Podcast) September 16, 2025
  • EP 156: acuCONNECT 2025 Preparation – Part 3 (Podcast) September 6, 2025
  • EP 155: Chris Hackett – Update on Acumatica User Groups (Podcast) August 26, 2025

Recent Forum Posts

  • matthewjames

    RE: Generic Inquiry Screenid changes to ScreenId=00000000

    if anyone gets this error again (resetting screen ID to...

    By matthewjames , 3 days ago

  • Travis

    RE: Pick List report suddenly not splitting on Shipment

    I never found a solution initially - here I am 3 years ...

    By Travis , 3 weeks ago

  • ToonSix

    RE: Feeling Stuck on Making a Sandbox of our Database

    Delete as many snapshots as possible before making a ne...

    By ToonSix , 3 weeks ago

  • Retha

    RE: Printing Product Labels from Purchase Receipt

    I have read the article on the How to print multiple pr...

    By Retha , 1 month ago

  • Paul Lambert

    RE: Generic Inquiry into Business Event to monitor Import Scenarios

    An idea I've been brainstorming and haven't yet tested ...

    By Paul Lambert , 1 month ago

  • Jacky Mao

    How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)

    Hi everyone, I’m trying to create a Business Event fo...

    By Jacky Mao , 1 month ago

  • Lunar Windbloom

    Feeling Stuck on Making a Sandbox of our Database

    Hi all! Hope your day is going well! It's finally the...

    By Lunar Windbloom , 2 months ago

  • Tim Laird

    RE: [SOOrder.Status] = 'Open' always returns false

    @russ Customer Classes are user maintained, so you setu...

    By Tim Laird , 2 months ago

  • Tim Laird

    RE: What Triggers a Customization to need a Restart?

    OK, one more update. This creeped up again this weeken...

    By Tim Laird , 2 months ago

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.