No, the problem is in the SQL script for a new company. The AUTOINCREMENT counter should start with number 1. I guess it states no. 18 now and this has to be changed ASAP.
/Joe
4,401 05/23/2009 08:52:17 am
Re: Journal Entry start with No. 18 not No. 1 (1 replies, posted in Banking and General Ledger)
4,402 05/23/2009 08:50:00 am
Re: The way of designing the general ledger , accounts , groups , classes (3 replies, posted in Banking and General Ledger)
Hello,
I don't see the problem here. When retrieving the SQL it will only get the appropriate date. F.i. a Balance
sheet will only show accounts that are belonging to a group that are belonging to a class that are belonging to a balance sheet.
/Joe
4,403 05/22/2009 01:49:14 pm
Re: Setup:Maintenance: Attach Documents (3 replies, posted in Setup)
Yes, tom but this was on the wish list a year ago and we decided to implement it. One option was to scan supplier invoices. When processing a supplier invoice you are asked if you want to attach a scanned document.
But of course, you should be aware of the spce required.
/Joe
4,404 05/21/2009 08:50:17 pm
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
I hope you will find a solution. I'm afraid I can't help you with this. As you see it works on the demo server. The download filename is in English. I guess you will need some local expert help.
/Joe
4,405 05/21/2009 08:07:06 am
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
Fyi I just uploaded the last Arabic translations (also on sourceforge.net/projects/frontaccounting) from you to the Linux demo server . The Arabic language is set to utf-8. There is no problem downloading to Excel from here. If you have blocked for download, you may have to try twice to get the download. But no problems triggering the download.
Try for yourselves
/Joe
4,406 05/21/2009 07:17:12 am
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
Hello, Yes you are right. It doesn't trigger a download. At present I have no idea of why.
I don't know if setting $go_debug in config.php would detect errors or warnings, but you could try. You will not see normal reports but the internal PDF code if you use $go_debug.
Please also try the alternative XML interface, that can be dwonloaded from the Website.
/Joe
4,407 05/20/2009 09:32:15 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
When trying at the demo site, did you get the desired result?
There must be something here that is out of sync. Eventually try a new installation with a fresh downloaded setup installation from 2.1.2.
/Joe
4,408 05/20/2009 09:24:39 pm
Re: More controle accounts must be added to system and gl setup (1 replies, posted in Misc. Charts of Accounts)
infotechaccountant wrote:
there is some thing strange here , I know that there are some common practices when designing a software , one of them is the controlling accounts which is placed in system and gl setup windows , but really I surprised when I tried to make a new template for new company with new chart of accounts and some nominal accounts , when I opened the script related to my template I found that there is four accounts not mentioned there in the windows system and gl setup as the following:
1- Goods Received Clearing Account (1430)
2- Retained Earnings (2050)
3- Purchase Price Variance (4220)
4- Direct Labour (5000)why the developers not add those accounts to the windows of system and gl setup ?
These accounts were obsolete in release 2.1. Was original inplemented for future release. In release 2.2 some of them are used when closing fiscal years (automatic creating a balanced year). The Purchase price variance and the labour are not used at present.
infotechaccountant wrote:
what is the accounting cycle with the transactions ( must be published to know what is happening behind sense )
We are planning in future version to clean transactions when deleting fiscal years. Convert the deleted years transactions into Open Balances. Also cleaning other transactions.
infotechaccountant wrote:
what is the accounting system followed here is periodic inventory system or perpetual inventory system ?
if we are about manufacturing solution where is the costing methods of inventory like FIFO , LIFO , Weighted or Moving Average Method , Specific Identification Method ?
The Inventory system and the manufacturing solution are based on the average methods.
/Joe
4,409 05/20/2009 02:50:27 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
It seems to me that something is out of sync. Please set the $go_debug flag in fonfig.php to 1. You will not see the report with this debug flag, but the internal PDF code. But eventually eooros or warnings will show up on the page.
/Joe
4,410 05/20/2009 10:33:56 am
Re: Module : Chequing Accounts & Cheque Issue / Print (10 replies, posted in Modules Add-on's)
Please set the $go_debug flag in file config.php. This well catch eventually errors or warnings.
/Joe
4,411 05/19/2009 08:51:17 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
This should not be a problem.
Did you enter the correct period? Did you enter the dimension on a line with an income/costs type account?
Something must have been done wrong.
/Joe
4,412 05/18/2009 11:44:27 pm
Re: What transaction will involve with a customer credit note (1 replies, posted in Accounts Receivable)
If you credit through the stand alone menu Credit Invoice, then the link to the invoice is not there. The standard transactions are reversed in relation to the invoice. This credit note can be used for other allocations.
Yes you can credit a Direct Invoice. Here you can use the 'Credit this' link in Customer Transactions. At least as long as it is not allocated. Otherwise you must use the stand alone Credit Invoice.
4,413 05/18/2009 11:27:17 pm
Re: Inventory Item Status (7 replies, posted in Items and Inventory)
Yes, you are right Tom. The Advanced Manufactured items should be included in On Order as long as the WO is NOT closed (during productions the QOHs are updated). The normal assembly updates the QOHs at once, so there should be no update to On Order in this case.
The CVS Main repository is updated on Sourceforge.net. Affected file /inventory/inquiry/stock_status.php
Some other mb_flag checks are fixed too in CVS Main.
/Joe
4,414 05/18/2009 12:15:15 pm
Re: Work Order Flow (4 replies, posted in Manufactoring)
Yes, Tom, simple assembling does all the steps in one sweep.
/Joe
4,415 05/18/2009 12:11:33 pm
Re: explanation of some GL items (3 replies, posted in Banking and General Ledger)
Hello,
The Required date is only used in the Advanced Manufacturing. In simple assembling the required date is set to be the same date as the issuing date.
When ticking the Show Item Codes, the Item listboxes shows the item code in front of the item name.
/Joe
4,416 05/17/2009 02:04:30 pm
Re: Prompt payment discounts (2 replies, posted in Accounts Receivable)
Due to various rules on how to calculate the percent I will demonstrate how it works:
Customer A has marked 2.5% for prompt payment discount. We issue an invoice on $125.
You get payment from your customer A. A field indicates that customer A has prompt payment discounts on 2.5% (only informative field). You decide if this is a prompt payment and then it is up to you to split the fysical payment and the discount field (due to various rules on how to calculate ev. tax). If you want full 2.5% on $125 and you got $121,87 from Customer A you enter that in the first field and the discount $3,13 in the second field.
Now you process the payment and if you continue to immediate allocation you will see that everything end up right-
/Joe
4,417 05/15/2009 11:07:32 pm
Re: Arabic Translation for the Latest Version (10 replies, posted in Translations)
Thanks, and this translation is now available for download on
/Joe
4,418 05/15/2009 07:53:24 pm
Re: Dimensions from invoices etc. are not used in ledger (4 replies, posted in Dimensions)
i've just looked through all the reports that can be filtered by dimensions and everything works just like a charm.
Normally you don't see any dimension transaction in the Balance Sheet, unless you explicitly have entered them in the Journal Entry Form.
But they should show up in P&L Statement, GL Account Statement, trial balance report etc. and many inquiries, that can be filtered by dimensions.
Did you select correct periods?
Which reports showed an empty report.
This is the first time I have heard of any problems with this.
/Joe
4,419 05/15/2009 02:36:57 pm
Re: Dimensions from invoices etc. are not used in ledger (4 replies, posted in Dimensions)
If you put a dimension, either on an article or a client, it will automatically generate sales lines for these items. Please try a little harder to see how it works.
When you invoice, and if you put a dimension on the customer, this dimension is suggested. After you have created your invoice you can look at the GL entry.
The dimensions inside FA are powerful tools to follow a specific cost centre, project or whatever you use it for.
When you run a Balance Sheet or profit & loss statement, you can filter by dimension. There are other reports filtered by dimensions.
So please try again.
/Joe
4,420 05/14/2009 10:04:15 am
Re: Audit trail (3 replies, posted in Banking and General Ledger)
You will see the user id stamped into the memo field. This is only a simple audit-trail.
You can see it when running the Report, List of Journal Entries.
A more detailed one has been created for release 2.2 unstable.
So stay tuned for this to come.
/Joe
4,421 05/14/2009 06:10:48 am
Re: Advanced Date (1 replies, posted in Report Bugs here)
No, but in the next release 2.2 you can choose to set the time zone stamp on the print out date.
/Joe
4,422 05/13/2009 03:48:24 pm
Re: CashFlow repport /forecast (4 replies, posted in Wish List)
Sounds great alejreb,
yes and we, the developers, will monitor this thread also and try to help.
/Joe
4,423 05/13/2009 03:46:38 pm
Re: Dimension dates: what are they meant for (3 replies, posted in Dimensions)
I guess a minor bug showed up here. When I tested to close a dimension it was still shown in the lists around FA. It shouldn't and this is fixed in CVS Main trunk, affected file /includes/ui/ui_lists.inc
Be careful when closing a dimension mistakenly. It can only be restored (opened) by accessing the database directly f.i. with phpMyAdmin.
Thanks softechmatrix
/Joe
4,424 05/13/2009 03:19:33 pm
Re: Help with a meaning (1 replies, posted in Translations)
Yes you are and it is unlucky that we do not use the same English words on various places.
Good that you found out.
7Joe
4,425 05/13/2009 03:17:01 pm
Re: Dimension dates: what are they meant for (3 replies, posted in Dimensions)
The first date is the creation date for the dimension. The second date is the estimated end day. This is only an informative field. If you want to close a dimension you have to do that in the dimension form.
/Joe