Search options (Page 60 of 247)

Alternatively output the necessary lines to a separate file and use it.

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.

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

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

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.

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

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

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.

The setting is in the config.php file.

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.