Rapid ERP Development Files

THE SEXY CHARTMAKER BY RED1 - UNDER SPONSORSHIP by ZEESHAN HASAN of SYSNOVA, BANGLADESH.

SPECIAL THANKS TO PAUL BOWDEN, STEVEN SACKETT, AUSTRALIA FOR THE THINKING AND INTEGRATION OF CHARTBUILDER API INTO ADEMPIERE ERP PROJECT CODEBASE, NOW IN THE CORE OF IDEMPIERE THANKS TO EFFORT OF CARLOS RUIZ AND TEAM

THIS CHARTMAKER PLUGIN IS NOT IN CORE AND HAS NO IMPACT TO CORE CODE OR METADATA.

TRY IT NOW!
1. Download org.red1.chartmaker<timestamp>.jar. No need 2Pack as its embedded and auto pack-in during install.
2. INSTALL in OSGi console or via Felix Console of your iDempiere
3. Login SystemAdmin and see Chart Maker in the main menu.
4. Fill in:
	a. Name of Chart: 	Sales YTD
	b. Time: 		Month
	c. Table: 		C_OrderLine
	d. Category Column: 	DateOrdered
	e. ValueBreak: 		LineNetAmt>C_Order.M_Product.M_Product_ID
	f. Sql WHERE:		b.DocStatus IN ('CO','DR') AND b.AD_Client_ID=@#AD_Client_ID@ AND b.IsSOTrx='Y'
5. Press OK
6. Logout and login as GardenWorld Admin
7. Open Sales Rep Dashboard and view bottom chart Sales YTD
	a. If nothing appears it is because you have no test data. Create many sales orders on the fly via the SalesLead CRM plugin for SalesOrder.

Note that 4.f is optional. It is just for convenience for you to copy and paste and edit your preferred sql where clause.
Note that you need not toggle between SystemAdmin, if you follow the forum link below for my advice.

How to Change Chart Dimension
1. Go to SystemAdmin Chart Maker again.
2. Fill in same as above but for ValueBreak: LineNetAmt>C_Order.C_BPartner_ID
3. Relogin and view chart to see changed legend items in breaks

Refer screenshots and progress in http://red1.org/adempiere/viewtopic.php?f=45&t=1826

PLEASE SUPPORT MORE OF SUCH GREAT GOODIES - DONATE TO MY PAYPAL AT
red1@red1.org

May 9, 2016
Malaysia