I guess you forgot to do some allocation(s) for the payment before printing the cheques.
/Joe
4,576 01/15/2009 09:19:47 am
Re: Module : Chequing Accounts & Cheque Issue / Print (10 replies, posted in Modules Add-on's)
4,577 01/15/2009 12:46:46 am
Re: Modifying Sales Invoices vs Customer Credit Notes (14 replies, posted in Accounts Receivable)
Hello,
When you read a customer/supplier balance, you see the values in either charges or credits column. The right most column (Outstanding) gives you what the customer ows you. The 'Allocated' column is just a mirror of how much of the absulute value that has been allocated.
/Joe
4,578 01/13/2009 10:48:30 pm
Re: Year-End Closing Procedures (27 replies, posted in Banking and General Ledger)
My advise is when closeing fiscal year you should create an account (the last one of the expense accounts) and call Year End Result (or something like that). After you have done your depreciations and other year end posting you should create an income statement to see the calculated return.
This calculated return value should then be posted in debit on the newly created account and credited Retained Earnings account (counterwards if the calculated return is a loss).
If you later want an income statement for the closed year, the calculated return will be 0, but you will have the year result in the Year End Result account.
/Joe
4,579 01/13/2009 10:34:59 pm
Re: New Company SQL Failing (3 replies, posted in Setup)
I am not sure if I understand your question right? Did you use the Automatic install process? Have you created a new company? Are the company/0 and company/1 folders writable? Please give some more information.
/Joe
4,580 01/11/2009 05:01:35 pm
Re: Removing an item from the selection list, or changing an item code (2 replies, posted in Items and Inventory)
One solution would be to export all the company by company backup.
There is a freeware program called 'Replace'em, I guess it was named. Google the internet. There might be other similar free tools.
Here you can make a list of strings with old strings (item codes) and replacement strings (new item codes). This will only work if there are differences between all the original strings and the new strings. Remember also to use exact match.
Then you can run a replacement of all the values.
When you are ready and the created script looks correct, you can upload and restore the company again.
Because there are key constraints on the item_code in many places it is rather difficult to create a script to handle this.
The procedure above will work and you are sure you get all the values correct.
/Joe
BTW. Remenber to backup your company with another script before you begin, should it go wrong.
4,581 01/10/2009 09:26:46 am
Re: Bank Account Reconciliation (15 replies, posted in FA Modifications)
The CVS repository for unstable 2.1 is now updated with Bank Reconciliation. I will ask Janusz to upload this to Demo 2.1 unstable.
Here is how it works according to hugerobot:
1. Select the account you want to reconcile.
2. Get your bank statement (from the bank)
3. The first time you reconcile you will need to enter a reconcile date and a start balance...
Or 0 for the start balance if it is actually a new account.
4. Enter the end balance from the statement
5. Check entries that match the entries from your bank statement
6. If all entries match, 'Difference' should be 0. If it is, you are done and you
have reconciled your account for the period.
7. Click reconcile to record the reconciliation.
8. All checked items are recorded as reconciled in the bank_trans table and the ending balance
and reconciled date is recorded for that account in the bank_accounts table.
9. The next time you reconcile against a bank statement, the ending balance from the last
reconciliation is automatically used as the starting balance for this reconciliation..
You enter the ending balance for this reconciliation and repeat steps 5-8/Joe
4,582 01/10/2009 12:56:35 am
Re: Bank Account Reconciliation (15 replies, posted in FA Modifications)
Yes, I detected that. The beginning and ending balance was not updated into the table bank_accounts.
The file you copied from was from release 2.0.6, therefore I had to change the file a bit. I also eliminated some warnings. But it doesn't matter. This is only minor things, so please resend the file as you have it and I will extract the changes into the 2.1 file.
I think this is nice work, Rob.
/Joe
4,583 01/09/2009 10:49:40 pm
Re: Bank Account Reconciliation (15 replies, posted in FA Modifications)
Thank you very much Rob, I will start immediately fixing it into the core source at 2.1 unstable.
/Joe
4,584 01/09/2009 04:43:16 pm
Re: Bank Account Reconciliation (15 replies, posted in FA Modifications)
Hello again hugerobot. I like your persistence 
When you explain this it makes sense.
Please continue with the job you have started, and please try to not do it complicated. We try to use the KISS (keep it simple st....). I guess you know that expression, right? . We will then incorporate it in the program core.
We were planning to ship release 2.1 beta next week, but we are willing to wait for this wonderful thing. Do you think you can have it finished next week? We will not stress you, just curiousity.
/Joe
4,585 01/09/2009 04:22:33 pm
Re: Fixed Assets module (3 replies, posted in Wish List)
In release 2.1 you can define Quick Entries for doing this. Look at the demo 2.1 unstable (link on the frontpage).
/Joe
4,586 01/09/2009 08:34:41 am
Re: Formulae and Variables for (complex) templated transactions! (1 replies, posted in Wish List)
NO, there are no plans to extend the quick entries at present, but maybe in the future, when 2.1 has been released and tested.
/Joe
4,587 01/09/2009 08:32:07 am
Re: Accumulated Dimensions (on Reports)? (1 replies, posted in Dimensions)
No, this is not possible. But you can always write a special module that does that. Look on the Download Modules for how to do this.
/Joe
4,588 01/08/2009 10:14:15 pm
Re: Bank Account Reconciliation (15 replies, posted in FA Modifications)
Your ambition is very much appreciated. I cannot tell you, what is going wrong here, without seeing all the file, but if I understand you right, you want a column in the bank inquiry with checkboxes, to mark the transactions as reconciled, right?
In version 2.1, I think this could be included in the bank inquiry. We will then have to add a field in the bank_trans table, reconciled.
And when users click this column, the transaction should be updated with a mark.
I guess this would be the best way of doing it, right?
/Joe
4,589 01/07/2009 04:40:02 pm
Re: Credit notes operation issue (12 replies, posted in Accounts Payable)
Hello again,
We have now decided to follow your advice, btsui, and have implemented a period search in release 2.1. Default is 30 days back, but you can extend/change the search period.
The CVS repository for unstable is updated, and Janusz will update the demo 2.1 ASAP so you can see this issue working.
You can still credit the supplier invoices one by one in the supplier transactions. If you know the invoice number this is still more safe to use and you get the allocation done at once.
/Joe
4,590 01/07/2009 09:03:19 am
Re: Dimension vs Brach (5 replies, posted in Dimensions)
By setting the sales account to another sales account in the branch accounts you can follow the sales of this account. But if you want to follow the results (purchase) etc. of a branch you should consider using a dimension instead.
In our next release, 2.1, you can put a dimension on the sales documents (delivery and invoice) and this way you will get the purchase (delivery notes) and the sales (sales invoice) for this dimension as well.
As you know many of the General Ledger reports can be filtered by dimensions, so you get results for your dimensions.
/Joe
4,591 01/07/2009 08:51:18 am
Re: Credit notes operation issue (12 replies, posted in Accounts Payable)
Oh yes, I understand your issue.
In release 2.1 you will just have to credit the supplier invoices one by one in the supplier transactions. This is very fast and the allocations are done at once too. This is how we have solved this problem if you have too many invoice lines from a supplier when using the normal Supplier Credit Notes, you can just take them one by one in the supplier transactions.
/Joe
4,592 01/06/2009 11:08:49 am
Re: Dimensions (4 replies, posted in Setup)
You can have as many dimensions as you like, but you can only have a maximum of 2 on the same transaction line. See above for how to use them.
/Joe
4,593 01/05/2009 12:32:00 pm
Re: Credit notes operation issue (12 replies, posted in Accounts Payable)
This issue has been solved in release 2.1 unstable (not ready for release yet). It has been solved in the same way that on the customer side.
In the customer transactions you have an option to 'Credit This' for all the invoices that are not fully allocated.
The same option has been implemented in supplier transactions.
/Joe
I will ask Janusz to update demo 2.1 with this, so you can see for yourself.
4,594 01/05/2009 08:35:27 am
Re: Credit notes operation issue (12 replies, posted in Accounts Payable)
I understand your problem. At present we have no solution to this. We will, however, have a look into this.
/Joe
4,595 12/30/2008 05:39:13 pm
Re: What is 'tax-type' for ? (6 replies, posted in Banking and General Ledger)
Hello,
When we are talking about this tax issue, we are talking about release 2.1.
The tax_code on the accounts in 2.1 has changed from tax_type to tax_group. In release 2.1 the tax report is terminated with the same tax inquiry that are shown in the Banking and General Ledger tab. This tax inquiry is based on the GL transactions.
You can use the quick entries to whatever you need. If you mark the entry line as tax include, the amount are reduced by the tax amount that are set in the tax group that are set on the account. F.i. Let us say you have a Phone entry line and tax included and amount is 0. If you select this quick entry and an amount of 100 the phone account line is first reduced by the tag group (if only one tax item of 25%) so the amount is going to be 80 and the tax line is set to 20. This tax line is of course included in the tax report when this report is calculated.
Try to do some experiments. Nothing happens as long as you do not process the bank payment/deposit/journal entry.
The quick entries is very flexible. You can do whatever you want to do. You can have as many lines you want or need.
The tax entries we are talking about in the quick entries has nothing to do with the trans tax tables in the debtors/suppliers trans. These tables are used when you use the normal item entries in customer/supplier invoice. However, those tax entries are going to the GL tax accounts when saving the documents. And these taxes are also shown when looking at the tax inquiry.
Quick entries is only a way of automatic entrance of many GL entry lines. But used right, it saves you a lot of time.
/Joe
4,596 12/29/2008 09:37:24 am
Re: Importing via CSV - Exposed ! (6 replies, posted in Items and Inventory)
This tool is now available for download at the Download section - Miscellaneous page. I have converted the file from .xlsx to .xsl. This way it is more compatible with older versions of Excel as well as it can be used by Open Office Calc.
The instructions given by Qaiser above is also placed in a CSVImporting.txt file that is included in the package.
/Joe
4,597 12/24/2008 09:17:22 am
Re: Foreign currency transactions (20 replies, posted in Setup)
For easier navigating the General Ledger for Foreign Currency Accounts, we now stamp the memo field with 'Exchange Variance'.
CVS updated. Same file /gl/includes/db/gl_db_banking.inc
/Joe
4,598 12/23/2008 11:32:48 pm
Re: Considering FrontAccount (3 replies, posted in Setup)
Hello eviking,
I just want to add a couple of comments.
1. Inside the company setup (tab setup) there are fields for tax periods and how long back they go. You can just enter you own values here, then when selecting Tax Report in reports the selection period will correspond to that. In our next release 2.1 you can also make a screen inquiry of the tax report (you can see a demo here , demouser / password ).
2. The VAT is, as Janusz describe it, very professional and handles almost everything you can think of.
3. Again, the flexibility is mandatory for FrontAccounting. I think you can solve the constraints by setting up internal instructions about how to handle the various work flows. It should be possible to reprint invoices, both for own usage, and invoiceses can 'disappear' or get destroyed my mistake.
If you like the program after testing, you might want to translate the texts into Norwegian, right?
/Joe
4,599 12/23/2008 11:14:42 pm
Re: Foreign currency transactions (20 replies, posted in Setup)
The CVS repository (MAIN) is now updated. Affected file: /gl/includes/db/gl_db_banking.inc.
Don't be afraid when you see a greater exchange variance in the GL the first time. FA will sync the total balance in accordance with the respective foreign account the next time you make a bank /payment/deposit/transfer entry (no supplier/customer, they will be handled during allocations).
FA will always sync the GL account when entrying bank deposits/payments/transfer. This is done by comparing the foreign account balance multiplied by the rate of the entry date, and the GL account balance .
/Joe
4,600 12/23/2008 02:18:35 pm
Re: Foreign currency transactions (20 replies, posted in Setup)
Janusz and I have found a solution to this. The last transaction where a foreign account is involved it will update the GL account and put differencies on exchange variations. The CVS will later be updated.
/Joe