Topic Options
#48936 - 02/10/16 08:17 AM Import prior year transactions
Compass Offline
Stranger

Registered: 02/10/16
Posts: 3
Loc: Canada
We cloned our GL, exported the transactions to be imported in to the new GL as prior year data. No changes to the spec and yet the error message.
Transaction out of balance.Debits (0.00) do not equal credits (2.541.68)

Top
#48937 - 02/10/16 08:24 AM Re: Import prior year transactions [Re: Compass]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Are you changing your year end? This is a very odd procedure to go through.

Have you checked the exported transactions to see whether the debits and credit are equal?
_________________________
Andrew Bates

Top
#48940 - 02/10/16 08:30 AM Re: Import prior year transactions [Re: Retired_Guy]
Compass Offline
Stranger

Registered: 02/10/16
Posts: 3
Loc: Canada
Yes the year end was changed, we have a stub year. For the current year i am unposting the batches changing FP and reimporting to the cloned GL with new FP's.
AS for the CSV no changes were made to the amounts, its coming directly from Adagio spec.

Top
#48942 - 02/10/16 08:45 AM Re: Import prior year transactions [Re: Compass]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
OK. There are other ways to accomplish a change of fiscal year, but you'd want to be talking to your Adagio consultant.

Imports are fiddly. You are going to have to figure out why the debits and credits aren't equal. Try exporting and importing through and Excel sheet rather than through a CSV. Inspect the exported transactions to make sure all the ones you expected were exported.

Are you letting the import set the fiscal period, or are you setting the fiscal period in the import file? Do the debits and credits balance within each period?

Sorry, but this is about the limit of the guidance that can be provided on the Forum. Someone needs to be looking at your actual data and import/export templates.
_________________________
Andrew Bates

Top
#48943 - 02/10/16 08:59 AM Re: Import prior year transactions [Re: Retired_Guy]
Compass Offline
Stranger

Registered: 02/10/16
Posts: 3
Loc: Canada
Okay, thank you

Top


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