AugForums.com

An Acumatica User Group

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

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

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 4 years ago
4 Posts
1 Users
1 Reactions
1,286 Views
RSS
mstanczak
Posts: 14
 mstanczak
Topic starter
May 3, 2021 12:29 pm
(@mstanczak)
Eminent Member
Joined: 4 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: 4 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: 4 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: 4 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,526 Topics
  • 10.9 K Posts
  • 42 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

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.

‹›×

    ‹›×