Nice Fix.
5,402 09/18/2013 02:59:23 am
Re: Help required to create Chart of Accounts (5 replies, posted in Misc. Charts of Accounts)
Translated and taken from the Colombian link above
CHAPTER II:
CATALOGUE OF ACCOUNTSARTICLE 14. Encoding the Chart of Accounts is structured on the basis of the following levels:
Class: The first digit
Group: The first two digits
Account: The first four digits
Sub: The first six digitsThe classes that the first digit identifies are:
Class 1: Active
Class 2: Passive
Class 3: Heritage
Class 4: Income
Class 5: Expenditures
Class 6: Cost of sales
Class 7: Costs of production or operation
Class 8: Debit memorandum accounts
Class 9: Credit memorandum accountsClasses 1, 2 and 3 include the accounts comprising the balance sheet, the classes 4, 5, 6 and 7 correspond to the accounts of the state of gains or losses or income statement and Classes 8 and 9 detailed memorandum accounts .
Kindly note that the CoA given here will have variable length Account Codes which can be normalised to 6 digits by padding right with zeroes.
Class: 3 Heritage should be Share Capital or Stock Holders since Google translate of the Spanish patrimonio is poorer than Babylon's.
5,403 09/18/2013 02:51:02 am
Re: Trying to change Printing Profiles (3 replies, posted in Setup)
Lines 1109-1123 of sql/en_US-new.sql:
CREATE TABLE IF NOT EXISTS `0_print_profiles` (
`id` smallint(6) unsigned NOT NULL auto_increment,
`profile` varchar(30) NOT NULL,
`report` varchar(5) default NULL,
`printer` tinyint(3) unsigned default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `profile` (`profile`,`report`)
) ENGINE=MyISAM AUTO_INCREMENT=10 ;
--
-- Dumping data for table `0_print_profiles`
--
INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);Therefore an integer should be used and not a string. This was not an issue for older MySQL versions, but the later ones after Oracle took over seem to become more strict in such insert syntaxes. Wonder if NULL values would cause trouble (backward compatibility issues) or a mere 0 should suffice.
Lines 52-65 of admin/db/printers_db.inc:
function update_printer_profile($name, $dest)
{
foreach( $dest as $rep => $printer) {
if ($printer != '' || $rep == '') {
$sql = "REPLACE INTO ".TB_PREF."print_profiles "
."(profile, report, printer) VALUES ("
.db_escape($name).","
.db_escape($rep).","
.db_escape($printer).")";
} else {
$sql = "DELETE FROM ".TB_PREF."print_profiles WHERE ("
."report=" . db_escape($rep)
." AND profile=".db_escape($name).")";
}A prior integer cast for $printer may be in order here.
The offending line is line 60 in the above code:
.db_escape($printer).")";which may be replaced with:
. ($printer + 0) .")";5,404 09/18/2013 02:40:56 am
Re: Unable to email Purchase Order (9 replies, posted in Accounts Payable)
Try to debug the portion that makes the mail content and see if it is delivering it to sendmail. Also check for errors in the apache error log.
5,405 09/18/2013 02:38:55 am
Re: Installation issue. (2 replies, posted in Installation)
In your hosting control panel, create your database and use and assign privileges for the db to the user and make sure what prefix for them - mostly your hosting panel username or it's morph.
Then proceed to add them in to the next page.
5,406 09/17/2013 04:03:57 pm
Re: Company name not showing up in PO (10 replies, posted in Accounts Payable)
@Sriram: In your case you would be better off just downloading the PDF (Print PDF Report) instead of just clicking the View PO link. The downloaded PDF can be emailed to the customer as an attachment - this has all the bells and whistles - Company Name, Address, Logo, etc.
For what it is worth, the logo (jpg or png type) is in company/#/images folder and can be set at Setup -> Company Setup and it can be displayed with an <img src=.... type of html construct in the hack given in a previous post in this thread.
All the variables can be exposed by inserting a echo print_r($_SESSION, true); statement at the place where the hack is present to see what variables are visible to be displayed.
5,407 09/16/2013 09:06:37 am
Re: Permissions (6 replies, posted in Installation)
644 is sufficient for both if the user:group is webserver user (Apache).
5,408 09/15/2013 01:52:09 am
Re: Company name not showing up in PO (10 replies, posted in Accounts Payable)
I understand the logic of saving screen real-estate space for such popups. The Company Name is currently displayed on the PDF Documents quite nicely.
Accountants offices manage the books of many clients and sometimes their accounting client manager may have logged into more than one instance of FA to answer more than one client on the phone at nearly the same time.
Having such popups from more than one instance of FA would confuse the FA user in such an instance if there is no company identifier on the popup screen.
A config variable that enables company identification on popup screens would serve to alleviate requirements of such users.
5,409 09/14/2013 03:11:52 am
Re: downloading modules directly - possible ? (5 replies, posted in Modules Add-on's)
There appear to be no changes in the theme and chart files available in the repo.frontaccounting.eu site from 2013-08-21 to 2013-09-09. There seem to have been some changes made in these on 2013-09-04 and 2013-09-07 which did not persist thru till now. Any corruption in the said repo?
Also the textcart pkg seems to be packaging md5sums of the .git folder as well in the _init/files file.
The username is anonymous and the password is password for the repo.frontaccounting.eu site and is available in version.php file.
The latest (2013-09-09) version of the repo in zipped up form is available for download at my unofficial GitHub repo.
5,410 09/14/2013 02:12:16 am
Re: "Prepayment" payment type (6 replies, posted in Accounts Receivable)
The Sales -> Direct Invoice is the way to go for your case. Unfortunately, it assumes a cash sale and does not require any delivery. The non-payment status at generation time may be sent to a "Due NOW - Not Yet Paid" Cash account (tagged if necessary). When the payment arrives, it can be "applied" to the said entry.
Also please check that your Cash Only is not set to Prepayment type in Setup -> Payment Terms. It should be set to cash if you want to be able adjust the date of Direct Invoice before adding it - (Forum Post). Setting up another payment term with due after number of days set to zero may also work.
A similar case with Supplier Payments is discussed in this forum post and another.
Joe, having a generic "Payment DUE NOW" Cash/Bank Type Account in the CoA along with it's Net tagged receipts being part of the "allocate to invoice" list for applying payments would make it easy for such transactions.
5,411 09/14/2013 02:04:01 am
Re: Unable to email Purchase Order (9 replies, posted in Accounts Payable)
Joe, it would be better to introduce some SMTP email variables in the config file that can get propagated to the mail class to sort out such issues. Otherwise, those in the "not familiar with php" will be leftout.
Alternatively, anyone willing to sponsor the development of a PHPMailer class integration into FA - it may bloat the FA size a bit though even if those classes alone are "included".
5,412 09/13/2013 08:59:10 pm
Re: Unable to email Purchase Order (9 replies, posted in Accounts Payable)
Refer the wiki for EMail Issues.
5,413 09/13/2013 08:53:36 pm
Re: Company name not showing up in PO (10 replies, posted in Accounts Payable)
When dealing with multiple companies on the different tabs of a browser, it might come in handy and prevent confusion.
5,414 09/13/2013 08:51:57 pm
Re: Any pre-written reports for US Federal 940, 941 tax forms? (1 replies, posted in Reporting)
Try making a report in TCPDF directly or modify any of the existing report files in the reporting folder.
Alternatively since the PDFs are already available, try overlaying it with data from FA in TCPDF.
5,415 09/13/2013 08:44:16 pm
Re: shortcut menu hack for dashboard template (4 replies, posted in FA Modifications)
Paste the code between code tags like:
[ code]
code goes here
[ /code]
without the space between the "[" and the "code"
5,416 09/13/2013 08:18:57 pm
Re: Effect of Exchange Fluctuation on GRN Clearing Account (6 replies, posted in Items and Inventory)
Banking and General Ledger -> Currencies
choose to edit specific currency
uncheck Automatic exchange rate update
5,417 09/13/2013 08:14:00 pm
Re: Permissions (6 replies, posted in Installation)
Please check that there are 2 files called installed_extensions.php - one in the webroot and another in the company/#/ folder.
Also check who the apache user is and what apache group it belongs to.
What Server OS are you using and is it virtualised and if so what host is it on and is it on a shared kernel (OpenVZ, etc)?
5,418 09/13/2013 08:11:20 pm
Re: Invoice - How to issue invoice with partial payment (8 replies, posted in Accounts Receivable)
Create 2 sales orders which are editable. Delivery note can refer to both sales orders. The delivery note can then become single invoice.
5,419 09/13/2013 08:06:57 pm
Re: "Prepayment" payment type (6 replies, posted in Accounts Receivable)
Please read the wiki on the usage of the Tag feature. By accepting a payment on account from a customer, the entry will be of Cash/Bank receipt from customer and tagged to a particular Sales Order. When the actual invoice is raised, it can also be tagged to the same Sales Order. When the final payment arrives, it should also be tagged to the same Sales Order.
This Sales Order Tag's transactions can be viewed and the payments listed can then be applied to the Sales Invoice listed there.
1. Sales -> Sales Order Entry
2. Advance received tagged to Sales Order above
3. Sales -> Delivery Against Sales Orders (tagged to Sales Order)
4. Sales -> Invoice Against Sales Delivery (tagged to Sales Order)
5. Final Payment received tagged to Sales Order
5,420 09/13/2013 07:45:34 pm
Re: Company name not showing up in PO (10 replies, posted in Accounts Payable)
The Company Name gets printed in the Report - reporting/rep_209 in it's included file reporting/includes/pdf_report.inc by line 536:
$this->Text($companyCol, $this->company['coy_name']);Only the PO # gets printed in the View PO - purchasing/view/view_po.php by line 30:
display_heading(_("Purchase Order") . " #" . $_GET['trans_no']);Replacing line 30 in purchasing/view/view_po.php with:
display_heading($_SESSION['SysPrefs']->prefs['coy_name'] . "\n" . _("Purchase Order") . " #" . $_GET['trans_no']);will display the Company Name in the View PO as well.
Patch File and support files attached.
Joe - can you add it to the FA core?
5,421 09/12/2013 02:40:01 pm
Re: Company name not showing up in PO (10 replies, posted in Accounts Payable)
Have you setup the company name inside the Setup -> Company Setup.
Possibly Sales -> Template Delivery may be useful.
5,422 09/12/2013 02:35:58 pm
Re: Permissions (6 replies, posted in Installation)
Making all folders 755 and all files 644 would be okay if the owner:group is set to webserver (apache) user and group.
This way no 777 would be needed for any file or folder. The config.php (during install), installed_extensions.php (in webroot and in company/#/), lang/installed_languages.inc, cache/tmp files will generally get updated from time to time according to settings changed from the Web GUI.
5,423 09/12/2013 02:30:06 pm
Re: Effect of Exchange Fluctuation on GRN Clearing Account (6 replies, posted in Items and Inventory)
Will Quick Entries suffice or would it be better to turn off auto exchange rate acquisition for all or any specified currency?
5,424 09/12/2013 02:26:30 pm
Re: Supplier Payment With Bank Charges (5 replies, posted in Report Bugs here)
5,425 09/12/2013 02:21:46 pm
Re: Customization for FA (1 replies, posted in Jobs wanted/offered, non-free offers)
Contact any FA partner. Too much money has been printed - most developers are not interested in any - money just serves the likes of the Rothschilds.