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...
Inventory Managemen...
 
Notifications
Clear all

Questions Inventory Management GI

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 1 year ago
2 Posts
2 Users
0 Reactions
854 Views
RSS
Guilherme Zica
Posts: 9
 Guilherme Zica
Topic starter
July 19, 2024 3:30 am
(@gzica)
Active Member
Joined: 2 years ago

Hi Eveyone,

We're trying to create a GI that consolidates all the purchase orders, sales orders (not completed) and on hand inventory level for an inventory ID. This GI needs to also pull the dates that these items are coming in/out of stock and as a next stage, we'd like to make a graph or use any visualization tool to see this data. 

Has anyone here implemented something similar to this before? Any ideas how to get there? 

TIA,

Guilherme


1 Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
October 31, 2024 10:59 am
(@timrodman)
Famed Member
Joined: 10 years ago

I did something that's sort of like this using SQL here:

https://www.augforums.com/acuconnect2024


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 14 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Tax on Inventory Transfer
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

  • Tim Rodman
Acumatica Forums

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.

‹›×

    ‹›×