[
https://issues.apache.org/jira/browse/OFBIZ-12754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17684949#comment-17684949
]
Daniel Watford commented on OFBIZ-12754:
----------------------------------------
Issue is caused by GlAccountHistory records for contra accounts have their
balance calculate using 'Credit Account' rules, i.e. a credit balance is
considered positive. But when displaying contra account balances in the Balance
Sheet those balances should be represented as asset accounts with a negative
value.
The negative value is being correctly applied for all contra account
transaction entries that are not summarised by GlAccountHistory records - as is
the case for currently open time periods - but the rule is not being applied to
balances from GlAccountHistory sourced balances.
This issue was found while working on OFBIZ-12753. I would like to apply the
fix on top of that refactored code, but this would require admitting
OFBIZ-12753 into release 22.1 where we currently have a feature freeze in place
pending a release.
> Accumulated depreciation switches from negative to positive value following
> closure of corresponding time period
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-12754
> URL: https://issues.apache.org/jira/browse/OFBIZ-12754
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: 22.01.01
> Reporter: Daniel Watford
> Assignee: Daniel Watford
> Priority: Critical
>
> This bug marked as critical since OFBiz appears to be producing an incorrect
> financial report.
> When the corresponding time period is open, the balance sheet will display
> the sum of contra account credit entries for that time period as negative
> when displayed on the balance sheet as these balances are displayed alongside
> and summed with asset balances. This has the (presumably intended) effect of
> reducing the overall value of assets.
> Once the time period for the contra account credit balance is closed, the
> contra account balance will then be treated as a positive value on the
> balance sheet, having the effect of increasing, rather than decreasing, total
> asset value.
> This behaviour can be observed using demo data.
> For the demo company, create the following Fiscal Month custom time periods
> (time values should be 00:00:00):
> * 2009-01-01 to 2009-02-01
> * 2009-02-01 to 2009-03-01
> * 2009-03-01 to 2009-04-01
> * 2009-04-01 to 2009-05-01
> Access the Balance Sheet report and produce a balance sheet for Thru Date
> 2009-04-01. This balance sheet will then include the entry for vehicle
> depreciation with transaction date 2009-03-31 08:00:00.000.
> The balance sheet should show this depreciation in the Assets part of the
> report with a value of -$2500.
> Close the first three time periods one-by-one, regenerating the above balance
> sheet after each closure. You should see that once the March 2009 time period
> is closed the depreciation balance changes from -$2500 to $2500.
> Further, the Total Assets entry at the bottom of the report will have
> increased to $202,500, misrepresenting the true state by $5000.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
