76 Topic by bobloblian

(3 replies, posted in Banking and General Ledger)

Due to the need to get a feature working in another software on my server, I am now using php7.  This forced my hand on fa, so I put 2.4 and am working through it.  There are some things I really really like, like the little magnifying glasses everywhere for searching, those are awesome, there are some things I am struggling with, like trying to figure out how to get my dashboard back.

Anyway, today I am starting to make entries (keeping track of course), and in making a journal entry - moving funds from chequing account to shareholders account - I am presented with something called "counterparty".  This is a drop down menu, it contains one item, and that item is an organization that happens to be both vendor and customer.  I don't know what counterparty is, and I have no idea why only this one option is listed.  Can someone enlighten me?

Go to forum: Banking and General Ledger

77 Reply by bobloblian

(4 replies, posted in Wish List)

Agreed, a popup on log on would be an ideal solution.

Go to forum: Wish List

78 Reply by bobloblian

(4 replies, posted in Wish List)

Hi Apmuthu,

not as far as I can tell.  Under the sales tab there is a "create and print recurrent invoices" link, under there I have to scroll though my list and find current invoices, then click the little icon to send them...

I would rather they didnt' send automatically, though, it is good to know what is being sent before it gets sent...

Go to forum: Wish List

79 Topic by bobloblian

(4 replies, posted in Wish List)

Good Day,

I find I don't check my recurring invoices frequently enough, and sometimes I am several days (weeks) late sending out recurring invoices.  Some kind of alert when logging in letting me know I have invoices that need to be processed would be super handy.  Or even better, since I don't log into FA every day, an email alert.

I currently use the dashboard reminders for AP transactions, I will use those as a work around, just need to find time to enter them all...

Go to forum: Wish List

80 Reply by bobloblian

(2 replies, posted in Banking and General Ledger)

In case some one benefits from it, or in case I forget and need to look it up again, the flow that seems to work:

do a bank account transfer from visa=>USD account
bank payment: to misc; from USD bank account; choose GST in CoA, enter USD
bank payment: to misc; from USD bank account; choose bank fees in CoA, enter USD

Go to forum: Banking and General Ledger

81 Topic by bobloblian

(2 replies, posted in Banking and General Ledger)

Hello,

I posted a while ago about getting a correct quick-entries formula, which Leland was kind enough to answer (thanks Leland!).  Unfortunately, I never did figure a satisfactory work flow, which leads me to believe I  probably didn't ask the correct question to begin with. 

I am a CAD company.  One supplier I deal with works it so that I have to deposit money into an online account that works in USD, and when I buy a product from them, they take the money out of that account.  While it is not a real bank account, for my purposes it works like one and I would like to reconcile against it, so I set up a USD bank account in FA to represent it.

When I put money into the account of said supplier, they take CAD from my visa and deposit a USD value into the account.  If I want to put $100USD into the account, the way it is recorded on their statement is as a credit to the account for 108.25, and a debit of $3.25 as a handling fee, and another debit of $5.00 is taken for GST. 

I tried doing this entirely by journal entry but after a bunch of times trying to work out how, I figured out that that smells like a bad idea.

So I trawled the forums and found that I shouldn't be using a journal entry for this, but a payment/deposit/transfer instead, and indeed under bank account transfers I see what I am looking for to take CAD money from visa and put it into the USD bank account.  But I don't understand how to record the 3.25 into banking fees account and the 5.00 in the GST account, both of which are coming from the USD bank account into my native CAD CoA accounts?  I seem stuck back at making journal entries.

What would be the best way to enter this into FA?

Go to forum: Banking and General Ledger

82 Topic by bobloblian

(5 replies, posted in Banking and General Ledger)

Hi,

I am trying to make a quick entry for a journal entry with a percentage calculation, but it's not calculating the values I want.

By way of example, in the journal entry, I want to credit one account for 108.25.  the corresponding debits should be 5.00 for tax, 3.25 for service fees, and 100.00 goes into an asset account. 

I set up a quick journal entry and added the following quick entry lines:

