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

["simon maskell (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-5282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13862868#comment-13862868 ] 

simon maskell commented on OFBIZ-5282:
--------------------------------------

Hi and Happy new year to everyone

Thought I would add some background to the patch that Hans has created. We are a medium sized company(£200m+ turnover) made up of 5 operating companies and 9 subsidiaries around the world,  our financial department work for our holding company. 

We have been using Ofbiz for a 1.5 years and we will be rolling it out to all 5 companies and 9 subsidiaries, the modules we will be rolling out include Lead Management, Sales Orders, Invoicing, CRM, HR, Stock control, Manufacturing, Shipping and hopefully finance. 

Hans started work on this patch to solve a problem we have with the accounting module, we need to be able to tag every financial transaction so we can then export the transactions into our accounting package. Our aim would be to use Ofbiz Finance but at the moment we are struggling to convince our finance department to use it.

We also have Rupert working on Ofbiz for us and he has used the Patch Hans created to introduce a Purchase Order system which allows us to tag line items, regarding assigning percentages this isn't something we need for PO's but it may be useful for other accounting transactions e.g. we have utility bills which we would want to split  as percentage across the operating companies. 


Having reviewed Han's patch we also noticed there was a few bugs and I believe  we have removed most of those, 
I think any medium size business would need to have this type of functionality of tagging transaction even if it is to only post the transactions into a third party finance package.

My view is we have a starting point with the work Hans has done and we will be developing this further  over the next few years and  we are keen to push our changes back to the community to further enhance the accounting module.  








> 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
>             Fix For: SVN trunk
>
>         Attachments: ledgersegment-2013-12-24.patch, ledgersegmentOct18.patch
>
>
> 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 was sent by Atlassian JIRA
(v6.1.5#6160)