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

Re: Solved: Supplier ID in Rep 201 and 205

2017-05-23T19:32:59Z

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

2017-05-23T19:19:18Z

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

2017-05-23T18:04:06Z

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

2017-05-23T17:11:02Z

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

2017-05-23T16:34:07Z

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

2017-05-23T10:59:23Z

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.