How can i do for Update Analysis View Entry

hunterhunter Member Posts: 19
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

  • DaveTDaveT Member Posts: 1,039
    Hi,

    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.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
Sign In or Register to comment.