51 Topic by bobloblian

(6 replies, posted in Setup)

Hi,

Wondering if someone can point me at what is going on with this once in a while occurrence. 

like just now, I entered a vendor invoice dated 3 days ago.  I added an attachment, and then applied a payment, also for 3 days ago, as they took it from visa on the same day.  I have actually entered 4 invoices from this vendor for this week, ranging from 5 days ago to 2 days ago, all payments matching the date of the entered invoice.  But for some reason, when I go look under suppliers=>transactions for this vendor, this one invoice is listed in red.  it is not overdue, it is not unpaid. 

I see this with some frequency; always have, with vendors and customers.  For example, under allocate customer payments, I have one payment listed in green from 2014, but there is 0.00 left to allocate, and the only invoice she ever got from me is paid in full.   

So long as everything looks good, I have just been ignoring it, but today my curiosity got the better of me and I started trying to find a reason, and there doesn't appear to be one.  What am I missing?

Go to forum: Setup

52 Reply by bobloblian

(6 replies, posted in Report Bugs here)

I feel like I am harping on this issue excessively, if I am please accept my apologies.

Another thing I have noticed is that the bank account reports do not match the GL account reports that are tied to them.  I still haven't had time to sit down and do the math, but in general it seems to me that the reconcile bank account module and the bank account report are calculating the same thing, and neither of them is including all entries that actually exist in the GL account.

Go to forum: Report Bugs here

53 Reply by bobloblian

(6 replies, posted in Report Bugs here)

Hi Apmuthu, you are absolutely correct that the issue was created by my own error. 

However, when I used the reconciliation function, the vendor invoices that were entered in the bank account GL did not appear.  That is to say, under banking and general ledger=> reconcile bank account, the mistakenly entered vendor invoices should have appeared as credits, but they did not.  It was only by going and manually reconciling the GL account that I was able to find the discrepancy.  I am pretty sure that is an unintended limiation/oversight. 

Please also see my post regarding beginning and ending balance, which I believe is related, but I haven't actually proven yet. 

There is no argument this is human error; specifically my error, but if I can make it others can and will.  So my suggestion that the reconcile function be adjusted to show the error, or a check be implemented to prevent invoices being entered against GL accounts configured with a bank account, is to make the program more robust and user friendly so that it may enjoy wider adoption and higher creditation....

Go to forum: Report Bugs here

54 Topic by bobloblian

(6 replies, posted in Report Bugs here)

Hi,

This is not so much a bug as it is a user error, but it took me a while to figure it out, and I suspect that this should have been immediately apparent either through an error message at the time of entry, or through use of the reconciliation module.

The problem: I created several quick entry entries for the recommended reasons.  it turns out that in two of my quick entries, I had accidentally set the remainder to to my chequing account instead of a GL Liability account.  This resulted in supplier invoices showing in the chequing account GL, and my bank account being out of balance.

I think that because the GL is tied to a bank account, it should not be able to have supplier invoices entered against it, only payments and similar.  I think an error should be generated when this happens.  I am no accountant, so perhaps there is a usage scenario where you would enter a supplier invoice in your bank account GL, in which case I think wrong.

However, these entries should have shown up when I did the reconciliation, and they did not.  The supplier payments I entered did, but the supplier invoices entered through the quick entry did not. 

As I said, this is clearly a user error on my part and not on the part of FA, however, I would suggest for future consideration something be put in place to prevent this kind of human error...

Go to forum: Report Bugs here

55 Reply by bobloblian

(3 replies, posted in Accounts Receivable)

I have been searching around on this today, and it seems like the crux of the problem has been raised before, and that is that you cannot create an invoice for a prepayment.  To say that another way, there is no way in FA to send a customer a document that indicates some portion of a payment is due before processing of the order begins. 

Unless someone can point out an error in this finding, then pretty much the only way to handle that is to write a handwritten invoice, and attach a scanned copy of it in the system...

Go to forum: Accounts Receivable

56 Topic by bobloblian

(3 replies, posted in Accounts Receivable)

Hi again, I am trying to figure the workflow on this scenario and I am not meeting with success.

I have an order from my customer for a given set of devices.  I have gotten a quote from a few vendors in order to fill the order.

I do not have sufficient money to pay the vendor, so the customer has agreed to make a partial prepayment. 

I have created the quote and sent it to the customer.  After it was approved, I created the sales order from the quote.  I have setup a deferred income account and a prepayment payment term.  In the sales order, I have set the "prepayment required" field to the value that the customer has agreed to pay. now when I go to sales=>invoice prepaid orders, I can only create an invoice for the full amount, not the agreed upon prepayment value. 

I am not really clear how to send them an invoice for the value of the partial prepayment.  Seems like I am missing a step, maybe in the delivery?  but I can't make delivery till I get the vendor invoice, and I can't get the vendor invoice before prepayment, so maybe there is another way to do this?

suggestions would be appreciated...

Go to forum: Accounts Receivable

57 Topic by bobloblian

