Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I´m using a section access to assign permissions via an excel Spreadsheet to users. Now I´m wondering if it is possible to do the following:
I´ve field "SoldToBusinessPartner" that contains customer numbers. Our customer numbers from different production sites start with a different number range, e.g. 2000XXXXX or 26000XXXXX. Now I would like to know if it is possible to assign a permission to a user using the field "SoldToBusinessPartner" and assign him all customers that start with 2000*. I tried to use just 2000* in my excel spreadsheet but that was not the solution. Does anybody know how to do this?
Best regards,
Carolin
I would define the Customer groups in the Customer table, for instance through
Left(CustomerNumber, 5) as CustomerGroup
and then use this new field CustomerGroup in my Section Access.
I don't know what the logic is around the number ranges, but either the above or something similar to
Left(CustomerNumber, Len(CustomerNumber)-6) as CustomerGroup
should probably do the trick.
HIC
Hi Carolin,
Yes you can use your suffixe to identify a group
so you can set
UserID, GroupId, Login, Password....
best regards
Chris
Hi, see this attached
Good Luck
Fernando
I would define the Customer groups in the Customer table, for instance through
Left(CustomerNumber, 5) as CustomerGroup
and then use this new field CustomerGroup in my Section Access.
I don't know what the logic is around the number ranges, but either the above or something similar to
Left(CustomerNumber, Len(CustomerNumber)-6) as CustomerGroup
should probably do the trick.
HIC