• Registered: 01/10/2011
  • Posts: 7

Topic: Zero transaction in Journal Entries and GL Account Transactions

Hi,

Software version: Version 2.3.1 Build 04.01.2011

Found several transactions with zero amount in the Journal Entries and GL Account Transactions:

Example:

Journal Entries:
Journal Entry # 28 1101008 01/05/2011 BUREAU VERITAS HONG KONG LTD TESTING FEE ON NOV 2010 USD65
2150 Accrued Expenses USD6520 @7.75 0.00
1062 BOC HKD C/A USD6520 @7.75 0.00

Journal Entry # 28 1101008 01/05/2011 BUREAU VERITAS HONG KONG LTD
TESTING FEE ON NOV 2010 USD65
2150 Accrued Expenses USD6520 @7.75 0.00
1064 BOC USD C/A USD6520 @7.75 0.00
2150 Accrued Expenses USD6520 @7.75 0.00
1064 BOC USD C/A USD6520 @7.75 0.00
2100 Accounts Payable USD6520 @7.75 50,530.00
1064 BOC USD C/A USD6520 @7.75 50,530.00

GL Account Transactions:
Journal Entry 1101008 28 01/05/2011 USD6520 @7.75 0.00 0.00
Journal Entry 1101008 28 01/05/2011 USD6520 @7.75 0.00 0.00
Journal Entry 1101008 28 01/05/2011 USD6520 @7.75 50,530.00 -50,530.00

Audit trail:
01/11/2011 03:31:02 pm user1 01/05/2011 Journal Entry 28 Changed 50,530.00
01/12/2011 04:23:07 pm user1 01/05/2011 Journal Entry 28 Changed 50,530.00
01/12/2011 04:24:06 pm user1 01/05/2011 Journal Entry 28 Changed 50,530.00
01/12/2011 04:24:06 pm user1 01/05/2011 Journal Entry 28 Closed 50,530.00

As per above, several changes has been made to journal entry 28, and resulted in the zero transactions.

Another Example below, with no changes made:
Journal Entries:
Journal Entry # 23 1101003 01/01/2011 AIA CO (TRUSTEE) LTD - MPF DEC 2010 BOC#716128
2150 Accrued Expenses 14,311.07
1062 BOC HKD C/A 14,311.07

GL Account Transactions:
Journal Entry 1101003 23 01/01/2011 14,311.07 -14,311.07

Audit trail:
01/11/2011 01:42:43 pm user1 01/01/2011 Journal Entry 23 Closed 14,311.07

No zero transactions discovered in journal entry 23.

Is this a bug?

Regards

Shan Yee

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Zero transaction in Journal Entries and GL Account Transactions

We will investigate this. Thanks for pointing this out.

/Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Zero transaction in Journal Entries and GL Account Transactions

Hello again,
The reason for the 0 transactions is that when you change a JE the old rows are voided (set to 0) before creating new ones. This way it is easy to see that changes have been done.

So this is not a bug.

/Joe

  • Registered: 01/10/2011
  • Posts: 7

Re: Zero transaction in Journal Entries and GL Account Transactions

Hi,

Is it possible to filter the zero transactions from printing out?

Please advise.

Regards

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Zero transaction in Journal Entries and GL Account Transactions

If you look under Banking And General Ledger, you will see that Kalido has the same topic. He has suggested a way to filter away the 0 transactions.
We are considering implementing this.

/Joe