One is the FA GUI form field called by it's label and the other is the table field name (#_sales_orders.comments) into which it gets populated.
4,502 01/24/2015 07:38:12 pm
Re: modify direct invoice later (3 replies, posted in Accounts Receivable)
Just keep making Sales Orders when you do the jobs and edit them at will. At the end of the month, make one delivery of all the "pending orders" and invoice the delivery.
4,503 01/24/2015 07:35:50 pm
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
Great!
If you put it into the company/0/reporting folder then it will apply only to Company 0.
If you you put it into the webroot's reporting folder then it will be for all companies.
4,504 01/24/2015 05:58:48 am
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
Try the files in this attachment - place the rep107.php in the company/0/reporting folder and the header2.inc (unchanged from previous mod) in the includes folder under it.
4,505 01/24/2015 05:27:19 am
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
Please provide the complete path of the file including file name that you have placed. Please note that the includes folder starts with a lower case "i".
Are you using a windows or linux server?
What are the versions of your php/mysql?
The files and folders in the webroot including the current file must be readable by the webserver process. There is already a header2.inc in the reporting/includes folder that must not be touched. The header2.inc attached in the 5th post here should be placed in the same path but under your company folder like: company/#/reporting/includes/header2.inc
4,506 01/23/2015 11:23:42 am
Re: Problem with Excel Reports (22 replies, posted in Reporting)
Just choose a define('XXXX','yyyy') in the calling script or one that already exists in FA and exit in the called script if it does not exist.
Sharing it in the public domain will help get rid of such vulnerabilities rather than live with "security thru obscurity".
4,507 01/23/2015 10:00:22 am
Re: Problem with Excel Reports (22 replies, posted in Reporting)
Thanks @carmelr: way to go! Now look at the security implications of anyone having a go at the excel file maker script xlssend.php! Have a check for something to indicate that the user is logged in.
4,508 01/23/2015 09:57:36 am
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
It is company folder and not ccompany (probably a typo). The missing includes folder must be created.
4,509 01/23/2015 06:35:35 am
Re: Cannot retrieve exchange rate when invoicing, delivery, receive items (6 replies, posted in Banking and General Ledger)
Thanks for the feedback.
4,510 01/23/2015 06:06:13 am
Re: Spanish (Chile) language v2.3.22 (1 replies, posted in Translations)
If it is small enough, upload the zip here or place a link to it here. You can also fork my github repo that has all the extensions and more and send in a pull request.
4,511 01/23/2015 06:04:36 am
Re: Bulk/Volume Discount (1 replies, posted in Accounts Receivable)
Can apply Discount at Payment time as well on Payment Allocation form. Have a service item as discount billed in with negative amount may be possible.....
4,512 01/23/2015 06:02:33 am
Re: Keyboard shortcuts not working in dashboard, exclusive & exclusive_db (15 replies, posted in Report Bugs here)
If it is small enough, upload the zip here or place a link to it here. You can also fork my github repo that has all the extensions and more and send in a pull request.
4,513 01/23/2015 05:58:56 am
Re: Problem with Excel Reports (22 replies, posted in Reporting)
I too am unable to duplicate this error in a test environment in Debian Squeeze, Debian Wheezy and XAMPP v1.7.3 in WinXP SP3 / Win7 / LXDE on Debian 7 Desktop and IE 8 and FF33.
@carmelr can post the code and location of file include here and/or in the wiki for anyone encountering this problem.
4,514 01/22/2015 07:09:03 pm
Re: Problem with Excel Reports (22 replies, posted in Reporting)
Replace the line with:
$abc = "Content-Disposition: attachment; filename='$filename'";
header($abc);
4,515 01/22/2015 06:23:38 pm
Re: Problem with Excel Reports (22 replies, posted in Reporting)
See my post of 4 seconds earlier than yours.
4,516 01/22/2015 06:20:38 pm
Re: Problem with Excel Reports (22 replies, posted in Reporting)
The only difference I find is that your $filename is quoted but the one in the code I posted is not!
Replace line 36 in reporting/prn_redirect.php
header("Content-Disposition: attachment; filename=$filename" );
with
header("Content-Disposition: attachment; filename='$filename'");
Or try swapping the single and double quotes in the replacement as well.
4,517 01/22/2015 06:14:34 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Non Field DB Data inclusion into reports and data entry forms for FA 2.3 is in my GitHub FAMods repo.
The enablers for it ported for FA 2.4 have been submitted to the devs and attached herein.
The actual implementation will vary across implementations and hence the devs may not want the specifics in my FAMods to be ported.
In FA 2.4, the function get_supplier_details_to_order() is in purchasing/includes/db/po_db.inc whereas in FA 2.3 it was in purchasing/includes/ui/po_ui.inc. Form customisations should still be made in the latter.
4,518 01/22/2015 06:03:51 pm
Re: Problem with Excel Reports (22 replies, posted in Reporting)
This is a browser encoding issue. Try to set the browser encoding to Western and then to Unicode and see the difference. Also what platforms and browsers have you tried? What about a browser in Linux? The major ones - IE 8, FF24+, Chrome (I haven't tesed it), etc should have their own quirks for encoding settings. Also see if there are any line endings that may be dos instead of unix style in the scripts.
Also try to upload a good xls file to the server and download it back to see if there are any differences.
4,519 01/22/2015 04:15:00 pm
Re: Report generator (3 replies, posted in Modules Add-on's)
Refer the Wiki's Reports Page.
1.1 - Aged Customer Analysis
1.2 Company's debts to the customers - Sundry Creditors
2.1 - Aged Suppliers Analysis
2.2 Suppliers debts to Company - Sundry Debtors
Also checkout Outstanding Transactions (Print Statements).
Sundry Debtors / Creditors -> GL Ledger Reports.
4,520 01/22/2015 04:01:25 pm
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
Attached is the header2.inc file that should be placed in the company/#/reporting/includes folder where # is your company number. This will make the condensed report only for the specific company and only for the invoice report whilst all other reports will not be affected.
If you have found this useful, consider donating to the project and help others in the forum as you gain experience.
4,521 01/22/2015 11:21:22 am
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
Checkout the attachment if that is what you want. It is a very dirty hack of the reporting file inclusions.
4,522 01/22/2015 09:48:06 am
Re: Decimal Point in Item Quantity Field (4 replies, posted in Accounts Receivable)
Setup => Display Setup => Decimal Places for Quantity.
Since you already have that setup correctly, it could be some js_cache issue as well. just delete all js files from company/#/js_cache folder and try. Also check the units of measure table for 0_item_units => there is decimals field there.
4,523 01/22/2015 09:40:10 am
Re: Sales Invoice Customization and Web Link remove from the Report (13 replies, posted in Setup)
For your second one, comment out line 322 in includes/reporting/pdf_reports.inc like:
// $this->Text($companyCol, $this->host);
This will suppress it from all reports that do not use the Headers2 function that includes the balance sheet (rep706.php).
If you want to selectively do it, then wrap it with appropriate "if" statement on document type.
Your files have been attached for the forum to be independent of external sources.
4,524 01/21/2015 08:14:51 pm
Re: FA v2.4 development (48 replies, posted in Setup)
The current snapshot installs correctly.
Current progress in FA 2.4:
Installs without errors.
Report Headers2 now have SetCommonData variables available for use.
All session current_user data now have safe fallbacks on no user.
In FA 2.3, the js cache for the company was in:
./company/0/js_cache/
but now in FA 2.4 it is in
./company/0/js_cache/1,
./company/0/js_cache/2,
..
This is to have separate folders ($user_id) for each user so that date format and other specifics will not overwrite / constrain one another.
The files generally in the /tmp folder - faillog.php, errors.log, etc are to be placed above the webroot and hence are not in the release / repo and get generated on usage based on settings in the config.php file.
4,525 01/21/2015 06:08:08 pm
Re: Textcart module (31 replies, posted in Modules Add-on's)
I had made an error in the replacement value and have corrected the post since. Have a go again now.