FrontAccounting forum — Repeating line items block inside single invoice page

Re: Repeating line items block inside single invoice page

null@example.com (apmuthu) — Sat, 09 Dec 2017 02:09:24 +0000

Stands corrected:
Line 146 in reporting/rep107.php:

               $result = get_customer_trans_details(ST_SALESINVOICE, $row['trans_no']);

gets the line items from the function (defined in sales/includes/db/cust_trans_details_db.inc) used above like:

SELECT line.*,
       line.unit_price+line.unit_tax AS FullUnitPrice,
       line.description AS StockDescription,
       item.units, item.mb_flag
FROM 1_debtor_trans_details line,1_stock_master item
WHERE (
       (debtor_trans_no=1) -- 1st Transaction in Demo Co
       AND debtor_trans_type=10 -- ST_SALESINVOICE
       AND item.stock_id=line.stock_id
)
ORDER BY id

This result having the invoice's line items are cycled through from lines 148 to 181 in reporting/rep107.php.

Re: Repeating line items block inside single invoice page

null@example.com (zi) — Fri, 08 Dec 2017 17:44:53 +0000

apmuthu wrote:

Lines 344 onwards in reporting/rep107.php cycle through the line items which is what you need to put into some javascripted set of tabs.

Did u mean L144?

Also it is pdf invoice which I am referring to.

Re: Repeating line items block inside single invoice page

null@example.com (kvvaradha) — Fri, 08 Dec 2017 12:40:36 +0000

may be the query has duplicates, try to run the query separately on direct phpmyadmin or mysql workbench to check the results.

Re: Repeating line items block inside single invoice page

null@example.com (apmuthu) — Thu, 07 Dec 2017 09:28:44 +0000

Lines ~~344 onwards~~ in reporting/rep107.php cycle through the line items which is what you need to put into some javascripted set of tabs.

Repeating line items block inside single invoice page

null@example.com (zi) — Thu, 07 Dec 2017 05:12:20 +0000

I am trying to print invoice as multiple leaves on single page, I am able to create a block by hit and trial already, but it seems I can't find out how to control/duplicate the line items into 2nd and 3rd block.

https://monosnap.com/file/ibnktD6fedx1H … hylnWhUMbP

Can some one point me in right direction?