lavanyakashyap,
Look into "reportico" report maker, all you need is :
1) very basic sql
2) run through the tutorial of less than 2 hours
3) know FA's database schema
1 07/24/2014 02:52:59 am
Re: Getting Consolidated Reports (4 replies, posted in FA Modifications)
2 06/30/2014 01:57:20 am
Re: Error when allocating payment (3 replies, posted in Report Bugs here)
Hi,
I get this error when trying to edit customer credit note from sales-customer transaction inquiry when I select a credit note without first choosing a specific customer. If i pick a specific customer so only transactions from one specific customer is showing, this goes away.
3 06/30/2014 01:54:12 am
Re: Error while trying to edit batched invoice (5 replies, posted in Report Bugs here)
Hi,
I have a gotten a similar error message but under different circumstances.
I 'transferred' information from my old software and this error happened when:
sales_order_details.id does not match up with debtor_trans_details.src_id (which i initially left as 0).
After I adjusted the src_id, eveything was fine and dandy again
4 06/11/2014 01:26:32 am
Topic: Customer Credit note doesn't print due to wrong trans type (0 replies, posted in Reporting)
Hi,
I cannot get the pdf report customer credit note to show(print):
The error with the query = "...WHERE trans.trans_no='8917' AND trans.type='10' AND trans.debtor_no=cust..."
The issue I believe is that customer credit notes should be trans.type='11'
Can somebody please tell me how to remedy this situation?
5 08/27/2013 08:10:30 am
Re: Items do not show up correctly on sales invoice (3 replies, posted in Items and Inventory)
Hi I found my problem.
in X_item_codes; item_code and stock_id must BOTH be equal to stock_id in X_stock_master when is_foreign=0
item_code may be different from stock_id if is_foreign=1 AND there is already another item code with is_foreign=0 and item_Code=stock_id
6 08/17/2013 02:49:25 am
Topic: Items do not show up correctly on sales invoice (3 replies, posted in Items and Inventory)
Hi,
I'm in the processing of changing the software my company is using. After importing all the data from old database to current one via phpmyadmin. I am able to select the items in "sales invoice" but when I click on add, instead of adding an extra line with the item i added w/ quantity and price etc, its just blank.
Any insight into this would be appreciated.
Thank you