web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)

(0) ShareShare
ReportReport
Posted on by 565

Hi. We recently upgraded to MS D365FO. We use the standard role of Sales man for some of the sales guys in our company.

They are facing this error "Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)" when trying to generate the pro-forma invoice or the sales invoice, neither of which have any customizations.

I searched the forum for this error but did not get a solution. I am the admin and I can generate the pro forma invoice / sales invoice just fine. To narrow it down a bit, I also figured out that the role "Accounts Receivable Manager" is able to generate the invoices just fine. I tried to compare the duties of both roles but I found nothing that jumped out at me for this case. 

I also tried checking the security diagnostics to find the roles / privileges involved for Packing Duty License Number in the customer's profile. It already shows Sales man, so I'm fresh out of options at the moment. 

Any advice on how to resolve this?   

I have the same question (0)
  • Alex VN Profile Picture
    1,994 on at
    RE: Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)

    Hi,

    You might refer to this document for further explanation.

    alexdmeyer.com/.../

    Regards,

    Anh Ong

  • Suggested answer
    NikolajSorensen Profile Picture
    1,784 on at
    RE: Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)

    Hi Vijay.

    You need to make sure that the security role has been granted specific access to the CustTable.TaxLicenseNum table/field.

    The reason why the role "Accounts receivable manager" can generate the sales invoice is because the Privilege "Edit customers" has this specific table and field access granted.

    The privilege is attached to the "Maintain customer master" duty which is attached to the "Accounts Receivable manager" role, but the "Sales Manager" role also has the "Maintain customer master" duty attached.

    So this table/field access should already be part of the role you mention. 

    pastedimage1635928178601v1.png

    This prompted me to double check the accesses of the Sales manager role and the standard role does not contain access to generate customer invoices. I think the roles you are mentioning have been modified to include the customer invoice generation, even though you have stated there are no customizations. 

    To fix the issue you are facing, you need to ensure that the table/field access as mentioned above is added to the security role, either through a privilege, duty or directly on the security role.

    BR

    Nikolaj

  • oldman.logan Profile Picture
    565 on at
    RE: Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)

    Dear Anh, Thanks for your reply. I had seen this article earlier, it describes my exact problem and explains the reason that its because there's no explicit access to the particular field in the table. But it gave me only a vague idea and not a direct solution, perhaps because I'm still new to the system. Thanks for your help!  

  • oldman.logan Profile Picture
    565 on at
    RE: Access denied to field Packing duty license number (TaxLicenseNum) in table Customers (CustTable)

    Dear Nikolaj, Thanks for your reply. In our system, creating  / editing customers is not allowed to regular sales staff. Its done only by the manager. So I gave them only the read option for the TaxLicenseNum as you mentioned. Works like a charm! Thank you so much for helping me out with this!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans