IPA and AP05.3 - LawsonGuru.com - LawsonGuru.com Forums -

Prev Go to previous topic

Go to next topic

Last Post 9/20/2023 1:21 AM by Randy

IPA and AP05.3

3 Replies

0 Subscribed to this topic

163 Subscribed to this forum

Sort:


You are not authorized to post a reply.

Author

Messages

Randy
Systems Administrator
Rochester Regional Health

(124 points)
Veteran Member
Posts:46

Send Message:

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
Private
Private

(1336 points)
Veteran Member
Posts:464

Send Message:

9/19/2023 8:14 PM
If you can copy/paste the AGS call, maybe somebody will see something obvious

John Henley
Private
Private

(9980 points)
Senior Member
Posts:3344

Send Message:

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. Thanks for using the LawsonGuru.com forums! John

Randy
Systems Administrator
Rochester Regional Health

(124 points)
Veteran Member
Posts:46

Send Message:

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.

You are not authorized to post a reply.