• From: Qatar, Doha
  • Registered: 08/17/2019
  • Posts: 29

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

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?

  • Registered: 04/19/2020
  • Posts: 60

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

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']]);

flpages's Website

  • From: Qatar, Doha
  • Registered: 08/17/2019
  • Posts: 29

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

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

  • Registered: 04/19/2020
  • Posts: 60

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

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']);

flpages's Website