I’m creating an inventory app that is performed every month. The user can import the data once a month to do the inventory. Inventory in the following month does not rely on the previous month. However, I still want the user to be able to filter back to a month and pull the inventory count numbers
Problem: I don’t want to use uneccessary data rows when it’s not going to be utilized for most of the time. But I still want the user to be able to retrieve the inventory done in prior months and that requires me to maintain the data
Solution: Is there a way where I can save a snapshot of the past inventory in PDF so I can always override the rows for the month I’m doing inventory for (overriding the current month will ensure minimum rows used)? That way, users can still go back and retrieve the inventory count as a PDF but not real time
