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
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...
Have something to add? Share your thoughts — no account required.
Ask the community — no account required