 Posted 5/26/2009 7:11:26 PM
|
|
|
|
| I was wondering if there was a way to update my entire database of inventory using the inventory import sheet without duplicating the existing items. Is this possible and or am i going about it the wrong way?
|
|
|
Posted 5/27/2009 9:12:59 AM
|
|
|
|
| Christian, There is nothing in the system that will update inventory information once its in IS. What exactly are you trying to update? Is it descriptions, categories, pricing, costing, supplier info, etc.? Realize that all of this information is stored in several tables in IS.
BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog
|
|
|
Posted 5/27/2009 10:01:46 AM
|
|
|
|
| BJ, Thank you for your responce. Yes I was hoping to use the import sheets to update categories of existing products as i add new products that the old products would now have to be linked to via category. I will have to use sql to accomplish this I am guessing? Christian
|
|
|
Posted 5/27/2009 2:42:17 PM
|
|
|
|
| Christian, Correct. Remember the table that stores the categories for inventory items is InventoryCategory. Also remember that you can only have one primary category per item as well as you'll need to lookup the ItemCode from InventoryItem using your ItemName (since the system stores the ItemCode in the InventoryCategory table). Hope this helps.
BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog
|
|
|
Posted 5/27/2009 3:59:42 PM
|
|
|
|
| I am a little confused. I can only have one category per item? Is this correct? In ML i was able to map to multiple categories with ease.
|
|
|
Posted 5/27/2009 4:55:26 PM
|
|
|
|
| Christian, You can have any number of categories for an item but only one of those categories can be marked as primary. The system will not work correctly if more than one category is marked as primary. For Example: Item ABC can have Category 123 and 456 but only Category 123 can be selected as the primary (Hope that makes since).
BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog
|
|
|
Posted 5/27/2009 7:41:01 PM
|
|
|
|
| ok this makes sence. thanks for the clarification. I just want to thank you guys for putting up this forum as it is a huge help to us users who have been left out in the cold when it comes to support for IS. The Taylor Corp should be paying you guys to handle their support!! Christian
|
|
|
Posted 5/28/2009 6:46:05 AM
|
|
|
|
|
|
|
Posted 5/28/2009 9:00:11 AM
|
|
|
|
+2 thanks Dimesoft from me too 
|
|
|
|
