Notifications
Announcements
No record found.
Hello..
How I can get InventDimId or InventLocationId from inventdimprint column .
the inventdimprint exist In report Sales order line tmp (SalesLinesExtendedTmp) table.
In inventory management the warehouse named just 21 , is there and method can take the inventdimprint and return InventDimId or InventLocationId
Thanks.
Hi Ahmed,
Value in inventdimprint is a string combination of pairs Inventory dimension label + value and pairs are separated by 3 spaces. So you can just try to parse it with str2con function to container and work with the container to get the needed value. But you will not get original InventDimId value.
Could you, please, how are you planning to use values extracted from inventdimprint?
Thank you i just need it to sum some qty from other sales orders based on inventlocationid
I think if the user change the language , the result will be wrong right ?
The label "warehouse" is depended on language settings. You can try to use this snippet to parse this value.
container pairs = str2con(inventDimPrintValue, ' '); container warehousePair = str2con(conpeek(pairs, 1), ' : '); //1 is warehouse pair position in inventDimPrintValue info(conpeek(warehousePair, 2)); //1 is label position, 2 is value position
Can explain why this job return :return colon before 13
thanks
In str2con function in AX2012 second parameter has length 10 and "Warehouse :" just cut to 10 lenght as well. In this case you need to use str2con_RU where unlimited strings are used as parameters.
Also if topic is related to AX2012, you can modify report provider class directly and get access to SalesLine.InventDimId to get warehouse value from it (In D365 it's not possible anymore).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
