Financial Report: Add inverse operation option for credit/debit only column

Description

For subtraction/addition calculation line type, there are cases where you want to apply inverse operation to the debit/credit only column.

e.g:

 

Period Debit

Period Credit

Period Change

Net Sales

100,000.00

200,000.00

100,000.00

COGS

070,000.00

030,000.00

040,000.00

Gross Profit

170,000.00

230,000.00

060,000.00

For the gross profit line, we want to apply addition for the period debit and period credit column and subtraction for the period change column. With the new improvement, we can achieve this by setting the gross profit line as subtraction of "Net Sales - COGS" and set the "inverse for debit/credit only column" flag to true.

Environment

None

Activity

Carlos Ruiz 
March 13, 2013 at 6:13 AM

Thanks Michael name of script fixed:
https://bitbucket.org/idempiere/idempiere/commits/8681041

About
> The INSERT statement on line 38 of the migration script does nothing
> (i.e. it inserts zero rows on my system).
> Is this a problem? I only tested with the PostgreSQL variant.

That's fine - is used to synchronize translations when they exist.

Regards,

Carlos Ruiz

Michael Hüttemann 
March 13, 2013 at 5:11 AM

I made some comments on the first commit related to this ticket here: https://bitbucket.org/idempiere/idempiere/commits/8b1db17a048824e90fa101d45552d72deb3b9b7b

Sorry for the noise. I am still unsure where to post stuff like this (Jira, Bitbucket, Google Group...).

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created March 12, 2013 at 4:05 PM
Updated March 13, 2014 at 2:19 PM
Resolved March 13, 2013 at 12:28 PM