RQ04 Requesters for multiple Companies

Our requestors have the ability to change companies in RQC on the From Location. Have you tested this possibility?

There is a setting in rqc_config.xml that lets the user select the company. Where I have found this to be problematic, however, is if you are trying to restrict the chargeable companies/accounting units for the requester.

Changing companies on the Detail Profile tab really doesn't do much unless you need to pull from an inventory location tied to that company. It's the company on the Basic tab that is key for how the charge hits the GL.

Yes, you CAN set up requesters with multiple companies. After you set up the requester with the first company and have added the associated AUs, just change the company and requesting location (or leave this blank) on the Main tab. Then add the AUs they should have access to on the Accounting Units tab. The system will keep the information from the previous company (hidden in the background). If you change the company back to the previous one (actually click Change) and go to the AU tab and inquire the previous AUs will appear. The AUs associated with the second company are now hidden. Your requester is set up for both companies now. They just have to remember to change it in RQ10 or RQC.

Posted By JonA on 09/11/2012 03:16 PM
Yes, you CAN set up requesters with multiple companies. After you set up the requester with the first company and have added the associated AUs, just change the company and requesting location (or leave this blank) on the Main tab. Then add the AUs they should have access to on the Accounting Units tab. The system will keep the information from the previous company (hidden in the background). If you change the company back to the previous one (actually click Change) and go to the AU tab and inquire the previous AUs will appear. The AUs associated with the second company are now hidden. 

I think you're actually seeing a fluke, and it was never intended to work that way.  
The code in RQ04 uses the company shown from RQ04 when updating RQACCTU.
If you change the company on RQ04, it actually deletes the requester and re-adds it with the changed company.
The records are left in RQACCTU are orphans...
Try this (substitute your values): 
Add requester as company 1
Add Account unit A for company 1
Change requester to company 2
Add acct unit B for company 2
Change requester back to company 1 (clicking change).
Change to the acct unit tab ...it will still have acct unit B there.
Change line FC to 'D', and click change ... you will get a lacobrts.

This may be true. I've heard that before that it creates orphan records in RQACCTU table. But it's a viable solution in my opinion. RQC works as I would expect it to. We've been using it this way for 9 years without an issue.

Very interesting! I guess this is a "feature"...this is in the Lawson KB:

Requester with access to Multiple Companies in RQC (Requisition Center)
Article ID:5405456
Description:
I want users to have the ability to add multiple companies/account information to a single requester in Requisition Center (RQC). How do I do this?
Resolution:
Inquire on the user's existing Requester (RQ04) record then add additional Company and Account information to the Requester and do a Change. If you want the user to have limitations to Accounting Units you can set this up on the Accounting tab of RQ04. An upcoming Enhancement Request is currently being worked on to add an additional field to the Accounting tab to show each combination of Companies the Requester is affiliated with. In the rqc_config.xml file, you also need to change the setting or make sure that the setting for 'Allow Company Select' is set to "true" and if you change the rqc config file you need to save your changes and Reload the Configuration file in the Utilities link in RQC (Requisition Center) in portal. When a requester's RQ04 record is changed or has their company changed, it does not remove the records associated with the previous company and accounting units. This will leave one record for the Requester on the REQUESTER database table and multiple company/Account Unit entries for the Requester on the RQACCTU database table.

Thanks for the suggestions. We'll give it a try.

Bruce . . . .

An additional option - I setup rqc_config to allow requesters to be changed, Supply Chain built alternate requester ID's by company. (ex..Requester 1000 and 1000a Same person with different defaults). Used ED40 to capture all those variants. (Used CHANGE_REQUESTER as the list name with the users ID and the requester ID). I then built a design studio form that allowed the user to select which ID that wanted to order for. The form prevents a user from manually entering a requester ID (This restricts to only authorized multi-company requesters). This has work very well and allow our MMIS staff to manage multi-company requesters.

That's a very clever, out of the box thinking, solution. I like it, especially using ED40 to load the variants. But I've always believed that simpler is better. This problem can be solved in 10 minutes with RQ04.