09.01.2007, 02:17 | #1 |
Участник
|
InventTable form is empty
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 |
|
09.01.2007, 15:39 | #2 |
Участник
|
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 ? |
|
09.01.2007, 16:15 | #3 |
Участник
|
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') |
|
09.01.2007, 16:24 | #4 |
Участник
|
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. |
|
10.01.2007, 20:28 | #5 |
Участник
|
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 |
|
|
|