Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 183 of 199)
Topics by joe User defined search
Posts found: 4,551 to 4,575 of 4,967
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
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
Thank you very much Rob, I will start immediately fixing it into the core source at 2.1 unstable.
/Joe
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
In release 2.1 you can define Quick Entries for doing this. Look at the demo 2.1 unstable (link on the frontpage).
/Joe
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
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
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
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
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
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
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
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.
I understand your problem. At present we have no solution to this. We will, however, have a look into this.
/Joe
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
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
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
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
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
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
Hello, I think I must enter this discussion.
You made a deposit into the USD account, $100, and the balance sheet shows 120 CAD. Everything ok.
On the next day you make a transfer of 100 USD into the CAD account with this day exchange rate 110 CAD. Everything is ok. FrontAccounting doesn't know anything of the relationship between these transactions. The USD account reports 0 USD as a balance which is correct. But the balance sheet shows 10 CAD still there in the USD account. This is calculated based on the GL transactions. The first transaction was 120 CAD and the second one was 110 CAD. Due to that there are no relationship between the two transactions this would show up.
In this case the 10 CAD is really an exchange variance, but FA wouldn't know. On the other hand the balance sheet for the CAD account should show an evened out responding to the 10 CAD in the USD account. So the total for the cash/bank would be ok in domestic value.
I am not sure of how to solve this in a better way because of the missing relationship between the transactions.
A way around this would be to allow entrance of the exchange rate in the Bank payments/deposit/transfer forms so you can use the origin exchange rate when doing the transfer, but then again you have to remember the exchange rate.
When you use the customer/supplier payments the situations are eliminated due to the relationship between the transactions during allocation.
/Joe
Hello again,
Before you start rewrite things, please try to learn the program. It is capable of doing almost everything. And also read the news about the coming release 2.1.
/Joe
Sorry, there were some mistakes. Please download these files again:
/gl/gl_bank.php
/gl/gl_journal.php
/includes/ui/ui_view.inc
/Joe
Hello all,
I just want to say, that we do not recommend this approach. You have to replace everything you have changed when the next release is shipping.
It is much better to use one of the existing ones, and create this as a module. A module is just a way of extending the program in an easy way. And it can be installed from inside FrontAccounting.
/Joe
Now the files are committed to CVS unstable. Following files affected:
/gl/gl_bank.php
/gl/gl_journal.php
/gl/includes/db/gl_db_banking.inc
/includes/ui/ui_view.inc
/purchasing/supplier_credit.php
/purchasing/supplier_invoice.php
/purchasing/includes/ui/invoice_ui.inc
/joe
Posts found: 4,551 to 4,575 of 4,967
