Custom Lawson tables using Addins

JudeBac

Veteran Member

Posts: 129

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: 468

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

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: 468

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

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: 468

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

2/6/2018 4:24 PM

Seems the one I am looking for! I will keep you posted. Thanks

JudeBac

Veteran Member

Posts: 129

2/6/2018 9:19 PM

Works like a charm. Thanks!