Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 96
	Members: 0
	Total: 96

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

A batch program replicating PR23 edit checks

3 Replies

0 Subscribed to this topic

18 Subscribed to this forum

Sort:

Author

Messages

prithwee

New Member

Posts: 0

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

New Poster

Engaged Reader

Avid Reader

4/12/2006 8:31 PM

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

prithwee

New Member

Posts: 0

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

New Poster

Engaged Reader

Avid Reader

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.