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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
Posts: 129
Veteran Member
2/6/2018 9:19 PM
Works like a charm. Thanks!