Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 122
	Members: 0
	Total: 122

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

A batch program replicating PR23 edit checks

3 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

prithwee

Basic Member

Posts: 20

4/12/2006 6:17 PM

We hav been asked by the users to create a batch program which should delete all records in EMPDISTMAST table (updated by PR23), takes an input file from another system and do the same edit checks as PR23 and then populate the table. In their words, it should invoke the same AGS/DME calls that PR23 uses. What is the fastest way to do that?
Note: I will be learning Lawson programming as I do that.

Thanks

John Henley

Posts: 3353

4/12/2006 8:31 PM

Why don't you use the Excel upload wizard??

prithwee

Basic Member

Posts: 20

4/14/2006 6:31 PM

John,

When we try to use add-ins to upload data to PR23, it asks for keys. It doesn't allow updating all at one shot. I tried couple of different options and it asks me to enter keys.

Thanks
Prithwee

John Henley

Posts: 3353

4/15/2006 1:23 AM

I haven't tried that particular form, but you should be able to upload against it. You probably just need to map to some of the hidden fields. The best way to figure it out is to use Portal to enter against the form, and then use Ctrl-Alt-A and look at the Transaction XML. It should show what values have to be loaded.