why this error display when i make post in purchase order

ahmedba

Hi guys i have purchase order when i click post button i found this error display why this error display

i create user Sohail i give him permission security filter to see item category code AGG (aggregate)

but after i make order then i make post then it give me message error "you don't have permission to read purchase line table"

i upload my files in Mediafire website :

http://www.mediafire.com/?b9h7e1gwqbgxgzv

I want to know how i solve this problem.

mohana_cse06

What roles did you assign for user?

do they have permissions to read 39 table data?

ahmedba

Yes i make to read permission to table 39 this is purchase line if you see picture i uploaded in link you will see that i make security filter to see AGG in one role AND in another permission i give hime indirect permission

ahmedba

when i make post in purchase order debugger as link http://www.mediafire.com/?b9h7e1gwqbgxgzv
it give me this error
IF PurchaseLines.FIND('-') THEN BEGIN
REPEAT
(yellow cursor) IF PurchaseLines."Prepmt. Amt. Inv." <> PurchaseLines."Prepmt. Line Amount" THEN
EXIT(TRUE);
UNTIL PurchaseLines.NEXT = 0;
END;
and message told me "you dont have permission to read purchase line table"

ahmedba

Please can any one help me in this proplem

ahmedba

can any one know what is the problem in this code

Nik_B

hi ahmedba,

There is nothing wrong in the code, it is just that the user who is using NAV or Posting PO have not direct permission to read Purchase line

Go to Tools

---

>Security

---

>SQL/Windows Login

---

>Locate the User and see its role
What ever roles assinged to him/her see its permission and add table Purhcase line table with Read permission(dnt check indirect permission).

Once done esc and Sync the User
Go to Tools

---

>Security

---

>Sync Single Login.

Then Restart the NAV application. This must solve your Problem.

ahmedba

I already asyncronus single login but i dont show in my pictures and also I add purchase line table with yes read yes inset execute yes

Nik_B

Remove security filter that is applied, it is restricting the data to read

ahmedba

OK but i have problem how if i remove security filter.How i make restrict to user to see specified data as sp item because i make this to make security filter

ahmedba

Are this problem because i not assign set permission filter function