Topic Options
#36273 - 03/27/13 06:20 AM Importing Quotes
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Are there sample csv files for importing quotes or am I safe to assume the ones for order entry will work? The templates look the same except for the fields unique to CQ.

Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#36274 - 03/27/13 07:27 AM Re: Importing Quotes [Re: MikeS]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4514
Loc: Wynnewood, PA
Hi Mike

There are six sample csv files, in the \Softrak\ACWIN\Samdata folder. They start with the letters QT and have an extension of CSV.

Steve

Top
#36275 - 03/27/13 09:04 AM Re: Importing Quotes [Re: Steve Schwartz]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Thanks Steve, I was afraid of that. I deleted all my Samdata folders but one assuming that they were the same for all modules. But since I'm doing a simple import (Quotes Version 1 Default) I'm not gong to worry about it right now. Everything worked fine but as follows:

I assumed that non-imported fields would use default values (other than those documented in the manual). I have defaulted every customer/prospect with a Contact/ShipTo Code of "BLANK" and the corresponding description "Same". I don't want the billing info always printing in the ShipTo fields. When I did the import, the Contact/ShipTo Code "BLANK" and the first description line "Same" where there, but every other field was filled in with the billing info. Must I always import blank data for all the ShipTo fields when i do an import??

Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#36301 - 03/28/13 12:37 PM Re: Importing Quotes [Re: MikeS]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1739
Loc: Waterloo, Ontario, Canada
Mike,

You should call your Adagio Consultant to help you with this. We have done a number of imports into Adagio CQ from Web stores and it works quite well.

We have recently released our Link2SalesCQ which now handles mass transfers of Approved Quotes (Web Orders) into Adagio Order Entry. Our bench mark is about 80 quotes per minute on a busy network. We have transferred as imports into Adagio Order Entry, as many as 400 per import with over thousands line of details.

Works well. Please call when you are looking for a solution to transfer the quotes (approved) to Order Entry, if you have the volume.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#36386 - 04/05/13 03:42 AM Re: Importing Quotes [Re: Brian Stief]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 225
Loc: Montreal, Canada
With Link2SalesCQ, do the quotes arrive in OE as open orders or as invoices? In the past the problem has always been doing the Ship All and posting the invoices one-by-one because of OE's inability to post multiple orders like Adagio Invoices does. How does Link2Sales CQ handle this?
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#36435 - 04/08/13 09:57 AM Re: Importing Quotes [Re: Brian Puddington]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1739
Loc: Waterloo, Ontario, Canada
Hi Brian,
With Link2SalesCQ, the quotes normally arrive in OE as open orders. If your settings in OE are set to default to shipped as ordered or if you want to receive the orders in from SalesCQ as being shipped, that is possible, too.

The Link2SalesCQ is used a vehicle to select (in mass) quotes that we use Gridview to create the driver file of quotes that are approved for sending to Order Entry. We currently map the quoted quantity as the ordered quantity, but we could easily map the ordered quantity from the web, and and feed into the ordered and shipped quantity in Order Entry, if by default the site was shipping the quantity in OE before confirming the packing slip details.

Thanks,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Rebecca Young), 55 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70724 Posts

Max Online: 432 @ 01/20/25 10:17 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