Method:API Q&A

Re: Importing Bills

Method_Paul — Mon, 06 Jul 2009 20:30:46 GMT

Excellent. Thank you for letting me know.

Re: Importing Bills

jobcostingjames — Mon, 06 Jul 2009 14:36:28 GMT

Hi Paul,

I tested it and it worked fine!

Thanks!

Re: Importing Bills

Method_Paul — Sat, 04 Jul 2009 13:33:55 GMT

James -

Can you check it out on your end now? It is doing the rounding properly for me now.

Paul

Re: Importing Bills

Method_Paul — Wed, 01 Jul 2009 22:25:46 GMT

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 over 3600 the comparision is off by -0.0001, triggering the bogus message.

We expect to update the platform on Friday morning, so you'll have the fix then. Shouldn't stop you from writing your Method API code in the meantime, though.

Paul

Re: Importing Bills

Method_Paul — Wed, 01 Jul 2009 18:44:15 GMT

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 moving ahead, because it really should allow a $0 balance to go to QuickBooks.

Paul

Re: Importing Bills

jobcostingjames — Wed, 01 Jul 2009 17:45:44 GMT

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 $0.

I think with QBXML, it imports because I am not sending the amount due. It is calculated in QuickBooks based on the expense and line items sent. Does that sound right? Does Method send the amount due on the import?

Thanks

Re: Importing Bills

Method_Paul — Wed, 01 Jul 2009 17:34:43 GMT

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

Re: Importing Bills

jobcostingjames — Wed, 01 Jul 2009 17:30:01 GMT

Hey Paul,

Here is the image I received while in Method

Thanks!

James

Re: Importing Bills

Method_Paul — Wed, 01 Jul 2009 16:33:05 GMT

That shouldn't be a problem. Method still uses QBXML in the back-back-back end.

We don't restrict bills from going to QuickBooks that are 0 amount due.

Just make sure you add the line items. It won't send a bill that has no items or expense entries on it. That is against the rules.

Paul

Re: Importing Bills

jobcostingjames — Wed, 01 Jul 2009 15:37:26 GMT

Thank you for the Quick Response Paul! I was doing some testing and just noticed a problem. The bills we are sending are already paid (i.e. a $0 due amount). When using QBXML, I can import this with no problem. However, it appears that Method is not able to send a bill with $0 in the AmountDue field.

Is there a way to get around this?

Thanks!

James

Re: Importing Bills

Method_Paul — Wed, 01 Jul 2009 14:45:10 GMT

James -

We don't have an example of bills. But there is an example of a web app that inserts an invoice. You can get the sample apps here:

http://www.methodintegration.com/web/self-service-documentation.aspx

The idea is that you would use the MethodAPI Insert function to insert a Bill. This would give you the RecordID of the Bill.

Then use the Method API Insert function to insert the BillLineItem and BillLineExpense values, referencing the Bill's RecordID.

Then use the Method API Send to Desktop to commit the bill into QuickBooks.

If you are used to VB.NET and web services, I think you could write this in a couple hours. But I'm always an optimist.

Paul

Importing Bills

jobcostingjames — Wed, 01 Jul 2009 14:34:46 GMT

Hello,

I am currently importing bills into QuickBooks using QBXML. We run payroll for our customers, query the data, convert to QBXML, and send to the customer for importing. I was told we could import bills into Method, and I am wondering if anyone has an example of one they have done.

Any help would be much appreciated!

Thank you!

James