Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with the following data:
Product, Date, Stock
aaaa, 30/01/2017, 100
bbbb, 25/01/2017, 150
cccc, 30/01/2017, 120
...
And we also have for each date, the movements (inputs and outputs) produced in another table:
Product, Date, Input, Output
aaaa, 25/01/2017, 40,0
aaaa, 15/01/2017, 0, 30
aaaa, 10/01/2017, 50,0
bbbb, 20/01/2017, 0, 35
bbbb, 16/01/2017, 22, 0
bbbb, 14/01/2017, 14,0
bbbb, 12/01/2017, 0, 35
cccc, 28/01/2017, 16,0
cccc, 26/01/2017, 0,18
cccc, 24/01/2017, 0, 10
....
We have to get a table with a record for each product and date (from min Date to Max Date) indicating the stock at that date.
Product, Date, Stock
Thank's in advance
Hi,
Here you have an excel with data and result expected
Thank's in advance
Saludos,
Enrique Colomer
May be you have some idea to see the UI. Can you let us know your expected Table to see
Hi,
Here you have an excel with data and result expected
Thank's in advance
Saludos,
Enrique Colomer
this is just a demo, for printing every product on a separate sheet, you'll need NPrinting, macros or a patient assistent