The entered date is closed or not in fiscal year.
can be
The entered date is not in active fiscal year.
3,501 06/26/2016 06:41:19 pm
Re: Migrated Close Period function from 2.4.RC1 to 2.3.25 (4 replies, posted in FA Modifications)
3,502 06/26/2016 06:38:50 pm
Re: Start and End Date on Print Statement (10 replies, posted in Reporting)
Reports that have no date ranges are for the entire period from the beginning of the active fiscal year till date. The Active Fiscal Year is set in the Company Setup.
3,503 06/26/2016 06:37:14 pm
Re: Getting grasp of FA (1 replies, posted in FA Modifications)
TCPDF is for reporting only.
FA uses it's own framework.
3,504 06/20/2016 03:48:54 pm
Topic: Adminer for FA (0 replies, posted in Modules Add-on's)
Adminer can be used effectively for FrontAccounting. The Adminer Editor can be leveraged to getting data into specific FA tables. It is available in GitHub.
phpLeaveManager is my example/tutorial for Adminer Editor that can be used as a template for managing FA Tables.
3,505 06/20/2016 03:44:19 pm
Re: Account Payable (1 replies, posted in Accounts Payable)
You have asked many questions to which you may find answers by consulting the wiki. Also search the forums here. Take support from consultants for implementation.
3,506 06/20/2016 03:40:03 pm
Re: EXCHANGE RATE SOURCE (3 replies, posted in Banking and General Ledger)
Refer this commit.
3,507 06/20/2016 06:38:54 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
When a direct invoice has been voided what policy do you expect for any payments received for that invoice till then?
Actually any payments received from the customer for that invoice should be either voided or re-assigned to be advances received on account before voiding any associated direct invoice.
Check the customer ledger account to see if the customer payment is still there and void it there if necessary.
@joe: What is the policy on treating customer payments received on voiding associated direct invoice?
3,508 06/18/2016 11:13:27 am
Re: How can I edit opening balance (bank account) via phpmyadmin? (3 replies, posted in Setup)
If there is an error in the opening balance of one account where did the contra entry go? The Balance Sheet should balance out and the difference might get into Cash on Hand. Pass a Journal Voucher to correct the error as on the first day of 2015.
Alternatively, re-open the previous year, make corrections there and then close the previous year and see what gives.
3,509 06/18/2016 11:09:57 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
Anything in the error logs?
3,510 06/17/2016 11:23:59 am
Re: How can I edit opening balance (bank account) via phpmyadmin? (3 replies, posted in Setup)
Pass a Journal Voucher correcting it.
How did you get the opening balance - by closing the previous year or by entering a JV in the current year?
3,511 06/17/2016 11:21:52 am
Re: ERROR IN MYSQL WHEN A CUSTOMER PAYMENT IS VOID (3 replies, posted in Report Bugs here)
Make a separate clean install of FA v2.3.25 and take a backup of the sql schema.
Compare the sql with that of your pre-upgrade v2.3.22 and see if there are any settings change.
Compare the sql/en_US-new.sql in FA v2.3.25+ with your Singapore CoA and see what differs.
3,512 06/17/2016 11:02:38 am
Re: Frontaccounting expert custom support and Training (1 replies, posted in Jobs wanted/offered, non-free offers)
Provide an ERD schema of the new tables your module has introduced along with a workflow diagram.
Where is the GitHub repo for others to take it forward?
What licence does it come with?
3,513 06/17/2016 10:55:26 am
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
In plain vanilla FA, there is no cheque number field. It must exist only in the Memo / Description field. You can make a module extension for yourself for the new field in the forms / reports with new tables in a 1:1 relationship with existing ones or extend the table schema for a new field. Such changed will break your upgradeability unless you also upgrade your module extension.
Attempting to live within the Memo / Description field can be done using the Inventory Bin hack listed in the wiki.
3,514 06/17/2016 10:48:41 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
Is there anyone facing this issue?
If there is a customer payment or bank deposit involved the amount should not be 0 (!=0). So where is the problem?
3,515 06/15/2016 06:25:55 am
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
Then treat the payment as on Account and pay by allocation with check number which would be searchable. For reporting by cheque number, you will have to parse it out into a custom report.
3,516 06/13/2016 02:12:23 pm
Re: Single, double quotes and other special characters replacements (8 replies, posted in Reporting)
@joe: what parts need to make it to the core?
3,517 06/12/2016 05:53:11 pm
Re: Release 2.1 - Extensions to FrontAccounting. How to? (6 replies, posted in Modules Add-on's)
Best way:
1. Take sql backup.
2. Manually make 1 entry.
3. Take another sql backup
4. Compare the backups and see what changed
5. Generate and execute MySQL statements (in phpMyAdmin, SQLyog, etc) to simulate these changes (Inserts / Updates) for all other entries to be imported.
3,518 06/12/2016 05:50:10 pm
Re: ERROR IN MYSQL WHEN A CUSTOMER PAYMENT IS VOID (3 replies, posted in Report Bugs here)
Which version of FA are you using?
The current stable one is v2.3.25+.
Which Chart of Account are you using?
Since it is related to another post, it is best if posted in that thread itself.
3,519 06/12/2016 05:44:13 pm
Re: FA 2.4RC1--Do not retrieve DB data in UTF (3 replies, posted in Setup)
In the Charts itself?
3,520 06/12/2016 05:43:07 pm
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
Use the Memo box with wordings being "Part of Ch No...."
3,521 06/12/2016 05:39:41 pm
Re: Career opportunity for an INTERNAL AUDITOR (opened to relocation) (1 replies, posted in Jobs wanted/offered, non-free offers)
Does the client use FrontAccounting or do they intend to do so?
This is not a general employment forum but specific to FA related work.
3,522 06/12/2016 05:37:15 pm
Re: Single, double quotes and other special characters replacements (8 replies, posted in Reporting)
Kindly provide code changes that worked.
It may be necessary to make the storage in the tables proper so that they do not get encoded multiple times like & => & amp; => & amp;amp; etc.
3,523 06/06/2016 04:53:56 am
Re: Single, double quotes and other special characters replacements (8 replies, posted in Reporting)
There is some code in FA where Polish characters are spared. Checkout includes/session.inc lines 312-332 in FA 2.3:
function html_cleanup(&$parms)
{
foreach($parms as $name => $value) {
// $value = @html_entity_decode($value, ENT_QUOTES, $_SESSION['language']->encoding);
if (is_array($value))
html_cleanup($parms[$name]);
else
$parms[$name] = @htmlspecialchars($value, ENT_QUOTES, $_SESSION['language']->encoding=='iso-8859-2' ? 'ISO-8859-1' : $_SESSION['language']->encoding);
}
reset($parms); // needed for direct key() usage later throughout the sources
}3,524 06/04/2016 06:00:48 am
Re: Single, double quotes and other special characters replacements (8 replies, posted in Reporting)
A full list is here.
A complete search and replace in the database is in order for such fields.
This is a known issue atleast in FA 2.3.
3,525 06/03/2016 12:09:00 pm
Re: Ubuntu 16.04 and php7.0 (1 replies, posted in Announcements)
@Digger: Thanks a ton!
@joe: This should be a sticky!
