Modern Budget System for iDempiere

[redhuan d. oon]

Dear Happening Community,
I have completed part one of a modern budget system that is based on revenue as well, to control purchasing and GL Journal entry. The revenue of past years are used and it is configurable as to how many years back you want to base on (up to 100 years!) or if you set a specific revenue estimate for present year (for new clients or easy setup).
The revenue projection follows given formulas such as average, average add on to last year's, progressive, accumulative, or Year-to-date. There is also prorata setting for monthly breakdown.
The criteria to set a budget rule is based on the Purchase Order and GL Journal's fields such as Period (Month of purchase), BPartner, Accounting Element (GL only), Project, Activity, Campaign, Product (GL only, PO in phase II), OR ANY combination thereof!
The exception display is also highly informative as the above image shows.
This is a work in progress where in this next phase II, I am creating an Info-Window that shall pick out accounting facts that are above or below budget as an indicator of business operations and performance, ability to generate month-on-month budget rules based on past performances and of course more real world formulas such as even rolling previous months revenue control of present month spending. I even thinking of future intelligent behaviour where the system maps out a pattern of spending and cash flow movements to advice which BPartner payment terms will be most suited.
You can follow my progress in my forum here http://red1.org/adempiere/viewtopic.php?f=45&t=1798. Please record your ideas there for me to see if it is feasible for inclusion.

[redhuan d. oon]

I have uploaded a PDF guide that contains basically the functional specs in detail for review. The code is quite done to that and i am also making it ADempiere 360 series compatible. That should be announced in a week or so. Meanwhile any feedback as to improve the specs please do so before they are cast in first official plugin release.
Here is the link again in case the embedded one above is not working http://sourceforge.net/projects/red1/files/ADempiere%20PDFs/Budget.pdf/download

[Pedro Rozo]

Very good job Redhuan .. we hope to check/test it soon .

Regards

Pedro R

[redhuan d. oon]

I finally made ADempiere361FINAL compatible. Sources here: http://sourceforge.net/projects/red1/files/p2/Budget/
Explained from page 11 to 17 in the Budget.pdf
Also note that it is now Sales Target usable which allows to track sales documents if they reach defined target same way that purchasing documents surpass budgets, only that targets are good news, allowed to pass but logged.

[mostafa ahmed]

Great work,
I read on the budget.pdf follow the steps and try the new module on both Idempiere and Adempiere, but the following are messing:
1- the budget generator process in both (idempiere, adempiere)
2-in the budget confgurator window the following fields are missing(stop excess,include invoices,include payments, purchasing key) only in idempiere.

[Carlos Collazos]

Same here, Menu option for generator process does not show. Also the aforementioned fields.

REgards

---------------------------------
Carlos Collazos
coll...@gmail.com
----------------------------------

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/c34a299d-a8fc-4fe6-8300-298832af20f5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[redhuan d. oon]

You have to run Role Access Update. Anyway I made recent updates. Please check the Source Forge repo again. PDF also updated daily. Everything in the PDF should work as i took actual screenshots.
Thanks for reporting.

I now working on test engine but doing a accounting data generator first to populate years of accounts.

[redhuan d. oon]

Try to use the ADempiere361Final edition instead of iDempiere because i am working on ADempiere for the moment. I have put in the repo http://sourceforge.net/projects/red1/files/p2/Budget/ the BUDGET360_DB_postgres.jar which is the live database dump that has the same data setup including Spanish translation of the Messages.

[mostafa ahmed]

Thank you, I run role access update on Adempiere and it solve the issue, but it does not work for Idempiere v2
Also, in Idempiere I run create column from database and two fields show up (include invoices,include payments) . I understand that Idempiere is not fully updated at the moment. I will test the cycle on ADempiere361Final.
Thanks

[redhuan d. oon]

Yes those two new columns in BudgetConfigurator is the one of the new features to include all associated invoices and payments for budget control, very nice, but i am still at ADempiere360 because i have to prove the code to be working as much as possible before porting it back, as it can be confusing to do it midstream. Thus your feedback to me on anything in 361FINAL is crucial. It works quite well there so far.
I am now testing out the MontoToMonth generating of new budget based on 12 years of historical Accounting Facts. I have made a FactAcct generator for any account, working but as usual some hiccups, by today it will test me more things and then i work backward regress testing as every code change may have impact. The nice part here is that i have to refactor the code to be cleaner, more robust and discover new tricks or issues with the logic. It is getting complex because it is trying to solve everything as stated in the PDF. So feedback this few days while its hot is best.
Thank you so much. Good luck also!

[redhuan d. oon]

Major today. Please follow https://idempiere.atlassian.net/browse/IDEMPIERE-1813.  Automatic test data populating for Fact table also created to test GenerateBudget Year-on-year Mth2Mth budgeting.

[redhuan d. oon]

I put up this graphics overview for developers to decide if this budget module is suitable before proceeding further.

[redhuan d. oon]

 

FitNesse testing framework completed to make rigorous debugging and fixing quickly http://red1.org/adempiere/viewtopic.php?f=45&t=1798&p=8610#p8606 , after completing the magic window i will port this back to iDempiere and rewrite the Budget PDF guide. Fresh update of the ADempiere361 FINAl version is here http://sourceforge.net/projects/red1/files/p2/Budget/

[redhuan d. oon]

I have successfully converted the Budget360 back to iDempiere. ReadMe at https://sourceforge.net/projects/red1/files/p2/Budget/

[redhuan d. oon]

Final update to the completed PDF guide uploaded now: http://sourceforge.net/projects/red1/files/p2/Budget/
Please review and feedback any bugs.

[redhuan d. oon]

 Based on a real world input from Steven Sackett below,  i am going to make an Import Loader for B_BudgetPlanLine that imports also the Sales and Purchasing budget with Product and Qty options. :

I get the feeling that what you have done would suit a lot of use cases but there will still be old school people who do it in a spreadsheet and import so maybe you will need to support both methods in the end.  We have a customer using it in production and all the bugs are fixed... strangely the bugs were in the original imports and posting routines .. like GL Journal not posting qty .. and/or ignoring the sign on qty.

Hope to release that in a couple of days.

[redhuan d. oon]

Import Loader for Budget Plan Line from CSV format done. Sample CSV also provided. http://red1.org/adempiere/viewtopic.php?f=45&t=1798&p=8619#p8618