Range value on item form query

Finance and Operations/AX Technical Forum
1

Hi , I have a problem that only one of my items actually displays in the item form - this is because when I look at the Form via set up (right mouse click) and then look at the query the InventItemLication has a range for the InventDim set to a value that is a specific InventDim and not ‘Axapta’ ( as per the standard system) -my problem is that I cannot remove this range value - I have re set all the Usuage data without any success - I have searched the source code and the value is not hard coded - when I run in debug the value in Classes\inventDimGlobal\InventDimIdBlank is the value that relates to the only item I can see on the form - ? any ideas how I get rid of this would be welcomed.

Thanks

2

Hi, there,

Sorry I am not exactly getting your problem.

In Item Master, by default, it shows all the items.

If you put some code in datasource of Itemtable, then only it will filter records on the basis of filter criteria.

If you are opening the Item Master form, from another form, then you have to put some condition for the filteration.

The filter criteria on InventItemLocation will depend on the item selected on Itemmaster, so it will show all recordsof Item Table, and related to selected item , it will show all location of that item only.

I hope, it will help you out…

Bye

3

Under Basic and Periodic there is a “Consistency Check” option, this should resolve the issue of the item form showing one form, pretty sure it is to do with the import routine and not populating one of the related tables.

4

Hi

thanks for replying , appreciated

a while ago I was animating the program to see what it was doing and entered a value into the inventdimid or inventlocationid ( can’t exactly remember now)

since then it has kept that value and only products that have a inventdimid equal to this appear on the item form

when I animate the program the classs

InventDimId inventDimIdBlank()
{
;
if (!inventDimIdBlank || dataAreaIdDimBlank != curext())
inventDimIdBlank = InventDim::findOrCreateBlank(false).InventDimId;

dataAreaIdDimBlank = curext();
return inventDimIdBlank;
}

returns with a value

NAME:
inventDimIdBlank
VALUE:
11760_060
TYPE:
str 20

but where has it got this value from is my real question as I cannot find where to change it - I think it is normally set to “Axapta” -

( if you open the item form from inventory and right click and select set up and then query tab - under InventItemLocation and Ranges the default in the VPC is inventDimId==Axapta )

The whoe class content is below - and the dataareaid is populted wih “dmo” which it must know from the company I am logged into , so where does it get the other values from ?

NAME:
this
VALUE:
new
TYPE:
InventDimGlobal
NAME:
dataAreaIdDimBlank
VALUE:
dmo
TYPE:
str 3
NAME:
dimSearchBase
VALUE:
new
TYPE:
InventDimSearchBase
NAME:
fields
VALUE:
<size = 8>
TYPE:
container
NAME:
fields_read
VALUE:
true
TYPE:
boolean
NAME:
fieldsEnabled
VALUE:
<size = 8>
TYPE:
container
NAME:
fieldsEnabled_read
VALUE:
true
TYPE:
boolean
NAME:
fieldsEnabledName
VALUE:
<size = 0>
TYPE:
container
NAME:
fieldsEnabledName_read
VALUE:
false
TYPE:
boolean
NAME:
fieldsName
VALUE:
<size = 8>
TYPE:
container
NAME:
fieldsName_read
VALUE:
true
TYPE:
boolean
NAME:
handleListForm
VALUE:
{65123, 65124, 65125, 65126, 65128, 65130, 65132, 65469, 65477, 65478, 65480, 65481, 65482, 65485, 65487}
TYPE:
Set
NAME:
handleListReport
VALUE:
null
TYPE:
Set
NAME:
inventDimIdBlank
VALUE:
11760_060
TYPE:
str 20
NAME:
inventDimParmInitAllCovDim
VALUE:
<recid = 0>
TYPE:
InventDimParm
NAME:
inventDimParmInitAllCovDim_read
VALUE:
false
TYPE:
boolean
NAME:
inventDimParmInitAllItemDim
VALUE:
<recid = 0>
TYPE:
InventDimParm
NAME:
inventDimParmInitAllItemDim_read
VALUE:
true
TYPE:
boolean
NAME:
inventDimParmInitAllPriceDiscDim
VALUE:
<recid = 0>
TYPE:
InventDimParm
NAME:
inventDimParmInitAllPriceDiscDim_read
VALUE:
false
TYPE:
boolean
NAME:
inventDimParmInitAllstorageDim
VALUE:
<recid = 0>
TYPE:
InventDimParm
NAME:
inventDimParmInitAllstorageDim_read
VALUE:
false
TYPE:
boolean
NAME:
inventDimSetupGridList
VALUE:
null
TYPE:
List
NAME:
inventDimSetupGridList_read
VALUE:
false
TYPE:
boolean
NAME:
itemDimFieldsEnabled
VALUE:
<size = 0>
TYPE:
container
NAME:
itemDimFieldsEnabled_read
VALUE:
false
TYPE:
boolean
NAME:
itemDimFieldsEnabledName
VALUE:
<size = 0>
TYPE:
container
NAME:
itemDimFieldsEnabledName_read
VALUE:
false
TYPE:
boolean
NAME:
parmFields
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFields_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsEnabled
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsEnabled_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsEnabledName
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsEnabledName_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsLarge
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsLarge_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsLargeEnabled
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsLargeEnabled_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsLargeEnabledName
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsLargeEnabledName_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsLargeName
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsLargeName_read
VALUE:
false
TYPE:
boolean
NAME:
parmFieldsName
VALUE:
<size = 0>
TYPE:
container
NAME:
parmFieldsName_read
VALUE:
false
TYPE:
boolean
NAME:
storageDimFieldsEnabled
VALUE:
<size = 0>
TYPE:
container
NAME:
storageDimFieldsEnabled_read
VALUE:
false
TYPE:
boolean
NAME:
storageDimFieldsEnabledName
VALUE:
<size = 0>
TYPE:
container
NAME:
storageDimFieldsEnabledName_read
VALUE:
false
TYPE:
boolean
NAME:
systemHasMultipleItemDim
VALUE:
true
TYPE:
boolean
NAME:
systemHasMultipleItemDim_read
VALUE:
true
TYPE:
boolean

Many thanks

5

I sorted this - the value is populated via the first record in the INVENTDIM table when you read it via the index - I had managed to chnge what is normally stored in this field (Axapta) - now having deleted what was there and re inserting Axapta - all my products now display in the Item form !

Thanks for the input though