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! 