Topic Options
#46773 - 08/05/15 12:02 PM Switching from a 13 period to a 12 period calendar
RPope Offline
Casual

Registered: 04/23/12
Posts: 13
Loc: Canada
Hi,

I have a new client that requested to be setup with 13 periods, and now wants to change to 12 for reporting purposes. This is a new setup that has only been running for a few months, so they have no previous year history. What is the easiest way to accomplish this, and have the already posted transactions show in the correct period based on the 12 period fiscal year?

Thank you,

Top
#46774 - 08/05/15 12:17 PM Re: Switching from a 13 period to a 12 period calendar [Re: RPope]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Hi Ross

(assuming you are using Ledger 9.x and nothing is posted to period 13)

This is not going to sound easy but the alternatives are worse. First unpost every batch, then export those now unposted batches to a CSV file by using File | Export | Batches, then create a new Ledger with 12 periods by using the File | Export | Clone Company function, and then finally import the CSV file into the new Ledger. It will all come in as one batch but everything will be in the correct period.

This is a bit of a simplification, you'll need to check that the export file has the fields you want to move, and that the import template matches the exported file. But you get the idea.

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (AudreyQuick), 54 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14472 Topics
70682 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
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 31