A client prints and consolidates their subledger activity by account/source/date before retrieving it into Ledger at the end of the fiscal period. Let's not get into a discussion of whether that is a "best practice" (it's not); they are fanatical about it and I would rather save my breath for more important issues.

They accidentally retrieved last month's activity without printing/consolidating. They are apoplectic. Restoring from a backup would require hours of re-entry into subledgers, which is not only time consuming, but error-prone.

Is there any way to consolidate posted transactions in Ledger by account/source/date? I see there is an option to consolidate, but it is by account/period, which does not match what they are used to.

I'm thinking I could unpost the batches, export them to Excel, consolidate them there, and re-import them. Before I do, are there any other ideas?

Thanks

Steve

Hi Steve,

If the choices for consolidating posted transaction directly in Ledger do not meet your clients needs, and the option on the account to post as consolidated rather than in detail also does not work for them (I wouldn't expect this latter option is desirable), then you'll need to manually consolidate the batch as you suggested.

Steve:

Sorry, you already know the only way forward.

I have a couple of clients like this too. I'm trying to get them comfortable about the idea of giving it up by telling them we are expecting the developer to remove this option in future releases.

I went the Excel route and it worked.

But I think that the same options that exist in the subledger for consolidating should also exist in the Ledger.

Steve