6,076 10/10/2012 01:48:51 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
6,077 10/10/2012 01:16:01 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
Debian Squeeze cups-bsd package (1.4.4-7+squeeze1) can provide for lpd on the server only. In the scenario where FA is a hosted service and the Printer is in another location (office) behind a NAT, would this work without VPN-ing to reside on the same lan?
Also, lpd does not work (?) outside of the LAN.
As for ipp://, it is more of a URI and port (631 instead of 515 for lpd) difference.
6,078 10/09/2012 01:17:15 pm
Re: Assets Management (8 replies, posted in Wish List)
WebERP has an extensive Asset Register module - check out their project page.
6,079 10/09/2012 01:14:14 pm
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Contact me offline if you are still stuck - will need schema dump of all databases - zipped. Later will need data dump of standard data tables alone - zipped. Also see if you are using legacy roles or not.
6,080 10/09/2012 01:08:20 pm
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
Now this thread has got hijacked into a different topic - Sorry.
The demo sql file has the LPD host name as server. Must it be merely a domain, ip or URI? The newer ipp (internet Printing Protocol) supports Port 631. Used to print from one Ubuntu 12.04 to another behind a NAT (opening TCP and UDP ports 2207/8 and 631) and uses http://ip/printers/[print-queue-name] and it does not work on FA.
6,081 10/09/2012 02:22:13 am
Re: spotmouth provides free FA hosting (1 replies, posted in Jobs wanted/offered, non-free offers)
Please have a look at the www.owncloud.org stackato branch repo for the file:
owncloud/config/autoconfig.php - Ref
It illustrates how data from such a file can be injected into the last page of the install process and have the application setup easily - no needless checks at all - for standard same type installs.
This might be a useful addon for FA as well.
6,082 10/09/2012 02:13:21 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
On reports, the PDF/Printer option shows a PDF page that can be printed on a local printer from the local OS. On Printers / print Profiles, despite setting the main server printer, nothing prints. An example of printer profile usage would be nice.
6,083 10/09/2012 02:04:06 am
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Using RazorSQL, SQLyog Ultimate or Navicat Premium you can connect to and synch all companies to the existing default company's schema or create a dummy database with the contents of the latest en_US-new.sql file and check out the diffs and sync from there. As for the data diffs, it is a bit more tricky as standard data elements only must be considered. That is why I preferred a separate schema file and standard data sql file besides demo data sql file. For COAs only the standard data sql file needs to be different!
6,084 10/08/2012 07:13:04 pm
Re: Revisit Date Form Field defaults on report requests (2 replies, posted in Reporting)
Across Fiscal years is okay. Across non existant fiscal years is not okay....
6,085 10/08/2012 02:29:38 pm
Re: disabling journal reference (5 replies, posted in Setup)
If this is important, can it be selected by a config variable?
6,086 10/08/2012 02:27:53 pm
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Do a db schema diff check between the default company and the other companies.... or change the field value to be 2.3rc in each of the companies databases / tables
6,088 10/08/2012 02:15:02 pm
Re: Overdraft Limit Error (11 replies, posted in Banking and General Ledger)
Can we not have a config variable for this? Provided the error does not crop up for non negative values.
6,089 10/08/2012 02:13:04 pm
Re: doubt on pre-requisites (15 replies, posted in Installation)
Click on my nickname on the left of my post here in this thread and click on the email link. This forum does not have PM facility enabled for users.
Remove / rename the .htaccess file first and try.
6,090 10/08/2012 02:07:22 pm
Topic: Revisit Date Form Field defaults on report requests (2 replies, posted in Reporting)
Please revisit the logic behind and the choice of default date field values on all report requests before next release.
The following test scenario is used:
Active Fiscal Year: 01-01-2011 to 31-01-2011
Current Real Year: 2012 no entries or fiscal year defined for it yet
Browse to:
/reporting/reports_main.php
Check out each date field default that is illogical on each link.
Start Date should not be earlier than start Date of current active fiscal year for company.
End Date should not exceed last date of current active fiscal year for company.
All
Customer -> Print*
Supplier-> Print*
Manufacturing -> Print*
reports have no Start or End Date defaults when no transactions exist.
6,091 10/07/2012 12:48:46 pm
Re: Dimension and GL posting (2 replies, posted in Dimensions)
Thanks for the tip. Wikied it.
6,092 10/07/2012 12:37:22 pm
Re: doubt on pre-requisites (15 replies, posted in Installation)
The fa directory should have permissions 755 and not 555.
It must be chmod-ed to the webserver user.
In case the config.php file cannot be created, do so manually by copying the config.default.php as config.php and edit them. Also place the installed_extensions.php file in the the company/0/ folder after removing variables other than the array of extensions. Language extensions file may also have to be created. Manually execute the sql/en_US-new.sql file in mysql.
Any issues, provide access on PM.
6,093 10/07/2012 04:49:08 am
Re: New Fix-Asset Module (11 replies, posted in Modules Add-on's)
Nice re-ordered listing of menu links from other modules and quick entry equivalents for existing forms modified with filters to make a new module!
6,094 10/07/2012 04:26:55 am
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Please compare the existing sql dump for a new company with it's standard (non demo) data with that from the sql/en_US-new.sql file - it is possible that a few of the alter*.sql files did not go thru correctly. Also check the list of entries in each relevant alter*.sql file in order to see if they were missed out in the main en_US-new.sql file. This info is in the light of mismatched sql files corrected in Mercurial Changeset 3076 for the unstable branch.
In general, when any change is done to the database - schema or standard data - it should be faithfully propagated to the necessary alter*.sql file and the demo sql file as well. It is possible that some changes may solely reside in the demo sql file alone!
6,095 10/07/2012 04:19:10 am
Re: Having memo or comment displayed on bank_inquiry.php (4 replies, posted in Banking and General Ledger)
6,096 10/03/2012 08:41:45 am
Re: Date Format Modification to dd-Mmm-YYYY (18 replies, posted in FA Modifications)
Have bundled the consolidated unstable branch sql bugfix to help Janusz incorporate them easily - both changed files and patches.
6,097 10/03/2012 08:35:52 am
Re: version 2.4 (5 replies, posted in Wish List)
FA v2.4 alpha (current Mercurial last changeset 3072) has a few small sql bugs that need to be corrected before install and testing. There is a new 0_wo_costing table that finds no mention in the default COAs and the upgrade sql patch at sql/alter2.4.sql cannot be for executed even on a new install due to these discrepencies.
The unstable corrected files and patches are available here since BugFixes 1809-1812 in Mantis have access denied issues that prevent us from following it up.
Hope the community can now accelerate bugfixing the development branch v2.4 alpha using these snapshots.
6,098 10/03/2012 07:07:56 am
Re: Install/Activate Extensions, Theme, Chart of Accounts not working (27 replies, posted in Installation)
php.ini needs to be edited to enable openssl and Apache restarted.
Connection to internet is essential so that COAs and other goodies can be downloaded from the frontaccounting.eu repos.
6,099 10/03/2012 02:03:21 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
6,100 10/03/2012 01:49:22 am
Re: Date Format Modification to dd-Mmm-YYYY (18 replies, posted in FA Modifications)
Alternatively, it should suffice to delete the said js files from each /company/X/js_cache folder.
Well done Joe!
Unrelated aside:
Bugfixes 1809-12 pertaining to unstable became marked as access denied in Mantis. Bugfix 1785 is still awaiting inclusion. (Role Elevation from reporter to developer in Mantis has not alleviated the Access denied status for following up on the said Bugs)