You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Hans Bakker <h....@antwebsystems.com> on 2015/04/01 10:09:07 UTC
Budget/forecasting function in accounting
Good day,
we have a request from a customer to implement a full budget function
into accounting of which the entered values should also appear on the
standard P&L and balance sheet of a specific organization. Yes this is a
multi company accounting implementation.
Anybody any thoughts on this or would like to work with us? I did not
not yet discuss this with our customer if this function can be
contributed or not, i just would like to know if there is interest of
the OFBiz users in general.
Because i will be visiting ApacheCon in Austin in 2 weeks, we could also
discuss it there?
Regards,
Hans Bakker
CEO http://antwebsystems.com
Re: Budget/forecasting function in accounting
Posted by Jacques Le Roux <ja...@les7arts.com>.
Then the wiki would be the better place for this documentation, please David ask for contributor privileges if you need them.
Thanks
Jacques
Le 23/10/2015 08:49, Sharan-F a écrit :
> Hi David
>
> It sounds like you have a good practical understanding about how a budget
> function could really work based on real world business requirements;
> Perhaps it could be useful for you to document what you see as the
> requirements so that people could see what functioning solution should be
> able to do.
>
> I think it is sometimes hard to implement solutions without real world
> requirements or examples. With concrete use cases people can see how they
> could possibly build out or expand an existing solution and then hopefully
> submit patches around it;
>
> Thanks
> Sharan
>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4673783.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Budget/forecasting function in accounting
Posted by Sharan-F <sh...@gmail.com>.
Hi David
It sounds like you have a good practical understanding about how a budget
function could really work based on real world business requirements;
Perhaps it could be useful for you to document what you see as the
requirements so that people could see what functioning solution should be
able to do.
I think it is sometimes hard to implement solutions without real world
requirements or examples. With concrete use cases people can see how they
could possibly build out or expand an existing solution and then hopefully
submit patches around it;
Thanks
Sharan
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4673783.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Budget/forecasting function in accounting
Posted by Pierre Smits <pi...@gmail.com>.
Hi David,
I am inclined to agree. See also my review on the budget subject:
http://ofbiz.markmail.org/message/5p3n7kso6ngkolqb
Best regards,
Pierre Smits
*OFBiz Extensions Marketplace*
http://oem.ofbizci.net/oci-2/
On Wed, Oct 21, 2015 at 11:06 AM, David H-O <
david.hughes-owens@stannah.co.uk> wrote:
> I am looking at the accounting functionality as there is a proposal to use
> ofbiz in our overseas subsidiaries including the accounting elements.
>
> It is apparent that it is possible to enter accounting transactions with
> the
> various GL fiscal types to enter budgets and forecasts in Ofbiz accounting.
> However the OOTB accounting transactions do not allow for accounting tags
> to
> allocate budgets to specific areas of the business. Although, for us this
> would be a simple modification to incorporate the tags we already use and
> store against accounting transactions entities.
>
> I have also seen the budget entity tables, again these could be adapted to
> capture the accounting tag detail that would be required to set budgets
> against specific areas of the business and gl accounts. But these appear to
> have no link to entering budgets via the GL fiscal type method or the
> subsequent reporting.
>
> In addition, there is the approval process that I believe Hans introduced,
> but this does not provide the functionality that would be required to setup
> a revenue/operational budget.
>
> I have been in contact directly with Sharan to get her view on how budgets
> are supposed to be handled by Ofbiz.
>
> For me, it seems the gl fiscal type and creating accounting transactions is
> the simplest method of setting budgets and forecasts.
>
>
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4673673.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Budget/forecasting function in accounting
Posted by David H-O <da...@stannah.co.uk>.
I am looking at the accounting functionality as there is a proposal to use
ofbiz in our overseas subsidiaries including the accounting elements.
It is apparent that it is possible to enter accounting transactions with the
various GL fiscal types to enter budgets and forecasts in Ofbiz accounting.
However the OOTB accounting transactions do not allow for accounting tags to
allocate budgets to specific areas of the business. Although, for us this
would be a simple modification to incorporate the tags we already use and
store against accounting transactions entities.
I have also seen the budget entity tables, again these could be adapted to
capture the accounting tag detail that would be required to set budgets
against specific areas of the business and gl accounts. But these appear to
have no link to entering budgets via the GL fiscal type method or the
subsequent reporting.
In addition, there is the approval process that I believe Hans introduced,
but this does not provide the functionality that would be required to setup
a revenue/operational budget.
I have been in contact directly with Sharan to get her view on how budgets
are supposed to be handled by Ofbiz.
For me, it seems the gl fiscal type and creating accounting transactions is
the simplest method of setting budgets and forecasts.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4673673.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Budget/forecasting function in accounting
Posted by Adrian Crum <ad...@sandglass-software.com>.
How would a budget forecast fit in GL? What does your client have in min?
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 4/1/2015 9:09 AM, Hans Bakker wrote:
> Good day,
>
> we have a request from a customer to implement a full budget function
> into accounting of which the entered values should also appear on the
> standard P&L and balance sheet of a specific organization. Yes this is a
> multi company accounting implementation.
>
> Anybody any thoughts on this or would like to work with us? I did not
> not yet discuss this with our customer if this function can be
> contributed or not, i just would like to know if there is interest of
> the OFBiz users in general.
>
> Because i will be visiting ApacheCon in Austin in 2 weeks, we could also
> discuss it there?
>
> Regards,
> Hans Bakker
> CEO http://antwebsystems.com
Re: Budget/forecasting function in accounting
Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Everyone,
Accounting by its very nature is complex and elaborate. I would suggest
instead of creating a new component instead to do the following:
1- simplify the transaction processing screens and reports
2- move all the complexity into the setup screens (parameters) and reduce
menu entries.
So in essence, I think we can really simplify the accounting module by
hiding most stuff into the setup screens and not expose everything the way
we are doing it right now.
My 2 cents
On Thu, Apr 2, 2015 at 11:22 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> So this will be in continuation of https://issues.apache.org/
> jira/browse/OFBIZ-3169 right?
>
> I agree with Pierre to have a specialpurpose component. In the same
> spirit, should we not separate budget from forecasting?
>
> http://www.accountingtools.com/questions-and-answers/
> what-is-the-difference-between-a-budget-and-a-forecast.html
> http://www.financialpreneur.com/?p=162
> http://support.quickbooks.intuit.com/support/articles/INF13041
>
> My 2cts
>
> Jacques
>
> Le 02/04/2015 08:09, Pierre Smits a écrit :
>
>> Hans, All,
>>
>> Might I suggest to separate current budget entities and functionalities
>> from the accounting component into a separate (e.g. special purpose)
>> component. Current accounting application is
>> (screen-/user-experience-wise)
>> already overcrowded with a lot, and adding more might make it even more
>> complex to explain.
>>
>> Separation from accounting enables you and the rest of the OFBiz community
>> to offer the budgeting functionality as an optional to potentials and keep
>> the the additionals (functional documentation, manuals) as concise as
>> possible, while at the same time eventual JIRA issues contained and better
>> visible than when integrated in accounting.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Apr 2, 2015 at 3:57 AM, Hans Bakker <h....@antwebsystems.com>
>> wrote:
>>
>> Thank you all for your interest.
>>>
>>> We plan to follow chapter 8 of the data model resource book vol 1. I hope
>>> you understand that we first have to find out what this customer
>>> requires,
>>> then generalize the implementation and then i can present the result if
>>> the
>>> customer agrees to contribute it. From that point on, comments on the
>>> implementation can be implemented. The planned implementation with the
>>> customer is June this year.
>>>
>>> Now i see there is interest, I will keep you informed of any
>>> developments.
>>>
>>> Regards,
>>> Hans
>>>
>>>
>>> On 01/04/15 17:32, Jacopo Cappellato wrote:
>>>
>>> Interesting.
>>>> OFBiz has already a "Fiscal Gl Type" field in the transactions (with
>>>> possible values "Budget" etc...) but currently only "actual" type is
>>>> used.
>>>>
>>>> Jacopo
>>>>
>>>> On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com>
>>>> wrote:
>>>>
>>>> Good day,
>>>>
>>>>> we have a request from a customer to implement a full budget function
>>>>> into accounting of which the entered values should also appear on the
>>>>> standard P&L and balance sheet of a specific organization. Yes this is
>>>>> a
>>>>> multi company accounting implementation.
>>>>>
>>>>> Anybody any thoughts on this or would like to work with us? I did not
>>>>> not yet discuss this with our customer if this function can be
>>>>> contributed
>>>>> or not, i just would like to know if there is interest of the OFBiz
>>>>> users
>>>>> in general.
>>>>>
>>>>> Because i will be visiting ApacheCon in Austin in 2 weeks, we could
>>>>> also
>>>>> discuss it there?
>>>>>
>>>>> Regards,
>>>>> Hans Bakker
>>>>> CEO http://antwebsystems.com
>>>>>
>>>>>
Re: Budget/forecasting function in accounting
Posted by Pierre Smits <pi...@gmail.com>.
Forecasts are build from various sources: opportunities, quotes, requests,
orders, project execution plans.
These inputs are already covered in various (appropriate) components. They
should feed into various forecasts reports.
Budgets are - in general - defined once per period for the longer term (1
year often), and are adjusted based on actuals and forecasts.
Budgets (longer term) + forecasts (short term) <> actuals.
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Thu, Apr 2, 2015 at 10:22 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> So this will be in continuation of https://issues.apache.org/
> jira/browse/OFBIZ-3169 right?
>
> I agree with Pierre to have a specialpurpose component. In the same
> spirit, should we not separate budget from forecasting?
>
> http://www.accountingtools.com/questions-and-answers/
> what-is-the-difference-between-a-budget-and-a-forecast.html
> http://www.financialpreneur.com/?p=162
> http://support.quickbooks.intuit.com/support/articles/INF13041
>
> My 2cts
>
> Jacques
>
> Le 02/04/2015 08:09, Pierre Smits a écrit :
>
>> Hans, All,
>>
>> Might I suggest to separate current budget entities and functionalities
>> from the accounting component into a separate (e.g. special purpose)
>> component. Current accounting application is
>> (screen-/user-experience-wise)
>> already overcrowded with a lot, and adding more might make it even more
>> complex to explain.
>>
>> Separation from accounting enables you and the rest of the OFBiz community
>> to offer the budgeting functionality as an optional to potentials and keep
>> the the additionals (functional documentation, manuals) as concise as
>> possible, while at the same time eventual JIRA issues contained and better
>> visible than when integrated in accounting.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Apr 2, 2015 at 3:57 AM, Hans Bakker <h....@antwebsystems.com>
>> wrote:
>>
>> Thank you all for your interest.
>>>
>>> We plan to follow chapter 8 of the data model resource book vol 1. I hope
>>> you understand that we first have to find out what this customer
>>> requires,
>>> then generalize the implementation and then i can present the result if
>>> the
>>> customer agrees to contribute it. From that point on, comments on the
>>> implementation can be implemented. The planned implementation with the
>>> customer is June this year.
>>>
>>> Now i see there is interest, I will keep you informed of any
>>> developments.
>>>
>>> Regards,
>>> Hans
>>>
>>>
>>> On 01/04/15 17:32, Jacopo Cappellato wrote:
>>>
>>> Interesting.
>>>> OFBiz has already a "Fiscal Gl Type" field in the transactions (with
>>>> possible values "Budget" etc...) but currently only "actual" type is
>>>> used.
>>>>
>>>> Jacopo
>>>>
>>>> On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com>
>>>> wrote:
>>>>
>>>> Good day,
>>>>
>>>>> we have a request from a customer to implement a full budget function
>>>>> into accounting of which the entered values should also appear on the
>>>>> standard P&L and balance sheet of a specific organization. Yes this is
>>>>> a
>>>>> multi company accounting implementation.
>>>>>
>>>>> Anybody any thoughts on this or would like to work with us? I did not
>>>>> not yet discuss this with our customer if this function can be
>>>>> contributed
>>>>> or not, i just would like to know if there is interest of the OFBiz
>>>>> users
>>>>> in general.
>>>>>
>>>>> Because i will be visiting ApacheCon in Austin in 2 weeks, we could
>>>>> also
>>>>> discuss it there?
>>>>>
>>>>> Regards,
>>>>> Hans Bakker
>>>>> CEO http://antwebsystems.com
>>>>>
>>>>>
Re: Budget/forecasting function in accounting
Posted by Jacques Le Roux <ja...@les7arts.com>.
So this will be in continuation of https://issues.apache.org/jira/browse/OFBIZ-3169 right?
I agree with Pierre to have a specialpurpose component. In the same spirit, should we not separate budget from forecasting?
http://www.accountingtools.com/questions-and-answers/what-is-the-difference-between-a-budget-and-a-forecast.html
http://www.financialpreneur.com/?p=162
http://support.quickbooks.intuit.com/support/articles/INF13041
My 2cts
Jacques
Le 02/04/2015 08:09, Pierre Smits a écrit :
> Hans, All,
>
> Might I suggest to separate current budget entities and functionalities
> from the accounting component into a separate (e.g. special purpose)
> component. Current accounting application is (screen-/user-experience-wise)
> already overcrowded with a lot, and adding more might make it even more
> complex to explain.
>
> Separation from accounting enables you and the rest of the OFBiz community
> to offer the budgeting functionality as an optional to potentials and keep
> the the additionals (functional documentation, manuals) as concise as
> possible, while at the same time eventual JIRA issues contained and better
> visible than when integrated in accounting.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, Apr 2, 2015 at 3:57 AM, Hans Bakker <h....@antwebsystems.com>
> wrote:
>
>> Thank you all for your interest.
>>
>> We plan to follow chapter 8 of the data model resource book vol 1. I hope
>> you understand that we first have to find out what this customer requires,
>> then generalize the implementation and then i can present the result if the
>> customer agrees to contribute it. From that point on, comments on the
>> implementation can be implemented. The planned implementation with the
>> customer is June this year.
>>
>> Now i see there is interest, I will keep you informed of any developments.
>>
>> Regards,
>> Hans
>>
>>
>> On 01/04/15 17:32, Jacopo Cappellato wrote:
>>
>>> Interesting.
>>> OFBiz has already a "Fiscal Gl Type" field in the transactions (with
>>> possible values "Budget" etc...) but currently only "actual" type is used.
>>>
>>> Jacopo
>>>
>>> On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com>
>>> wrote:
>>>
>>> Good day,
>>>> we have a request from a customer to implement a full budget function
>>>> into accounting of which the entered values should also appear on the
>>>> standard P&L and balance sheet of a specific organization. Yes this is a
>>>> multi company accounting implementation.
>>>>
>>>> Anybody any thoughts on this or would like to work with us? I did not
>>>> not yet discuss this with our customer if this function can be contributed
>>>> or not, i just would like to know if there is interest of the OFBiz users
>>>> in general.
>>>>
>>>> Because i will be visiting ApacheCon in Austin in 2 weeks, we could also
>>>> discuss it there?
>>>>
>>>> Regards,
>>>> Hans Bakker
>>>> CEO http://antwebsystems.com
>>>>
Re: Budget/forecasting function in accounting
Posted by Pierre Smits <pi...@gmail.com>.
Hans, All,
Might I suggest to separate current budget entities and functionalities
from the accounting component into a separate (e.g. special purpose)
component. Current accounting application is (screen-/user-experience-wise)
already overcrowded with a lot, and adding more might make it even more
complex to explain.
Separation from accounting enables you and the rest of the OFBiz community
to offer the budgeting functionality as an optional to potentials and keep
the the additionals (functional documentation, manuals) as concise as
possible, while at the same time eventual JIRA issues contained and better
visible than when integrated in accounting.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Thu, Apr 2, 2015 at 3:57 AM, Hans Bakker <h....@antwebsystems.com>
wrote:
> Thank you all for your interest.
>
> We plan to follow chapter 8 of the data model resource book vol 1. I hope
> you understand that we first have to find out what this customer requires,
> then generalize the implementation and then i can present the result if the
> customer agrees to contribute it. From that point on, comments on the
> implementation can be implemented. The planned implementation with the
> customer is June this year.
>
> Now i see there is interest, I will keep you informed of any developments.
>
> Regards,
> Hans
>
>
> On 01/04/15 17:32, Jacopo Cappellato wrote:
>
>> Interesting.
>> OFBiz has already a "Fiscal Gl Type" field in the transactions (with
>> possible values "Budget" etc...) but currently only "actual" type is used.
>>
>> Jacopo
>>
>> On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com>
>> wrote:
>>
>> Good day,
>>>
>>> we have a request from a customer to implement a full budget function
>>> into accounting of which the entered values should also appear on the
>>> standard P&L and balance sheet of a specific organization. Yes this is a
>>> multi company accounting implementation.
>>>
>>> Anybody any thoughts on this or would like to work with us? I did not
>>> not yet discuss this with our customer if this function can be contributed
>>> or not, i just would like to know if there is interest of the OFBiz users
>>> in general.
>>>
>>> Because i will be visiting ApacheCon in Austin in 2 weeks, we could also
>>> discuss it there?
>>>
>>> Regards,
>>> Hans Bakker
>>> CEO http://antwebsystems.com
>>>
>>
>
Re: Budget/forecasting function in accounting
Posted by Hans Bakker <h....@antwebsystems.com>.
Thank you all for your interest.
We plan to follow chapter 8 of the data model resource book vol 1. I
hope you understand that we first have to find out what this customer
requires, then generalize the implementation and then i can present the
result if the customer agrees to contribute it. From that point on,
comments on the implementation can be implemented. The planned
implementation with the customer is June this year.
Now i see there is interest, I will keep you informed of any developments.
Regards,
Hans
On 01/04/15 17:32, Jacopo Cappellato wrote:
> Interesting.
> OFBiz has already a "Fiscal Gl Type" field in the transactions (with possible values "Budget" etc...) but currently only "actual" type is used.
>
> Jacopo
>
> On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com> wrote:
>
>> Good day,
>>
>> we have a request from a customer to implement a full budget function into accounting of which the entered values should also appear on the standard P&L and balance sheet of a specific organization. Yes this is a multi company accounting implementation.
>>
>> Anybody any thoughts on this or would like to work with us? I did not not yet discuss this with our customer if this function can be contributed or not, i just would like to know if there is interest of the OFBiz users in general.
>>
>> Because i will be visiting ApacheCon in Austin in 2 weeks, we could also discuss it there?
>>
>> Regards,
>> Hans Bakker
>> CEO http://antwebsystems.com
Re: Budget/forecasting function in accounting
Posted by Jacopo Cappellato <ja...@hotwaxsystems.com>.
Interesting.
OFBiz has already a "Fiscal Gl Type" field in the transactions (with possible values "Budget" etc...) but currently only "actual" type is used.
Jacopo
On Apr 1, 2015, at 10:09 AM, Hans Bakker <h....@antwebsystems.com> wrote:
> Good day,
>
> we have a request from a customer to implement a full budget function into accounting of which the entered values should also appear on the standard P&L and balance sheet of a specific organization. Yes this is a multi company accounting implementation.
>
> Anybody any thoughts on this or would like to work with us? I did not not yet discuss this with our customer if this function can be contributed or not, i just would like to know if there is interest of the OFBiz users in general.
>
> Because i will be visiting ApacheCon in Austin in 2 weeks, we could also discuss it there?
>
> Regards,
> Hans Bakker
> CEO http://antwebsystems.com
Re: Budget/forecasting function in accounting
Posted by Sharan-F <sh...@gmail.com>.
Hi Hans
It sounds interesting as I know implementing budget functionality has been
discussed before and think something really basic exists at the moment.I
would be keen to be in the loop about the discussions and any potential
ideas.
Thanks
Sharan
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4666126.html
Sent from the OFBiz - User mailing list archive at Nabble.com.