I encountered a problem in financial statistics when I was doing the sales function today and thought of a solution.

If you want to accurately count all the processes and profits of a product from purchase to sale
Each product has a tag (one product and one number)

But now many companies cannot do this.
What should I do?
Thought of a solution

When we enter a product in the database, we automatically add a number for it, and then record the various information of this product in detail (not a type of product, it is the details of a product ), then, the product is sold in accordance with the first-in-first-out principle during sales, and the profit can be accurately calculated.

Note: If you encounter a major account, a detailed record of the product table may contain a lot of information.
So when you do this, you can make it a dynamic table, and change it for half a year or one year. Then you can change the configuration file. (this is also a method to solve the problem of other large data volumes)