By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
0
Reactions
233
Views
July 19, 2024 3:30 am
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
October 31, 2024 10:59 am
I did something that's sort of like this using SQL here: