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 184 of 200)
Topics by joe User defined search
Posts found: 4,576 to 4,600 of 4,985
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
Hello again, Rasmus.
I have now looked at the suppler invoice/credit note entry of gl_codes, and the quick entries are now implemented here as well.
I will later commit the files to CVS unstable. Just thought you wanted to know ASAP.
There is no problem removing the constraint of adding other bankaccounts in bank payment/deposit. Do you want me to do that. Everything is handled internally correct. The other bank transactions are done as well, just as they should.
/Joe
Actually you can if you have admin priviligies in Journal Entry, but your second suggest seems to be more adequate. I will have a closer look at this. I will be back when I have done my research.
/Joe
Use the Bank Payment in Banking and General Ledger tab. Select Miscellaneous and then you just select the cash/bank account and enter the amount in a selected office equipment account.
/Joe
Good, I guess you figured out how to solve the TCPDF error. Inside /reporting/includes/class.pdf.inc, about line 90, there are some fonts to use. Please find the ar_EG language and check that you have the files installed in the /reporting/fonts folder. If you need a font it can be downloaded from the download fonts section on the website.
/Joe
I guess the official word is utf-8. However, I am not sure if I can be of any help, though the language zh_CN (simplified) uses the charset GB2312. I have a test-copy running locally without problems with this.
I am glad that you have started the translation and please share it with us as soon as your project has majured.
Maybe other can help us. Just wait and see if any replies show up. I am also glad that you are able to experiment a bit.
Have you tried the reports? The PDF engine supports chinese without problems and it can use the adobe built-in cid0 fonts (must be separately installed) but after that the report size is reduced significantly. You can download a cid0 font on the download page. There are also instructions on how to do it.
/Joe
BTW, if you want to send something to us, just use our support contact us form on the site. When I return your email, you will be able to attach files to us.
This issue was solved after the topic was created. A button, Add All Items, were added, so all the items were added in one sweep.
This is inside Supplier Invoice.
/Joe
No, there are no periods defined in FA. You simply select your periods yourself when reporting.
There are no problems having JE posts on 12/31/2007. You don't need an extra period for the closing entries. Every entry you make should be available inside the fiscal year.
And if you don't want to close your years, the reporting will still work. All income/expense accounts do not have an open balance (unless you are selecting inside a fiscal year, then it will show open balance from the beginning of the fiscal year). Assets/Liabilities/Equity will always have incoming balances from the very beginning.
If you don't close your fiscal years, then the trial balance will have an unbalance opened balance, because the year closure is missing. But this is no problems for reporting.
But of course you should make the close balance when you are finished with a fiscal year. And after that you should close the fiscal year. In my opinion the best is to create an account in the expense as a last account and debit this and credit the retained earnings balance account with the revenue for the year (credit / debit if you have a loss).
/Joe
Posts found: 4,576 to 4,600 of 4,985
