Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training

Technical and Installation Discussions

Reply
Topic Options
MOSTER618
unidentified user
MOSTER618
Posts: 2
Registered: 03-31-2011
0
Accepted Solution

Can not link Work order to AR customer after upgrading 4.05 to 4.4

Options

03-31-2011 12:48 PM

It seems that the field SOCustNumber in WO1 was expanded to LEN=20 between versions 4.05 and 4.4.  After migrating the data I can not link the field SOCustNumber in WO1 to AR_Customer CustomerNo because the WO1 SOCustNumber field is padded with spaces and the AR table is not.  

 

Has anyone else come accross this??

Message 1 of 3 (84 Views)
 
Reply
Super Contributor
DFeller
Posts: 2,944
Registered: 10-28-2008
0

Re: Can not link Work order to AR customer after upgrading 4.05 to 4.4

Options

03-31-2011 01:16 PM

Is the ODBC DSN set up to skip trailing spaces?

 

Dawn

Sage Support Site (Requires Login)
Product Enhancement Request
Message 2 of 3 (80 Views)
 
Reply
MOSTER618
unidentified user
MOSTER618
Posts: 2
Registered: 03-31-2011
0

Re: Can not link Work order to AR customer after upgrading 4.05 to 4.4

Options

04-01-2011 06:04 AM

It is now. Thanks, you are awwwwsome.

Message 3 of 3 (58 Views)
 
Reply