Want to Hide Few Fields such as Purchase Price etc ONLY in the Purchase Invoice Reports

[Sohailans]

We have a scenario where we ahve to give Purchase Invoice Reports/List Access to One of the User, but we dont want him to view the Item Purchase Price in the Default Purchase Invoice Reports.

can you see the Grant Total Purchase Price, we have to hide this Column (in image below)

Solution 1 we tried but to no avail → We tried to make separate mysql query based report (without Purchase Price) for purchase Invoices and to give him access to that report ONLY, but if we give him Purchase Role access, he gets access to All other Purchase Invoice reports which shows him Purchase Price as well.

Solution 2 we tried but to no avail - > we made User Permission to allow him only MYSQL query based report but that too is visible only when we given Pruchase Role and not otherwise.

Pls suggest efffective SOLUTION.

Thanks highly appreciated

[ejaaz]

Try using field-level permissions; change this to 1 or 2, and don’t give access to this field for your user role, for example, Purchase User.
https://docs.erpnext.com/docs/user/manual/en/changing-the-properties-of-a-field-based-on-role