InventTable form is empty

[gb]

Hello,

I have a strange behaviour of InventTable form in my development environment ( AX3 + sp2 + KR2)

When I open this form it shows no records, although, InvnetTable, InventTableModule, and InventItemLocation have all records. If I disable innerJoin on InventItemLocation datasource then I get all records on the form and an error message thrown by kernel:

"Query does not contain 5 data source(s)."

If I disable InnerJoin on Purch datasource then I again get all the records and four similar error messages:

"Query does not contain 2 data source(s)."
"Query does not contain 3 data source(s)."
"Query does not contain 4 data source(s)."
"Query does not contain 5 data source(s)."

Same form works fine in Production and Testing environment.
Has anybody seen this? Any suggestions?

Thanks,
gb

[slava09]

Have you records in InventItemLocation where field InventDimId = 'Axapta' for each record in InvnetTable ?
Have you 3 records in InventTableModule for each record in InvnetTable ?

[kashperuk]

The explanation for the messages you are getting is simple:
All operations with the datasources on the InventTable form are performed using the method dataSourceNo(), so in order for the form to work properly you must have 5 datasources connected.

As for the error with the missing records, I think it has to be due to one of your previous modifications.
Have you added more datasources to the form?
And do check what slava09 wrote in his post above - the InventDimId for the records in InventItemLocation has to equal the one specified in method findOrCreateBlank of InventDim table (by default, it is 'Axapta')

[gb]

Yes, that is all in place..
The form was working fine before. Something happened a few days ago and it stopped working properly. Interesting thing is that if I add new record to InventTable, then it will show up in the form, but all existing records are not shown. I compared new records in InventTable and InventTableModule and InventItemLocation and they all look similar.

[gb]

I found my problem and solution. The globalIventDimId was set to default Axapta, while we use DIM000001 as an "empty" dim Id.
Clearing the cache resolved the issue.
Regards,
gb