Looking for a SOP Field to use

[Borvik]

I'm looking for an SOP Field I can use to store an email address for an SOP Document.

The comment field is out - as that is already widely used.
The User Defined fields are out - as they only hold 21 characters.

Basically this field is going to be imported by our shipping computer to automatically setup delivery notifications with our shipper.

Any thoughts?

 

[VictoriaYudin]

The only fields I can think of that are not typically used for anything are the GPSFOINTEGRATIONID and INTEGRATIONID in SOP10100, but they are both only 31 characters, which may still be too short. If this is all going to happen with imports and automation (in other words, the users never need to see or edit this field) then I would simply create my own table linking on the SOPTYPE and SOPNUMBE to SOP10100 and store the e-mail in there. If you need to interact with this field in the UI, perhaps using Extender is the best way to do it?

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[Borvik]

Yes the users will need to maintain this field. It's the shipping software that will be automatically using this field.

Though I will be semi-automating which ever field is chosen - it would be nice to be able to hijack an existing field.

If I need to I can create a new field by way of a 3rd party addon (Dexterity rather than Extender) - I was just hoping to avoid that.

 

[VictoriaYudin]

Gotcha,

Yes, I would prefer to use Dex for this also, if given the choice. It the length of the field that's really causing the issue here unfortunately.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[Borvik]

Yea, thanks for the response.