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
Acumatica Forums

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

Forums
AUG Forums
Acumatica Generic I...
Using the INItemSit...
 
Notifications
Clear all

Questions Using the INItemSiteHistory Table to find sell through rates on items over a Financial Period

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 7 years ago
2 Posts
2 Users
0 Reactions
2,009 Views
RSS
Posts: 3
 Jarrett Eller
Topic starter
July 11, 2019 1:49 pm
(@jeller)
Member
Joined: 7 years ago

This table is perfect for what I am trying to find. However, when I try to use the data field "ItemHistory.FinPeriodID" as a parameter to filter which financial period I am trying to view, it seems to not work and just shows aggregated data. Any thoughts here?


Topic Tags
Inventory sales orders Generic Inquiry
1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
July 31, 2019 9:39 am
(@timrodman)
Famed Member
Joined: 11 years ago

Hi Jarrett,

Can you elaborate on what you mean by "aggregated data"?

Maybe include a screenshot?


Reply
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
    1 year ago
  • Equivalent to Excel Post-Special, "transpose"
    2 years ago
  • Generic Inquiry - Last Modified On Date Change
    2 years ago
  • Generic Inquiry, pulling data from two unrelated sources
    2 years ago
  • Inventory Usage reporting based on previous system reports
    2 years ago
Topic Tags:  Inventory (15) , sales orders (11) , Generic Inquiry (41) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 25 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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

  • Terry Payne
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.

‹›×

    ‹›×