FrontAccounting forum — Search by Branch

Re: Search by Branch

null@example.com (apmuthu) — Tue, 30 Jun 2015 11:20:02 +0000

Make the Aircraft as the Customer and the Contact Person as the Real Customer to be billed. Better still, make the Aircraft RegNo and the Customer Name concatenated into being the FA Customer.

If you wish to mine the branch table, use, phpMyEdit.org / Adminer.org or some such CRUD program for a quick and effective job.

Re: Search by Branch

null@example.com (janus) — Mon, 29 Jun 2015 09:34:47 +0000

Hi chrisklinger

I saw this query and was wondering if you managed to overcome the challenge with regards to searching a "branch" only.

Let me know please.

Re: Search by Branch

null@example.com (chrisklinger) — Wed, 12 Feb 2014 14:12:30 +0000

Apmuthu - I see where this could be used, but it is quite cumbersome; would be quicker to make a spreadsheet with all customers/branches.

I suppose I could write a short php script to mine the mySQL tables directly.

Thank you for the input.

Re: Search by Branch

null@example.com (apmuthu) — Wed, 12 Feb 2014 04:41:24 +0000

Would References, Dimensions and / or Tags do?

Search by Branch

null@example.com (chrisklinger) — Thu, 30 Jan 2014 17:43:02 +0000

I would like to be able to search by branch when I don't know who the customer is.

I maintain aircraft, and each registration number is a branch; a customer may have several aircraft. Often, I can't recall what the customer name is, though I know the branch name (simply by looking at the airplane in the hangar).

Can this be done?

TIA

Chris