• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 27
Advanced Member
7/22/2014 12:39 PM
Margie,

What is in your "D" column?

Dave
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
7/22/2014 12:58 PM
effective date as yyyymmdd
Dave Williams
Advanced Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 337
Veteran Member
7/22/2014 2:17 PM
I think the two best KB articles are 1196839 and 1199678