1,476 Reply by apmuthu

(3 replies, posted in Accounts Receivable)

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.

Go to forum: Accounts Receivable

1,477 Reply by apmuthu

(2 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

1,478 Reply by apmuthu

(26 replies, posted in Banking and General Ledger)

There is a trial balance report that provides all the ledger balances.

Go to forum: Banking and General Ledger

1,479 Reply by apmuthu

(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?

Go to forum: Report Bugs here

1,480 Reply by apmuthu

(29 replies, posted in Installation)

Also check the contents of the installed_extensions.php in both the FA webroot and in the company folders.

Go to forum: Installation

1,481 Reply by apmuthu

(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.

Go to forum: Report Bugs here

1,482 Reply by apmuthu

(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.

Go to forum: Accounts Payable

1,483 Topic by apmuthu

(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/

Go to forum: Installation

1,484 Reply by apmuthu

(3 replies, posted in Report Bugs here)

https://frontaccounting.com/punbb/viewtopic.php?id=7680

Go to forum: Report Bugs here

1,485 Reply by apmuthu

(3 replies, posted in Accounts Payable)

Make sure the Ordering Sequence of the records is from the smaller / first to the bigger / last one.

Go to forum: Accounts Payable

1,486 Topic by apmuthu

(0 replies, posted in Installation)

IIT Mumbai, India's Video Tutorials on FrontAccounting are now available in English, Gujarati, Malayalam from Spoken Tutorial site.

Go to forum: Installation

1,487 Reply by apmuthu

(3 replies, posted in Translations)

@ngicon: Added Translator for Bengali

Go to forum: Translations

1,488 Reply by apmuthu

(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

Go to forum: FA Modifications

1,489 Reply by apmuthu

(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?

Go to forum: Banking and General Ledger

1,490 Reply by apmuthu

(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.

Go to forum: Translations

1,491 Reply by apmuthu

(10 replies, posted in Setup)

Can also PM me. Try posting your requirements on the Job board.

Go to forum: Setup

1,492 Reply by apmuthu

(7 replies, posted in Setup)

The setting is in the config.php file.

Go to forum: Setup

1,493 Reply by apmuthu

(5 replies, posted in Report Bugs here)

Thanks for the feedback.

Go to forum: Report Bugs here

1,494 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

1,495 Reply by apmuthu

(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.

Go to forum: Report Bugs here

1,496 Reply by apmuthu

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

Download it here.

Go to forum: Modules Add-on's

1,497 Reply by apmuthu

(1 replies, posted in Reporting)

Read the Wiki and use the extensions.

Go to forum: Reporting

1,498 Reply by apmuthu

(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.

Go to forum: Report Bugs here

1,499 Reply by apmuthu

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

This module is for Canadian Cheque Printing. Take the latest code from my unofficial repo.

Go to forum: Modules Add-on's

1,500 Reply by apmuthu

(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.....

Go to forum: Modules Add-on's