Zoho Sheet-Pulling in Data
I have a module where we track POs, Bills etc (its easier for us this way). In this PO Module, we have a task related to a Job/Deal and various fields for costs. A Supplier on a Job might have several POs in this module for the job. I want to generate a Sheet with a list of these costs from the different PO Module inputs, but just for that job eg:
Supplier Job/Deal PO Module Ref Amounts
XYZ Builder Job 003 PO 1 $3000
Job 003 PO 1 $2000
Job 003 PO 2 $1000
Can this be done?
It would work if data could be pulled in from the Vendors Related List, but it doesn't look like it can.