What are the general solutions for warehouse accounting problems?

Question

Algorithms

Perhaps there is somewhere a description of the general algorithms of warehouse accounting? For example, calculating the cost of an order that is assembled from different batches (there are three batches with different product prices, one order is formed from them, you need to calculate its cost ... the task is, of course, simple, if you do not take into account thousands of orders and dozens of deliveries). I made a head-on solution, but it's not the most elegant... I want beauty.

Answer 1

How the cost of a batch is calculated when written off from a warehouse is determined primarily by accounting policy.
LIFO, FIFO, average.
Based on the methodology used, the desired algorithm is used.
In order to optimize calculations and reduce the load on databases during operational accounting, a special fixed price is used at which the write-off takes place, and at the end of the period, the write-off cost in each document is adjusted to the real one.
Also, 1C has a crap called Advanced Cost Accounting Analytics, which uses the numerical solution of SLAE to solve this problem.