Changing Unit counts using an Excel File

Hi,

I'm trying to update the database item counts. For example I have 3 unique styles in the item database and there are 5 item counts for each style. Is there a way for RMS to use an Excel spreadsheet so I don't have to key in each new value of count for each style?

I have thousands of styles that I need to update the item count so an easier way would be nice.

Thank You, Daniel Sie

Reply to
DanielSie
Loading thread data ...

Well, I'm not sure it's appropriate in your context, but the Physical Inventory feature is one way to enter onhand quantities in bulk from a CSV File. Check the online help for Physical Inventory and look for the "Import" button.

The inventory wizard also has an import feature, but it may be harder to use...

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.