1. % amount of base, reduce base: 3.25%
2. Taxes included, reduce base: choose GST(5%)
3. remainder: into my asset account

Now when I go to make a journal entry, enter 108.25 into the quick entry line and press go, I get:

3.52 for service fees
4.99 for tax
99.74 into the asset account

or if I swap the percentage and tax lines:

5.15 for tax
3.35 for service fees
99.75 into the asset account

It seems the tax is calculated from the remainder value, but the percentage is not.  Is there a way to get it to work like I want, preferably without putting in a dummy tax account?

Go to forum: Banking and General Ledger

83 Reply by bobloblian

(3 replies, posted in Wish List)

Hi Apmuthu,

Thanks for responding.

under sales=>customer transaction inquiry=>view sales invoice, I find an invoice date and a due date, but no indication that the invoice was sent by email.  Maybe I am not looking in the right spot...

Normally I record this information in my job tracking software, but it recently happened that I was checking on an overdue invoice, and I didn't record if an invoice got sent or not.  So I have to assume I didn't send it, rather than knowing if it was sent or not.

It also happens once in a while where I would like to be able to say to a customer an invoice was sent on this date, then this date, then this date.  Thankfully I have very few customers where this is necessary, but it is good to have some evidence that I did my part when dealing with the one or two who need it...

So it would be a useful feature, I think...

Go to forum: Wish List

84 Topic by bobloblian

(3 replies, posted in Wish List)

when viewing an invoice, it would be good to be able to see an email history of when an invoice was sent.

Go to forum: Wish List

85 Reply by bobloblian

(2 replies, posted in Accounts Receivable)

no time for working on this right now, but I just had to adjust another payment date and this is the output I wasn't able to paste last time

/var/www/fa.computerisms.ca/sales/includes/db/cust_trans_db.inc:188:     display_backtrace()
/var/www/fa.computerisms.ca/includes/banking.inc:165:     get_customer_trans('141','12')
/var/www/fa.computerisms.ca/includes/ui/allocation_cart.inc:219:     exchange_variation('12','141','10','204','2015/03/19','105','2')
/var/www/fa.computerisms.ca/sales/customer_payments.php:267:     (allocation Object)->write()

Go to forum: Accounts Receivable

86 Topic by bobloblian

(2 replies, posted in Accounts Receivable)

I entered a customer payment last week that didn't end up in the bank till today.  I found a button to edit the payment and changed the date, which threw an error of about 6-7 lines.  Sadly, I accidentally trashed my clipboard before I pasted it.  But now when I try to view the payment, for example by way of sales=>customer transaction inquiries and clicking the # column that opens a new window, I get an error in said window:

/var/www/fa.computerisms.ca/sales/includes/db/cust_trans_db.inc:188:     display_backtrace()
/var/www/fa.computerisms.ca/sales/view/view_receipt.php:31:     get_customer_trans('130','12')

However, if I view the GL for the payment from the same spot, I see the payment exists and has the correctly changed date.  Also, if I go to reports=>print receipts, the receipt prints with the corrected date.

Did I do something wrong to cause this to happen?  I seem to have posted a cheque today that is dated for next week, so will have to do this again; maybe there is a better way

Go to forum: Accounts Receivable

87 Reply by bobloblian

(4 replies, posted in Reporting)

bobloblian wrote:

As to spacing the output, I didn't find a good solution if you need to actually print to paper, but if you output to excel you can drag the columns around to make it so everything is readable...

Actually, set line 202 to use TextColLines instead of TextCol

Go to forum: Reporting

88 Reply by bobloblian

(4 replies, posted in Reporting)

for the sake of anyone trying to accomplish this themselves, the solution is actually pretty easy.  First copy reporting/rep704.php to company/0/reporting/, then open that file and at line 189 make this change:

//$memo = $myrow['memo_'];
$memo = get_comments_string($myrow['type'], $myrow['type_no']);

As to spacing the output, I didn't find a good solution if you need to actually print to paper, but if you output to excel you can drag the columns around to make it so everything is readable...

