AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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 171: Automating Acumatica Sales Orders with Artificial Intelligence (Podcast) April 23, 2026
  • EP 170: Unboxing AI Assistant in Acumatica 2026 R1 (Podcast) April 19, 2026
  • EP 169: Laura Jaffe – Unlocking Acumatica Report Designer (Podcast) April 8, 2026
  • EP 168: Joe DiPaolo – Hosted Acumatica and Joe’s Jr. AI Developers (Podcast) March 31, 2026
  • EP 167: Nicole Ronchetti – A Claude Skill for Acumatica ERP (Podcast) March 27, 2026

Recent Forum Posts

  • cschwark

    Nested SubReport Issue

    I have a custom Shift Changeover Checklist report (AM64...

    By cschwark , 2 days ago

  • tmac

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    I've had a similar issue with the out-of-the-box Fixed ...

    By tmac , 3 weeks ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @jjbotes Good thoughts. We'll endeavor to find a soluti...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    The question is "when" in the business process does the...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @jjbotes Thank you for the feedback. I will discuss wit...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    Acumatica can have positive units in stock but a negati...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    @azeigler I am concerned as well about the lack of s...

    By Ed Dolan , 1 month ago

  • Johan Botes

    RE: Limited or no support from Acumatica?

    Hi Ed - the principle is embedded in standard functiona...

    By Johan Botes , 1 month ago

  • Ed Dolan

    RE: Limited or no support from Acumatica?

    Johan, Thanks for the rely and I hope you are well. ...

    By Ed Dolan , 1 month ago

Terms of Use & Disclaimers :: Privacy Policy

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