How to put invoice record in read only after special condition

[geraldbigot]

Hi,
I need to add new feature to my crm due to accounting demand :
How to put an invoice record in "Read only" after changing invoice status to a specific value ?
I was looking for such function in workflows but not found.
Gérald

[rslemer]

Hi
I think you can do that using Business map
Look documentation --> https://discussions.corebos.org/document...s[]=access

[joebordes]

I agree with Ranieri, RAC should work. Have a look also at the archive record pattern explained here:

https://blog.corebos.org/blog/archiverecordpattern

that should work too.

Let us know how it goes.

[geraldbigot]

Thank you for your 2 advices.
I will look at it to adapt it to my case.

Gérald

[geraldbigot]

Thank you for your 2 advices.
I will look at it to adapt it to my case.

Gérald

Joe's idea seems more easy to me.
I have succeeded with this solution but : what about administrator user ?
I mean, if we have an accounting control, no one could modify an invoice, even admin user.

Is there any settings to make invoice record totally "read only"

Gérald

[joebordes]

no, there isn't. especially considering that an admin can easily get access to the database itself and go directly there to do anything they want

I have this sort of question in planning. My idea is to send the information to immudb or an immutable table in ClickHouse and permit consultation and comparison with the data in MySQL. Not difficult to do but still a bit far away.