vladimiratanasiu
Active Member
- Joined
- Dec 17, 2010
- Messages
- 347
- Office Version
- 365
- 2021
- Platform
- Windows
Hello!
On my job, I have to make daily inventories of the raw materials / final products from our company. They are carried out based on some inventory lists, generated automatically by the ERP system. Taking into account that the stocks include products acquired / manufactured at different dates, they appear in reports divided in specific lots, as it’s shown into the linked document Stocks on 29.10.2021- logistic.xlsx. Giving the large amount of products with their subsequent lots, the lists are very large and vary considerably every day. I meet problems when one / more product(s) and is / are repeated in the list, and the whole quantity is divided depending on the lots (e.g. articles PF_00040, PF_00050, PF_00067, PF_00098 etc.). I ask you if is any way to reduce the iterations of a product name and its article code only to single line, summarizing at the same time the quantities of all lots in a final value, as it’s illustrated in the red text. At the same time, I mention that the content from the present list is only indicative. Its content is permanently changed by including other new products or removing some existing ones, with their corresponding values. In this sense I wish, if it’s possible, the solution be working also with some new elements, no matter how many iterations could have a product in terms of codes and names with quantities.
Thank you!
On my job, I have to make daily inventories of the raw materials / final products from our company. They are carried out based on some inventory lists, generated automatically by the ERP system. Taking into account that the stocks include products acquired / manufactured at different dates, they appear in reports divided in specific lots, as it’s shown into the linked document Stocks on 29.10.2021- logistic.xlsx. Giving the large amount of products with their subsequent lots, the lists are very large and vary considerably every day. I meet problems when one / more product(s) and is / are repeated in the list, and the whole quantity is divided depending on the lots (e.g. articles PF_00040, PF_00050, PF_00067, PF_00098 etc.). I ask you if is any way to reduce the iterations of a product name and its article code only to single line, summarizing at the same time the quantities of all lots in a final value, as it’s illustrated in the red text. At the same time, I mention that the content from the present list is only indicative. Its content is permanently changed by including other new products or removing some existing ones, with their corresponding values. In this sense I wish, if it’s possible, the solution be working also with some new elements, no matter how many iterations could have a product in terms of codes and names with quantities.
Thank you!