Share
Reporthow to add vendor code in on hand inventory report. i personalized but it said underived DATA
You’re offline. This is a read only version of the page.
95
how to add vendor code in on hand inventory report. i personalized but it said underived DATA
Hi Waseem,
The table InventSum is used to display data of on-hand information. It does not have a field for the vendor. If you took the primary vendor from the item master, then it is indeed not working as the on-hand is presented based on aggregated data and not all fields of the item master are retrieved from the database.
What exact vendor ID do you expect here? The primary vendor on the item master or can it be different vendors per item receipt?
Hi Waseem Altaf,
I don't this that it is possible to simply add the vendor code to the inventory value report as it is not designed for this purpose.
As an example, if you post an inventory adjustment - as a kind of correction - there is no vendor code.
Would you like to leave your additional field blank then?
Also, if you want to include the vendor code at which level (site, warehouse, etc.) do you want to see this information and what kind of drill down do you want to allow?
I believe that it might be easier and faster designing something new compared to trying to tweak the already existing (and complex) standard reports.
Best regards,
Ludwig
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,760
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
