An Excel table is needed for inventory accounting in the warehouse. A warehouse accounting template. I am not strong in macros, so it would be better if someone else could do this. At a minimum
Serial number
Article
Barcode
Product Name
Quantity
Purchase Price (calculated based on the average if there were different purchases at different times. For example, there is 1 item available for 1 dollar. Purchased 2 more items for 2 dollars. In total, the average purchase price of the product in stock is 5 dollars divided by 3 items
Receiving Date / Shipping Date (Automatically)
Document number of receipt (if there are multiple documents, there should be an option to add each)
And the balances accordingly with highlighting of certain cells depending on their value
Products are entered manually, then using a barcode scanner, products are added to the balance and removed from the balance with automatic issuance of the date of addition and removal from the balance, so that it can later be checked on what date and which product was removed and added to the balance.
Something like that... I look forward to proposals on price and production timelines
