Hi Devon,
First of all, thank you so much for your detailed response!
What I am specifically trying to achieve is a query that returns the quantity of an item based on the Lot Number.
Currently, I am using the following query to get the opening balance for a specific item, but based on the Lot Number:
Let me explain this query:
InventoryTransactions
is an original view from Dynamics GP.ReqIVLineLotDetailView
is a view I created, which contains the following data:The issue I am facing is that the query doesn't return the correct QTY
based on the Lot Number.
What I need is a query that can accurately retrieve the quantity for the specific Lot Number. It's not a requirement to use the views mentioned above, so I am open to suggestions for alternative approaches.
Your help and support are greatly appreciated.
Best regards
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156