[jira] [Updated] (OFBIZ-5282) Introduce Accounting ledger segmentation

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-5282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Bakker updated OFBIZ-5282:
-------------------------------

    Attachment: segmentImport.xml
                ledgersegments.patch

A new patch which fixes the reported problems and add the possibility to add segments when ledger entries are added manually.

implementing the patch only does not interfere with the normal ofbiz operation and segments are not shown when the segment data is not loaded.

if you would like to see these segments, load the data from the xml file which will enable this feature:
1. in purchase orders, purchase invoices and accounting entries you can add a segment definition
2. balance sheet allows the selection of a single segment

these extra definitions are shown in the invoice overview screen when the invoice is posted.

use demosupplier and big-gizmo as product.

function we are adding now:

Add segment selection to the following reports:
1. income statement
2. trial balance
3. cashflow statement

and be able to select more than a single segment which will or-ed.

regards,
Hans

               

> Introduce Accounting ledger segmentation
> ----------------------------------------
>
>                 Key: OFBIZ-5282
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5282
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting
>    Affects Versions: SVN trunk
>         Environment: any
>            Reporter: Hans Bakker
>            Assignee: Hans Bakker
>             Fix For: SVN trunk
>
>         Attachments: ledgersegment.patch, ledgersegments.patch, segmentImport.xml
>
>
> We have the possibility here to be able to introduce Apache OFBiz accounting in a large multi company organization. This organization is evaluating the several alternatives and after evaluation of OFBiz, came up with a function which OFBiz needs to have, in order to be considered.
> The user story:
> Although OFBiz accounting has the 'costcenter' function, it is not fine-grained enough, we need to be able to segment the ledger to a lower level that the GL accounts namely to the accounting transaction.. Further, all existing reports should have the facility to be able to select a segment of the ledger for either costing, profit or other purposes like special projects.
> The proposed user interface.
> We need at least at the order item level the ability to specify a parent-segment/segment and a percentage, if the percentange is not 100% the remainder to 100% should be assigned to another segment.
> These segments can be defined and assigned by the user to the order item upon entry. When the related invoice is created the segment(s) will be copied and can overridden before posting when these segment names will be copied to the accounting transaction.
> The proposed user reporting.
> All existing ledger reports will have the additional ability to select these segments and will only incorporate accounting transactions where this segment is specified.
> The proposed technical implementation.
> 1. add a new entity called LedgerSegment with fields: ledgerSegmentId, parentSegmentId, description
> 2. add another 3 similar entities: OrderItemSegment, InvoiceItemSegment, AcctTransSegment to make the relation to the LedgerSegment entity and to specify the percentage.
> 3. Change the order, invoice, accounting transaction screens and ledger report entity views to be able to use the segment names when available in the LedgerSegment entity
> As i said , please let me know what you think, this is a great opportunity for OFBiz accounting.
> Regards,
> Hans Bakker
> CEO AntWebsystems.com

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira