I have a stock report for my company which comes from a central database. I am now offering a new system where we will buy product back from our customers, if our stock is low or out while a customer may be sitting on dead stock. I have created an Excel file which will be distributed to all customers listing their dead stock, where I will collect all the data and accumulate it into one database and add it to my existing report.
I would like to see my existing report in full as it is now, for the products which are located at a different site / customer site I'd like them listed in the same designated area as the existing report but (embedded in the existing report) highlighted in another colour, therefore it the product would be listed a second time in another colour so staff knows it’s an outside stock.
I have added another database file to my existing stock report and linked the products by our manufacturing code #, now I'm listing the products but since the added database (customers dead stock) only accounts for about 2% of our total stock, only the customer products are being listed the 2% of stock plus our main warehouse for that product as well, all products which are located at the main warehouse only eare not listed, since the two databases are linked and there is no listings for these products in the Customer Dead stock listing. How can I fully list my existing stock report but also link the new report while still displaying the areas where only one location resides?
Sorry it is a bit hard to explain but I know it's shouldn’t be too complex, basically I would like to keep the same products and group them but I don't want the one database to affect or change the other.
I would like to see my existing report in full as it is now, for the products which are located at a different site / customer site I'd like them listed in the same designated area as the existing report but (embedded in the existing report) highlighted in another colour, therefore it the product would be listed a second time in another colour so staff knows it’s an outside stock.
I have added another database file to my existing stock report and linked the products by our manufacturing code #, now I'm listing the products but since the added database (customers dead stock) only accounts for about 2% of our total stock, only the customer products are being listed the 2% of stock plus our main warehouse for that product as well, all products which are located at the main warehouse only eare not listed, since the two databases are linked and there is no listings for these products in the Customer Dead stock listing. How can I fully list my existing stock report but also link the new report while still displaying the areas where only one location resides?
Sorry it is a bit hard to explain but I know it's shouldn’t be too complex, basically I would like to keep the same products and group them but I don't want the one database to affect or change the other.