Hi there, Azores44.
Generally, companies with large inventory lists provided by a few vendors can update these lists with an .IIF from your vendor. By simply importing the updated file into your company file, we'll be able to record the changes. However, this will erase the existing fields that you didn't update.
For us to update the cost and price of your items, we'll have to use the Add/Edit Multiple List Entries option. Please know that we can also copy your data from Excel then paste it into the Add/Edit Multiple List Entries window to expedite the process. I'll show you how:
- Select List from the top menu bar, then choose Add/Edit Multiple List Entries.
- Click the List drop-down arrow, then select the list that you want to update.
- Choose in any field and begin making changes.
- You can copy (Ctrl+C) the data from Excel then paste (Ctrl+V) it into the Add/Edit Multiple List Entries window.
- To copy the data in a specific field to the remaining records, simply highlight the desired field and right click then choose Copy Down. If data is in any of those remaining fields, it will be overwritten.
- To duplicate a row simply place your cursor in any row, right-click and choose Duplicate Row. The record is duplicated into the next row and is preceded with the word "DUP."
- Click Save Changes when you're done.
In case you'll need to track where your company stands in terms of expenses and accounts payable, we can customize your vendor reports.
If there's anything else that I can help you with, please don't hesitate to insert a comment below. Stay safe and healthy.
