PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/19/2016 8:05 AM by  Kat V
RQ04.1 (REQUESTER) Add-Ins for Accounting Unit
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JODAMORE
Senior Supply Chain Analyst
Boston Medical Center
Basic Member
(14 points)
Basic Member
Posts:8


Send Message:

--
12/12/2016 1:59 PM

    Greetings,

    Has anyone leveraged the Excel Add-Ins tool to Delete/Add AU's within the RQ04 table?  I was hoping it would be an easy mapping, but it appears not.  I tried utilizing a PT-Accounting Unit field logic like other problematic Position-To tables such as REQ LOC, but it still does not work.  Quick rundown as follows:

    Have several hundred old REQUESTERS with REQ LOCS and AU's populated that are inactive and were never used.  I want to cleanse the system of these junk records, but am required to delete the REQLOC and AU fields to do so.

    When I run the Add-In, I populate the upload with f2 REQUESTER, f31 (H)PT-ACCT-UNIT = AU I want to "Position-To " and delete, f84.0 LINE-FC-A1 = "D" to delete.  Due to the AU being inactive, it fails and lets me know the "AU ####### is inactive".  The change does not go through, but I can manually Delete the AU and REQ LOC, click change, then delete the requester without issue.  (EDIT:  I have also attempted to run this same upload detailing the REQ LOC (f7 REQ-LOCATION) as blank value.  Do to the error of "REQ LOC INACTIVE" if I try and change the AU independently.  

    I DO NOT want to have to do this several hundred times.  Please, greater LawsonGuru minds, help me solve this easily.  Any insight would be appreciated.

    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    12/14/2016 9:47 AM
    Is this in V9 or V10? For V9, I only use _f2,REQ-REQUESTER, _f84:0,LINE-FC-A1, and _f85:0,ACCT-UNIT1 for both adding and deleting accounting units.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    12/19/2016 8:05 AM
    I have the same problem - it is when the requester has multiple AUs. You need to position to the AU that you want, which it can't do because the inquire returns "Accounting Unit ###### is inactive"

    If the requesters only have 1 AU, Jon's map works. I get on the phone with Finance and have them activate the AU long enough for the upload and then re-inactivate.
    You are not authorized to post a reply.