FrontAccounting forum — Solved: Supplier ID in Rep 201 and 205

Re: Solved: Supplier ID in Rep 201 and 205

null@example.com (Alaa) — Tue, 23 May 2017 19:32:59 +0000

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

Re: Solved: Supplier ID in Rep 201 and 205

null@example.com (Alaa) — Tue, 23 May 2017 19:19:18 +0000

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

Re: Solved: Supplier ID in Rep 201 and 205

null@example.com (apmuthu) — Tue, 23 May 2017 18:04:06 +0000

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.

Re: Solved: Supplier ID in Rep 201 and 205

null@example.com (Alaa) — Tue, 23 May 2017 17:11:02 +0000

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

Re: Solved: Supplier ID in Rep 201 and 205

null@example.com (apmuthu) — Tue, 23 May 2017 16:34:07 +0000

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

Solved: Supplier ID in Rep 201 and 205

null@example.com (Alaa) — Tue, 23 May 2017 10:59:23 +0000

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.