Topic Options
#15537 - 01/02/09 04:14 PM Retrieve Subledger batches into G/L 9.0
Victor B. Offline
Adagio Scholar

Registered: 05/07/06
Posts: 97
Loc: Toronto, ON, Canada
Hi All,

Happy New Year,

We just converted GL to 9.0A. Is the a way to retrieve subledger batches into "Next Year"?

Thank you
Victor
_________________________
Victor

Top
#15538 - 01/02/09 04:24 PM Re: Retrieve Subledger batches into G/L 9.0 [Re: Victor B.]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
Run the Create Next Fiscal Year function to activate the next fiscal year.
o You can retrieve, enter and post batches for this year before closing your current fiscal year.
o The Fiscal Calendar for the New Year will be created and is accessible from the Edit menu.
o Budget amounts may optionally be copied from the Current year to the Next fiscal year.
o The Close Current Fiscal Year function is now visible on the Maintenance menu.
o Posting to the Prior fiscal year is not accessible until you close your Current year.

Top
#15539 - 01/02/09 05:25 PM Re: Retrieve Subledger batches into G/L 9.0 [Re: Michael Mulrooney]
Retired_Guy Offline
Adagio Master

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

...and to complete the list provided by Michael...

0 When retriving transaction from subsidiary ledgers by date, the transactions will automatically be placed into the correct year.

Happy New Year!
_________________________
Andrew Bates

Top
#15540 - 01/02/09 06:46 PM Re: Retrieve Subledger batches into G/L 9.0 [Re: Retired_Guy]
Victor B. Offline
Adagio Scholar

Registered: 05/07/06
Posts: 97
Loc: Toronto, ON, Canada
Hi Andrew,
Hi Michael,

Thank you.
Very often transaction date could be outside of fiscal period you retrieving the data to. For instance accounts payable uses transaction date the same as vendor's invoice date. Therefore the transactions automatically placed into the correct year based on transaction date only. When I try to retrieve my December AP data (Year end November 30) some transactions were retrieved into current year and some into "Next Year".
Is the workaround or this is something to correct in the future?

Thank you
Victor
_________________________
Victor

Top
#15541 - 01/02/09 09:43 PM Re: Retrieve Subledger batches into G/L 9.0 [Re: Victor B.]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Hi Victor

What you are describing is the desired behaviour of an accounting software program. There is no workaround needed and nothing to correct.

What's the problem with November-dated transactions being retrieved into November and December-dated transactions being retrieved into December?

Steve

Top
#15544 - 01/04/09 10:21 AM Re: Retrieve Subledger batches into G/L 9.0 [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

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

You can move transactions back and forth between the current year and next year, although this should be the exception, rather than the rule.

As Steve asks, what's the problem with the way the program behaves?
_________________________
Andrew Bates

Top
#15583 - 01/09/09 09:30 AM Re: Retrieve Subledger batches into G/L 9.0 [Re: Retired_Guy]
Victor B. Offline
Adagio Scholar

Registered: 05/07/06
Posts: 97
Loc: Toronto, ON, Canada
Thank you,

However one more question:

A/P period end is done;
A/P year end is done;
A/P Y/E Reports are printed
A/P batches are retrieved and G/L A/P control account is reconciled to subledger;

Now we create next year and retrieve transactions into corresponding periods. A/P balance will change. How we can provide the proper support for G/L accounts payable balance?

Thank you again
Victor

Top
#15596 - 01/09/09 07:49 PM Re: Retrieve Subledger batches into G/L 9.0 [Re: Victor B.]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Hi Victor

The same way you do it every period. There is nothing special about this just because it's year-end.

You can always re-run the December 31st Open Payables report and it should tie to the December 31st GL AP balance, assuming everything is retrieved and posted in the GL.

Steve

Top


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