Daily report of sales and storage

[Dican]

Hi everyone!

I have the next tables:

I've designed the app so I can register all the sales by vendors and register all the product that was sent from the storage to the vendors.

And I would like to generate a daily report that compares both tables.

I tried making another sheet where i would manually create an entry for every vendor with the date of today, when theres an register from the storage/vendor would update the report, but I find tedious making every day the entries of the vendors by date.

Ideas? Thanks! ❤️

[Marc_Dillon]

Make a daily Bot to generate a PDF?

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials