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

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

2020-08-21T04:05:43Z

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?

2020-08-20T22:22:47Z

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?

2020-08-20T06:48:03Z

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?

2020-08-19T18:59:13Z

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?