Adding quantities to inventory list

Joined
Mar 4, 2014
Messages
12
Reaction score
0
I have a list in excel of about 250 items with quantities. If I import the list as a whole, do I need to omit the quantities and add those with POs? Or can I add quantities with the items from the start? My concern is how QB will match the cost of the item list added.
 
Joined
Feb 3, 2014
Messages
6
Reaction score
0
According to Intuit QuickBooks Support:

If you are importing existing inventory items, you cannot update their Quantity On Hand (QOH), value on hand (VOH) or average cost.
For new inventory items you are importing, you can set up a Quantity On Hand (QOH) and a Value on Hand (VOH) and establish an average cost. QuickBooks enters an Adjust Quantity/Value on Hand debiting the item's asset account and crediting Opening Balance Equity.


Hope this helps.
 
Joined
Jan 6, 2015
Messages
5
Reaction score
0
Yes for importing existing inventory items one cannot update QOH, VOH. But if you are importing a new inventor items you can add up QOH and other things.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top