You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Daniel Watford (Jira)" <ji...@apache.org> on 2023/02/06 21:06:00 UTC
[jira] [Commented] (OFBIZ-12754) Accumulated depreciation switches from negative to positive value following closure of corresponding time period
[ 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)