DateAcct in GL_JournalLine is not validated to be within the same period of GL_Journal

Description

This bug is observed in one of our installation and can be replicated on demo.idempiere.com.
A quick check: DateAcct appears on these "Line" tables: GL_JournalLine, C_TaxDeclarationLine, and C_BankStatementLine.
Currently, DateAcct in hidden in window GL Journal and is only displayed when currency other than the base currency is selected in the GL Journal tab. I think it is for currency conversion calculation.
However, currently there is no validation to ensure that the newly entered date is within the period specified in GL Journal tab.
For example: I selected period Feb 13 in GL Journal tab, and i can entry 18 Oct 2012 for DateAcct in the GL Journal Line. The document can be completed and the journal will be created with DateAcct = 18 Oct 2012 and Period Feb 13!

Environment

None

Activity

Show:

Heng Sin Low May 3, 2013 at 3:58 PM

Hi Edwin,

Do you have a patch for this ?

Regards,
Low

Edwin Ang April 24, 2013 at 11:01 AM

Proposed solution:

  • Add DateDoc column in GL_JournalLine. Default value is the same as DateDoc value in GL_Journal

  • Lock value of DateAcct to be the same as DateAcct in GL_Journal

  • Change the logic of Currency Conversion to take rate based on DateDoc instead of current DateAcct.

Fixed

Details

Assignee

Reporter

Components

Affects versions

Priority

Created March 29, 2013 at 7:46 AM
Updated February 1, 2020 at 1:40 PM
Resolved December 23, 2019 at 2:12 PM