Search options (Page 135 of 246)

Pass a single journal voucher to contra all supplier and customer balances (preferably as of the last date of the previous financial year) like for example for a single supplier:

By Supplier 1 Cr $1200 (mock payment)
To Suspense (or Cash) Dr $1200 (mock receipt)
# Allocate above payment to outstanding Supplier Invoice
By Suspense (or Cash) Cr.  $1200 (mock refund)
To Supplier 1 Dr $1200 (mock refund receipt)

Yes by using mock payments and contra journal entries on account.

Just edit the 1002 gms mango as 1000gms real mango and 2gms of "wastage" that you forgo.... or alternatively order for 1002gms mango and provide a 2gm "discount" for writeoff.

If you do not intend to track Supplier Invoices at all (and also not bother to enter them with individual line items as you do not want inventory), just pass journal vouchers for the Supplier invoice gross totals and make payments directly into the supplier accounts and use the general ledger to track account summary balances for the suppliers.

If you have the .mo file, use msgunfmt to extract back the .po file.

On further investigation, it appears that the logo width, if too high only results in truncation of image when displayed in the report header.

Some sort of cache may be playing havoc.

The solution is to
1. upload some other Company logo (Setup -> Company Setup) and update the company and then
2. revert back to the original logo and update the company and then
3. print range of invoices

Attached is a set of logos of varying widths and the way they get displayed in the Invoice header.

It is imperative for the stock_id field to be indexed in the debtor_trans_details table for all FA databases used with the equivalent of:

ALTER TABLE `0_debtor_trans_details` ADD INDEX `stock_trans` (`stock_id`);

The function get_customer_trans_details() in the file sales/icludes/db/cust_trans_details_db.inc is used in reporting/rep107.php (and in 110, 113 reports as well) to acquire the transaction list filtered as appropriate. The non filtered SQL in it is:

SELECT trans.*,
       trans.unit_price + trans.unit_tax AS FullUnitPrice,
       trans.description AS StockDescription,
       stock.units,
       stock.mb_flag
FROM 0_debtor_trans_details trans
        INNER JOIN 0_stock_master stock USING (stock_id)
ORDER BY id;

As the stock_master.stock_id and debtor_trans_details.id fields are primary keys, they stand already indexed. Hence the foreign key debtor_trans_details.stock_id is the one that is left to be indexed as it is the INNER JOIN field.

The said function can be modified to be:

function get_customer_trans_details($debtor_trans_type, $debtor_trans_no)
{
    if (!is_array($debtor_trans_no))
        $debtor_trans_no = array( 0=>$debtor_trans_no );
    $sql = "SELECT trans.*,
        trans.unit_price + trans.unit_tax AS FullUnitPrice,
        trans.description As StockDescription,
        stock.units, stock.mb_flag
        FROM ".TB_PREF."debtor_trans_details trans
             INNER JOIN ".TB_PREF."stock_master stock USING (stock_id)
         WHERE (";

    $tr=array();
    foreach ($debtor_trans_no as $trans_no)
        $tr[] = 'debtor_trans_no='.db_escape($trans_no);
    $sql .= implode(' OR ', $tr);

    $sql.=    ") AND debtor_trans_type=".db_escape($debtor_trans_type)."
        ORDER BY id";
    return db_query($sql, "The debtor transaction detail could not be queried");
}

@joe: want to include it in the core? Committed in my FAMods.

I can confirm that even after this, when a range of invoices is attempted to be printed, the webserver hangs. Single invoice printing works. Multi Invoice (range) printing fails at second invoice call of function get_sales_parent_lines() in file sales/includes/sales_db.inc.
In the first invoice call in the Training Co (Demo Co) it succeeds:

SELECT parent.*
FROM 1_debtor_trans_details parent
    LEFT JOIN 0_debtor_trans_details trans 
        ON trans.src_id=parent.id
WHERE trans.debtor_trans_type='10' 
  AND trans.debtor_trans_no='17' 
GROUP BY parent.debtor_trans_no 
ORDER BY parent.debtor_trans_no;

SQL SELECT debug Trail attached.

Web Server hangs when the statement $rep->NewPage() tries to get executed for the second page in rep107.php - tested in XAMPP v1.7.3 on WinXP SP3 / FireFox v37.0.

msgmerge ar_EG-2.4.0-2.po empty.po > ar_EG_new.po

Now translate the merged .po into a .mo file and use it.

Edit the .po file by comparing it with the empty.po file and put in the missing strings and then compile it with PoEdit (atleast in Windows) to a .mo file and use it instead of the existing one for your language.

It is the .mo file that is used by the php gettext function. If moving the .po has solved your problem, then it is the lack of gettext functionality that caused the graceful degrade to gettext.php file where an array of translated strings would come in. File ownership may have been the issue otherwise but since 777 did not work that is ruled out.

There are some minor issues you will come across on such upgradation.

Release Date: 2008-09-19
https://sourceforge.net/projects/tcpdf/files/OldFiles/tcpdf_4_0_027.zip
https://sourceforge.net/projects/tcpdf/files/OldFiles/tcpdf_4_0_027_php4.zip

The latest in that series was released on 2008-10-13:
https://sourceforge.net/projects/tcpdf/files/OldFiles/tcpdf_4_0_033.zip
https://sourceforge.net/projects/tcpdf/files/OldFiles/tcpdf_4_0_033_php4.zip

All these files are just under 9.5 MB.

Import and commit them (intervening versions as well) one by one into a local Git repo and see what changes occurred between successive versions and what breaks.