Prev
Next
Forums Financial Management Lawson S3 Financials

Activity Level Length

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
John Costa
Veteran Member
Posts: 154
Veteran Member
10/20/2009 8:08 PM

    I'm looking for a technical reason as to why an Activity level length cannot be modified after it has been created.  We are using four activity levels to identify an Activity in Lawson.  We are wanting to change the length of level four from 8 characters in length to 9 characters. 

    I've done some playing around in one of my Lawson sand boxes, updating the ACACTGRP file in our product line database.  I set the LEVEL_SIZE_04 value for our primary Activity Group to 9.

    So far, what we've found is that the VAR-LEVELS value for each Activity record in AC10 was appended by adding a zero to the level four value.

    What repercussions can we expect from this change?  I know the documentation states that you cannot change a level length after it has been created.  I'm looking for a technical explanation as to why.

    Any help would be appreciated.  Thanks.

     

    _________________ John - Wichita, KS
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran Member
    10/21/2009 3:41 PM
      I'm assuming you made the change behind the scenes and not through AC00 (which would block the change if activities exist).

      Several reasons:
      1) Updating ACACTGRP does not effect variable levels already assigned in AC10 - ACACTIVITY.
      2) VAR LEVELS is also stored (in violation of relation integrity) in ACTRANS, ACMASTER, and ACCONSOL.

      Theoretically, one could fix the AC10 records using a SQL statement, fix ACTRANS looking to the fixed ACACTIVITY and then use AC580 to rebuild ACMASTER and ACCONSOL. (There may be a budget impact also but I haven't checked that).

      I haven't done this for activities although I have worked on a similar project for GL involving acct units.