Is there somewhere to view a report or log of
1. Journal Inquiry modifications
2. Void entries
Thanks!
1 05/26/2016 12:09:19 pm
Topic: report on journal edits or voids (1 replies, posted in Banking and General Ledger)
2 05/26/2016 11:12:36 am
Topic: limit journal inquiry editing / modifying user permissions (2 replies, posted in Banking and General Ledger)
Hi, is there way to limit which group of users
/admin/security_roles.php?
have access to editing or modifying Journal Inquiry entries
/gl/gl_journal.php?ModifyGL=Yes&trans_no=4409&trans_type=0
so that I can stop the user from going back and editing journal entries depending on their level of access
3 04/20/2010 05:23:00 am
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
maybe a button to click to make it semi automatic
4 04/19/2010 03:53:11 pm
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
ok now that i have made all the posts i clearly understand how it works, and work it does.
at times it is a few cents out. max of 20 cents out. not sure why.
as you said it is
exchange_variance = (old_rate-current_rate)* account_balance.
OR probably easier to understand
Take your GBP balance in your bankaccount and multiply it with the exchange-rate from the last day of transactions. This should give the same balance as in the GL account.
I couldn't find a sticky or wiki on this topic so perhaps do one to explain how it all works.
5 04/18/2010 03:22:43 pm
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
Yes! It works just fine if I enter the GBP payments in sequentially by date as they appear on the bank statement. No extra exchange variance entries are coming up at all now that I am entering them in sequence.
You guys are amazing. You provide better support than any paid support I have experienced on top of a great free open source product. Time to donate 
6 04/18/2010 02:13:17 pm
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
ok i didn't get it before re: the account balance. so if the payments/deposits are not entered sequentially that could cause the numbers above?
i will void all the payments / deposits and enter them sequentially and let you know how that goes.
7 04/18/2010 10:07:32 am
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
Hi,
I am not using the GL account 1210 for any journal entries. It only has bank deposits and payments into it including the the opening balance. In addition GL account 1210 has one GBP bank account assigned to it.
Regarding your 2nd paragraph 'Be aware of the transaction date', I am not sure if I understand it, but in my example below I made a bank payment entry for GBP 39.47. I put the date in as the 9th feb which was when the payment was made, and the GL transaction details came out as below. I understand the 61.61 is the USD equivilant of GBP 39.47, which I guess makes the rate on the date GBP 1: USD 1.56. That's fine. It's just the bottom two automatic extra GL transaction details of 980.58 which seem incorrect.
5030 Hosting / Domains 61.61
1210 Lloyds GBP Account 61.61
1210 Lloyds GBP Account 980.58 Exchange Variance
4920 Foreign Exchange Gain 980.58 Exchange Variance
I also posted that exact same bank payment a couple of weeks earlier and it gave totally different results, which also seem incorrect. Below is the GL transaction details of that.
5030 Hosting / Domains 61.61
1210 Lloyds GBP Account 61.61
1210 Lloyds GBP Account 147.58 Exchange Variance
4920 Foreign Exchange Gain 147.58 Exchange Variance
As you can see the conversion of GBP 39.47 to USD 61.61 stays the same, which is fine, but then the bottom two automatic extra GL transaction details of 146.58 seem incorrect, and are totally different to 980.58
8 04/14/2010 05:40:04 am
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
another example of an actual post to a GBP account in out USD based accounts. The amount was entered today as GBP 39.47 and the date of the transaction entered was 9th Feb 2010. Below is what happened in USD.
5030 Hosting / Domains 61.61
1210 Lloyds GBP Account 61.61
1210 Lloyds GBP Account 980.58 Exchange Variance
4920 Foreign Exchange Gain 980.58 Exchange Variance
As you can see the foreign exchange gain has no bearing on the changes in the GBP:USD at that time or since then.
9 04/14/2010 04:52:08 am
Re: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
It seems the amounts it posts to the foreign exchange gain are incorrect. From my understanding of what you are saying, in my example above it would mean the change in the curreny rate between USD and GBP was 100% (or 1:1 to 2:1) which did not happen?
Also is there a way to stop the foreign exchange gain from automatically being posted, and then I can manually revalue it when I choose.?
10 04/06/2010 04:45:04 pm
Topic: Foreight Exchange Gain (17 replies, posted in Banking and General Ledger)
I am using 2.2.7 and also had this error in 2.2.6
I currently only use really use the banking and general ledger tab in front for bank deposits, bank payments and journal entries (and dimensions and setup occasionally).
My default currency is USD. I also have a GBP account setup.
At the moment any bank payments or deposits I make into the GBP account always add 2 extra journals. example below on the bottom 2 lines.
7901 Bank Charges 7 General 12.35 Bank Charges
1210 Lloyds GBP Account 12.35
1210 Lloyds GBP Account 12.35 Exchange Variance
4920 Foreign Exchange Gain 12.35 Exchange Variance
It is always the Foreigh Exchange Gain account that is posted to whether it is a payment or deposit made to the GBP account.
I think this is a bug that was not around in 2.2.5, although I don't want to post it to bugs until I understand more. I could just be missing something about this exchange variance thing.
11 02/16/2010 06:11:12 am
Topic: View Bank Deposits only or specific bank account only (1 replies, posted in Banking and General Ledger)
I have a number of staff only receipt or do bank deposits only. I would like them to
either
1. have access to be able to view bank deposits only.
or
2. have access to view a specific bank in 'Bank Account Inquiry'
Is that possible?
Garth
12 01/12/2010 08:35:57 pm
Topic: balance sheet moving totals and showing them incorrectly (1 replies, posted in Banking and General Ledger)
Hi,
I am using 2.2.2
I used the south african chart of accounts from your download section.
I have just finished doing 2009 books.
The profit and loss report is perfect.
The balance sheet balances and is almost perfect except ...
under Assets there are no totals for 'Investments' or 'Bank Accounts' or 'Intangible Assets'
under Liabilities 'Total Investments' and 'Total Bank Accounts' and 'Total Intangible Assets' appear, and they should not, and the totals in them do not seem to be related the total investments or bank accounts from assets. I have bolded this problem below. Is this a bug or ????
My 2009 balance sheet
---------
Assets
(500300 - 500399) - Motor Vehicles
500300 Motor Vehicles xxx
Total (500300 - 500399) - Motor Vehicles xxx
(500400 - 500499) - Office Furniture and Fittings
500400 Office Furniture and Fittings xxx
Total (500400 - 500499) - Office Furniture and Fittings xxx
(500500 - 500599) - Computer Equipment
500500 Computer Equipment xxx
Total (500500 - 500599) - Computer Equipment xxx
Intangible Assets
(600000 - 600100) - Goodwill
600100 Goodwill xxx
Total (600000 - 600100) - Goodwill xxx
(600200 - 600299) - Investments
600200 Investments xxx
(701000 - 710999) - Debtors Control Account
701010 Company Tax paid in Advance xxx
Total (701000 - 710999) - Debtors Control Account xxx
(701100 - 701999) - Sundry Debtors
701100 Sundry Debtors xxx
701150 Staff Loans xxx
Total (701100 - 701999) - Sundry Debtors xxx
(702000 - 702999) - Inventory Control Accounts
702000 Inventory Control Account xxx
Total (702000 - 702999) - Inventory Control Accounts xxx
(703000 - 703099) - Bank Accounts
703000 USD Bank Accounts xxx
703100 USD Cash xxx
703200 GBP Bank Accounts xxx
Total Assets xxxx
Liabilities
(801100 - 801199) - Sundry Creditors
801120 Provision for Directors Salaries xxx
Total (801100 - 801199) - Sundry Creditors xxx
(805000 - 805200) - Vat Control Account
805000 VAT Control Account xxx
Total (805000 - 805200) - Vat Control Account xxx
(807000 - 807999) - Accruals
807200 Other Accruals xxx
Total (807000 - 807999) - Accruals xxx
Total (703000 - 703099) - Bank Accounts xxx
Total (600200 - 600299) - Investments -xxx
Total Intangible Assets -xxx
Long-term Liabilities
902000 Loans from Directors xxx
Total Long-term Liabilities xxx
Total Liabilities xxx
Shareholders Equity
Stakeholders Equity
950200 Reserve xxx
Total Stakeholders Equity xxx
Calculated Return xxx
Total Shareholders Equity xxx
Total Liabilities and Equities xxx
============
my GL account groups
-------
5 Fixed Assets Assets
6 Intangible Assets Assets
7 Current Assets Assets
550 (500100 - 500199) - Land and Buildings Fixed Assets Assets
570 (500300 - 500399) - Motor Vehicles Fixed Assets Assets
580 (500400 - 500499) - Office Furniture and Fittings Fixed Assets Assets
590 (500500 - 500599) - Computer Equipment Fixed Assets Assets
600 (600000 - 600100) - Goodwill Intangible Assets Assets
605 (600200 - 600299) - Investments Intangible Assets Assets
615 (600400 - 600499) - Loans to Subsidiaries Intangible Assets Assets
650 (701000 - 710999) - Debtors Control Account Current Assets Assets
660 (701100 - 701999) - Sundry Debtors Current Assets Assets
670 (702000 - 702999) - Inventory Control Accounts Current Assets Assets
680 (703000 - 703099) - Bank Accounts Current Assets Assets
8 Current Liabilities Liabilities
9 Long-term Liabilities Liabilities
750 (801000 - 801099) - Creditors Control Account Current Liabilities Liabilities
760 (801100 - 801199) - Sundry Creditors Current Liabilities Liabilities
800 (805000 - 805200) - Vat Control Account Current Liabilities Liabilities
820 (807000 - 807999) - Accruals Current Liabilities Liabilities
10 Stakeholders Equity Shareholders Equity
1 Revenue Income
3 Sundry Income Income
101 (100000 - 149999) - Income Revenue Income
150 (200000 - 209000) - Sundry Income Sundry Income Income
2 Cost of Goods Sold Cost of Sales
120 (150000 - 190000) - Cost of Goods Sold Cost of Goods Sold Cost of Sales
4 Expenditure Expenses
175 (301000 - 310950) - Personnel Expenditure Expenses
200 (303000 - 303950) - Marketing Expenditure Expenses
225 (305000 - 305950) - Vehicle Expenses Expenditure Expenses
250 (307000 - 307950) - Office Expenses Expenditure Expenses
275 (309000 - 309950) - Services and Fees Expenditure Expenses
300 (401000 - 401950) - Communication Expenditure Expenses
325 (403000 - 403950) - Finance Expenditure Expenses
350 (405000 - 405950) - Depreciation and Amortisation Expenditure Expenses
==========
my GL Account Classes
-----------
1 Assets Assets
2 Liabilities Liabilities
3 Shareholders Equity Equity
4 Income Income
5 Cost of Sales Cost of Goods Sold
6 Expenses Expense
13 08/04/2009 03:35:35 am
Topic: email immediately after creation (1 replies, posted in Wish List)
Well done on a great system! I have searched the net for a long time to find this gem you have created.
I would like to be able to email an order, delivery note, invoice, payment etc .. directly after I have created it.
At the moment after creation of say an order I get
'View This Order'
'Print This Order'
'Make Delivery Against This Order'
'Enter a New Order'
I'd love it to be
'View This Order'
'Print This Order'
'Email This Order'
'Make Delivery Against This Order'
'Enter a New Order'
and it would email the relevant customer etc ...
instead of having to go to reports to do it.
Thanks,
Garth