PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/12/2019 12:02 AM by  Red
Mapping excel add in for 2 different screens?
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Stefanie Terrell
Senior Data Analyst
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
8/23/2019 1:19 PM
    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2890 points)
    Veteran Member
    Posts:988


    Send Message:

    --
    9/9/2019 7:29 PM
    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
    Content Manager, Supply Chain
    Sutter Health
    Veteran Member
    (255 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    12/12/2019 12:02 AM
    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.
    You are not authorized to post a reply.