Go to forum: Reporting

89 Reply by bobloblian

(4 replies, posted in Reporting)

@apmuthu,

hm.  no I don't want both, I want just the transaction memo.

I am aware that space will be a concern, but I would like to get it into the report anyway and see if I can deal with the spacing...

Go to forum: Reporting

90 Topic by bobloblian

(4 replies, posted in Reporting)

Hi,

I have been playing around with the reports.  I have been trawling the wiki and the forums and based on what I have found, I have been able to adjust column widths and a number of other features to my satisfaction.

One thing I want is the memo field that shows up in the journal entries report, such as customer payment memo "pd with chq#00100", to show up in the GL Accounts report.  As it is, if I enter a memo as a line item in a transaction, it seems to show up, but if I enter it in the main memo box for the transaction, it does not.  I found a post (which I cannot find now for reference) where Joe said that if the line item memo was empty, the main memo should be used instead, and at first glance the code in rep704 seems to support that, but in practise this seems to be true only of the journal entries report.

I understand that space may be an issue, but I am hoping to find  a way to work around that.

Before I embark on another adventure traipsing through the code, I am wondering if someone can point me at a simpler solution?

Go to forum: Reporting

91 Reply by bobloblian

(4 replies, posted in Modules Add-on's)

@apmuthu

that fixed it, thank you.  had to do similar on line 92.

gotta say wow, this is awesome sauce...

Go to forum: Modules Add-on's

92 Reply by bobloblian

(4 replies, posted in Modules Add-on's)

I enabled the dashboard extension and theme. 

Selecting one of the tabs along the top results in this error:

mysql_fetch_array() expects parameter 1 to be resource, boolean given in file: includes/db/connect_db.inc at line 98

However, once under a tab, all of the side-menu items work.

Not looking for a fix, just reporting a problem.

Go to forum: Modules Add-on's

93 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

you are awesome, thank you

Go to forum: Banking and General Ledger

94 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

@apmuthu
Based on the assumption that what is happening on my install is happening on everybody else's install, I would suggest this text:

At the moment (FA v2.3), the GL Account should not have any transactions for it to be used as a Bank Account. Once assigned to a Bank account (or a Credit Card Account), the GL Account cannot be deleted within FrontAccounting.

read like this:

At the moment (FA v2.3) the following conditions are true:
1. you cannot create a bank account using a Bank Account GL Code where the GL account has existing transactions.  You must begin with an empty GL account
2. When editing an existing Bank Account, it is possible to change the Bank Account GL Code to use a GL account that does have existing transactions, but Reports=>Bank Statements will not include any of those pre-existing transactions.
3. Once created, a bank account cannot be deleted.

Go to forum: Banking and General Ledger

95 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

For the sake of completing the whole story from the point of view of a guy who read the wiki page then tried to do what the program would let him do:

I had already created the GL acct (1061) and made journal entries for my 2nd bank account before I found I could make it as a bank account.  When I tried to add it, I could not.  but there was an existing bank account called petty cash (gl acct 1065).  I edited that bank account to use gl acct 1061 instead, but when I ran a bank statement report, it gave me nothing.  Today, I can get a report, but it seems to only report on journal entries I have made since yesterday, so it isn't a complete report of activity in gl acct 1061.  Given that the program let me do this I would (and did) think something was broken had I not been looking for some problem

Based on apmuthu's response, I created another gl acct 1062, and I was able to make a bank account tied to this gl acct.  I have made no transactions on this gl acct, but today I cannot delete it, I get this error:

Cannot delete this bank account because transactions have been created using this account.

But there really are no transactions in it.  if I run a bank statement report, it is empty, and there are no journal transactions on gl acct 1062.  So not sure if that is by design, seems like I should be able to delete it.

Though I cannot delete the account, I can modify it to have a different GL account.  This differs from the original petty cash bank account for gl acct 1065 that I modified to gl acct 1061.  I can no longer change the gl acct for that account, which given that the  bank account actually does show transactions now, it makes sense.

While I cannot delete the bank account for glacct 1062, I can successfully inactivate it.

So I guess the way forward is to not delete the bank account for gl acct 1062, use journal entries to move everything from gl acct 1061 to 1062, and deactivate the bank account for gl acct 1061 so it is not listed.  Rinse and repeat for the Visa...

so; summary of suggestions:
-The error message should read as Joe suggests; I would have understood that.
-A user should not be able to modify an existing bank account to use a gl acct that has transactions in it for the same reason he cannot create it.  Same error should be displayed
-If there is a legitimate reason that a bank account cannot be deleted after it is created even when empty, a note should be made on the wiki page warning that it is a non-reversible action, and perhaps a popup warning in the program as well.
-if there are conditions where a bank account can be deleted, it would be useful to have them mentioned in the error message, or have the error message contain a link to a wiki page with explanation.
-On the wiki's getting started page, it mentions setting up bank accounts as part of the POS system, it might be a good idea to have mention that one should also set up bank accounts for each real bank account and visa account.

I want to express gratitude; I am finding this program to be pretty awesome.  Thanks for writing it, and thanks for taking the time to engage me in discussion on these boards...

Go to forum: Banking and General Ledger

96 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

Hi Apmuthu,

Thanks once again for your assistance.  Soon I will owe you a lot of beers...

I did solve it.  The trick is you can't create a bank account unless the GL account is empty when you start.  Since I was trying to turn existing GL accounts that already had transactions in them into bank accounts, it failed.

Sorry for the noise...

Go to forum: Banking and General Ledger

97 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

sorry apmuthu, I think you misunderstood.  that was not a solution, but the steps I took to produce the problem

I still cannot add another bank account, if I try it tells me the GL account is already in use even though no other bank account is using the GL account number I am trying to link.

Changing the existing bank account to a different GL account produces an empty report when you try to get a bank statement.

Go to forum: Banking and General Ledger

98 Reply by bobloblian

(16 replies, posted in Banking and General Ledger)

bobloblian wrote:

I got the same problem when trying to add a 2nd bank account, but I was able to work around the issue by changing the existing petty cash bank account.

Hm... no.  primary bank account is 1060, add a second GL account 1061.

Make a journal entry and move some money out of 1060 and in to 1061.

Go under Banking and General Ledger=>bank accounts=>edit petty cash=>change account name to savings=>change bank account GL code to 1061.

go under Banking and General Ledger=>Banking Reports=>Bank Statement=>get empty report.

check the general ledger reports, can see the transaction in GL Account Transactions and List Journal Entries.

Go to forum: Banking and General Ledger

99 Topic by bobloblian

(16 replies, posted in Banking and General Ledger)

As per the bank accounts wiki page, I have created a liability GL account for a credit card, and am trying to link a bank account to it.  When I do this, I get the error

The GL account selected is already in use. Select another GL account.

I got the same problem when trying to add a 2nd bank account, but I was able to work around the issue by changing the existing petty cash bank account.

Seems like it should be straightforward, but I am clearly missing something?

Go to forum: Banking and General Ledger

100 Reply by bobloblian

(3 replies, posted in Banking and General Ledger)

hi @apmuthu,

just to be clear on this;

The quick entries for supplier invoices are still created under Banking and General Ledger tab => Maintenance Menu => Quick Entries.  But if you want to make a payment with them you go to Purchases => Supplier Invoices => Quick Entry, as opposed to with a bank payment where you go to Banking and General Ledger => payments.  that was the distinction I didn't find in the wiki before. 

Also, under the tips and tricks is the following:

First go into Quick Entries and create a new Quick Entry. Select Bank Payment and call it f.i. Phone. Don't set a fixed amount. Save it and select it again. Create 2 Quick Entry Lines.

Which conflicts with the image linked at the bottom of the page.  And given that I found other instructions that indicate a phone bill should be payed under purchases=>supplier invoices, I believe that to be in error.

Go to forum: Banking and General Ledger