Customized General Ledger with Sales Order

Gien_Vicencio · June 18, 2020, 3:30pm

Hello Everyone,

I have a problem with my customized general ledger. I created it because we want to include the Sales Order. Actually it is working fine if I am using administrator account. However, upon changing to my personal account I am receiving this error message. I am not sure if it is related to any rights/permission.
InternalError: (1054, u"Unknown column ‘tabGL Entry.company’ in ‘where clause’")

Suresh_Thakor · June 18, 2020, 5:42pm

Please roll back it’s role permission once then reassign and check…

Gien_Vicencio · June 18, 2020, 6:38pm

Hi Suresh, thank you for responding. What do you mean of roll back? I’m a bit confuse.

Suresh_Thakor · June 18, 2020, 7:17pm

Remove permission then save it.

Check again. Report should have restrictions to access for this user.

Then assign permission and check again.

Gien_Vicencio · June 18, 2020, 7:53pm

Hi @Suresh_Thakor, I tried it but still encountered same error.

Meet_Patel · May 28, 2021, 8:37am

Hi!

How can I add Sales Order in General Ledger Report?

Gien_Vicencio · June 22, 2021, 8:33am

Solution:

Joseph_Marie_Alba1 · June 22, 2021, 9:22am

If you update to a newer version using bench in the future, bench might require you to do a reset.