(4 replies, posted in Accounts Receivable)

Hi,

I just noticed this.  when I create an original invoice, I am billing at the beginning of the cycle for the cycle.  example, I bill the service provide in January on January 1 with the original invoice.  When I generate the recurring invoice on February 01, it contains a remark that the billable service is for January 01-31, but it should be feb 01-28.  it is an excellent feature that this gets automatically added to the invoice, but how can I make it say it is billing ahead instead of behind?

Go to forum: Accounts Receivable

58 Reply by bobloblian

(1 replies, posted in Announcements)

+1

Go to forum: Announcements

59 Reply by bobloblian

(1 replies, posted in Report Bugs here)

go to banking and general ledger=>payment.

Set date; set from = customer and select customer; into bank acct; select GL acct and enter amount; process deposit.

go to sales, allocate customer payments.

Go to forum: Report Bugs here

60 Reply by bobloblian

(2 replies, posted in Accounts Receivable)

ended up making the 1-off invoice, then changing the start date on the recurring invoice to the next scheduled one after that.  thanks for the idea...

Go to forum: Accounts Receivable

61 Reply by bobloblian

(20 replies, posted in Announcements)

janusz cleared a pile of bugs in the mantis system this last weekend.  I have been using it in production for the last 4+ months on a debian/php7 server, and it seems to be mostly working for me.  There have been a few bugs/issues that have required me to do some workarounds, but nothing that I would call a show stopper...

Go to forum: Announcements

62 Topic by bobloblian

(2 replies, posted in Accounts Receivable)

Hi,

I have a customer who needs her invoice before the regular recurring occurrence, just as a one-time exception.  is there a way to handle this?  I don't see one...

Go to forum: Accounts Receivable

63 Topic by bobloblian

(1 replies, posted in Wish List)

subject says it all.  We have it for AR, would be nice to have it for AP.

Go to forum: Wish List

64 Reply by bobloblian

(15 replies, posted in Installation)

I would start by checking your web server logs, I don't recognize your symptoms, but it sounds like something should show up in there...

Go to forum: Installation

65 Reply by bobloblian

(15 replies, posted in Installation)

that is not helpful enough for me to know what you are talking about....

Go to forum: Installation

66 Reply by bobloblian

(15 replies, posted in Installation)

what warning sign?

Go to forum: Installation

67 Reply by bobloblian

(1 replies, posted in Banking and General Ledger)

follow up.  I just reconciled the month of September in another account.  I have a check mark for every entry in the real bank statement, yet, the balance is out, and it has adjusted the opening balance of this account, as well as the ending balance of the previous month.  Should the program be able to change the ending balance of a previous month?

Go to forum: Banking and General Ledger

68 Topic by bobloblian

(1 replies, posted in Banking and General Ledger)

Hi All, Happy new year.

I have been having mostly good success with FA2.4, thanks to all those who have put their efforts into it.  What few issues there have been I have been able to work around so far, or havn't been important enough that I need to find a work around.

I have not had a chance to catch up on bank reconciliations since I made the upgrade, and am now trying to get all that done for year end, but I have discovered that all the beginning and ending balances on my primary chequing account have changed.  it's like they got recalculated or something, which I find odd because I think those should be static values that I have entered. 

When I go back all the way to the beginning of 2015, the balances in the reconciliations no longer match the values on the real bank statements, but I know for sure everything was correct for 2015.  And I know everything was good up to end of August of 2016, that was the last reconciliation I did, and I did the 2.3=>2.4 upgrade in September. 

The other bank accounts I have configured are all showing the correct balances in reconciliation.

So I am not really sure if I did something wrong here, maybe I missed something in the upgrade.  Maybe I am missing some entry I was supposed to make, but going all the way back to the beginning of 2015.  Or maybe something changed in the way things are done in 2.4 and I need to account for that?

Anyone have any insights?

Go to forum: Banking and General Ledger

69 Topic by bobloblian

(1 replies, posted in Report Bugs here)

Hi,

I created a bug in the mantis system, not sure if anyone has looked at it yet, but hoping there might be a suggested fix.

I found right after I did my 2.4 upgrade that the reference number on customer payments does not auto-increment.  Today, the auto-increment also stopped working on supplier invoices, both direct and normal.  Is there a setting I can toggle to fix this, or is this a bug in the code?

Go to forum: Report Bugs here

70 Reply by bobloblian

(19 replies, posted in Setup)

Still think something is broken here, but was working out a bank transfer so I could make a journal entry from a different bank account, when I figured out I could accomplish the same GL entries using a bank payment.  So good now, thanks.

Go to forum: Setup

71 Reply by bobloblian

(3 replies, posted in Banking and General Ledger)

apmuthu wrote:

I shall assume you are working on FA 2.4RC1 with all fixes till date.

Correct

apmuthu wrote:

IAs for the 4 GL Accounts issue, check their entries in the db tables for any record / field differences other than account code and name. Also check their entries in the sys_prefs table if the mischief is in it's being set as some default.

