Sage 100

 View Only
  • 1.  Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:13
    Wondering if anyone else has run into this: AR Contacts, the Notes field. I can import or export to the field, but there does not seem to be a Data Dictionary entry for it. I cannot reference it in Crystal Reports. This is an issue for a client that has used this field extensively in 4.05, now that we are in 4.50 we cannot reference the data contained in Crystal Reports. Any ideas?


  • 2.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:21
    I just checked on my MAS 4.50 in Crystal . When I viewed the AR_CustomerContact table, I see the ContactNotes field there. So I do see it in Crystal Reports. Maybe I misunderstood your issue.


  • 3.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:25
    I see notes in AR_customermemo - memo text has them notes in it. Is that what you are looking for?


  • 4.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:27
    also see in ar_customercontact - contact notes.


  • 5.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:29
    If you don't see these fields maybe you need to verify database?


  • 6.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 10:34
    Verify did help. Don't know if it was the swapping of versions. Was getting frustrated. Thanks!


  • 7.  RE: Wondering if anyone else has run into this: AR Co

    Posted 10-08-2012 12:53
    I see ContactNotes as a field in VI, but you have to scroll the Data List down to see it.