I forgot to mention. I added 3 columns to the 0_cust_branch table at the end
br_street, br_barangay, and br_town
1 01/16/2014 10:54:46 am
Re: Add new field in Customer branch (1 replies, posted in Accounts Receivable)
2 01/16/2014 10:52:59 am
Topic: Add new field in Customer branch (1 replies, posted in Accounts Receivable)
Hello. I would like to add a few field in customer branch. I want to break down address into street, barangay (village), town
I have edited sales/manage/customer_branches.php
The fields are appearing on the webpage but they dont seem to get saved on the table 0_cust_branch.
here are lines i added/changed
84 $_POST['default_ship_via'], $_POST['notes'], $_POST['br_street'], $_POST['br_barangay'], $_POST['br_town']);
96 $_POST['default_ship_via'], $_POST['notes'], $_POST['br_street'], $_POST['br_barangay'], $_POST['br_town']);
207 $_POST['br_street'] = $myrow["br_street"];
208 $_POST['br_barangay'] = $myrow["br_barangay"];
209 $_POST['br_town'] = $myrow["br_town"];
266 table_section_title(_("Addresses")); // added the 3 lines below
267 text_row(_("Street:"), 'br_street', null, 32, 30);
268 text_row(_("Barangay:"), 'br_barangay', null, 32, 30);
269 text_row(_("Town:"), 'br_town', null, 32, 30);
Are there anything else I need to change in this file or another?
3 09/27/2013 11:17:33 am
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
apmuthu - I have been looking at the previous topics regarding RepGen.
Firstly, I would just like to say thank you for the significant contribution you made in making this extension work. Kudos.
I am having trouble in using it, i guess you are in the best position to point me in the right direction.
here are my problems:
1. i tried making a report. My SQL statement is working fine when tested. but when i hit run i get a blank pdf file.
2. page definition for strings - store item button does not work. it does not save any item at all.
have checked debug - no error were recorded
4 09/27/2013 09:33:02 am
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
Thanks. apmuthu. Was able to make it run by manually inserting the table. now time to test the extension
5 09/24/2013 02:13:33 pm
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
thanks apmuthu. i was able to install rep gen and was able to access it. unfortunately stumbled into another problem on opening repgen
Debug mode database warning:
error code : 1146
error message : Table louie_Acc.xx_reports' doesn't exist
sql that failed was : SELECT * FROM xx_reports WHERE (typ = 'info' OR typ = 'block' OR typ = 'funct') ORDER BY id
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file: /home1/louie/public_html/ad/louie_Acc/includes/db/connect_db.inc at line 89
Should i manually add xx_reports to my database?
6 09/09/2013 12:50:51 pm
Re: Fixing Usage - report generator (40 replies, posted in Modules Add-on's)
Good day. Could you help me.
I tried installing repgen from Setup>maintenance>install extension. report generator did not appear, in the setup tab.
I tried manual install of repgen and followed https://frontaccounting.com/fawiki/index.php?n=Devel.FAReportGenerator, I still could not make rep gen appear in my setup tab.
any other tips?
7 09/09/2013 09:58:37 am
Topic: Report Gen Not Working (2 replies, posted in Reporting)
Good day can someone help me.
I installed RepGen using Setup>Maintenance>Install extension. It showed that it is installed.
On the Setup tab. I could not find Report Generator
Opened installed_extension.php at root
2 =>
array (
'name' => 'Report Generator',
'package' => 'repgen',
'version' => '2.3.9-3',
'type' => 'extension',
'active' => false,
'path' => 'modules/repgen',
I dont know where to start looking for the problem 