Print Page | Close Window

Importing Inventory ADDs units.

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Inventory Control
Forum Discription: Inventory operations
URL: http://www.almyta.com/forum/forum_posts.asp?TID=1777
Printed Date: 24 Oct 2020 at 5:21pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: Importing Inventory ADDs units.
Posted By: Andre_D
Subject: Importing Inventory ADDs units.
Date Posted: 17 Apr 2013 at 1:19pm
Hello,

I just imported an Inventory Units list.  This is the 5th one I import and up to now everything has been going great.

In THIS specific list, I had inventory that already had units in the software.  My understanding of the tutorials is that importing units will UPDATE existing inventory.  What it did in fact was ADD to the existing inventory. So I now have, for example,  6 units AND 5 units of product ABC in Bin 1, instead of what I expected which would have been simply 5 units. So it didn't update the 6 units to 5, it simply added 5 units to Bin 1.

I did make a backup of the database prior to doing the import, and I can manually go through all 400+ items I am importing to remove any ones that already have units in stock and re-import into the saved database. I just want to know if I have missed something somewhere that would cause it to add and not just update, or if I am just wrong about what importing does.

Thank you,

André



Replies:
Posted By: BillD
Date Posted: 18 Apr 2013 at 1:01pm
No, the inventory units is the only table, I believe, that does not update, but adds. It just does not know how to match imported against existing.


Posted By: Andre_D
Date Posted: 19 Apr 2013 at 5:43am
Thank you Bill.

I will get started filtering out any items that already have units in the database and re-import.


André



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk