I am trying to come up with a way to create an excel report of my items and their quantity on hand. I need the report to automatically be emailed to certain recipients at a certain time.
There are a few inventory reports built into Zoho Inventory but it doesn’t seem like the reports can be altered to just list part numbers and quantity on hand. Zoho Analytics can automatically generate a report and automatically email it. I have been trying to build a report in Analytics that would display the information I need so that it can be automated from there but keep running into issues with the quantities displaying properly.
Any idea how I can accomplish this?
Any help would be greatly appreciated!