• Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Topic: Solved: Supplier ID in Rep 201 and 205

Hello,

When opening a new supplier account ..
i see this field "Our Customer No:"
Can we call this supplier ID ??
And how do we print it out in the Supplier Balances and Supplier Detail Listing?

Kind Regards.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Solved: Supplier ID in Rep 201 and 205

The "Our Customer No:" maps onto suppliers.supp_account_no field. This is the CustomerID allotted to us in the Suppliers' books of account.

apmuthu's Website

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Solved: Supplier ID in Rep 201 and 205

Is it possible to show the CustomerID in a new column just before the customer name column in report 201 and 205?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Solved: Supplier ID in Rep 201 and 205

Report 201: Suppliers Balance
Report 205: Supplier Detail Listing
You can concatenate the supp_account_no and supp_name fields (from the suppliers table) in the said reports in the place of supp_name alone.

apmuthu's Website

5 Reply by Alaa (edited by Alaa 05/23/2017 07:20:42 pm)

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Solved: Supplier ID in Rep 201 and 205

Concat is like joining 2 tables ?
somthing like this ?
SELECT CONCAT('supp_account_no','.','supp_name');

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Solved: Supplier ID in Rep 201 and 205

This seems to be working
$sql = "SELECT supplier_id, CONCAT(supp_account_no, ' ' , supp_name) AS name, curr_code FROM ".TB_PREF."suppliers";