Maybe I am not looking in the right tables, but nothing about the two accounts that create the counterparty column stands out to me.

apmuthu wrote:

As you are using PHP7, there seems to be a sticky post in announcements that could be useful.

I have already investigate this.  if This simply will not work out for me, I will find another machine to host FA until it can be integrated into the existing server.  I am keeping careful track of all my entries in case I need to redo them...

apmuthu wrote:

Counterparty is just the contra account in a transfer transaction. It can be between 2 bank accounts or even between some balance sheet entries and P&L entries like in depreciation entry transactions apart from the ones you already mentioned.

This is what I understand from investigating the definitions.  But does not seem to be consistent with how things are working in the interface...

enough for one day, will revisit again tomorrow...

Go to forum: Banking and General Ledger

72 Reply by bobloblian

(3 replies, posted in Banking and General Ledger)

I have been investigating this, still don't have much idea what is behind this.

First; the best definition of counterparty I can find on the net is that this is the opposing party in the transaction.  In a supplier invoice, the counterparty would be my vendor.  in a customer invoice, the counterparty would be my customer.  I cannot find anything that makes me think this should be showing up in a journal entry anywhere.

I have 4 GL accounts configured as bank accounts, this only happens on one of them, my primary chequing account with GL account number 1060.  Here I get only one option in the drop down, and since that entry is both a customer and a vendor, I do not know where it is pulling it from, nor do I know why I am getting only one entry when it would seem ti should be all my vendors or all my customers, or both.

It also shows up on GL account 2100 Acounts payable, and there I get a full list of all my vendors.

I didn't test every single GL account, but I did test several accounts in each category, and these were the only two that showed the counterparty column.  I still dont' understand why only one option shows up under the 1060 account, nor do I understand how I am supposed to use this when I want to transfer money out of my chequing account, but not to a vendor and not to another bank account.  I am not sure this is working the way it is intended to?

Go to forum: Banking and General Ledger

73 Reply by bobloblian

(19 replies, posted in Setup)

Hi Apmuthu,

Your help is, as always, truly appreciated.

my upgrade path went like this: upgrade server, find can't log in to FA. back everything up.  Unpack 2.4 over existing installation, get logged in, to to setup=>software upgrade, see option to upgrade to 2.4, do it and get no error.  mess around and find lots of oddness, like enable new theme, log out and in, and find new theme not enabled, but selectable in preferences.  Moved entire installation out of the way, and used just the 2.4 files as downloaded from sourceforge.  copied over the company/0/files, setup config_db.php.  still saw odd things, so found a file you posted with fixes, checked that out and found the CHANGELOG was more current than the download from sourceforge, so unpacked that over the new 2.4 install.

I say this because it seems I will have more questions in the near future, because I still have a number of errors that show up, Only variables should be passed by reference in file: $WEBROOT/frontaccounting.php at line 79 for example, and the occasional unexpected logout, and other odd things here and there.

When should I just make a bug report in mantis vs asking here first?  should I be putting this and the above errors in mantis because it is something that didn't work as expected, or should I generally ask here first and then put something in mantis after it has been identified as a bug and not a user/computer problem?

Since your last post, I have removed all themes and extensions from the web interface, and gone in and scrubbed out the themes and modules directories, leaving only the default theme.  This makes it so the web interface has a dashboard link beside preferences, and I believe this is builtin and thus expected as per a post I found at kvcodes.com

After that I installed the dashboard extension and activated it, then installed the dashboard theme.  I then went under setup=>access setup, and now I find I can enable dashboard setup and reminders.  After logging out and logging in again, I can now find and click on the links under setup=>Miscillaneous, but the reminders link gives me a blank page with error:

Cannot redeclare text_input() (previously declared in$WEBROOT /includes/ui/ui_input.inc:507) in $WEBROOT/modules/dashboard/includes/dashboard_ui.inc on line 28

clicking the dashboard setup link gives the same error, but not on a blank page, just in the main frame of the window.

Is there something else I need to do?

Go to forum: Setup

74 Reply by bobloblian

(19 replies, posted in Setup)

Hi Apmuthu,

Thanks for your response.  The upgrade already happened, and I have already made entries.  I also have my server running php7 now, which means if I were to roll back to 2.3 I would not be able to log in and upgrade that way.  I have already tried uninstalling and reinstalling the extension and the theme, but the configuration options never showed up.  I will see if there are some other ways to do that and report back with what happens...

Go to forum: Setup

75 Topic by bobloblian

(19 replies, posted in Setup)

in 2.3 I had a plugin, I believe it was part of the dashboard extension, called reminders.  I could configure it to schedule and display reminders under sales/purchases/etc.  I still have a table in the database called dashboard_reminders, but I don't find an option in 2.4 for it anymore, nor do I find any reference to it in the code.  Is there any way to get that back?
Also in 2.3 using the dashboard extension with the exclusive_db theme, one could configure the layout and some options of the various widgets, but that also seems to be missing in 2.4.

Go to forum: Setup