4,501

(5 replies, posted in Reporting)

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

(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.

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.

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.

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

(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

(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.

It is company folder and not ccompany (probably a typo). The missing includes folder must be created.

Thanks for the feedback.

4,510

(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

(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.....

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

(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

(22 replies, posted in Reporting)

Replace the line with:

$abc = "Content-Disposition: attachment; filename='$filename'";
header($abc);

4,515

(22 replies, posted in Reporting)

See my post of 4 seconds earlier than yours.

4,516

(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

(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

(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

(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.

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.

Checkout the attachment if that is what you want. It is a very dirty hack of the reporting file inclusions.

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.

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

(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

(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.