PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/05/2018 3:31 PM by  Lance Jurgensen
BN32 update specific line?
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lance Jurgensen
Lawson System Administrator
Private
Advanced Member
(66 points)
Advanced Member
Posts:30


Send Message:

--
11/05/2018 10:15 AM

    I am trying to update BN32.1 lines but it always wants to update line 1. The query brings back the DC plans that do not have a stop date for terminated employees. Is there a way to determine what line a record is on?  In my example I have Benefit Type = DC and in the form the inquire brings back 3 lines, a DC04, DC02 and a DC05.

    My transaction string is as follows and I'm guessing I need to do something on the highlighted entry below?

    _PDL=&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=&BEN-EMPLOYEE=&LINE-FCr0=&BEN-STOP-DATEr0=&BEN-PLAN-CODE=&BEN-START-DATE=&_DELIM=%09&_OUT=XML&_EOT=TRUE

    We are on IPA 10.1

    Thanks, 

    -Lance

    Lance Jurgensen
    Lawson System Administrator
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    11/05/2018 10:39 AM
    I see the variables where stripped, this is more like what I currently have:
    _PDL=HRDEV&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=15&BEN-EMPLOYEE=123456&LINE-FCr0=S&BEN-STOP-DATEr0=20181031&BEN-PLAN-CODE=DC02&BEN-START-DATE=20180101&_DELIM=%09&_OUT=XML&_EOT=TRUE
    Ragu Raghavan
    Private
    Private
    Veteran Member
    (893 points)
    Veteran Member
    Posts:311


    Send Message:

    --
    11/05/2018 10:48 AM
    There are hidden fields PT-COMPANY, PT-EMPLOYEE etc. that the logic uses to position the records. Maybe you can use those, so the first line will be the record you want to update?
    Lance Jurgensen
    Lawson System Administrator
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    11/05/2018 11:10 AM
    I believe they are COMPANY, EMPLOYEE and START-DATE but that does not help in my case when 2 of the 3 plans have the same start date...
    Bob Canham
    Private
    Private
    Veteran Member
    (567 points)
    Veteran Member
    Posts:205


    Send Message:

    --
    11/05/2018 11:16 AM
    I stay away from BN32 for changes since it doesn't have a position-to field. Instead, I use BS32 for doing stops and BN31.1 for adding new records.
    Lance Jurgensen
    Lawson System Administrator
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    11/05/2018 11:31 AM
    I will take a look at BS32, thanks!
    Lance Jurgensen
    Lawson System Administrator
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    11/05/2018 11:39 AM
    Would you happen to have an example of a BS32.1 stop transaction string? Wondering how to find/use the position-to?
    Bob Canham
    Private
    Private
    Veteran Member
    (567 points)
    Veteran Member
    Posts:205


    Send Message:

    --
    11/05/2018 11:44 AM
    Here is my BS32.1 update. You don't need a position to on that form as it doesn't come pre-populated, so you just fill in record 0.

    
    

    _PDL=PROD&_TKN=BS32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=1&BEN-EMPLOYEE=EMPLOYEE&LINE-FCr0=S&BEN-PLAN-TYPEr0=DC&BEN-PLAN-CODEr0=PlanCode&BEN-START-DATEr0=20180101&BEN-STOP-DATEr0=20181105&_DELIM=%09&_OUT=XML&_EOT=TRUE

    Lance Jurgensen
    Lawson System Administrator
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    11/05/2018 3:31 PM
    Thank you for the push in the right direction, using BS32 is exactly what I needed. Working great and scheduled to run.
    You are not authorized to post a reply.