Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 0
	Prev. 24 Hours: 2
	Overall: 5208

	People Online:
	Visitors: 293
	Members: 0
	Total: 293

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
Chesca	1042

IPA and AP05.3

3 Replies

0 Subscribed to this topic

51 Subscribed to this forum

Sort:

Author

Messages

Randy

Veteran Member

Posts: 50

New Poster

Engaged Reader

Avid Reader

9/19/2023 5:14 PM

Anyone have success with IPA and adding distribution records. I have the node setup and the fields all set via SQL. The first record will add just fine, however the second will error (AGS) with "Distribution Code Already Exists". I know the method is "ADD" and unlike excel upload there is no "ADD then Change". Anyone have correct methofd for doing this?

Ragu Raghavan

Veteran Member

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

9/19/2023 8:14 PM

If you can copy/paste the AGS call, maybe somebody will see something obvious

John Henley

Posts: 3362

New Poster

Engaged Reader

Avid Reader

9/19/2023 10:11 PM

For header/detail forms, I find the easiest thing to do is start with the ADD for the header, and then add the lines using a CHG but with a Line FC = A. In other words, use two different AGS calls--one for the header, and a second for the details. Don't try to get fancy.

Randy

Veteran Member

Posts: 50

New Poster

Engaged Reader

Avid Reader

9/20/2023 1:21 AM

John Henley - Thats exactly what I ended up doing, however had to get a little fancy. Records live in a SQL DB, 1 Table, 1 row = HDR and Detail data. You cannot add the header without 1 detail row with the Lawson transaction node, AP05.3. The SQL row numbers the data rolling on COMPANY,DIST_CODE. I add all the headers where ROW =1. Then with another SQL/Transaction node I add all the rows ROW <> 1. Worked as it should.