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

What drill down are you expecting beyond this?

@joe: Can update the sys_prefs data in the default chart sqls with:

,('long_description_invoice', 'setup.company', 'tinyint', '1', '0')

Also, see if the attached patch for reporting/rep107.php can be incorporated.

703

(1 replies, posted in Reporting)

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.

@rafat: Thanks for the feedback. Hence no utf8_encode() was necessary if the necessary fonts are installed and called upon.

@joe: This can be implemented in the core for 2 line item in invoice with a SysPrefs flag for a company-wise choice.

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.

When transactions are entered out of order in a single day or when supporting documents come it, this might be a use case scenario for negative balances.

Logo of your firm can replace the file:

themes/default/images/logo_frontaccounting.png

@joe: need this fix?

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

Very nicely done. Keep up the good work.

No one seems to indicate if they are accountants!

712

(2 replies, posted in Setup)

And read this post.

@joe can this be included into the core with a Company Setup flag in sysprefs table?

714

(22 replies, posted in Setup)

Updated Wiki.

Account Types appears in the bank_accounts table and in the menu Banking & GL => Bank Accounts and has the following values / choices:

0 => Savings Account
1 => Chequing Account
2 => Credit Account
3 => Cash Account

Expect these functionalities and choices to be hard coded in the php scripts. How do we use it to summarise them?

The wiki entry asks to allocate a single GL account to many Bank Entries at:
https://frontaccounting.com/fawiki/index.php?n=Help.BankAccounts

Also there is very little info on Account Tags in the wiki. at:
https://frontaccounting.com/fawiki/index.php?n=Help.AccountTags

@joe: The recurring invoice template can have a flag (sysprefs?) to pass on the dimension parameter to subsequent invoices generated.

717

(22 replies, posted in Setup)

@joe: Need to refurbish the end of year routines to make sure that the client balances are automatically made along with unpaid and partially paid invoice data for allocation of payments in the subsequent year. This needs to be done for suppliers as well. The appropriate stock moves too need to be taken care of.

718

(1 replies, posted in Development)

NotePad++ does it.
https://stackoverflow.com/questions/11341660/change-eol-on-multiple-files-in-one-go

To convert line endings use unix2dos and dos2unix.

719

(15 replies, posted in Setup)

Sales => Sales Types
Choose to Include or Exclude Tax in prices.

Compare the sql/<chart>.sql used in InMotion hosting and the one in the sourceforge and inform softaculous / hosting provider of the discrepancy. Possible that the latter did not update their install scripts.

Thanks for reporting it.

721

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

Turn on debug in the config file and see what errors accrue.

Then why create subsidiary ledgers for them in the first place? If such a need is for reporting only, then write a custom one.

Petty cash is treated like a bank account in FA. That is why you will find it in the bank_accounts table (check using the standard Chart of Accounts with demo data).

724

(20 replies, posted in Report Bugs here)

The parenthesis should be added to the second condition as it is a fallback. First choice Output, then Input and last NULL.

Lines 464-465 of file gl/includes/db/gl_db_trans.inc:

        $reg_type = in_array($trans_type, array(ST_SUPPINVOICE, ST_SUPPCREDIT)) ? TR_OUTPUT
                : in_array($trans_type, array(ST_SALESINVOICE, ST_CUSTCREDIT)) ? TR_INPUT : null;

should be:

        $reg_type = in_array($trans_type, array(ST_SUPPINVOICE, ST_SUPPCREDIT)) ? TR_OUTPUT
                : (in_array($trans_type, array(ST_SALESINVOICE, ST_CUSTCREDIT)) ? TR_INPUT : null);

It is properly coded in line 86 of includes/JsHttpRequest.php.

@joe: can implement this and check for others.

The sql construct starting at line 107 refers to an alias: Demmand. Is it used and is the mis-spelling intended? The said column does not appear to be explicitly named anywhere in usage.

The only indexes worth creating are:

ALTER TABLE 0_sales_orders ADD INDEX FromStkLocIdx (from_stk_loc); 
ALTER TABLE 0_stock_master ADD INDEX MBFlagIdx (mb_flag); 

The function stock_demand_manufacture is recursive in nature to cycle through all BOMs that may have other BOMs as part of itself. Check that the BOMs do not have any parent entities as part of the downline.