Welcome, Guest. Please Login.
05/08/25 at 17:19:01
News:
Home Help Search Login


Pages: 1
Send Topic Print
Alphanumeric Fields (Read 463 times)
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Alphanumeric Fields
05/30/14 at 07:27:08
 
On several report we use the Job Number as a filter.
In our case the job number is use to define a Division.
 
Example P stand for "Products Division"
In order to print all Purchase Orders, per example, of that division we use
 
P0000000000000000
to
PZZZZZZZZZZZZZZ
 
That will covert
P001
P999
PHOLD
PSTOCK
 
We have notice that the PO-I-A does not show all Open Purchase Orders,
Could it be because the way we use the Job Number Field to filter?
 
embarrassed
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Alphanumeric Fields
Reply #1 - 05/30/14 at 08:32:20
 
I just got an answer from Lynn
 
The proper use would be
P
to
PZZZZZZZZZZZZZZZZ
 
 
 embarrassed
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print