Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

PR36 add-in upload

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Phil Simon
Veteran Member Send Private Message
Posts: 135
Veteran Member
10/20/2009 11:16 AM

Hello All

I'm trying to create the upload for the PR36.  I have mapped the fields below and have read: 

Finding Splat or Hidden Key (HK) Fields for use with Lawson Add-ins for Microsoft Office  
Article ID:1054552  

For some reason, I can't get to the formdef to find the hidden field(s).  Anyone?  Thanks.

field# name database field name
24 Emp No TRD-EMPLOYEE
34 Date TRD-TR-DATE1
30 Pay Code TRD-PAY-CODE1
36 Shift TRD-SHIFT1
31 Hours TRD-HOURS1
29 FC LINE-FC1
22 Company TRD-COMPANY

Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
Phil Simon
Veteran Member Send Private Message
Posts: 135
Veteran Member
10/20/2009 11:37 AM
I'm guessing that the hidden field is f2 (Sequence number).
Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
Deleted User
New Member Send Private Message
Posts: 0
New Member
10/20/2009 11:40 AM
Phil - we upload to PR36 (and 35.2) every pay period - there shouldn't be any hidden fields. If you want to send a sample file to me I'll be happy to test it here. I'm off site at a meeting this am, but should be able to try this afternoon.
Phil Simon
Veteran Member Send Private Message
Posts: 135
Veteran Member
10/20/2009 1:07 PM
Thanks, Stephanie. We tried a fresh one sans hiddens fiels and success! Weird...
Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
Belma
New Member Send Private Message
Posts: 3
New Member
1/22/2024 5:59 PM

PR36.1 Hidden Key: the only thing I found in Excel Add-Ins PRTIME is F734: _HK field. I upload to add or change PR36.1, using Excel Addins and I do not have to use the Hidden Key. If I change the PR36.1, I do have to use the F45: TRD-Time-Seq field reference.