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 166: Tim uses ChatGPT and Claude to build something cool (Podcast) March 21, 2026
  • EP 165: Jake Wells – EOS Scorecard and Acumatica Dashboards (Podcast) March 12, 2026
  • EP 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026

Recent Forum Posts

  • Ed Dolan

    Negative/Credit Inventory Value?

    We are starting a new line of business to recycle const...

    By Ed Dolan , 1 day ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 1 week ago

  • Brynn Rutherford

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

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 weeks ago

Terms of Use & Disclaimers :: Privacy Policy

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