Journals & GL useability

[David McNeill]

I'm attempting to setup a new Ofbiz as an ERP.

In the General Ledger, I'm struggling to find the substance of it.

Key areas that I can't locate

* Entering an actual ledger journal - create a new GL direct transaction
(not from source AR, AP)

* Ledger Account balance enquiry

* Active ledger tree - clickable nested tree of accounts with balances
by period

* Ledger transactions display by account

It looks close in

Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
Accounts

Nice tree, but show me the money, and with a period selector.

This area seems 'setup' focused, not user focused.

Accounting Manager / Main is filled with list and show options, but none
GL related.

Documentation doesn't give any hints either...

https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup


        Creating ledger transactions.(to be completed)

And no mention at all of loading initial GL opening balances, which
would have to be second step after chart setup. Is this not possible?

Or do I need to write GL entry / view screens myself?  The data model
seems complete, the back end UI not really.

Am I missing something here? Or is OfBiz more web commerce with light
back end, ready for further customisation prior to actual use?

I'm totally committed to open source, need to deploy an ERP &
Accounting, and keep coming back to re-evaluate OfBiz  because it has
good community, stable Apache ownership, good database schema, good web
engine.  Just seems not ready for every day back end use by my
accounting team.

Comments anyone?

David

[Scott Gray-3]

Hi David,

In my personal experience I'm yet to fully implement GL functionality for a
client, although that isn't saying much because most of the contracts I've
been involved in span multiple years so we're only talking a few projects
really.

We'll often start working on it by mapping transactions to the appropriate
accounts and then it eventually falls down the client's priority list as
the crunch comes on towards going live.  If the mappings do make it through
to production then it's been for used for exporting to an external
accounting system.

I think you'd almost certainly need to fill some gaps and customize some
screens.  If you're looking to contribute then anything would be
appreciated, whether it's requirements, gap analysis, design, feature
implementations or whatever.

Again solely from my experience, OFBiz tends to serve as a base platform
for companies needing to build something quite specific where existing out
of the box solutions no longer meet their needs.  A few examples I've been
involved in:
- Employee rewards/recognition as a service
- Large scale event management (e.g. trade shows)
- Gift card buy/sell platform
- MLM

Regards
Scott

On 14 January 2017 at 21:31, David McNeill <[hidden email]> wrote:

> I'm attempting to setup a new Ofbiz as an ERP.
>
> In the General Ledger, I'm struggling to find the substance of it.
>
> Key areas that I can't locate
>
> * Entering an actual ledger journal - create a new GL direct transaction
> (not from source AR, AP)
>
> * Ledger Account balance enquiry
>
> * Active ledger tree - clickable nested tree of accounts with balances by
> period
>
> * Ledger transactions display by account
>
> It looks close in
>
> Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
> Accounts
>
> Nice tree, but show me the money, and with a period selector.
>
> This area seems 'setup' focused, not user focused.
>
> Accounting Manager / Main is filled with list and show options, but none
> GL related.
>
> Documentation doesn't give any hints either...
>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apach
> e+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup
>
>
>        Creating ledger transactions.(to be completed)
>
> And no mention at all of loading initial GL opening balances, which would
> have to be second step after chart setup. Is this not possible?
>
> Or do I need to write GL entry / view screens myself?  The data model
> seems complete, the back end UI not really.
>
> Am I missing something here? Or is OfBiz more web commerce with light back
> end, ready for further customisation prior to actual use?
>
> I'm totally committed to open source, need to deploy an ERP & Accounting,
> and keep coming back to re-evaluate OfBiz  because it has good community,
> stable Apache ownership, good database schema, good web engine.  Just seems
> not ready for every day back end use by my accounting team.
>
> Comments anyone?
>
> David
>
>
>
>

[Pierre Smits]

Hi David,

See inline.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Sat, Jan 14, 2017 at 9:31 AM, David McNeill <[hidden email]> wrote:

> I'm attempting to setup a new Ofbiz as an ERP.
>
> In the General Ledger, I'm struggling to find the substance of it.
>
> Key areas that I can't locate
>
> * Entering an actual ledger journal - create a new GL direct transaction
> (not from source AR, AP)
>

