Understanding Zoho Finance Data in Zoho Analytics
The Confusing Product ID Field
On invoice items, for example, the Item ID is NOT the ID of the actual item in the Items module. It’s the unique ID of the invoice item record.
The Product ID is the ID of the item in the items module.
So, if joining via SQL or trying to debug/investigate something, use the Product ID when working across modules.