Topic Options
#52843 - 03/02/17 11:27 AM Field Length
Ilona Wallace Offline
Zoo Keeper

Registered: 07/14/09
Posts: 14
Loc: Ontario Canada
One of the retailers we deal with is implementing changes to their systems and we will be required to use their new 7 digit "ship to" codes.

Adagio only deals with 6 and I was wondering if there will ever be changes made to the field lengths. This may become more of an issue in future as other large retailers move over to SAP. For the time being we'll have to work around this problem.

Just food for thought when possible software changes are being looked at.
Thank you,
Ilona Wallace
Farleyco Marketing Inc.
_________________________
Ilona Wallace
Farleyco Marketing Inc.

Top
#52845 - 03/02/17 11:30 AM Re: Field Length [Re: Ilona Wallace]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
You can store their 7 digit codes in one of the contact information fields in your ship-to record.
_________________________
Andrew Bates

Top
#52863 - 03/03/17 08:01 AM Re: Field Length [Re: Retired_Guy]
Ilona Wallace Offline
Zoo Keeper

Registered: 07/14/09
Posts: 14
Loc: Ontario Canada
I knew that, but it would be good if the "ship to" field actually matched our customer's "ship to" field. I've created a Gridview "Customer w/Ship to" report so hopefully I'll be able to add the contact field to the report (haven't checked into this yet). This way we can cross-reference our system's ship to codes with McKesson's.

Thanks Andrew
_________________________
Ilona Wallace
Farleyco Marketing Inc.

Top
#57550 - 05/23/18 09:25 AM Re: Field Length [Re: Ilona Wallace]
Chris_Smith Offline
Adagio Groupie

Registered: 10/30/14
Posts: 15
Loc: Florida
Hello,

I am running into a related issue with the item# field being limited to 16 digits. Some of the items I sell are modular, so the part number consists of multiple components each with their own 5-6 digit number with a total field length of 20+ digits. My current work around is to use a general description as the item number and the put the item number in the description. This doesn't work well for tracking inventory obviously so I'm hoping for a more permanent fix.

Thank you,
Chris Smith

Top
#57555 - 05/23/18 09:59 AM Re: Field Length [Re: Chris_Smith]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi, Chris,

I've added your suggestion to R&D. Question: 20+? What does this mean exactly? 22? 25?

Let us know please.
_________________________
Regards,
Softrak Tech Support

Top
#62389 - 11/27/19 09:02 AM Re: Field Length [Re: Softrak Support]
Chris_Smith Offline
Adagio Groupie

Registered: 10/30/14
Posts: 15
Loc: Florida
Hello,

Currently my longest part# is 23 digits. Sorry for not following up on this when you originally asked!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30