Topic Options
#65131 - 11/11/20 08:28 AM Importing Notes into Adagio
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Wherever there is a master table in Adagio - for example customers, vendors, items, prospects and GL accounts - one can enter notes, both date-stamped and "additional comments".

It's possible to import date-stamped notes from Excel for customers, prospects and GL accounts, but not for vendors or items.

Why not vendors or items?

Has anyone discovered a workaround for bringing vendor or item notes in, maybe using GridView RW?

Is there a way to bring in "additional comments"?

Thanks

Steve

Top
#65132 - 11/11/20 11:00 AM Re: Importing Notes into Adagio [Re: Steve Schwartz]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Steve:

Very unfortunate that Softrak hasn't yet added Note import for Vendors or Items when it has existed for some time in the other modules.

I've done some database repairs on the Notes (though it's been a couple of year) using GV-RW. Not positive but I'm fairly certain that at some point in the past I've also used GV-RW to add new notes.

The trick is to figure out the Header and Details relate and how Note Key & Line Numbers are assigned. For a one time import with GV-RW this shouldn't be too big of a challenge but definitely not a solution for end users who are looking for a solution to import notes on a regular basis.

I don't recall having ever do anything with the Additional Comments but they are in the Note Details with a Note Key of ######000000 and a sequential line number. Use GV-RW requires that you figure out the next line number to use.


Edited by Douglas Dickie (11/11/20 11:08 AM)
Edit Reason: Clarification
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#65139 - 11/12/20 10:47 AM Re: Importing Notes into Adagio [Re: Douglas Dickie]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Hi Steve/Doug,

I don't expect that the exclusion of Importing Notes into Inventory or Payables for items and vendors was intentional. I have directed your requests to R&D.
_________________________
Regards,
Softrak Tech Support

Top
#66491 - 07/08/21 02:34 PM Re: Importing Notes into Adagio [Re: Softrak Support]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Hello Steve,

This has been added in the Payables 9.3C (2021.07.06) Upgrade released today.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 120 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 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