+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Purchase Order Authorisation absolute limits (/showthread.php?tid=957)
Purchase Order Authorisation absolute limits - tohoma_erp - 07-03-2013
Hi all.
I am new to this forum and I just started to try webERP.
I am setting it up for a company in Indonesia using Rupiah currency and it requires quite a big number of PO authorization limit (>10billion). FYI, 1USD = ~10,000 rupiah.
When I entered 10billion (10,000,000,000), webERP change it to 2,147,483,647 (which only equivalent to 200thousands USD).
Is there any way to increase the limit, or just the limitation of the webERP?
If I have to change the code, appreciate if someone can provide pointer to what file/module to modify.
Thanks and regards,
iwan
RE: Purchase Order Authorisation absolute limits - phil - 07-03-2013
Looking at the database I can see that authlevel is using integers and limits per the mysql manual
Quote:INT 4 -2147483648 2147483647
I have just changed the demo to double - so should work for you now
RE: Purchase Order Authorisation absolute limits - tohoma_erp - 07-03-2013
Thank you Phil.
I just tried the demo and it worked. I've also modified my system.
Wrt the data type, shouldn't bigint be a better replacement for int instead of double?
Also, it will be good if this change can be implemented in the next release. There are quite a few currency that needs billions for the authorization value. Iran Rial, Vietnam Dong are even have less value then IDR. See http://en.wikipedia.org/wiki/Least_valued_currency_unit
Iwan
RE: Purchase Order Authorisation absolute limits - phil - 07-04-2013
Yes we could equally use bigint.
I have changed my working copy already - but not committed will do when I something else to commit, so yes it will be in the next release