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

Period Sales Analysis By Customer

March 3, 2015 by Tim Rodman

Acumatica Report Store: Period Sales Analysis By Customer

This report, the Period Sales Analysis By Customer report, takes the Sales Order Details By Inventory Item (SO611500) report and makes the following changes to it:

  1. Groups by Customer instead of by Item
  2. Replaces the Start Date and End Date parameters with one Period parameter which is required
  3. Amounts are shown in the Base Currency, not the Document Currency
  4. he Period column shows the Line Total value from the Sales Order Details By Inventory Item (SO611500) report if it falls in the Period parameter
  5. The Period Last Year column shows the Line Total value from the Sales Order Details By Inventory Item (SO611500) report if it falls in the same period, but the prior year of the Period parameter
  6. The Change column is simply Period minus Period Last Year
  7. The Change % column is Change divided by Period Last Year

Screenshots:

Acumatica Report Store: Period Sales Analysis By Customer

Acumatica Report Store: Period Sales Analysis By Customer

Acumatica Report Store: Period Sales Analysis By Customer

Acumatica Report Store: Period Sales Analysis By Customer

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.