https://ofbiz-vm2.apache.org:8443/accounting/control/newAcctgTrans?organizationPartyId=Company


>
> * Ledger Account balance enquiry
>

https://ofbiz-vm2.apache.org:8443/accounting/control/PartyAccountsSummary

>
> * Active ledger tree - clickable nested tree of accounts with balances by
> period
>
> * Ledger transactions display by account
>
> It looks close in
>
> Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
> Accounts
>
> Nice tree, but show me the money, and with a period selector.
>
> This area seems 'setup' focused, not user focused.
>
> Accounting Manager / Main is filled with list and show options, but none
> GL related.
>
> Documentation doesn't give any hints either...
>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apach
> e+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup
>
>
>        Creating ledger transactions.(to be completed)
>
> And no mention at all of loading initial GL opening balances, which would
> have to be second step after chart setup. Is this not possible?
>

Opening balances can be treated as accounting transactions, with
transaction date being the first date of the starting period.

>
> Or do I need to write GL entry / view screens myself?  The data model
> seems complete, the back end UI not really.
>
> Am I missing something here? Or is OfBiz more web commerce with light back
> end, ready for further customisation prior to actual use?
>
> I'm totally committed to open source, need to deploy an ERP & Accounting,
> and keep coming back to re-evaluate OfBiz  because it has good community,
> stable Apache ownership, good database schema, good web engine.  Just seems
> not ready for every day back end use by my accounting team.
>
> Comments anyone?
>
> David
>
>
>
>

[Sharan Foga]

Hi Dave

Welcome to the community!

A while ago I created a  couple of free basic quickstart OFBiz Accounting guides. They are for older versions of OFBiz but I don't think accounting has changed too much. This one is on the wiki

https://cwiki.apache.org/confluence/display/OFBIZ/Quick+Start+-+Basic+Accounting+Setup

And I'll email you offline, the other one.

Thanks
Sharan

On 2017-01-14 09:31 (+0100), David McNeill <[hidden email]> wrote:

> I'm attempting to setup a new Ofbiz as an ERP.
>
> In the General Ledger, I'm struggling to find the substance of it.
>
> Key areas that I can't locate
>
> * Entering an actual ledger journal - create a new GL direct transaction
> (not from source AR, AP)
>
> * Ledger Account balance enquiry
>
> * Active ledger tree - clickable nested tree of accounts with balances
> by period
>
> * Ledger transactions display by account
>
> It looks close in
>
> Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
> Accounts
>
> Nice tree, but show me the money, and with a period selector.
>
> This area seems 'setup' focused, not user focused.
>
> Accounting Manager / Main is filled with list and show options, but none
> GL related.
>
> Documentation doesn't give any hints either...
>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup
>
>
>         Creating ledger transactions.(to be completed)
>
> And no mention at all of loading initial GL opening balances, which
> would have to be second step after chart setup. Is this not possible?
>
> Or do I need to write GL entry / view screens myself?  The data model
> seems complete, the back end UI not really.
>
> Am I missing something here? Or is OfBiz more web commerce with light
> back end, ready for further customisation prior to actual use?
>
> I'm totally committed to open source, need to deploy an ERP &
> Accounting, and keep coming back to re-evaluate OfBiz  because it has
> good community, stable Apache ownership, good database schema, good web
> engine.  Just seems not ready for every day back end use by my
> accounting team.
>
> Comments anyone?
>
> David
>
>
>
>

[Bahaa Alamood]

Hi Sharan,

can you share  the other document with me as well?


On 1/31/2017 5:20 AM, Sharan Foga wrote:

