Search options (Page 200 of 247)

Please pass on the old customer import from csv module so that we can make it up-to-date. It does not seem to be available in the extensions repo.

On adding a customer through the FA Add Customer form the following SQLs are generated:

INSERT INTO `2_crm_persons` VALUES 
('2', 'Justin Zhou Lu', 'Justin Lu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0');

INSERT INTO `2_crm_contacts` VALUES 
  (3, '2', 'cust_branch', 'general', '2')
, (4, '2', 'customer', 'general', '2');

INSERT INTO `2_cust_branch` VALUES
 (2, '2', 'Justin Zhou Lu', 'Justin Lu', '', '1', '1', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', '', '0', 'Male', '0');

INSERT INTO `2_debtors_master` VALUES
 ('2', 'Justin Zhou Lu', 'Justin Lu', NULL, 'PQ453625N', 'USD', '1', '0', '0', '1', '4', '0', '0', '0', 'Male', '0');

Attached is what I understand to be the ERD between these tables (they are not fully depicted in the FA v2.3 ERD pdf).

Joe / Janusz - please explain if these relationships are correct with the 2_crm_contacts.type field enforcing some sort of filter.

There is no field for gender and CitizenID Number of the person in FA as of now.....GST / VAT Number field can be used for Citizen ID Number for now whilst gender can be placed in the Notes field but these land up in the 2_cust_branch and 2_debtors_master tables!

The id field of the 2_crm_contacts table does not seem to be referenced anywhere and is just used for uniqueness for view/edit purposes.

The cust_branch.branch_ref, debtors_master.debtor_ref and the crm_persons.name (and not the crm_persons.ref) are in the select boxes.

Hiding Menu Tabs might make sense. Otherwise, if you want to have an All-Journal system, then stop the other application files from being included and being invoked to be loaded in frontaccounting.php (comment out what is not needed in the following code snippet from the said file):

..
..
    include_once($path_to_root . '/applications/customers.php');
    include_once($path_to_root . '/applications/suppliers.php');
    include_once($path_to_root . '/applications/inventory.php');
    include_once($path_to_root . '/applications/manufacturing.php');
    include_once($path_to_root . '/applications/dimensions.php');
..
..
            $this->add_application(new customers_app());
            $this->add_application(new suppliers_app());
            $this->add_application(new inventory_app());
            $this->add_application(new manufacturing_app());
            $this->add_application(new dimensions_app());
....

any reason why person_id is a tinyblob?

Compare the Database backup schema with the CoA sql used and see what has changed and alter the db structure accordingly.

Be careful with any extensions used and their default data as well.

====
Google Translate:

Comparar el esquema de copia de seguridad de base de datos con el sql CoA utilizado y ver lo que ha cambiado y alterar la estructura db en consecuencia.

Tenga cuidado con las extensiones utilizadas y sus datos por defecto también.
====

The following new config variables have been introduced in FA v2.3.22:

    /* Show average costed values instead of fixed standard cost in report, Inventory Valuation Report */
    $use_costed_values = 0;    
    
    /* Print Item Images on Sales Quotations. Set to 1 if so. */
    $print_item_images_on_quote = 0;

    /* UTF-8 font for Business Graphics. Copy it to /reporting/fonts/ folder. */
    $UTF8_fontfile    = "FreeSans.ttf";

Attached is the changed filesset. No changes to DB.

What type of creditors are you referring to and what different kinds of "management" are you intending?

Joe / Janusz - this needs to be in the core. Thanks @cambell!

You might want to generate it with a timestamp if it is entirely random, but yes, it needs to be renamed manually for now.

I could not yet find a link on your website for it. Did you tag it properly? An explicit link in the forum would be nice.

A reboot of the Debian machine now shows:

# locale
LANG=
LANGUAGE=
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

And all works well!

The "Only Balances" Checkbox.

My GitHub Repo has been updated with the latest extensions.