Method Community

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

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

Adam,

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

Thanks

John M

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

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. 

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

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