Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello,
I recently ran a Data Import procedure to update the order cost on about 700 items. There were only three fields that I specified in the import: Item #, Item Name and Order Cost. I ran the import and everything looked fine. I didn’t realize until later, but Point of Sale entered a bunch of quantity adjustments. I do not understand why updating the order cost field would affect item quantity.
For the Question asked during the import:
When duplicate records are detected during import:
I selected:
Replace existing data with import data, ignoring blank fields
Has anyone else had similar issues with this?
Thanks
Thanks for getting in touch with the Community, KFlash.
Since your data import caused invalid quantity adjustments, you can restore to a backup if there's one available.
To experience a smooth import with Excel data, you'll want to make sure of the following:
If you have difficulty importing specific columns from your spreadsheet, verify that their cells are formatted correctly to work with the Data Import wizard.
Here's an example:
Additionally be sure to do a quick scan through your entire worksheet before mapping. Look for any anomalies, strange data, etc. You can open .CSV spreadsheets in the Notepad app to identify irregularities.
I've included a detailed resource about working with your Data Import wizard that may come in handy moving forward: Import and export data in QuickBooks Desktop.
I'll be here to help if there's any questions. Have a lovely day!
Hi Zack,
Thanks for the response. I didn't realize the import had entered the Qty Adjustments. By the time I discovered this, several days had elapsed which rendered any backups useless for this purpose.
The reason for my post is to determine why the system would make quantity adjustments when the only field being updated was the Order Cost field. As I said, there were only three fields from the Excel file mapped in the import: Item #, Item Name, Order Cost.
I'm at a loss.
Thanks,
Keith
Thanks for coming back, KFlash.
By default, QucikBooks Point of Sale creates an account named POS Inventory Adjustment. Users can use this account to send transactions when:
The QuickBooks POS inventory adjustment is used as a Holding Account. You can use General Journal Entry to change and remove balance. Since you already performed the troubleshooting steps provided by ZackE, we can run the Verify and Rebuild Utility tool to resolve any damaged data on your company file. Just follow the steps and details in the Resolve Potential Data Issues in QuickBooks Desktop article.
Once done, importing the data gain in QuickBooks POS. If the same thing happens, I'd suggest contacting our QuickBooks POS Support Team. They'll pull out your account in a secure environment and investigate what's causing this issue.
I'd like to know how you get on after contacting our support or trying the steps, as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. Have a great day ahead.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here