FA has plugin extensions capability. All extensions are loaded in from the Default Company and can be activated for any or all of the companies in that FA instance.

A list of extensions are in my repo. All official extensions are available for installation from within the default Company login in FA in the Setup tab.

In your case, you will need to make an extension for your workflow or have someone make it for you by posting a bounty in the Job Offers board.

Search the Wiki and the Forum before posting though.

This is more of a logistics requirement for delivery bunching.
An extension is in order.

1,403

(26 replies, posted in Reporting)

Yes, they are part of the Advanced PHP debugger.

1,404

(29 replies, posted in Installation)

The file you listed is in the webroot. There is no use in making 'active => true'. There is another installed_extensions.php in each company/# folder in which the active modules will have 'active' => 1,.

1,405

(26 replies, posted in Reporting)

@joe: Line 186 in admin/db/maintenance_db.inc can be preceded with:

if (!(is_array($db_connections)) $db_connections = array($db_connections);

1,406

(17 replies, posted in Modules Add-on's)

Contact host provider to allow php.ini overrides in scripts.

Can actually revert the whole commit and introduce the indices stated in my commit and commented in the original commit..

1,408

(17 replies, posted in Modules Add-on's)

Now this is a question of your "session / php.ini / file permission" settings on your linux server that prevents overriding ini parameter values inside the php code.

The issue here is that the alias of the table in addressing the field may be required in some MySQL versions. Therefore the field "account" referred to in the existing sql was sought by you to be replaced by "trans.account" which is okay. The NULL check is still retained.

Since the gl_trans is declared with an alias trans it might be necessary for some MySQL versions to use it as in:

        .($account == null ? '' : " AND trans.account=".db_escape($account))

1,411

(17 replies, posted in Modules Add-on's)

Try to insert the following php code as the first code in the helloworld.php file after the php opening tag:

$path_to_root="../..";

This may be a problem with your specific version of PHP and/or platform for scope and visibility.

What versions of PHP/MySQL/Apache (or other WebServer) and platform (Linux/Windows) are you using?

PHP 5.3.1 on Windows XP SP3 running XAMPP 1.7.3 has it's output on localhost attached and working.

Note that array element inline addressing is available in later versions of PHP only.

The function get_balance() is defined from Line 316 of gl/includes/db/gl_db_trans.inc and it;s prototype is:

function get_balance($account, $dimension, $dimension2, $from, $to, $from_incl=true, $to_incl=true) 

The computed data fields available are: credit, debit and balance.

Note that this file has had a commit recently and you may need to update it accordingly.

1,413

(17 replies, posted in Modules Add-on's)

It appears that you are using an old version of the hello_world extension.

The rep704 can be improved by allocating the Dimensions space for the first and Supplier Name columns when no Dimension is chosen for the report.

How does the current commit get supplier_id stored now? It has only removed the redundancy available in lines 149-150 in gl/includes/db/gl_db_trans.inc.

Negative entries in gl_trans table for [trans_]type=20 (ST_SUPPINVOICE) have always had their person_id populated in it. The [trans_]type=25 (ST_SUPPRECEIVE) still do not populate the person_id field in it. The INSERT statement in line 48 allows such population based on a NOT NULL check of $person_type_id in lines 51 and 61 of gl/includes/db/gl_db_trans.inc. Also must such purchase GRNs have such an entry here at all? Only invoices (10, 20) and payments (12, 22) for sales and purchases need and have it.

Choose your Account Receivable using some other function/query and then use the get_balance() function with that value instead of 1065.

This commit can also be backported to FA 2.3.x as well by those on that branch still.

This was already so in FA v2.3.x which needs no correction. This error in the FA 2.4.x branch crept in sometime around 2015-03-25.

Since the FA project devs chose to merge the FA 2.4 with FA 2.3 master instead of making the FA 2.4 as the master and keeping the FA 2.3 master as just the FA 2.3 branch, such comparisons cannot be made in the official FA GitHub repo to pinpoint the commit.

Probably does not have the opening balances.....

The Balance Sheet Drilldown page does what you want.
Also the General Ledger Enquiry too provides the single ledger folio.

Attached is a sample screenshot and the tb summary file for your reference.

The name2 gets populated only from second contact for customer/branch onwards. The first contect for each customer/supplier is assumed to be the entity itself.

Alternatively output the necessary lines to a separate file and use it.

Edit by commenting out the inner loop echo statements in gl/inquiry/gl_trial_balance.php.

Checkout the lines 171 to 182 in reporting/rep112.php:

            $rep->TextCol(6, 7, _("Received / Sign"), - 2);
            $rep->NewLine();
            $rep->TextCol(0, 2, _("By Cash / Cheque* / Draft No."), - 2);
            $rep->TextCol(2, 4, "______________________________", - 2);
            $rep->TextCol(4, 5, _("Dated"), - 2);
            $rep->TextCol(5, 6, "__________________", - 2);
            $rep->NewLine(1);
            $rep->TextCol(0, 2, _("Drawn on Bank"), - 2);
            $rep->TextCol(2, 4, "______________________________", - 2);
            $rep->TextCol(4, 5, _("Branch"), - 2);
            $rep->TextCol(5, 6, "__________________", - 2);
            $rep->TextCol(6, 7, "__________________");

The "_()" are the gettext translatable strings that may be hardcoded if you want or change them in your language's .po file and compile into a .mo file and use.

Hope you are using the Git Master code that has a lot of fixes included.