FrontAccounting forum — Is it Possible to Display Supplier Reference in Supplier Statement?

Re: Is it Possible to Display Supplier Reference in Supplier Statement?

null@example.com (flpages) — Fri, 21 Aug 2020 04:05:43 +0000

add the 2 statement end of while loop. (after line 226)

      if ($show_balance)
     $total[3] = $total[0] - $total[1];
     
     // display ref. on 2nd line  
      $rep->NewLine();                      
      $rep->TextCol(1, 2,$trans['reference']);

Re: Is it Possible to Display Supplier Reference in Supplier Statement?

null@example.com (niyazofficial@gmail.com) — Thu, 20 Aug 2020 22:22:47 +0000

Thank you so much. Its done. Can I ask you. Is it possible to include both in report? System reference & Supplier reference together?

Re: Is it Possible to Display Supplier Reference in Supplier Statement?

null@example.com (flpages) — Thu, 20 Aug 2020 06:48:03 +0000

I think most users enter supplier invoice number in the supplier ref. field.
and usually supplier sent statement only include the invoice number,
for easier checking, It's good to include supplier ref in the Supplier Balances report (rep201.php)

If you know php, you can change the reporting/rep201.php in ver 2.4.8 is on line number 192
change $trans['reference'] to $trans['supp_reference']

        while ($trans=db_fetch($res))
        {
            if ($no_zeros && floatcmp(abs($trans['TotalAmount']), $trans['Allocated']) == 0) continue;
            $rep->NewLine(1, 2);
            $rep->TextCol(0, 1, $systypes_array[$trans['type']]);

Is it Possible to Display Supplier Reference in Supplier Statement?

null@example.com (niyazofficial@gmail.com) — Wed, 19 Aug 2020 18:59:13 +0000

When we type a Supplier Bill there is one system-generated number & another is Supplier's Ref.: .

When I take the Supplier Report, I want this Supplier's Ref.: include in the statement. May I know to which report I need to run?