Prev
Next
Forums Integration / Customization S3 Customization/Development

Custom Lawson tables using Addins

 7 Replies
 2 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
JudeBac
Veteran Member
Posts: 129
Veteran Member
2/5/2018 3:00 PM

    I have a new custom table ZACCT with fields COMPANY, ACCTUNIT, ACCOUNT, SUBACCOUNT, all derived from GLMASTER. My plan is for our AP users to use excel addins to add records.

    Can I copy a similar program and replaced the field names or should I start from scratch using pgmdef? Any pgmdef for dummies is much appreciated.

     

    Thanks

    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    2/5/2018 7:59 PM
      I would start from scratch. Never know what kind of edits and behind the scenes update, the original program does.
      JudeBac
      Veteran Member
      Posts: 129
      Veteran Member
      2/6/2018 3:22 PM
        Agree Ragu. I made a copy and looked deeper into the codes and there are too many to cleanup.
        All I need in this new program is Add only. I will maintain the custom table via SQLServer.

        Any steps to create a new program with just ADD records? Thanks
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
        2/6/2018 3:40 PM
          If it is only ADD, why even bother with a 4GL screen? Have the users create a csv file, pull it into the Lawson server and run importdb?
          JudeBac
          Veteran Member
          Posts: 129
          Veteran Member
          2/6/2018 3:47 PM

            Good question Ragu. I have this as the next option. As a matter of fact, I will use IPA in order to have some sort of validation.

            However, the validation of addins and db primary key, reason I am looking at the Lawson program ADD only. It also gives immediate message to the user if using addins.

            Ragu Raghavan
            Veteran Member
            Posts: 476
            Veteran Member
            2/6/2018 4:05 PM
              Do you have access to the Lawson/Infor support site ? Search for "quick paint" - for example, KB 1204177 . That may be enough for you need
              JudeBac
              Veteran Member
              Posts: 129
              Veteran Member
              2/6/2018 4:24 PM
                Seems the one I am looking for! I will keep you posted. Thanks
                JudeBac
                Veteran Member
                Posts: 129
                Veteran Member
                2/6/2018 9:19 PM
                  Works like a charm. Thanks!