Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Human Capital Management
Lawson S3 HR/Payroll/Benefits
Must inquire before using this function code (_f0)
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
2
Prev. 24 Hours:
1
Overall:
5186
People Online:
Visitors:
276
Members:
0
Total:
276
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 HR/Payroll/Benefits
Must inquire before using this function code (_f0)
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Dave Williams
Advanced Member
Posts: 27
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
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
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
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
PA52.1_RateChg.xlsx
Dave Williams
Advanced Member
Posts: 27
7/22/2014 12:39 PM
Margie,
What is in your "D" column?
Dave
Margie Gyurisin
Veteran Member
Posts: 538
7/22/2014 12:58 PM
effective date as yyyymmdd
Dave Williams
Advanced Member
Posts: 27
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
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
7/22/2014 2:17 PM
I think the two best KB articles are 1196839 and 1199678
You are not authorized to post a reply.