Page 1 of 1

Serial Numbers within Orderlines not found

PostPosted: Tue May 11, 2010 3:10 am
by Charley
Hi,
we have Accounting Solution in FM11. On each Invoice (Table A) are most of the time more than one Invoiceline (Table B) where we place a Product (Table C).

We edit the calculated Description Field and add a Serial Number of the Product we want to sell.

For Example
After we choosed the Product
BP-01820, PEE:BA-DC-32CH
BrainAmp DC 32-Channel single amplifier


Then We add
BP-01820, PEE:BA-DC-32CH
BrainAmp DC 32-Channel single amplifier
AMP10041223


And now you might guess what we need to search for :)

We find the Record when we type in the Serial Number from the beginning like:

AMP1004 -> we get back every Order with a Product starting with AMP1004

OK. But. Most of the time we like to start backwards withe last 3 digits.

But if a look for *1223 i get nothing or completly wrong results.

Maybe someone has a idea?

Br
Charley

PostPosted: Wed May 12, 2010 2:57 pm
by John Sindelar
Interesting problem.

So what's happening is that fmSearchResults sees *1223 and, there being no letters in the search request, only searches the fields you've tagged as integer fields on your Table0X layouts.

So one fix is to add a new integer field to the search Table0X layout for the table in question and point it to this Description field. Give it an object name like "number02" (without the quotes).

You could also create a field that held just the last 4 digits of this serial number, add it as an integer to your search layout (your Table0X layout) and search on that without the *

In both cases, FMSR will search your text fields when you search for AMP10041223 and your number fields when you search for *1223

PostPosted: Mon May 17, 2010 12:37 am
by Guest
Thank you.

Adding the Description Field as an Interger Field on my TableXX worked fine.
:D