Hi all.
I have a situation where we have item numbers like so.
12-34-5678.
The customer would like them stored in the database as 12345678, but displayed (on item cards, invoices, etc.) as 12-34-5678, if possible.
If necessary, they could be displayed internally as 12345678 but show up on invoices as 12-34-5678.
I have been told that this can't be done.
Does anybody disagree, and if so, how can it be done?
Thanks.
0
Comments
However, you would have to customize many tables, forms and reports, thus the effort is absolutely not small.
it stores the stripped number, we have a part for example 5-4-37
it is stored in the no2 field as 5437
then I can put the appropriate field on the reports that need it.
We also set up an item cross refernce for both numbers
5437 and 5-4-37 so that we can look up the part using either number on sales orders, purchase orders ect. so we enter the cross reference field on the sales order and it brings up the appopriate part number
I added a key to the item table for the no2 field. so user can set there own preference on how they look up numbers, on the item list if they like to use the no2 field sort by that and can quickly search on it. and other who like the whole number can use the regular no. field.
In our case, we print out the whole part number, so we didn't change any reports, and no special programming was needed. since the no2 field is a standard field, just doesn't show up on the form by default.
http://www.BiloBeauty.com
http://www.autismspeaks.org
In using the No2 field, does that mean whenever you set up a new item, you need to enter the No, the No2 and the cross-reference, or do you have some way of automating this?
I don't have access to the cal code on tables or forms, so I use a non-printing report that filters on the item table and a blank no2 field. it runs and creates the cross references, and another report creates the no2 field. I run it from the job scheduler. so users think it is automatic.
you can use something like this to strip the characters you don't want out
STR:=DELCHR(Item.no,'=','/','-');
other users here can probably give you the exact code to use.
OnInsert or the item table or
Also to auto add into a different table. This is how we add UPC Codes scanned into the item card to an associated table called AltUPC table Using INSERT.
In your case you will fill in the fields needed in the Cross Reference Table and put the code on the OnValidate of the item table.
http://www.BiloBeauty.com
http://www.autismspeaks.org