There is a trial balance report that provides all the ledger balances.
1,426 11/19/2018 05:39:35 pm
Re: Grab Data of individual Accounts From Database (26 replies, posted in Banking and General Ledger)
1,427 11/19/2018 03:25:31 am
Re: Add input data check for Gl Setup (6 replies, posted in Report Bugs here)
A generic function encapsulating the error displayed and the checks may be in order. This may need to be done in a multitude of forms bloating the codebase otherwise.
@joe: There have been more than 50 commits since the last version release over 6 months ago - time for a another one with all translation strings as well?
1,428 11/18/2018 02:06:50 am
Re: Inactive modules even after activation (29 replies, posted in Installation)
Also check the contents of the installed_extensions.php in both the FA webroot and in the company folders.
1,429 11/18/2018 02:03:57 am
Re: Dimension not posted from Supplier Invoice/Credit Note GL Items (3 replies, posted in Report Bugs here)
Whilst it is not directly related, the fact is that dimensions and bank entries for Suppliers do not gel as of now in FA. This is possibly also related to another post where debit/credit note to suppliers needed a workaround. In FA 2.5, hopefully a few years from now (projecting from past experience) a more complete and predictable means would be in place. Payment allocation and possibly inventory tracking will be available only if supplier invoice gets created and the GRN is populated.
1,430 11/18/2018 02:00:08 am
Re: Printing Purchase Orders (3 replies, posted in Accounts Payable)
I am sure that whilst the thought did arise during the design, in most instances it is the last invoice that is chosen to be printed and hence the ease of choosing last invoice to last invoice was preferred. Furthermore, assuming that a large number of invoices existed, the dropdown would be tough to navigate. The only remnant of discord in such a sequence would be if there is a mixture of auto numbering and actual numbering interspersed.
1,431 11/17/2018 05:17:54 pm
Topic: PHP 7.2 gotchas (0 replies, posted in Installation)
Undocumented PHP 7.2 BC break:
https://bugs.php.net/bug.php?id=75682
http://php.net/manual/en/migration72.php
https://www.reddit.com/r/PHP/comments/82w04e/it_sucksphp72_count_break_bc/
1,432 11/17/2018 05:12:40 pm
Re: Dimension not posted from Supplier Invoice/Credit Note GL Items (3 replies, posted in Report Bugs here)
https://frontaccounting.com/punbb/viewtopic.php?id=7680
1,433 11/17/2018 04:35:56 pm
Re: Printing Purchase Orders (3 replies, posted in Accounts Payable)
Make sure the Ordering Sequence of the records is from the smaller / first to the bigger / last one.
1,434 11/16/2018 07:14:11 pm
Topic: Video Tutorials for FA on Spoken Tutorial site (0 replies, posted in Installation)
IIT Mumbai, India's Video Tutorials on FrontAccounting are now available in English, Gujarati, Malayalam from Spoken Tutorial site.
1,435 11/16/2018 07:09:20 pm
Re: Add Manual Language (3 replies, posted in Translations)
@ngicon: Added Translator for Bengali
1,436 11/16/2018 06:20:11 pm
Re: adding delivery date for each item in invoice (4 replies, posted in FA Modifications)
No need for extra field in any table.
Use the function get_customer_trans() in sales/includes/db/cust_trans_db.inc and use the trans_date field for the delivery date in your report. An example of the sql used in the said function is:
SET @TRANS_ID:=5;
SET @TRANS_TYPE=13; -- ST_CUSTDELIVERY
SELECT trans.*
, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total
, cust.name AS DebtorName
, cust.address
, cust.curr_code
, cust.tax_id
, trans.prep_amount>0 AS prepaid
, com.memo_
, shippers.shipper_name
, sales_types.sales_type
, sales_types.tax_included
, branch.*
, cust.discount
, tax_groups.name AS tax_group_name
, tax_groups.id AS tax_group_id
FROM 1_debtor_trans trans
LEFT JOIN 1_comments com ON trans.type=com.type AND trans.trans_no=com.id
LEFT JOIN 1_shippers shippers ON shippers.shipper_id=trans.ship_via
, 1_debtors_master cust
, 1_sales_types sales_types
, 1_cust_branch branch
, 1_tax_groups tax_groups
WHERE trans.trans_no=@TRANS_ID
AND trans.type=@TRANS_TYPE
AND trans.debtor_no=cust.debtor_no
AND sales_types.id = trans.tpe
AND branch.branch_code = trans.branch_code
AND branch.tax_group_id = tax_groups.id
1,437 11/13/2018 03:24:17 pm
Re: Revaluation amount is getting posted wrongly (9 replies, posted in Banking and General Ledger)
This appears correct as it is a single account that has Gain and Loss in it and the Gain is a Credit in it.
@joe: any changes needed here?
1,438 11/13/2018 03:20:53 pm
Re: Request inclusion of Hindi and Tamil in the Installation Wizard (2 replies, posted in Translations)
Latest Hindi and Tamil inclusions for the install wizard are in the GitHub Master and the session file is at:
https://github.com/FrontAccountingERP/FA/blob/master/install/isession.inc
see lines 112 and 121.
Any updates to the install wizard will be in my repo's FA24Mods at https://github.com/apmuthu/frontac24/tree/master/FA24Mods/install
Further po translations are on Transifex.
1,439 11/11/2018 04:56:18 pm
Re: Config Setup Options (10 replies, posted in Setup)
Can also PM me. Try posting your requirements on the Job board.
1,440 11/11/2018 06:02:22 am
Re: How can i implement logical Taxes (7 replies, posted in Setup)
The setting is in the config.php file.
1,441 11/11/2018 06:01:17 am
Re: Import Items CSV in FA 2.4.4 (5 replies, posted in Report Bugs here)
Thanks for the feedback.
1,442 11/11/2018 05:59:28 am
Re: Check Printing (Canada) not showing up on Purchaser Reports in 2.4.2 (9 replies, posted in Modules Add-on's)
The said function is present in the USA version of Tom Hallman extension present here and it's latest version is attached herewith.
Please note the spelling of check (USA) and cheque (Canada) in the extension and install what is appropriate for you.
1,443 11/11/2018 05:53:07 am
Re: Updated FA with Update modules (3 replies, posted in Report Bugs here)
You may first update your March 18 version with the latest git master changed files in the Announcement thread.
1,444 11/07/2018 04:25:56 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
Download it here.
1,445 11/07/2018 04:19:47 pm
Re: Where can I find Financial position - Cash flow - Statement of income (1 replies, posted in Reporting)
Read the Wiki and use the extensions.
1,446 11/07/2018 04:16:42 pm
Re: Updated FA with Update modules (3 replies, posted in Report Bugs here)
Which version of FA are you using and which version are you upgrading to?
If you installed modules in FA 2.3.x and have now upgraded to FA v2.4.x, and if they used any extra tables, you will have to carefully manually upgrade them.
1,447 11/07/2018 04:14:42 pm
Re: Check Printing (Canada) not showing up on Purchaser Reports in 2.4.2 (9 replies, posted in Modules Add-on's)
This module is for Canadian Cheque Printing. Take the latest code from my unofficial repo.
1,448 11/06/2018 05:02:11 pm
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
Change line 56 of modules/repgen/includes/repgen_def.inc from
unset $protocol;
to
unset($protocol);
Maybe your PHP version is very strict.....
1,449 11/06/2018 04:57:49 pm
Re: Fiscal year error on every transaction (11 replies, posted in Report Bugs here)
Changing the fiscal id will need to be reflected in some other tables as well.
1,450 11/06/2018 04:54:32 pm
Re: Automatic Creation of Transaction Reference Number (2 replies, posted in Banking and General Ledger)
Known Issue:
https://frontaccounting.com/punbb/viewtopic.php?id=6036
https://frontaccounting.com/punbb/viewtopic.php?id=7651
Check the Wiki for workarounds.