1
I need to create a control of purchases per line where generates a purchase need considering the quantity of each product per customer compared to stock availability.
As in the example of the table below I have an item XXX that repeats in different customers with different quantities my stock is 10un and the total demand is 21un for the first line I have availability not being necessary to buy however for the second line need to buy 01un, STK-Customer demand A, in the third line I need 10un, STK-Customer demand A-Customer demand B.
It is possible to create this type of control?
Note work in a company that has registered 15mil products where we receive orders every day.
Example table Attachment:
Result table Attachment:
I’m trying to adapt this Cód. I found on this site of Mr Alegr in the theme Add cascading data from a column in Access, but as it sums up by date and the BD where I am working the same item repeats at least 15 clients in the same day I’m not getting.