Wrong total balance due in by $700 & unable to open invoice from client area!!!

[tallship]

Okay this is really goofy.

I'm going to post some screenshots showing how HostBill is over $700 off  the correct balance for one of my clients. I don't know about you guys, but I can't afford to be shorted by $700, and this is just one client who owes me money!





As you can see, the three invoices above add up to $1930.21 - not $1225.42. If I try to click on the little arrows (the ">" signs) to manage/pay those individual invoices, the only one that doesn't work is #2013-286 (The invoice that is showing $1080.21 due). If I try to visit that invoice form the "Dashboard", it is a broken link!

As you can see in the graphic below, I applied a credit of exactly $704.79 directly to invoice #2013-286 - which is EXACTLY the amount that the incorrect balance due is off by.

WTF?



If I try to access the invoice be going to "Account ==> Invoices from the top menu, and then click on the invoice number, the pdf file opens up no problem!

WTF?






I'm very afraid to do almost any automatic accounting in HostBill now, things are getting worse by the day.

Before it was things breaking and/or not working, but now the accounting system is all screwed up and when a billing system tries to help you to rip yourself off for almost a thousand dollars, it's time to tell the world and stop adding new clients to that platform.

I'm so upset at this crappy billing system called HostBill that I think I'm going to throw up. I may even have to just manually generate these invoices from PayPal or zendesk instead.

For almost a year and a half now, I've been complaining about HostBill's complete and total lack of capability when it comes to billing in increments less than one hour too!

For example, you can bill for 1hr or 3hrs, by putting 1x85 into the line item or 3x85 into the line item, which would come out to $85 or $255, respectively, but you can't put in 1.25hrs, or 1.75hrs, or even 1.5hrs or .5hrs - HostBill won't take even half hour increments - This software totally fricken sucks!!!!!!!

[davemarks]

What version are you on?

I noticed lots of issues in 4.8.4 and up. Since Kris added the storage and display decimal places option. That's why I'm sticking to 4.8.2.

See this bug which has yet to be fixed: http://www.hostbillforums.com/index.php/topic,444.msg3312.html

[tallship]

Thanks for that link Dave I'm at 4.9.0 right now.

I don't think that's my issue though. I seem to have found a workaround based on something that I had recalled @Nibb talking about a couple of months ago in another thread - it makes no sense to me as to why, but here's what I did to resolve the FUBAR:

   
• I removed the credit applied directly in the invoice. After that, I was able to login as client and view the pdf of the invoice from their perspective.

   
• Then, I applied a manual credit directly to the customers account itself, insted of the customers invoice.

After that, the math was fixed, but alas, the particular invoice did not exhibit the credit. The credit is just there in the customer account waiting to be applied by the customer to whichever invoice they decide to pay.

Definitely not ideal, and definitely amateur hour, but at least the math is right and the credit will be applied to their account in some fashion whenever they pay one of their invoices.
Now there's the problem of the customer not being immediately able to tell they actually have a credit balance because of the open invoices, but I've opened another thread about that particular issue.

It kinda sucks real hard, but at least the math is right and I'm not getting gyp'd for $700.
Anyone know why this is messed up like this?

[blackrider]

The Account Balance equals with Total Invoices Unpaid (this include also partialy paid invoices) minus the Current credit this account has. So for example if you have 3 invoices 10,20,30 euro and the user adds funds of 15euro then the current balance will be 10+20+30 =60 - 15 = 45euro BUT all invoices will be shown as unpaid since the user hasnt apply the credit to any of them. when the user select to pay Invoice with total 10euro then it will take this ammount from current credit (15) mark this invoice as paid and then will leave in current credit 5euro.
then the Account Balance will be 20+30=50 -5 =45 euro But now the invoice with total 10 will be marked as paid even the Account Balance is the same as before and the current credit will be 5 euro.
Hope this helps you on this issue.

[tallship]

Thanks

That helps some, although from what I'm looking at it applies to the situation as it is now that I have removed the credit on the invoice and applied it to the user account.

Perhaps it would have worked out anyway, but the customer probably wouldn't have understood until a payment was made (or the credit applied, although I am sure I will be referring to your post again several times in the future to help keep my head on straight.

Thanks again

[blackrider]

I m glad that i ve helped you.
BTW also me in the past had some confusions about how some things work in HB and i had in mind that it was HB bugs but it was me the issue
The main problem i see is that there is NO UPDATED WIKI or User Guide or any updatet Manual for this.