Topic Options
#60950 - 05/24/19 06:40 AM Editing Reallocation Accounts
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
I have a dept for reallocation accounts, with 29 expense accounts. The % allocation is changing for the new fiscal year. Is there a way to export the Account Info including the reallocation info so that I don't have to edit each account individually in the Edit Accounts section?

Top
#60951 - 05/24/19 06:58 AM Re: Editing Reallocation Accounts [Re: MER]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
Hello,

What you want is under File>Imports>Account Reallocations. There should be an example of the layout in the sample data C:\SOFTRAK\Ledger\samdata\GLREALIM.xlsx that matches the default import template.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#60952 - 05/24/19 07:48 AM Re: Editing Reallocation Accounts [Re: Dan_Desautels]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Dan is correct if all you want to do is change percentages of existing reallocations.

It's more complicated if you want to delete a reallocation in total, or delete a detail from a reallocation.

Also, be careful when you are importing that all of the details of a reallocation are grouped together in the import file. If they are not, the import will fail because it will think the reallocation percentage doesn't total 100.

Steve

Top
#60953 - 05/24/19 08:15 AM Re: Editing Reallocation Accounts [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

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

I believe that when a reallocation for an account is imported, all the existing reallocation records for the account are deleted prior to the import being processed. So, all reallocation imports must sum to 100% and if you just want to change a couple of entries, the entire reallocation must be imported.
_________________________
Andrew Bates

Top
#60954 - 05/24/19 10:27 AM Re: Editing Reallocation Accounts [Re: Retired_Guy]
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
Thanks all. It was more complicated to do it simply (ha ha) than I thought, so I edited the accounts individually. It's on my list of things to review with our consultant when we meet with him.

Top


Moderator:  Christa_Meissner 
Who's Online
2 registered (Carol Wojick, Bruce Gardner), 88 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