I create a analysis by dimension, and all its ok, but sometimes when the user register a Entry forgot typing the right dimension values, so we have to check and write the correct dimension. When i update the analysis, just update the new entry but the old entries not are changed.
I created a function to update into the table 365: Analysis View Entry, but i get an error:
The analysis view entry doesn't exist
Identification fields and values
Its posible modify the table 365?? or how can i update the dimensions on the Analysis View Entry for old entries. Sometimes i delete the naalysis and created a new analysis but i think this is not the right form.
Any Idea Please
this is my code where i get the error
FIND('-');
REPEAT
rec355.RESET;
rec355.SETRANGE(rec355."Table ID",DATABASE::"G/L Entry");
rec355.SETRANGE(rec355."Entry No.","Entry No.");
IF rec355.FIND('-') THEN
REPEAT
CASE rec355."Dimension Code" OF
'TIPOPPTO': BEGIN
"Dimension 1 Value Code":=rec355."Dimension Value Code";
END;
'PROYECTO': BEGIN
"Dimension 2 Value Code":=rec355."Dimension Value Code";
END;
'CTROCSTO': BEGIN
"Dimension 3 Value Code":=rec355."Dimension Value Code";
END;
'OBJGASTO': BEGIN
"Dimension 4 Value Code":=rec355."Dimension Value Code"
END;
END; // Case
UNTIL rec355.NEXT = 0;
MODIFY;
UNTIL NEXT = 0;
Comments
Unless you have an analysis view setup with Date Compression set to None then the entry number is not populated. If the Date Compression is set to none then the entry no. is the entry no. of the value entry table and not the G/L entry table. You could clear the entries for the view, reset the last entry no. and update the analysis view again.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html