Who's On?

	Membership:
	Latest: TomV
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5186

	People Online:
	Visitors: 175
	Members: 0
	Total: 175

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

A batch program replicating PR23 edit checks

Sort:

You are not authorized to post a reply.

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

Senior Member

Posts: 3348

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

Senior Member

Posts: 3348

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.

You are not authorized to post a reply.