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

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

null@example.com (apmuthu) — Fri, 21 Nov 2014 21:35:29 +0000

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!?

null@example.com (joe) — Fri, 21 Nov 2014 21:21:38 +0000

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!?

null@example.com (apmuthu) — Fri, 21 Nov 2014 21:16:52 +0000

@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!?

null@example.com (tm) — Fri, 21 Nov 2014 11:54:03 +0000

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!?

null@example.com (apmuthu) — Fri, 21 Nov 2014 10:32:33 +0000

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!?

null@example.com (aRTx) — Fri, 21 Nov 2014 00:51:54 +0000

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 !!!