changing data in a table with a batch

JBeckJBeck Member Posts: 68
edited 2006-12-15 in Navision Financials
Hi,

I was wondering if I could manipulate de data of a table with a batch.
e.g. can I multiply the amount with a factor?

Thanks in advance
J.Beck

Comments

  • HalMdyHalMdy Member Posts: 429
    You could create a report or a CodeUnit to do this kind of thing ...

    What do you want to do exactly ? Are you End User or Nav partner ?
  • JBeckJBeck Member Posts: 68
    I'm an Nav programmer.
    I've already created a codeunit for this but it doesn't have any effect.
    I'm trying to multiply the amount with a thousand.
    The code looks like this:
    grootboekpst.SETCURRENTKEY(grootboekpst.Nr);
    grootboekpst.SETFILTER(grootboekpst.Boekingsdatum, '%1..', begindat);
    
    IF grootboekpst.FIND('-') THEN BEGIN
      REPEAT
         grootboekpst.Amount := grootboekpst.Amount * 1000;
      UNTIL grootboekpst.NEXT = 0;
      END;
    
    
  • kinekine Member Posts: 12,562
    What about saving the modification through .MODIFY??? ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • JBeckJBeck Member Posts: 68
    Of course #-o .....
    Thanks a lot!!!!! :D
Sign In or Register to comment.