2,326 Reply by apmuthu

(4 replies, posted in FA Modifications)

Stands corrected:
Line 146 in reporting/rep107.php:

               $result = get_customer_trans_details(ST_SALESINVOICE, $row['trans_no']);

gets the line items from the function (defined in sales/includes/db/cust_trans_details_db.inc) used above like:

SELECT line.*,
       line.unit_price+line.unit_tax AS FullUnitPrice,
       line.description AS StockDescription,
       item.units, item.mb_flag
FROM 1_debtor_trans_details line,1_stock_master item
WHERE (
       (debtor_trans_no=1) -- 1st Transaction in Demo Co
       AND debtor_trans_type=10 -- ST_SALESINVOICE
       AND item.stock_id=line.stock_id
)
ORDER BY id

This result having the invoice's line items are cycled through from lines 148 to 181 in reporting/rep107.php.

Go to forum: FA Modifications

2,327 Reply by apmuthu

(4 replies, posted in FA Modifications)

Lines 344 onwards in reporting/rep107.php cycle through the line items which is what you need to put into some javascripted set of tabs.

Go to forum: FA Modifications

2,328 Reply by apmuthu

(6 replies, posted in Setup)

The image links can have a title attribute for their "a" tag.

Go to forum: Setup

2,329 Reply by apmuthu

(24 replies, posted in Accounts Receivable)

It works okay in 2.4.3+.
The last significant changes to the file sales/create_recurrent_invoices.php that introduced the functions "calculate_from" and "calculate_next" were done between Apr and July 2015 and they compute correctly as per the wiki.

Attached are the screenshots of the Recurrent Sales Invoice Request Form, it's execution and the resultant Invoice generated.

Where in it do you face a problem?

Go to forum: Accounts Receivable

2,330 Reply by apmuthu

(19 replies, posted in Accounts Payable)

@joe, @itronics: any updates?

Go to forum: Accounts Payable

2,331 Reply by apmuthu

(2 replies, posted in Installation)

@joe: Thanks. Commit Link.

Go to forum: Installation

2,332 Reply by apmuthu

(55 replies, posted in Report Bugs here)

Since it was among the construct/destruct changes it was not obvious. Thanks for the reference Joe.

Go to forum: Report Bugs here

2,333 Reply by apmuthu

(1 replies, posted in Accounts Receivable)

The Customer Branch is set to be the charge to address. All non "cash only" direct invoices have the option to deliver from / to fields. There is a refresh issue with the direct invoice / sales order entry page is a non cash payment mode is chosen in one form and abandoned and then another is opened.

Go to forum: Accounts Receivable

2,334 Reply by apmuthu

(55 replies, posted in Report Bugs here)

Not yet.....

@joe: isn't it due?

Go to forum: Report Bugs here

2,335 Reply by apmuthu

(24 replies, posted in Accounts Receivable)

This was changed in FA 2.3.5 as stated in the wiki.

Go to forum: Accounts Receivable

2,336 Topic by apmuthu

(2 replies, posted in Installation)

The commit for allowing MariaDB uses an inline array reference on explode that is not accepted in PHP 5.3.1 and needs to be fixed as in the comment in it by replacing line 27 in includes/system_tests.inc:

    $test['result'] = $test['test']>='4.1' || explode('-', $test['test'])[1] == 'MariaDB';

with:

    if(!($test['result'] = ($test['test']>='4.1'))) {
        $db_str = explode('-', $test['test']);
        $test['result'] = ($db_str[1] == 'MariaDB');
    }

Go to forum: Installation

2,337 Reply by apmuthu

(7 replies, posted in Report Bugs here)

Clear the company/#/js_cache/*.js files and they will get re-created with the new preference settings on next login.

Go to forum: Report Bugs here

2,338 Reply by apmuthu

(67 replies, posted in Setup)

@itronics: make something generic wherever there is a reference that clashes with existing ones.

Go to forum: Setup

2,339 Reply by apmuthu

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

The demo does not seem to have it installed.
All methods are skeleton templates only.

Go to forum: Modules Add-on's

2,340 Reply by apmuthu

(3 replies, posted in Setup)

@itronics: That was a really involved fix indeed. The second if to test for a zip can be an elseif..... in admin/backups.php and a string somewhere to indicate that the file was successfully downloaded will complete it.

Go to forum: Setup

2,341 Reply by apmuthu

(67 replies, posted in Setup)

@itronics: Should this not be adjusted as you had done earlier and committed?

Go to forum: Setup

2,342 Reply by apmuthu

(1 replies, posted in Wish List)

Core functions are included first. Only extra functions come in from the themes. Overrides in the company folder override similar files in the core path. Hooks are sequentially activated and they are generally class methods. Custom themes too can partake of it's class methods to override the default ones.

Trying to upload a module is available using the pkg extension and the ar method of archiving that is similar to the .deb Debian packaging.

Allowing any other means of upload will cause security issues if not taken heed to in the program construct.

Go to forum: Wish List

2,343 Reply by apmuthu

(4 replies, posted in Translations)

I have the translated ones for FA 2.4.3 in the FA24extensions repo. Download and overwrite your .mo file

Go to forum: Translations

2,344 Reply by apmuthu

(5 replies, posted in Report Bugs here)

If your OS starts the MySQL server with the right default charset and collation and it matches that of the connection made from the php scripts, all should be well. This will affect both FA 2.3 and FA 2.4 as well.

Go to forum: Report Bugs here

2,345 Reply by apmuthu

(5 replies, posted in Report Bugs here)

This is specific to the mysqli_query execution where the connection handle is passed.

Go to forum: Report Bugs here

2,346 Reply by apmuthu

(9 replies, posted in Reporting)

Compare the php.ini files and the apache conf files.

Go to forum: Reporting

2,347 Reply by apmuthu

(5 replies, posted in Report Bugs here)

Make sure that the default / current session / connection are all of the same charset.
Check on the values of the concerned MySQL variables.

Go to forum: Report Bugs here

2,348 Reply by apmuthu

(9 replies, posted in Reporting)

Make sure you have the appropriate font in the reporting/fonts folder.

Go to forum: Reporting

2,349 Topic by apmuthu

(3 replies, posted in Setup)

When a backup is created and an attempt is made to download the backed-up file which downloads successfully, the spinner at the top keeps spinning and there is no message to state that the download was successful.

When a backed-up file is attempted to be viewed, there is no sql file extraction on archived backups before a view is attempted. If there is no intention of doing it for some reason, then a filter should be made before an attempt to allow a view like:

        if (!preg_match("/\.sql$/", $fname))
            display_error(_("You can only view *.sql backup files"));
        else {
..
..

in admin/backups.php file.

Go to forum: Setup

2,350 Reply by apmuthu

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

By end user I mean those who install, maintain and use FrontAccounting by themselves with the Slim API, not the FA application operatives using what someone else installs and maintains.

What is wrong with line 6 of index,php? Just a plain include of all php files in the src folder so that any function in any endpoint can use it. I am planning on working on it to make sure that native FA functions are used for the most part. It works for me.

If there is anyone for whom the code does not work, please let me know - I'd like to know why and will do what needs to be done. I am keeping it as backward compatible as is possible so that those on older PHP versions too can still keep their installs whilst leveraging the REST API.

If you put in some test access values in util.php, you can easily browse to say: http://localhost/fa24/modules/api24/category/1

I've been packaging the original submission from Andres Amaya Diaz for FA 2.3 and worked on it while it was being hammered out. You check the wiki history and the original threads too.

Go to forum: Modules Add-on's