License Permissions in SQL DB

Pavlos · 2005-11-28

Hi to all,

I have a question regarding license permissions in SQL DB. I have a customer that has purchases a navision (v4.00) license. When I try to run the Sales Order form I get a permission error on Service Invoice Line. This is because the customer has not purchase the Service module and there is a flow field on Item that uses the service invoice line. How can I handle this problem? It seems strange to me that this is not happening on Native database…

Thanks in advance.

Arhontis · 2005-11-28

Hi,

Could you enable the debugger and post the function that raises the error?
Verify that you are trying to open form 42.

Pavlos · 2005-11-29

Hi Arhontis,

The error raise in codeunit 5790 in function CalcGrossRequirement(Item). This is called from the panel in the right hand side of the Sales Order subform when trying to calculate the available inventory. I've comment out the code for the calculation of the flowfield Qty. on Service Order so I've manage to pass this error. However this is not seems to me to be the appropriate solution. As I've mention in my initial post this is not happening in native navision database. Any suggestions?

Thank you

kine · 2005-11-29

And is the "called" table empty? Are you sure, that there are no data left?

Pavlos · 2005-11-29

I've finally manage to solve the problem by deleting the data from the coresponding tables. But I still have the same question. Why this is happening in SQL db and not in native db?

kine · 2005-11-29

As I wrote in some other post - SQL need to touch the table to know if there are data... Native DB works in another way and do not need it...

Pavlos · 2005-11-29

OK I got it now!!!

Thanks a lot Kine. \:D/

License Permissions in SQL DB

Comments

Categories