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



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



    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


      stephanie











      Veteran Member



      Posts: 330




      Veteran 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



        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



          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.