Database Field Sizes.

May 08, 2008 2 Replies
R

I have two small problems, firstly Can the Matrix Description field size be increased to 40/60 chars at present too small. or is there a bigger field i can use eg the extended description field size increased.



We need a way that when a saleperson inputs a sale order at the POS and the item needs to be special order the following information is automatically passed to the purchased order for the supplier.



1, supplier Ref number for item.
2, Supplier Colour (four suppliers have 56 colours each)
3, Size of Dress etc
4, delivery date required
5, Order confirmation date and number from supplier
6, Brides Name and Wedding date. Any help would be great.

Regards Ray Williams


Vote
Twitter Facebook LinkedIn
C

You can expand the size of field via sql query, but you can't change the db type.. the extended description is a ntext field, the description is only a nvarchar field ...

If you use also headquarter, you need to change the size in all databases ..

this is possible only with a customization..

cod

Vote
Twitter Facebook LinkedIn
R

One important thing to know though Ray, is that changing field sizes can have some bizarre side effects in RMS. We worked with a client to change the size of the Item Lookup Field in RMS and though manager know the field size had been updated, the items no longer rang up properly at the POS. I would suggest test any changes you make THOROUGHLY!! And backup the databases before you make any changes to live data.

As for your 2nd item, we have recently developed a Special Order add in that will do this, but may need a bit of tweaking for your specific scenario. If you are at all interested please give me a call or drop me an email.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required