I'm trying to use insertRecords to create a new Invoice. The data comes from our accounting system so we don't plan to use Zoho CRM to generate the actual invoice, but we want the sales people to see the invoice information on the Account page. That way the sales people can easily talk about recent orders while they have the customer on the phone.
It basically works fine using the XML below, except that no products appear. How do we get the products into the invoice?
<Invoices>
<row no="1">
<fieldlabel value="Subject">Regular Weekly Order</fieldlabel>
<fieldlabel value="Customer No">5678</fieldlabel>
<fieldlabel value="Account Name">ABC Company</fieldlabel>
<fieldlabel value="Purchase Order">A-123</fieldlabel>
<fieldlabel value="Invoice Date">10/13/2009</fieldlabel>
<fieldlabel value="Product Name">Widgets</fieldlabel>
<fieldlabel value="Qty">255</fieldlabel>
<fieldlabel value="Net Total">250.65</fieldlabel>
<fieldlabel value="Sub Total">250.65</fieldlabel>
<fieldlabel value="Grand Total">250.65</fieldlabel>
</row>
</Invoices>