Search options (Page 29 of 247)

Check if this was a server time zone issue at the time when you tried it. This is a very old thread. Hope you have all the post release fixes in your install. Also a latest change was reverted to await v2.5 but is in mt FA24Mods folder (2019-06-24).

@x-roast: Kindly share your workaround for peer review to ensure that you are on the right track.

@joe: An alert in both instances before acceptance stating the possible ambiguity may be in order.

Which version of MySQL / PHP are you using? Later versions of MySQL may prevent blank value for salesman not to be taken as NULL and may wrongly insist in a NOT NULL field definition (with a default of 0) and strict mode enabled in the MySQL settings.  See that there is atleast one entry in the "0_salesman" table and make sure that is chosen for the new company's default salesman.

CREATE TABLE `0_cust_branch` (
...
...
`salesman` int(11) NOT NULL DEFAULT '0',
...
...

Creation of the DB would require additional privileges that the FA's DB user should have atleast for the duration of the install. Use phpMyAdmin / SQLyog / MySQL Workbench or some such MySQL client tool or just operate from the hosting control panel or the SSH terminal if you have access. Otherwise contact your hosting provider.

What platform are you having your FA hosted (Webserver / PHP / MySQL / OS) and their versions and what privileges and skills you have in manipulating them? If you are handicapped in the above skills, then take professional assistance providing a bounty on the Job Offers board.

Check if the attachment is what you need.

@joe: if acceptable, it can be placed with a checkbox in the filter fields to achieve this feature.

Banking & GL => Trial Balance
already has the drill down to the account numbers of interest links.

What drill down are you expecting beyond this?

Yes. Check if there is enough space on the report's lines to accommodate it. A memo is unlimited for all practical purposes to be contained within the space available.

First, enable the availability of the long_description field in the function get_customer_trans_details in sales/includes/db/cust_trans_details_db.inc by inserting the following line as line 23:

        item.long_description As StockLongDescription,

** @joe: the above can be implemented now **

Then put in these lines at line 166 in reporting/rep107.php:

                $c--;
                $rep->TextColLines($c++, $c, $myrow2['StockLongDescription'], -2);

If you have your Arabic fonts correctly setup to print Arabic characters in reports, all should be well.

Without Arabic Reporting fonts, some testing snapshots are attached.

Logo of your firm can replace the file:

themes/default/images/logo_frontaccounting.png

Try to put in both languages in the name itself or alter the rep107.php accordingly.