Method:Classic General Q&A

Re: QBO and inventory cost to estimates

Method_Adam — Thu, 20 Dec 2012 15:24:53 GMT

John,

Sorry for the confusion. I have QBO Essentials running on my machine, which doesn't support Inventory Tracking. This is why I couldn't find the invetory item or the cost field. Currently, the Quickbooks Onine API doesn't support inventory items. The link below is from the Intuit API. All developers face theis same limitation.

https://ipp.developer.intuit.com/0010_Intuit_Partner_Platform/0050_Data_Services/0400_QuickBooks_Online/Item

I was able to get access to a QBO Pro version and can confirm that the cost field is reflected in both the Item table and ItemService table under the PurchaseCost field.

- Adam

Re: QBO and inventory cost to estimates

John M — Wed, 19 Dec 2012 16:08:46 GMT

In the items table, you have a field called Average Cost. Would that field point to the quickbooks cost field?

Re: QBO and inventory cost to estimates

John M — Wed, 19 Dec 2012 16:03:00 GMT

Adam,

This cost field is in Quickbooks Online.

if youi make a item a inventory item, then a cost field apears. I was wondering if method had a field to reference that quickbooks cost field.

Re: QBO and inventory cost to estimates

Method_Adam — Wed, 19 Dec 2012 15:13:27 GMT

John,

In what table did you find the cost field? The only cost field I see is the on the EstimateLine grid, which actually refers to the Rate field in the EstimateLine table and also the SalesPrice field in Items. And yes, both reflect the Price/Rate field in QBO.

- Adam

Re: QBO and inventory cost to estimates

John M — Wed, 19 Dec 2012 01:49:59 GMT

Adam,

Yea all the stock estimate screens. I could not find cost fiend in the estimateline table.

Thanks

John M

Re: QBO and inventory cost to estimates

Method_Adam — Tue, 18 Dec 2012 20:38:57 GMT

John,

Which specific screens in Method are you looking at, just the Estimate screen? I'm assuming you're referencing the EstimateLine table, correct?

- Adam

QBO and inventory cost to estimates

John M — Tue, 18 Dec 2012 17:02:10 GMT

Greetings,

QBO> Products list> Inventory Item> there is a field call Price/Rate and this gets connected to the cost field in Method.

QBO also has a field, ifyou make the item inventory, called Cost. This cost field is not connected to any Method field.

Your QBO stock method screens have a cost field, so im getting the wrong impression that this is a cost field if i make the item inventory.

You see where im going here?

My goal is to have a cost field apear in a estimate so i can see where the numbers are.

Thanks!

John M