Sage 50 - Journal Entry Dates

Posted by Adrian Pearson PM | on Fri, 20/07/2012 - 09:59 3250 28 comments | report

If I run the report in Company > Nominal Ledger > Day Books: Nominal Ledger without setting any date criteria, I get a list of all Journals with overall totals for Debits and Credits that balance.

However, if I run the same report and set a specific date in the criteria (i.e. all transactions dated 31/08/09) I get a list of all journals on that date BUT the totals for Debits and Credits do not balance.

Can anyone please explain? How can one leg of a Sage journal have a date different to the other one?

Comments

There are 28 comments. Login or register to view them.

Journals

johndon68 | Fri, 20/07/2012 - 10:54

The thing that caught me out in Sage

Richard Willis | Fri, 20/07/2012 - 11:19

yep totally agree with the

Craigie_Bhoy | Fri, 20/07/2012 - 12:15

Seemed like plausible answers but ..

Adrian Pearson | Fri, 20/07/2012 - 15:15

This is not new

dahowlett | Fri, 20/07/2012 - 15:26

@Adrian

Si_Woodhams | Fri, 20/07/2012 - 16:12

Trial Balance does balance

Adrian Pearson | Fri, 20/07/2012 - 16:25

Audit Trail

johndon68 | Fri, 20/07/2012 - 21:26

Foriegn Bank Transactions

Si_Woodhams | Fri, 20/07/2012 - 17:00

More information

Adrian Pearson | Fri, 20/07/2012 - 22:31

No foreign currency

Adrian Pearson | Fri, 20/07/2012 - 22:43

Journals

johndon68 | Fri, 20/07/2012 - 22:52

Clear audit trail

Adrian Pearson | Sat, 21/07/2012 - 08:56

Clear Audit Trail

johndon68 | Sat, 21/07/2012 - 09:28

Thanks John

Adrian Pearson | Sat, 21/07/2012 - 10:18

For completeness ..

Adrian Pearson | Sat, 21/07/2012 - 10:25

Journals

johndon68 | Sat, 21/07/2012 - 10:44

CSV Import

Si_Woodhams | Mon, 23/07/2012 - 10:29

CSV Import

johndon68 | Mon, 23/07/2012 - 10:33

3rd Party software

Si_Woodhams | Mon, 23/07/2012 - 10:57

Import Journals

johndon68 | Mon, 23/07/2012 - 11:07

Thanks guys

Adrian Pearson | Mon, 23/07/2012 - 11:18

I don't know the answer but... this is what I would do...

brucedenney | Mon, 23/07/2012 - 12:07

not always

brucedenney | Mon, 23/07/2012 - 12:16

Journals

johndon68 | Mon, 23/07/2012 - 12:18

Beggars belief!

Healthpay | Thu, 02/08/2012 - 11:15

Not balanced

JWB | Thu, 02/08/2012 - 11:16

Not sub-totals

Adrian Pearson | Thu, 02/08/2012 - 11:36