add-ins for HR10

 14 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Phil Simon
Veteran Member
Posts: 135
Veteran Member
    Hello

    Anyone ever figure out if you can use the MS Add-ins to make changes on HR10?

    Thanks.


    Phil Simon
    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    John Henley
    Posts: 3353
      It works -- you just need to map the correct field number to the (hidden) field number (_f6).
      Thanks for using the LawsonGuru.com forums!
      John
      Phil Simon
      Veteran Member
      Posts: 135
      Veteran Member
        Thanks. I had been noodling with this but couldn't discern the difference between f5 and f6 on the HR10 upload screen. Do I really need both?

        I know that I need FC (f9), company (f3), and change via personnel action(f11).

        Do I need item name(f10) or would f5/6 take care of that?

        Thank you for the quick response!
        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
        John Henley
        Posts: 3353
          You just need f3, f9, f11, and f6.
          Thanks for using the LawsonGuru.com forums!
          John
          Phil Simon
          Veteran Member
          Posts: 135
          Veteran Member
            Coffee must not have kicked in. I tried this with these fields and I get that all too descriptive "field is required message." To make employee a PA-CHANGE-ONLY field, f6 would equal the field "employee"? I can send or post the .uwf and .xls files that I'm using, if that's helpful. We have way too many product lines here to keep doing hr10 changes manually so this would be really helpful.

            Thanks.
            Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
            John Henley
            Posts: 3353
              You need to plug in the INTERNAL field number from PADICT2.

              "Employee" = 1
              "Status" = 20

              I can send you a Crystal report that will print out the field numbers, etc. for "handy reference"...
              Thanks for using the LawsonGuru.com forums!
              John
              Phil Simon
              Veteran Member
              Posts: 135
              Veteran Member
                Thanks. I have ODBC here so I can get to the field values (one little victory)!

                company fc f5 F6 PA Results from HR10.1
                10 C E1 20 X Change Complete -

                I tried to change status (20) but don't see the results in Lawson Portal.

                Thanks.
                Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                John Henley
                Posts: 3353
                  You need to use 'tmcontrol' utility via LID to reload the form into memory, as the HR09/HR10 values are cached in Portal. See this article for more info:

                  https://www.lawsonguru.co...g-HR-setup-data.aspx
                  Thanks for using the LawsonGuru.com forums!
                  John
                  Phil Simon
                  Veteran Member
                  Posts: 135
                  Veteran Member
                    Thanks. I'll see if that helps. I went to the DBA's computer and pulled this up in LID but the change still isn't there. Is this a problem that transcends Portal? In other words, do you need to do this every time regardless of presentation layer?
                    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                    Phil Simon
                    Veteran Member
                    Posts: 135
                    Veteran Member
                      My .uwf must be wrong; the tmcontrol utiilty that the DBA ran didn't fix this. I'll play around. Thank you very much.
                      Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                      Phil Simon
                      Veteran Member
                      Posts: 135
                      Veteran Member
                        Below is a topica reply to this same question. I'm still noodling with this and would love to get this to work:

                        ********

                        I did a quick test to see if I could change the History field. Here are the fields I needed

                        Company(f3),Topic(f5),Item Name(f10),Fld #(f6),Hitory flg(f14),H-Item
                        Name(f17),HK(f117),FC(f9)

                        The key to making it work seems to be to include the field #, the HK field and a copy of of the field name in field f17.

                        Hope that helps.
                        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                        John Henley
                        Posts: 3353
                          Do you see the change taking effect in LID?

                          I did, using just f3, f9, f11, and f6.

                          You might need to do an IOSCacheRefresh in addition to the 'tmcontrol'
                          Thanks for using the LawsonGuru.com forums!
                          John
                          Phil Simon
                          Veteran Member
                          Posts: 135
                          Veteran Member
                            Using only those fields, I get "Field is required."

                            If you can shoot me a screen shot, then I'd appreciate it.

                            psimon88@comcast.net

                            Much obliged, John.
                            Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                            Phil Simon
                            Veteran Member
                            Posts: 135
                            Veteran Member
                              BTW, the last time that the DBA here did tmcontrol, there was no change on hr10, leading me to believe that it's my .UWF.
                              Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                              Phil Simon
                              Veteran Member
                              Posts: 135
                              Veteran Member
                                I'm still noodling with this and found Lawson article 1054552 on splat fields (great name). The example in the article is for AM30.1 but I would think that this would apply to HR10 as well. Would the process be the same as the one for uploading personnel actions? They both involve hidden fields.

                                Thanks.
                                Attachments
                                Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com