Sage 100

 View Only
  • 1.  MAS90 4.40. I'm trying to import new customers us

    Posted 04-14-2012 14:15
    MAS90 4.40. I'm trying to import new customers using the 'auto increment customer number' feature. I set the customer # in the import job to 'next' and a field that is blank. It's failing telling me the customer number is greater than 7 characters. We do not have the 'expanded customer numbers' turned on. What am I missing?


  • 2.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-14-2012 14:28
    Since 4.4 the CustomerNo is always stored as 20 characters. Choosing to turn on Expanded Customers formats screens and reports to display 20 but it's always stored as 20 regardless. Having said that, I don't know if using Next in V/I will necessarily allow Auto Increment Customer Number to work. Let us know.


  • 3.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-14-2012 17:11
    Interesting. Is the same true for the expanced IM number?


  • 4.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-15-2012 04:05
    Sounds familiar - have you tried a live import or is this all test? Sometimes the test imports are broken/ don't validate properly.


  • 5.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-15-2012 04:42
    Nancy - Wayne is right. The testing failis but the import works. Let me know if you need help this weekend.


  • 6.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-15-2012 15:55
    Good to know, the test fails but the import works!


  • 7.  RE: MAS90 4.40. I'm trying to import new customers us

    Posted 04-16-2012 06:45
    The live import works, the test failed. Thanks everyone for your quick responses.