|
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.
|