FrontAccounting forum — How to add some info fields for Customer and Supplier!?

Re: How to add some info fields for Customer and Supplier!?

2014-11-21T21:35:29Z

I meant for new installs for endusers. They would not have any backward compatibility issues.

A generic set of attributes in the sysprefs table may be okay for company wide variables but a per table field name / value pair in an attribute table (new) will be okay for now. The following fields:

Table name (without prefix),
Primary_Foreign_Key_Ref,
Attribute_Field_N,
Attribute_Field_N_Value,
Attribute_Value_jsons

An example record in it would be:

items
1
1
Short
{"Color":"blue", "Texture":"Soft"}

Re: How to add some info fields for Customer and Supplier!?

2014-11-21T21:21:38Z

It will not be backward compatible. This will have to wait to a major release.

Joe

Re: How to add some info fields for Customer and Supplier!?

2014-11-21T21:16:52Z

@joe: will extending tables with new nullable fields upset any insert/update sqls in FA?

Re: How to add some info fields for Customer and Supplier!?

2014-11-21T11:54:03Z

The first thing to check is if there are any fields you're not using. If there is a longer field (like "notes" or something), you might be able to shove all the numbers into that and parse them out when the report/invoice is created.

If that doesn't work, you need to extend the database. This can be done either by adding columns with ALTER TABLE or by creating a new table and linking it to the customer table.

Re: How to add some info fields for Customer and Supplier!?

2014-11-21T10:32:33Z

Customise reports in reporting/repXXX.php and place in your company path - hard code anything you need if it is constant.

How to add some info fields for Customer and Supplier!?

2014-11-21T00:51:54Z

In our country when you make an invoce, then if cilent is ABC you must print on invoice these info:
Business Number
Fiscal Number
Tax VAT Number.

How to create FIELDS for all of these info?

Please !!!