No permission error on Child DocType

ERPNext
1

Hi,

I’ve seen some similar problems but without a solution.

My Situation:

I need a DocType where I can add multilple items (AssetDefinition) that have a Parent-Child structure (Category-SubCategory).

To simplify, imagine that I need to add a listo of assets with a Name, a Brand and a Model, if I select a Brand, the dropdown shows me just Model associated to that brand.

DocType “SubCategory” (is Child Table = True)

  • Field 1: Name (Data)

DocType “Category” (is Child Table = False)

  • Field 1: Name (Data)
  • Field 2: SubCategories (Child Table of “SubCategory” DocType)

DocType “AssetDefinition” (is Child Table = True)

  • Field 1: Name (Data)
  • Field 2: Category (Link of “Category” DocType)
  • Field 3: SubCategory (Link of “SubCategory” DocType)

DocType “ItemList” (is ChildTable = False)

  • Field 1: Name (Data)
  • Field 2: AssetList (Child Table of “AssetDefinition” DocType

The ItemList form appear like this:

image
image1053×315 32.3 KB

When I add a new row it appears like this:

image
image1013×563 62.5 KB

Using Administrator all is working fine, I can select Category, then SubCategory is filtered with a Client Script based on the selected Category, but when I try to add a row from a User (that has permissions on the ItemList (the main DocType) and on the Category), I receive this error when trying to select the SubCategory:

image
image576×187 13.1 KB

I can’t provide direct permission on “SubCategory”, because it’s a Child Table.

How can I solve this?

Thanks

2

We have exactly the same problem. It does not matter whether I toggle the “ignore permission” setting or not in the respective custom field of the form. “Administrator” user can access, any other user even with role “Administrator” cannot.

Any hints for me?

Thank you in advance.

3

The only way I found to solve is to rebuild the SubCategory DocType.

Instead of having the Category + SubCategory child table,

Directly in SubCategory DocType I have added the Category link field, that is its parent.

In this way to populate all subcategories I need to create it one by one, instead of using a table inside the Category, but in this way it works, because now I have removed the nested childtable, that seems to create the problem.

My situation now is this one:

DocType “SubCategory” (is Child Table = False)

  • Field 2: Parent Category (Link)

  • Field 1: Name (Data)

DocType “Category” (is Child Table = False)

  • Field 1: Name (Data)

DocType “AssetDefinition” (is Child Table = True)

  • Field 1: Name (Data)

  • Field 2: Category (Link of “Category” DocType)

  • Field 3: SubCategory (Link of “SubCategory” DocType)

DocType “ItemList” (is ChildTable = False)

  • Field 1: Name (Data)

  • Field 2: AssetList (Child Table of “AssetDefinition” DocType