PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/06/2018 4:19 PM by  JudeBac
Custom Lawson tables using Addins
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JudeBac
Private
Private
Veteran Member
(320 points)
Veteran Member
Posts:124


Send Message:

--
02/05/2018 10:00 AM

    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
    Private
    Private
    Veteran Member
    (878 points)
    Veteran Member
    Posts:306


    Send Message:

    --
    02/05/2018 2:59 PM
    I would start from scratch. Never know what kind of edits and behind the scenes update, the original program does.
    JudeBac
    Private
    Private
    Veteran Member
    (320 points)
    Veteran Member
    Posts:124


    Send Message:

    --
    02/06/2018 10:22 AM
    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
    Private
    Private
    Veteran Member
    (878 points)
    Veteran Member
    Posts:306


    Send Message:

    --
    02/06/2018 10:40 AM
    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
    Private
    Private
    Veteran Member
    (320 points)
    Veteran Member
    Posts:124


    Send Message:

    --
    02/06/2018 10:47 AM

    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
    Private
    Private
    Veteran Member
    (878 points)
    Veteran Member
    Posts:306


    Send Message:

    --
    02/06/2018 11:05 AM
    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
    Private
    Private
    Veteran Member
    (320 points)
    Veteran Member
    Posts:124


    Send Message:

    --
    02/06/2018 11:24 AM
    Seems the one I am looking for! I will keep you posted. Thanks
    JudeBac
    Private
    Private
    Veteran Member
    (320 points)
    Veteran Member
    Posts:124


    Send Message:

    --
    02/06/2018 4:19 PM
    Works like a charm. Thanks!
    You are not authorized to post a reply.