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
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by 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
Hello,
If PHP GetText is not installed on your OS, then a PHP file is created the first time the language is run. This PHP file maps the language PO file.
The gettext.php file is from an outside developer that has left the license GNU Lesser GPL, which is nearly unrestricted, however function _load_domain (private function) is called from the function add_domain. This function is always called with the correct language path parameter, which should be like this: /lang/xx_YY/LC_MESSAGES where xx is the language and YY is the country.
If the GETTEXT is not installed, there should be a file inside this path called xx_YY.php where the xx_YY.po file is mapped to readable php strings.
/Joe
But Rasmus, couldn't you just have 2 quick entries. One that does the first part and one that does the payment part.
You could call them by your supplier name and give the a suffix so you easily can find them. They will be just after each other in the list.
You can create these quick entries with the existing setup very easy.
The way you suggest, will just complicate things. Now it is quite easy for everybody to create them. And as there is no harm done when playing with it, you can do several trial and errors. The Journal Entry is first updated when pressing the process button.
/Joe
Please look at the Cash Sales Sticky topic in the beginning of this forum.
/Joe
It is a little scary to have different dates within a journal entry (transaction with the same journal entry no).
I am not sure if I fully understand your wishes. Shouldn't there be any allocations involved?
Please make a little more explanations so we don't miss anything. Ev. give an example.
/Joe
Send a short mail by the Contact Us form. I will return my email by replying and then you can send the attachment to me.
/Joe
Sorry for the extra, but we are afraid of email harvesting. So I am not revealing my email here.
Normally I do not give any advise of accounting. You should talk to an accountant or look at the sticky topic about accountancy. There are some links to how to use accountancy.
There are so many ways of doing the structure.
There is no need to enter an initial balance of 0.00. You can do a reverse in 2 ways. Just counterbook an earlier journal entry or void it in the Setup tab.
In the bank/cash accounts you can have foreign currency accounts. In the general ledger everything is in you home currency.
/Joe
Before you can enter journal entries on the fiscal year, you must go into company setup and select this fiscal year.
/Joe
In the item tab, you can enter some supplier specific info in the Purchase Pricing. You have a conversion factor where you can set 24 and regulate the internal price accordingly.
While this doesn't work fully in 2.0.x, it will be better supported in 2.1 that are under development. These fields will automatically be updated in 2.1 when creating PO receivals/invoices.
/Joe
Hello guys,
Thanks for your contributions. Yes, the information for the Supplier is quite modest. We will extend the info in the next release 2.1, that we are working on at present. The field Bank Account is just for what you have guessed. We will change the label to Bank name/account. It is an info field.
Regarding the list search feature enabled. You use a '*' and tab key to fill the combobox. Or you can search for partly strings. This is handy if you have a bunch of customers/suppliers and/or items.
We have internal been discussing the extra fields. We have decided to stall these implementations at present and concentrate on the accountancy flow through all the sections in FrontAccounting. The transactions are huge and with currency rates/discounts and taxes with a lot of decimals we must first secure that the flow works all around. This is the main task for us.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.