Budget/forecasting function in accounting
Locked
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
|
|
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
|
|
In reply to this post by Hans Bakker
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 <[hidden email]> 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 |
|
|
In reply to this post by Hans Bakker
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 |
Re: Budget/forecasting function in accounting
|
|
In reply to this post by Jacopo Cappellato-5
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 <[hidden email]> 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
|
|
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 <[hidden email]> 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 <[hidden email]> >> 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
Administrator
|
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 <[hidden email]> > 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 <[hidden email]> >>> 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 >>>> |
|
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 < [hidden email]> 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 <[hidden email]> >> 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 <[hidden email]> >>>> 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
|
|
In reply to this post by Jacques Le Roux
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 < [hidden email]> 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 <[hidden email]> >> 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 <[hidden email]> >>>> 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 >>>>> >>>>> |
|
|
In reply to this post by Hans Bakker
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. |
|
|
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 |
Re: Budget/forecasting function in accounting
|
Administrator
|
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
|
|
In reply to this post by David H-O
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 < [hidden email]> 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. > |
|
|
In reply to this post by Sharan-F
Thanks Sharan Yes I have produced a few budgets in my time! ;-) I will try to put something together and forward it for review. Regards David Hughes-Owens IT Project Manager Stannah Management Services Tel: 01264 341268 Ext: 7068 From: Sharan-F [via OFBiz] [mailto:ml-node+[hidden email]]
Hi David If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Budget-forecasting-function-in-accounting-tp4666094p4673783.html
To unsubscribe from Budget/forecasting function in accounting,
click here. Click
here to report this email as spam. This email is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error, please delete it and notify the sender. Stannah Lift Holdings Ltd registered No. 686996, Stannah Management Services Ltd registered No. 2483693, Stannah Lift Services Ltd registered No. 1189799, Stannah Microlifts Ltd registered No. 964804, Stannah Lifts Ltd registered No. 1189836, Stannah Stairlifts Ltd registered No. 1401451. All registered offices at Watt Close, East Portway, Andover, Hampshire, SP10 3SD, England. All Registered in England and Wales. This message has been scanned for malware by Websense. www.websense.com |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |