inventdimid......AX 4.0

CJBeattie

When creating a new item, from the AOT table browser on table InventItemLocation, the inventitemid is set to 'AllBlank'

Does this mean when I import stock items, I set the InventItemID to always be 'AllBlank'?

The reason I ask is, it seems to be the inventdimid makes the records visible on the actual item form, not just the tables from the AOT.

If I am mistaken, please let me know.

Is 'AllBlank' the default that AX creates on a new item? therefore import all items into a new company with that inventdimid??

Any advice, please let me know....

Kind Regards

Björn

You're not seeing the items on the item form because InventTable is inner joined with 4 other data sources.

An item is defined by these records:

• InventTable
• InventItemLocation, with InventDimId for the empty dimension record. A method to acquire this ID exists on the InventDim table. It should be AllBlank, but it may be different on some installations.
• InventTableModule record for type Purch
• InventTableModule record for type Invent
• InventTableModule record for type Sales

AFAIK they are not created automatically when importing records to InventTable. You have to write a job or run the consistency check with the repair option to create defaults.