Topic Options
#44001 - 12/30/14 08:10 AM AR Import not picking up values in spec fields
Samuel Kopstick Offline
Adagio Virtuoso

Registered: 06/15/07
Posts: 892
Loc: GTA & North America (Remote Su...
Receivables 9.1A (131105)
I am doing an AR import (using an Excel file) to update the spec fields on the Invoicing tab of Customers.
(E.g. Invoice & Cr Note Print spec & Email spec fields)

Problem is, that it is not working properly.
I do not receive any error messages, but the fields simply do not get updated.
Even worse, if I had a value in the field before the import, the field is now blank.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#44002 - 12/30/14 08:22 AM Re: AR Import not picking up values in spec fields [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Have you tried exporting the fields and checking what is being sent? It's possible that the short file name is being stored in the file and is what you need to import. Certainly, it is the long spec description stored within the specification itself which is displayed in the drop down. That's not what you need to import.
_________________________
Andrew Bates

Top
#44004 - 12/30/14 09:35 AM Re: AR Import not picking up values in spec fields [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Virtuoso

Registered: 06/15/07
Posts: 892
Loc: GTA & North America (Remote Su...
Hello Andrew.
The short answer is: Yes.

I did a number of things.
I initially had long file names, and things were not working.
So, I renamed them so that each file name is either 7 or 8 characters.
As well, I entered the values into the first customer, and then I exported the field values.
In Excel, I simply copied the values to all the rows.
But when I import the file, the fields remain blank, and the first customer that originally had values, now appears blank in these fields.

It just is not working for me.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#44005 - 12/30/14 10:12 AM Re: AR Import not picking up values in spec fields [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Try the process with the sample data, and if that doesn't work, ZIP up the data and the spreadsheet you are trying to import and send it to me.
_________________________
Andrew Bates

Top
#44009 - 12/30/14 01:06 PM Re: AR Import not picking up values in spec fields [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Virtuoso

Registered: 06/15/07
Posts: 892
Loc: GTA & North America (Remote Su...
I gave it a shot with Sample Data, and it did work.
So, I next used the Sample Data spreadsheet with a small selection of the company data, and gave it another shot with the live data.
This time around I got the import going!
Not sure what I did incorrectly earlier. I am reviewing the spreadsheet, but nothing stands out.
Nonetheless, we are always pleased when things work properly.
Thanks for your input, Andrew.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Tanya_Belanger), 79 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14237 Topics
69720 Posts

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