Topic: report generator

can some one guide me how to make new reports using report generator i am not expert on sql statemnet it is asking me for
can some one give me little guidance on it i am quick learner i will figure out rest i just need little basic hlep how to write sql statment with in frontaccounting plat form

Re: report generator

http://www.tutorialspoint.com/mysql/mysql_pdf_version.htm

Re: report generator

dude it will take me months to read all of that
thanks any ways i dont think there is solution to this problem i am facing of creating a sales report displaying 1 customer details.

Re: report generator

Try to list what fields you want - it may be possible to use the standard reports with appropriate filters for it.

Re: report generator

ok this is in my layman way
i want to select 1 customer
display list of items invoiced to that particular customer with in given dates

thats it. sounds simple but i dont know why this feature is not already included as it is very important for any business to summarise what they have been selling to each customer

6 (edited by apmuthu 04/13/2015 06:42:08 pm)

Re: report generator

Choose the Inventory Sales Report and choose your customer and the date range.
The Wiki page on FA Reports has the specific report 304 you want.

Navigate to:
Items and Inventory => Inventory Reports => Inventory Sales Report

Re: report generator

yes you are rights thanks for pointing it out but is it posible to remove cost and contribution column in that report ?

Re: report generator

Copy the rep304.php into company/#/reporting/rep304 and edit it there - # is your company number. It will override the original report file of the same name.