• From: USA
  • Registered: 12/14/2018
  • Posts: 1

Topic: Maximum no. of inventory, vendor, customer, user

Is there any limit of inventory, vendor, customer and users quantities?

Anyone let me know the maximum no. of above each?

thank you

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Maximum no. of inventory, vendor, customer, user

Most primary keys that are INT type (MySQL) in FA are of default INT(11) unsigned. By definition:

.... and the maximum value will be 2147483647 (Signed) or 4294967295 (Unsigned)

Are you intending to exceed 4 billion entries? If so, FA may not be for you...... or customise the ID fields and increase the display width everywhere in screens and reports!

apmuthu's Website