cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Import inventory data

I want to 'update' my inventory -- I specifically want to import an Excel file (or similar) to load in the values from a year-end physical inventory.  Is there a way?  What I've seen so far say, "No."

Solved
Best answer December 24, 2018

Best Answers
Highlighted
Level 15

Import inventory data

Unfortunately the No answer you found is the correct one. you can not import an adjustment

View solution in original post

8 Comments 8
Highlighted
Level 15

Import inventory data

Unfortunately the No answer you found is the correct one. you can not import an adjustment

View solution in original post

Highlighted
Level 1

Import inventory data

Thank you.

Highlighted
Level 10

Import inventory data


@Rustler wrote:

Unfortunately the No answer you found is the correct one. you can not import an adjustment


Are you sure? Because in QBO you can import a file with quantities, and adjustment is created if quantity is different

Highlighted
Level 15

Import inventory data

yes I am sure

Highlighted
Level 10

Import inventory data

I am surprised. I'd think it's an easy thing to do. 

Highlighted
Level 15

Import inventory data

I prefer it this way, it makes you actually think about what you are doing, just too easy to mess up a spreadsheet for import.  And since you should only be doing this kind of thing periodically throughout the year it is just not that big a deal to me

Highlighted
Anonymous
Not applicable

Import inventory data

You can import inventory adjustment transactions.  One way using an IIF file created by our BRC IIF Transaction Creator Pro 

 

Note that you do need to calculate the adjustment you want to import, as there is no way to import something that will automatically adjust the inventory to a specific qty.

 

 

Highlighted
Level 15

Import inventory data

[smile]

ok from now on I will caveat my statements with "not without investing in a third party utility"

Need to get in touch?

Contact us