Mapping excel add in for 2 different screens?

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Stefanie Terrell
New Member
Posts: 1
New Member
    I want to update a user field on PO25.4; once the user field is populated and you hit OK, it takes you back to PO25.6 where the function box for that lines auto populates to 'C' and you have to hit change.  Is there a way to map duplicate pages in excel add ins?
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
      For the screens that you hit "ok" and not add/change - you upload to the actual application screen it returns to.

      So in this instance, you upload to PO25.6 and look for the PO25.4 fields marked as "(H)" for hidden. For my current version of Lawson on PO25.6 there are user fields at f96-f98 and then f132-f139. I *think* you want the set in the 90s as it's appearing with the min/max qty fields - but you would need to test to make sure.
      Red
      Veteran Member
      Posts: 87
      Veteran Member
        Stefanie,
        Generally speaking, Kat V is right--heck, she is always right--using Addins, it is often a challenge to get things fully updated on related, but separate screens.

        But there can be a different way to go... A number of years ago, Don Pederson at Lawson/Infor (who, along with Kat, I revere as one of my Infor Idols), published a few dozen worksheets that used a combination of Excel and VBA to accomplish some near miraculous updates (one of which might work for you 'off the rack'.) Think of these as Addins++ (there were sets for versions 9 and 10, but they are different). It did require Addins to be installed, as that was how it logged into your system. The VBA then performed AGS calls to the system based on information populated in the spreadsheet.

        For my team, I cobbled a handful of spreadsheets that focused on cost messages. For instance, I had one that closed a (an?) MA66.3 cost message, per our direction, added a boilerplate comment to the cost message and then added the same comment to the PO Line--essentially in one sweep. I also made one that just updates the comments on "Bill Only" POs, en masse. It wasn't easy, by any stretch, especially since my VBA skills are as good as my French (I can follow what others write when I read it, but I could not write much of anything to save my life). There is a fair amount of time dedicated to the set up, but the cost message 'automations' saved my team literally hours per day compared to the manual processes (assuming they were even doing the manual process).

        If you have any interest, let me know, I will do what I can to get you started.
        Good luck,
        Red
        Learn from the Past. Prepare for the Future. Act in the Present.