Monday, May 5, 2025

How to Retrieve Personnel Number for a Specific User in Dynamics 365 F&O

 In SQL:-

    

SELECT 

    HW.PersonnelNumber,

    PU.USER_

FROM 

    HcmWorker AS HW

JOIN 

    DirPersonUser AS PU ON HW.Person = PU.PersonParty

WHERE 

    PU.USER_ = 'Akhil';

No comments:

Post a Comment

How to Control Edit Access for Sales Tax Fields in PR Lines Through Configuration in D365 Finance & Operations

 To provide a configuration-driven approach for controlling edit access to the Item Sales Tax Group and Sales Tax Group fields on Purchase...