Topic Options
#33167 - 09/10/12 02:45 PM Ledger Batch Import
Sage Offline
Adagio Buff

Registered: 08/26/08
Posts: 53
Loc: Prince George, BC
Hi there,

I have imported a batch into the ledger. All seems to be great, no errors on the listing but when I post it, the message comes up that it has been posted and errors have added to a new batch. The new batch is the entire batch I tried to post. I have no idea what the issue is, all seems to be fine with the batch but it will not post. Any suggestions for what could be wrong?
_________________________
Thank you.

Top
#33169 - 09/10/12 03:15 PM Re: Ledger Batch Import [Re: Sage]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
There will be an error code on the error posting journal. Perhaps the period is closed?

Or do a batch listing of the error batch and see what it's complaining about.
_________________________
Andrew Bates

Top
#33179 - 09/11/12 05:36 AM Re: Ledger Batch Import [Re: Retired_Guy]
Sage Offline
Adagio Buff

Registered: 08/26/08
Posts: 53
Loc: Prince George, BC
There is no error listed so I have no idea what the problem is. The period is not closed. The dates all look good. Neither the original listing nor the error batch listing show any errors.
_________________________
Thank you.

Top
#33180 - 09/11/12 06:17 AM Re: Ledger Batch Import [Re: Sage]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Please upload a backup of your general ledger to http://www.softrak.com/dbr
_________________________
Andrew Bates

Top
#33183 - 09/11/12 06:44 AM Re: Ledger Batch Import [Re: Retired_Guy]
Sage Offline
Adagio Buff

Registered: 08/26/08
Posts: 53
Loc: Prince George, BC
I uploaded a pdf of the error listing. When I go to backup, it says it can't lock the data set exclusively. Is that ok?
_________________________
Thank you.

Top
#33184 - 09/11/12 06:48 AM Re: Ledger Batch Import [Re: Sage]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Perhaps - it depends what files in Ledger it is unable to backup. The backup must be complete. There's no harm in trying.

You've already said that the error listing does not indicate any errors.

What version of Ledger are you using (Help | About)?
_________________________
Andrew Bates

Top
#33185 - 09/11/12 07:20 AM Re: Ledger Batch Import [Re: Retired_Guy]
Sage Offline
Adagio Buff

Registered: 08/26/08
Posts: 53
Loc: Prince George, BC
Ok done.
_________________________
Thank you.

Top
#33187 - 09/11/12 08:38 AM Re: Ledger Batch Import [Re: Sage]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Sage,

This batch does not pass the Data Integrity Check (File | Data Integrity Check). Run the DIC and Rebuild the batch totals (they are off by 2 cents).

If you can send me the batch you imported, I'll have someone look at why the batch total is incorrect on the import and why this wasn't caught in the batch listing - which should have reported the error.
_________________________
Andrew Bates

Top
#33188 - 09/11/12 09:02 AM Re: Ledger Batch Import [Re: Retired_Guy]
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
The error was in the rounding from the origibally imnported spreadsheet. Let DIC fix it, and the batch now posts without error.
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada

Top
#33192 - 09/11/12 10:18 AM Re: Ledger Batch Import [Re: Ralph Allan]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Ralph,

The CSV batch imports without any error here. You might want to check the version of Ledger they are running.
_________________________
Andrew Bates

Top


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