Topic Options
#32746 - 07/27/12 10:07 AM AR Note Detail Export Error
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Hi, I'm trying to export the customer note detail but I'm getting a no records to export message. I opened A/R Customer Notes Detail table in Gridview and got a of list records. I'd like to import some notes but thought I'd export first to make sure my tables were correct. Thank you. (AR 9.0C (111209))


Edited by MikeS (07/27/12 11:35 AM)
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#32747 - 07/27/12 12:51 PM Re: AR Note Detail Export Error [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11324
Loc: Vancouver, BC Canada
Hi, Mike,

I'm using 9.0C(120224)and was able to export notes for a single customer, as well as a larger range. Also tested using 9.0C(111209) and was successful using that release as well. I'm using the Customer Notes Default template and am exporting to csv

Are referring to the detailed notes for which the user, date and time are included with the note or to the more general 'Additional comments' on the customer's Notes/Alerts window? The Additional comments don't export.
_________________________
Regards,
Softrak Tech Support

Top
#32748 - 07/27/12 02:46 PM Re: AR Note Detail Export Error [Re: MikeS]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3504
Loc: Toronto ON, Canada
Mike:
Further to Support's response, that table contains 2 types of records. The first is the transactional type that appear in the middle of the "Notes/Alerts" screen. Those are the ones with a date, time and user stamp. The second type is the "Additional Comments" that appear at the top of that screen. GridView shows both types in the "Notes Detail" table (the "Additional Comments" are distinguished in the "Note key" column as the Customer code + 6 zeros i.e. "BRAMBR000000").

Since Additional Comments aren't exported (not certain why not), your Detail table must likely has only Additional Comments and not transactional type notes.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 76 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
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 31