Method Community

Amanda, I ran into one issue. When the cents are 0-9, then the report prints 0/100 or 1/100 or 2/100. Since this is printing onto checks, you'll want it to be 00/100 or 01/100 or 02/100. I found VB formatting information on # and 0s but none of that seemed to apply to this report when I plugged it into the sub routine. Any ...

Have you ever seen someone do a happy dance? This is EXACTLY what I'm looking for! THANKS!!

That's the catch then! QB was not opened. I was testing Method's "real time" posting outside of QB. Are there any other places where Method must first talk to QB? Realistically, there could be times where the QB file for my clients may be closed for up to an hour. So I'll need to make them aware of the posting items that ...

James - Got a response for you.  It looks like an issue with the code using single data type instead of a double data type.  It's causing the number 12,345.67 to look like 12,345,670001 in the back end.  It's fine on smaller numbers, and never an issue when the bill doesn't total up 0. but in your case on totals ...

Phillip,  Also QuickBooks has to be opened before the balances are updated.  The reason for this is because Method first sends the request over to QuickBooks, QuickBooks then processes the payment and then updates Method with the new balances.   

awesome. Thanks! I need to have this ready to bring a client on board before their QB payroll subscription renews on the 7th of this month. Sounds like the timing is perfect. Thanks again for all your help! I'll dig into it this evening.

James, so long as they total up to $0, it really should be fine. Let me look into it from our end.  I tried an example of $100 positive, and $100 negative and it worked perfectly.  Perhaps with the number of items and number of expenses, it is getting upset somewhere. I'll let you know what I find out, but in the meantime, keep ...

 Hi Phillip, I just tested this out on my end and it worked fine. Try clicking on the refresh buttons on the Customer List and the Invoice grids, see if the balances are updated then.  Keep me posted. 

Yes there are negatives on the Expense side. Basically they use the Bill to do Job Costing because we run their payroll. So they charge the accounts they need to based on a particular job's department and taxes. Then they withdraw the total amount from the bank account that pays those expenses. In this scenario, the bill will always total ...

Sounds to me like there is more to it that meets the eye (but thanks for the screenshot!). I think you would get that if you total up all the Expense lins, and total up all the Item lines, and the sum is not 0 or greater. Are there any negative expense lines or negative item lines in there? Paul