Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Purchase Order Authorisation absolute limits
07-03-2013, 01:54 AM,
#1
Purchase Order Authorisation absolute limits
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
Reply
07-03-2013, 08:53 AM, (This post was last modified: 07-03-2013, 08:57 AM by phil.)
#2
RE: Purchase Order Authorisation absolute limits
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
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
07-03-2013, 05:02 PM,
#3
RE: Purchase Order Authorisation absolute limits
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


Reply
07-04-2013, 06:40 AM, (This post was last modified: 07-04-2013, 06:40 AM by phil.)
#4
RE: Purchase Order Authorisation absolute limits
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
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)