> Hi Dave
>
> Welcome to the community!
>
> A while ago I created a  couple of free basic quickstart OFBiz Accounting guides. They are for older versions of OFBiz but I don't think accounting has changed too much. This one is on the wiki
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Quick+Start+-+Basic+Accounting+Setup
>
> And I'll email you offline, the other one.
>
> Thanks
> Sharan
>
> On 2017-01-14 09:31 (+0100), David McNeill <[hidden email]> wrote:
>> I'm attempting to setup a new Ofbiz as an ERP.
>>
>> In the General Ledger, I'm struggling to find the substance of it.
>>
>> Key areas that I can't locate
>>
>> * Entering an actual ledger journal - create a new GL direct transaction
>> (not from source AR, AP)
>>
>> * Ledger Account balance enquiry
>>
>> * Active ledger tree - clickable nested tree of accounts with balances
>> by period
>>
>> * Ledger transactions display by account
>>
>> It looks close in
>>
>> Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
>> Accounts
>>
>> Nice tree, but show me the money, and with a period selector.
>>
>> This area seems 'setup' focused, not user focused.
>>
>> Accounting Manager / Main is filled with list and show options, but none
>> GL related.
>>
>> Documentation doesn't give any hints either...
>>
>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup
>>
>>
>>          Creating ledger transactions.(to be completed)
>>
>> And no mention at all of loading initial GL opening balances, which
>> would have to be second step after chart setup. Is this not possible?
>>
>> Or do I need to write GL entry / view screens myself?  The data model
>> seems complete, the back end UI not really.
>>
>> Am I missing something here? Or is OfBiz more web commerce with light
>> back end, ready for further customisation prior to actual use?
>>
>> I'm totally committed to open source, need to deploy an ERP &
>> Accounting, and keep coming back to re-evaluate OfBiz  because it has
>> good community, stable Apache ownership, good database schema, good web
>> engine.  Just seems not ready for every day back end use by my
>> accounting team.
>>
>> Comments anyone?
>>
>> David
>>
>>
>>
>>

[Sharan Foga]

Hi Bahaa

Yes sure. I'll send it to you.

Thanks
Sharan

On 2017-01-31 11:24 (+0100), Bahaa Alamood <[hidden email]> wrote:

> Hi Sharan,
>
> can you share  the other document with me as well?
>
>
> On 1/31/2017 5:20 AM, Sharan Foga wrote:
> > Hi Dave
> >
> > Welcome to the community!
> >
> > A while ago I created a  couple of free basic quickstart OFBiz Accounting guides. They are for older versions of OFBiz but I don't think accounting has changed too much. This one is on the wiki
> >
> > https://cwiki.apache.org/confluence/display/OFBIZ/Quick+Start+-+Basic+Accounting+Setup
> >
> > And I'll email you offline, the other one.
> >
> > Thanks
> > Sharan
> >
> > On 2017-01-14 09:31 (+0100), David McNeill <[hidden email]> wrote:
> >> I'm attempting to setup a new Ofbiz as an ERP.
> >>
> >> In the General Ledger, I'm struggling to find the substance of it.
> >>
> >> Key areas that I can't locate
> >>
> >> * Entering an actual ledger journal - create a new GL direct transaction
> >> (not from source AR, AP)
> >>
> >> * Ledger Account balance enquiry
> >>
> >> * Active ledger tree - clickable nested tree of accounts with balances
> >> by period
> >>
> >> * Ledger transactions display by account
> >>
> >> It looks close in
> >>
> >> Accounting Manager / Global GL Settings / Chart of Accounts / Navigate
> >> Accounts
> >>
> >> Nice tree, but show me the money, and with a period selector.
> >>
> >> This area seems 'setup' focused, not user focused.
> >>
> >> Accounting Manager / Main is filled with list and show options, but none
> >> GL related.
> >>
> >> Documentation doesn't give any hints either...
> >>
> >> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-accountingSetup
> >>
> >>
> >>          Creating ledger transactions.(to be completed)
> >>
> >> And no mention at all of loading initial GL opening balances, which
> >> would have to be second step after chart setup. Is this not possible?
> >>
> >> Or do I need to write GL entry / view screens myself?  The data model
> >> seems complete, the back end UI not really.
> >>
> >> Am I missing something here? Or is OfBiz more web commerce with light
> >> back end, ready for further customisation prior to actual use?
> >>
> >> I'm totally committed to open source, need to deploy an ERP &
> >> Accounting, and keep coming back to re-evaluate OfBiz  because it has
> >> good community, stable Apache ownership, good database schema, good web
> >> engine.  Just seems not ready for every day back end use by my
> >> accounting team.
> >>
> >> Comments anyone?
> >>
> >> David
> >>
> >>
> >>
> >>
>
>