Hello Alvin
What about credit the invoices in Customer Transactions? It is fast and secure.
/Joe
3,976 01/07/2010 04:28:16 pm
Re: Sale Return or Product exchange (4 replies, posted in FA Modifications)
3,977 01/07/2010 03:17:11 pm
Re: Vers2.1.2 Bug: possibility to create an invoice in closed Fiscal year (1 replies, posted in Report Bugs here)
You are right, Jackel7007. This bug has been there all the time.
It has been fixed in CVS Main and are going into release 2.2.3.
In the mean-time you can fix it in file /sales/create_recurrent_invoices.php.
After line 62
if (isset($_GET['recurrent']))
{insert the following lines
$date = Today();
if (is_date_in_fiscalyear($date))
{And after the end about line 99, insert the following lines.
}
else
display_error(_("The entered date is not in fiscal year."));So the previous code is inside the { and }.
/Joe
3,978 01/07/2010 02:27:23 pm
Re: producing a remittance (4 replies, posted in Accounts Payable)
Hello again, David. Vi have decided to include a document, Remittance, that does what you want.
This has been committed to CVS Main and will be included in release 2.2.3.
/Joe
3,979 01/06/2010 01:08:32 pm
Re: producing a remittance (4 replies, posted in Accounts Payable)
I guess David means a list of allocated items belonging to this payment. The Cheque Printing Module leaves a slip with these items at the bottom.
/Joe
3,980 01/05/2010 11:35:55 pm
Re: aged supplier report problem (3 replies, posted in Reporting)
Maybe you could run the Supplier Balances Report instead.
/Joe
3,981 01/05/2010 11:32:57 pm
Re: producing a remittance (4 replies, posted in Accounts Payable)
No, you will have to produce either a cheque (check printing module) or an Internet Bank Payment. We don't have any built-In fascility to do this because this is different from Bank to Bank.
/Joe
3,982 01/05/2010 03:19:32 pm
Re: aged supplier report problem (3 replies, posted in Reporting)
For Invoices and credit notes the due date is used as comparing to the end date. For payments it is trans date.
So if you have an invoice with trans date 01/01/2010 (MM/DD/YYYY) and a due date 01/10/2010 and an amount $1000 and an end date of 01/04/2010
this amount will show up under current.
If the end date was 01/12/2010 the amount will show up under 1 - 30 days. Given these operations I guess you can set the end date to display your needed information.
/Joe
3,983 01/05/2010 10:14:32 am
Re: repgen-2.2 error in tcpdf.php? (6 replies, posted in Modules Add-on's)
Hello again,
Enter the config.php file with an editor and set the $go_debug variable to 0 (when this is 1 FA prints the instructions to the pdf engine instead of the pdf file).
/Joe
3,984 01/04/2010 10:55:32 pm
Re: repgen-2.2 error in tcpdf.php? (6 replies, posted in Modules Add-on's)
Did you upgrade to the latest repgen for 2.2. There was an upgrade to this short after the release.
/Joe
3,985 01/04/2010 10:09:22 am
Re: Starting Sales Invoice Number (4 replies, posted in Setup)
Yes, you can. By using phpMyAdmin go to your database and company (table prefs). Enter debtor_trans and find your last transactions with type 10 (Invoice). You will probably find your last numbers here. Change these to follow your new number serie.
Remember to change these numbers also in table debtor_trans_details.
When FA is finding the next Invoice number it will take the MAX number + 1.
/Joe
3,986 01/04/2010 08:47:20 am
Re: Starting Sales Invoice Number (4 replies, posted in Setup)
The easiest way is to use the Reference number field as your invoice number. The next reference number for your invoice is set in Setup tab, Forms setup.
/Joe
3,987 01/03/2010 10:20:40 pm
Re: Year-End Closing Procedures (27 replies, posted in Banking and General Ledger)
The closing of a fiscal year is done automatically, when you close it. But you should wait until all the year-end entries has been done. When the year is closed you can no longer make entries into it.
The procedures will be updated on the wiki asap.
/Joe
3,988 01/03/2010 10:17:03 pm
Re: New Fiscal Year (1 replies, posted in Setup)
Sure, it is quite easy. Enter Setup tab, Fiscal Year. Create your new fiscal year.
Enter Company Setup, and select your new year.
When you are ready booking on the old year, you can later close it. After you have closed it you can no longer enter transactions into the old year.
/Joe
3,989 01/02/2010 10:44:28 pm
Re: Bug When Modifying Journal Entries (9 replies, posted in Report Bugs here)
The Journal Inquiry was rolled back to how it worked before the join of bank transactions.
/Joe
3,990 01/02/2010 10:41:24 pm
Re: Purchasing Pricing - How it works and how to use it! (25 replies, posted in Items and Inventory)
I guess you will have to split it up into different items. Or, as you say, an extension module.
/Joe
3,991 01/02/2010 04:33:34 pm
Re: osCommerce (59 replies, posted in Modules Add-on's)
Yes, maybe we can extend the global array, $installed_extensions, with access roles variables. I will discuss this with Janusz, when he is back in office.
/Joe
3,992 01/01/2010 09:11:16 pm
Re: osCommerce (59 replies, posted in Modules Add-on's)
There are no fixed rules regarding the asignment of values. Only the core values are starting at 1. So starting a bit up in the sequence seems to be the way of doing it. And checking with other similar modules that they do not share the same values.
/Joe
3,993 12/31/2009 11:48:08 pm
Re: chart of accounts in two languages (2 replies, posted in Banking and General Ledger)
No, I am afraid not.
/Joe
3,994 12/31/2009 08:57:47 am
Re: Proper Upgrade path (16 replies, posted in Installation)
Hello, I will try to explain how it works.
And I will explain it in an easy way.
After the fiscal year has come to an end and a new one is created, you may want to close the previous year when the last entries have been done.
Before that your assets have accumulated into $2000. The liabilities have reached $1500. The difference between these $2000 and $1500 is your Equity (or Net assets). $500.
Your revenues have reached $3000 and you expenses have reached $2500. Net income is $500.
Now you want to close the fiscal year. The Net Assets (or Equity) $500 is booked in credit on RETAINED EARNINGS (this account is accumulating the year net assets over years).
The Net Income, $500, will always be the same as the year net assets. So the debit booking of $500 is going to the PROFIT/LOSS YEAR.
When the fiscal year is closed you can no longer make entries into it.
/Joe
3,995 12/30/2009 11:46:02 pm
Re: Change in Taxes rate does not update Tax Group rate. (2 replies, posted in Report Bugs here)
A new file can be downloaded from CVS Main:
The fix is going into release 2.2.3.
/Joe
3,996 12/30/2009 11:03:15 pm
Re: Change in Taxes rate does not update Tax Group rate. (2 replies, posted in Report Bugs here)
Thanks Bryan, for pointing this out. We will have a look at this.
/Joe
3,997 12/30/2009 10:58:42 pm
Re: Proper Upgrade path (16 replies, posted in Installation)
Oops. This routine is inside the file /sql/alter2.2.php that is used when running Software Upgrade.
I haven't heard about problems here, and I find no spurious things here. The memo_ field is escaped.
I guess Janusz will look at this when he is back in office again.
Do you think you can fix the error, tom?
/Joe
3,998 12/29/2009 03:51:37 pm
Re: Proper Upgrade path (16 replies, posted in Installation)
You should be able to update directly. Just follow the instructions in update.html.
/Joe
3,999 12/27/2009 02:24:35 pm
Re: rate foreign currency balance end-year (5 replies, posted in Banking and General Ledger)
Hello ferre,
For your own safety you should download a fixed file from the CVS repository
/Joe
4,000 12/26/2009 09:48:52 pm
Re: rate foreign currency balance end-year (5 replies, posted in Banking and General Ledger)
First ensure you have different GL accounts associated with your Foreign Currency Bank Accounts.
Before doing the operations, you should check if there is an exchange rate for the transfer date. If not then get one.
Every time when you do a bank transfer the routine will check that the underlying GL Transfer against the current bank account are equal based on the date when the bank transfer is done. If this is not the fact, two GL transactions will be done covering the difference.
If you look at the Journal Entry after you have done the bank transfer (where there is a foreign currency involved and the exchange rate are different than an earlier one) there should be two transactions covering the diff.
/Joe