Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Must inquire before using this function code (_f0)

 8 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Dave Williams
Advanced Member
Posts: 27
Advanced Member
7/22/2014 12:01 PM
    I recently wrote my 1st Upload file and I can't get it to work.  I keep getting the error: "Must inquire before using this function code (_f0)”  I have searched this Forum and saw 2-3 postings on thgis same issue and tried to apply the answers to my situation but, to no avail.  I understand that it most likely is due to a Hidden Key issue, probably with the LINE-FC?  I currently have the following Hidden Keys mapped:

    (H),_f9,ORIG-COMPANY
    (H),_f10,ORIG-EMPLOYEE
    (H),_f11,ORIG-ACTION-CODE
    (H),_f12,ORIG-EFFECT-DATE
    (H),_f104:0,LINE-FC-11
    _f350,_HK

    Here is an example of my _f350 HK:

    0001000012291SALARYCHG 20140716

    This is derived from a formula: 

    =IF(B9="","",RIGHT("0000"&B9,4)&RIGHT("0000"&C9,9)&LEFT(D9&" ",10)&F9)

    WHERE "B9"= COMPANY, "C9" = EMPLOYEE, "D9"= ACTION-CODE, and "F9" = EFFECT-DATE

    I have tried "Change Only", "Try to Add, then Try to Change", "Add Only", then "Change Only"
    All of these indicate that I need to Inquire first.

    Also, in a previous Post, John Henley mentioned "One way to verify is to capture the AGS call when you are doing this in Portal, and then match up the _f* fields from the AGS call to your addins upload ...

    Unfortunately, I do not know how to capture the AGS call.

    Any help is greatly appreciated!!

    Dave Williams
    Margie Gyurisin
    Veteran Member
    Posts: 538
    Veteran Member
    7/22/2014 12:11 PM
      are you referencing PA52.

      Mine looks like this - =RIGHT("0000"&A20,4)&RIGHT("000000000"&B20,9)&LEFT(C20&" ",10)&D20&RIGHT("0000"&E20,4)

      Column a is company, b is employee number, c is the action code, e is the effective date.
      Dave Williams
      Advanced Member
      Posts: 27
      Advanced Member
      7/22/2014 12:25 PM
        Margie,

        Let me try changing my formula to match yours and see if that works.

        Dave
        M.J.
        Veteran Member
        Posts: 38
        Veteran Member
        7/22/2014 12:37 PM
          I believe this may change depending on your Lawson version but the attached excel file is what I have used successfully for the PA52.1 Add-In for rate changes.  It's also going to depend on where the field is that you want to change on the personnel action.  In our case, rate of pay is the first field on the personnel action.  If it wasn't, you would have to list the other fields as well even if not changing (I think).
          Attachments
          Dave Williams
          Advanced Member
          Posts: 27
          Advanced Member
          7/22/2014 12:39 PM
            Margie,

            What is in your "D" column?

            Dave
            Margie Gyurisin
            Veteran Member
            Posts: 538
            Veteran Member
            7/22/2014 12:58 PM
              effective date as yyyymmdd
              Dave Williams
              Advanced Member
              Posts: 27
              Advanced Member
              7/22/2014 1:13 PM
                Margie,
                Above you stated that E was the Eff Date. But, later you state that D is the Eff Date. Just to be clear, you said that yours is:

                =RIGHT("0000"&A20,4)&RIGHT("000000000"&B20,9)&LEFT(C20&" ",10)&D20&RIGHT("0000"&E20,4)

                a = Company
                b=Employee
                c=Action Code
                d= effective Date
                e =

                What would "E" be.....??

                Thanks

                Margie Gyurisin
                Veteran Member
                Posts: 538
                Veteran Member
                7/22/2014 1:27 PM
                  Sorry.

                  E is action number. We load them all as action number 1 and that field was added when we went to 9.0.

                  I don't remember why. Perhaps it was a kb article.
                  Mary Porter
                  Veteran Member
                  Posts: 337
                  Veteran Member
                  7/22/2014 2:17 PM
                    I think the two best KB articles are 1196839 and 1199678