How to get the requester department using x++

(1) Share

Report

Posted on by D365FO DEV

406

Hello,

i need the x++ to retreive the department of the selected requested in my PO header,

now if u click on position it shows you the Department of this requester.

so anyone can provide the x++ code to make this happen?

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Check this code:

HcmWorker hcmWorker; HcmPositionWorkerAssignment hcmPositionWorkerAssignment; OMOperatingUnit oMOperatingUnit; HcmPositionDetail hcmPositionDetail; HcmPosition hcmPosition; hcmPositionWorkerAssignment = HcmPositionWorkerAssignment::getActivePositionWorkerAssignment(POrequester); hcmPosition = HcmPosition:find(hcmPositionWorkerAssignment.position); hcmPositionDetail = HcmPositionDetail::findbyPosition(hcmPositionWorkerAssignment.position); oMOperatingUnit = OMOperatingUnit::find(hcmPositionDetail.Department); info("Department:"+oMOperatingUnit.Name);

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

Hi wael,

i tried your code but its not working

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

It should work, did you try to trace the code? Does the requester have active position or not? Reply to my questions in order to help you.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (1)

Report

Hi wael,

when i tried your code:

i got the following error:

'OMOperatingUnit.find' is missing argument 2 of type 'Extensible Enumeration(OMOperatingUnitType)'.

so i added the enum type:

Now i debugged the code and the values are null

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Yes, you should add OMOperatingUnitType. Can you check the value of the HcmWorkerpositionAssignment and HcmPositionDetail ?

Thanks,
Waed Ayyad

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

You can get it on another way:

OMOperatingUnit oMOperatingUnit = HcmWorkerHelper::getPrimaryDepartment(PORequester); info(oMOperatingUnit.name);

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
can you tell me what is PORequester in

hcmPositionWorkerAssignment = HcmPositionWorkerAssignment::getActivePositionWorkerAssignment(POrequester)
also i have debugged the values, they are all coming null

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

PO requester is Requester field on PurchTable.

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

PO requester is Requester field on Purch Table. You should select the Purch Table buffer first

HcmWorker hcmWorker; HcmPositionWorkerAssignment hcmPositionWorkerAssignment; OMOperatingUnit oMOperatingUnit; HcmPositionDetail hcmPositionDetail; HcmPosition hcmPosition; PurchTable purchTable; select Requester from purchTable where .... // Add where based on RecId or PurchTd, hcmPositionWorkerAssignment = HcmPositionWorkerAssignment::getActivePositionWorkerAssignment(purchTable.Requester); hcmPosition = HcmPosition:find(hcmPositionWorkerAssignment.position); hcmPositionDetail = HcmPositionDetail::findbyPosition(hcmPositionWorkerAssignment.position); oMOperatingUnit = OMOperatingUnit::find(hcmPositionDetail.Department, OMOperatingUnitType::OMDepartment); info("Department:"+oMOperatingUnit.Name);

Thanks,
Waed Ayyad
If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No