We are looking for an excel based inventory master file/database.
We are a retail business buying stock from multiple suppliers.
Ideally we would like to have a masterfile that can track the item, its internal code, its supplier code, description, invoice number, date, category, sub-category, cost price, and retail price along with GP's and markup.
Different suppliers will have different invoice formats so we will need the file to remember this and then check arriving prices (cost and retail) against existing.
We deal with approx 35 core suppliers but need the flexibility to add an unlimited amount over a period of time as we expand.