Hello,
I need help.
I want to calculate my inventory for a certain period date. Currenlty i get my information through a table with SQL. and i can get the the inventory value for the specific date, if i sell anything my inventory gets updated.
For example, if my inventory is currently:
| March 25, 2019 |
| Product | $Value |
| a | $ 4,000.00 |
| b | $ 1,200.00 |
| c | $ 600.00 |
| d | $ 1,300.00 |
| e | $ 100.00 |
| | $ 7,200.00 |
I want to be able to get the inventory from the beginning of the month or if i put a certain date like the beginning of last i want to know what was my inventory at that date:
Example:
| | November 1, 2018 | December 1, 2018 | January 1,2019 | February 1, 2019 | March 1, 2019 |
| | Product | $Value | Product | $Value | Product | $Value | Product | $Value | Product | $Value |
| | a | $ 2,000.00 | a | $ 400.00 | a | $ 5,400.00 | a | $ 3,000.00 | a | $ - |
| | b | $ 1,500.00 | b | $ 800.00 | b | $ 300.00 | b | $ 5,000.00 | b | $ 2,500.00 |
| | c | $ - | c | $ 1,500.00 | c | $ 800.00 | c | $ 3,000.00 | c | $ 1,200.00 |
| | d | $ 3,400.00 | d | $ 2,500.00 | d | $ - | d | $ 5,000.00 | d | $ 3,400.00 |
| | e | $ 2,000.00 | e | $ 6,000.00 | e | $ - | e | $ 4,000.00 | e | $ 1,500.00 |
| Total Stock | | $ 8,900.00 | | $ 11,200.00 | | $ 6,500.00 | | $ 20,000.00 | | $ 8,600.00 |
