Topic Options
#36989 - 05/17/13 11:45 AM Import Template help
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
This template used to work perfectly but there must be an update to the syntax. My template looks like this:

H 2/28/13 2
C Feb13 Brokerage
C
C Per GS stmt
D 1000.0 .00 Feb13Brkrge 2/28/13 Per GS stmt 2.00
D 4000.0 .00 Feb13Brkrge 2/28/13 Per GS stmt -2.00

etc

Now, once I import the file, I get the error "Error adding record to G/L Batch detail, record already exists." three times. When I print the journal, the first three lines (In my example the lines 2-4) disappear then the rest of the journal imports fine.

It still works, but it used to be nice to have the title of the journal appear at the top of the printed report. Any ideas what is causing the error?

Top
#36991 - 05/17/13 01:15 PM Re: Import Template help [Re: ASANTOS]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
It would be helpful to know what you are trying to import and into which module (inclding version number).

Looks like an order or invoice into OE but the error message isn't consistent with that type of import.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#36992 - 05/17/13 01:22 PM Re: Import Template help [Re: ASANTOS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
What has changed? What version of Ledger?
_________________________
Andrew Bates

Top
#36995 - 05/17/13 01:34 PM Re: Import Template help [Re: Retired_Guy]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
Nothings changed with the template... been using the same template since 2008. This is being used to import journals into General Ledger. We're using 9.0D It was working with the prior version.

Top
#36996 - 05/17/13 01:43 PM Re: Import Template help [Re: ASANTOS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
So, did you recently upgrade Adagio Ledger?

From which version? Are you running Ledger V9.0D (111017)?

I checked and the sample import file GLHDBTCHIM.SAM, which contains comment lines, imports properly into the sample data. You will need to inspect your import template and import data file to make sure that the fields and order of the fields (and file name) all match up.



Edited by Andrew Bates (05/17/13 01:54 PM)
Edit Reason: Tested sample.
_________________________
Andrew Bates

Top
#36999 - 05/17/13 02:16 PM Re: Import Template help [Re: ASANTOS]
JoeBen Offline
New Guy

Registered: 06/04/07
Posts: 5
Loc: CA , USA
This is a GL import batch. I check to see what is the source of the import issue.

Thanks.

Top
#37029 - 05/20/13 12:52 PM Re: Import Template help [Re: JoeBen]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
Andrew, just did a search on the network drive and the local hard drive... no sign of that sample template. Is it available for download somewhere?

Top
#37030 - 05/20/13 03:00 PM Re: Import Template help [Re: ASANTOS]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3613
Loc: Toronto ON, Canada
Look in the X:\Softrak\Ledger\Samdata folder (replace X: with the drive letter where Adagio is located in your environment). Andrew meant to type GLHDBTCHIM.CSV (note the extension of CSV). There is likely a quick explanation or solution to the problem. But if you can't resolve it soon, a call to your Adagio consultant would save you some time and frustration.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#37033 - 05/20/13 04:28 PM Re: Import Template help [Re: Bruce Gardner]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
Thanks... found the file. I'm just going to play around with placement of those three comment lines and see what happens. Thanks all.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 77 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