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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
GI Sales Order Hist...
 
Notifications
Clear all

Questions GI Sales Order History - by any given timeframe - end user filter Date Range

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by mstanczak 5 years ago
4 Posts
1 Users
1 Reactions
1,801 Views
RSS
mstanczak
Posts: 14
 mstanczak
Topic starter
May 3, 2021 12:29 pm
(@mstanczak)
Eminent Member
Joined: 5 years ago

I am trying to do a GI for Sale Order History - by date range  (this needs to be able to be a filter for what was sold in specified period of time, day, month, week, etc.)

image

 These are my tables. I have them Grouped by Inventory ID.   The filter needs to be the SO Date and the results should be the Sum of QTY.   How do I get this filter to work, if I take the date range out of the results grid? I tried doing it in the parameter but that isn't pulling anything when I enter dates.

 

MS-Sales with Qty (1).xml

3 Replies
mstanczak
Posts: 14
 mstanczak
Topic starter
May 3, 2021 5:29 pm
(@mstanczak)
Eminent Member
Joined: 5 years ago

This is the end results but I need to have a date filter by either ARTrans or Shipment Date.

image

 


Reply
mstanczak
Posts: 14
 mstanczak
Topic starter
May 4, 2021 10:56 am
(@mstanczak)
Eminent Member
Joined: 5 years ago

How can I make this be a Filter on the front end of the GI instead of hard coded in the Result Grid

I want the end user to be able to filter by date's they choose...

image

Reply
mstanczak
Posts: 14
 mstanczak
Topic starter
May 4, 2021 12:56 pm
(@mstanczak)
Eminent Member
Joined: 5 years ago

I got this figured out...thanks 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 41 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

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.

‹›×

    ‹›×