<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Aah, hadn't thought about describing the LineItems separately - I was expecting to see it in the Describe for the Inventory module. Or even just a reference to LineItems as a module!</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Thanks.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">I did manage to stumble across this data structure (in a random community discussion) as a starting point that works so far - if anyone else has the same problem!<br><br><pre style="background-color:rgb(43,43,43);color:rgb(169,183,198);font-family:"JetBrains Mono",monospace;font-size:9.8pt"><span style="color:rgb(152,118,170);background-color:rgb(35,37,37)">$params </span><span style="background-color:rgb(35,37,37)">= </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">array </span><span style="background-color:rgb(35,37,37)">(<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'assigned_user_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'administrator'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'subject' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'REST salesOrderSubject 6'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_city' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Drachten'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_code' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'9205BB'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_country' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Netherland'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_pobox' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">''</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_state' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">''</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'bill_street' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'schuur 86'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'carrier' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'contact_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'conversion_rate' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'1.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'currency_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'21x1'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'customerno' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'description' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Producten in deze verkooporder: 2 X Heart of David - songbook 2'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'duedate' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'2018-11-06'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'enable_recurring' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'end_period' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'exciseduty' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'invoicestatus' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Approved'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'payment_duration' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'pending' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'potential_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'productid' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'14x42'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'vtiger_purchaseorder' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'quote_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'recurring_frequency' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'salescommission' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_city' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'schuur 86'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_code' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'9205BB'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_country' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Netherlands'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_pobox' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_state' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'ship_street' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Drachten'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'account_id' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'11x37'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'sostatus' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'Approved'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'start_period' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'salesorder_no' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">NULL,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'terms_conditions' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'The payment is expected within 30 days.'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'discount_type_final' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'percentage'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// zero/amount/percentage<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'hdnDiscountAmount' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// only used if 'discount_type_final' == 'amount'<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'hdnDiscountPercent' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'20.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// only used if 'discount_type_final' == 'percentage'<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'pre_tax_total' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'1000.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'txtAdjustment' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'25.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'hdnS_H_Amount' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'20.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'hdnS_H_Percent' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'19'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'shipping_handling_charge' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(104,151,187);background-color:rgb(35,37,37)">0</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'shtax1' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(104,151,187);background-color:rgb(35,37,37)">0</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// apply this tax, MUST exist in the application with this internal taxname<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'shtax2' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(104,151,187);background-color:rgb(35,37,37)">0</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// apply this tax, MUST exist in the application with this internal taxname<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'shtax3' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(104,151,187);background-color:rgb(35,37,37)">0</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// apply this tax, MUST exist in the application with this internal taxname<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'adjustmentType' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'add'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// none/add/deduct<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'hdnTaxType' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'group'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">, </span><span style="color:rgb(128,128,128);background-color:rgb(35,37,37)">// group or individual taxes are obtained from the application<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'LineItems' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">Array</span><span style="background-color:rgb(35,37,37)">(<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">Array </span><span style="background-color:rgb(35,37,37)">(<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'productid' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'14x42'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'sequence_no' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'1'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'quantity' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'1.000'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'listprice' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'500.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'discount_percent' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">null,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'discount_amount' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">null,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'comment' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'sample comment product'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'description' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'product description'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'incrementondel' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'tax1' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'19.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'tax2' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0.00'</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'tax3' </span><span style="background-color:rgb(35,37,37)">=> </span><span style="color:rgb(106,135,89);background-color:rgb(35,37,37)">'0.00'<br></span><span style="background-color:rgb(35,37,37)">)</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">,<br></span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)"><br></span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)"> </span><span style="background-color:rgb(35,37,37)">)<br></span><span style="background-color:rgb(35,37,37)">)</span><span style="color:rgb(204,120,50);background-color:rgb(35,37,37)">;</span></pre></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p style="font-size:12.8px;color:rgb(80,0,80)"><span style="color:navy;font-family:Verdana,sans-serif;font-size:10pt">Martin Allen</span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><b style="font-size:12.8px"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)">01392 248692 - Main Office<br>01392 690659 - Direct Line</span></b><br></p><p style="font-size:12.8px;color:rgb(80,0,80)"><b><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)"><img width="288" height="65" src="cid:image001.png@01CFC1D6.1BCFF790" alt="signature2"></span></b><span style="color:rgb(31,73,125)"></span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:navy">Have you visited our website recently? <a href="http://www.clystnet.com/" style="color:rgb(17,85,204)" target="_blank">http://www.clystnet.com</a></span><span style="color:rgb(31,73,125)"></span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:navy"><br></span><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(153,153,153)">The information in this email is confidential If you are not the intended recipient, you must not read or use that information. This email and any attachments are believed to be virus free however no responsibility is accepted by Clystnet for any loss or damage arising in any way from receipt or use thereof. Clystnet Ltd (company reg number 7164503) is based at Silverdown Park, Fair Oak Close, Clyst Honiton, EX5 2UX</span></p></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 6 Oct 2020 at 13:40, Alan Lord <<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Try calling vtsw_describe for both the Inventory module you are creating <br>
AND for the "LineItem" module ;-)<br>
<br>
It will show you which fields are mandatory etc:...<br>
<br>
> vtws_describe for LineItem<br>
> Array<br>
> (<br>
> [label] => LineItem<br>
> [name] => LineItem<br>
> [createable] => 1<br>
> [updateable] => 1<br>
> [deleteable] => 1<br>
> [retrieveable] => 1<br>
> [fields] => Array<br>
> (<br>
> [0] => Array<br>
> (<br>
> [name] => parent_id<br>
> [label] => parent id<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [refersTo] => Array<br>
> (<br>
> [0] => Invoice<br>
> [1] => Quotes<br>
> [2] => PurchaseOrder<br>
> [3] => SalesOrder<br>
> )<br>
> <br>
> [name] => reference<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [1] => Array<br>
> (<br>
> [name] => productid<br>
> [label] => productid<br>
> [mandatory] => 1<br>
> [type] => Array<br>
> (<br>
> [refersTo] => Array<br>
> (<br>
> [0] => Products<br>
> [1] => Services<br>
> )<br>
> <br>
> [name] => reference<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [2] => Array<br>
> (<br>
> [name] => sequence_no<br>
> [label] => sequence no<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => integer<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [3] => Array<br>
> (<br>
> [name] => quantity<br>
> [label] => quantity<br>
> [mandatory] => 1<br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [4] => Array<br>
> (<br>
> [name] => listprice<br>
> [label] => listprice<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [5] => Array<br>
> (<br>
> [name] => discount_percent<br>
> [label] => discount percent<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [6] => Array<br>
> (<br>
> [name] => discount_amount<br>
> [label] => discount amount<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [7] => Array<br>
> (<br>
> [name] => comment<br>
> [label] => comment<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => text<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [8] => Array<br>
> (<br>
> [name] => incrementondel<br>
> [label] => incrementondel<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => autogenerated<br>
> )<br>
> <br>
> [nullable] => <br>
> [editable] => <br>
> [default] => 0<br>
> )<br>
> <br>
> [9] => Array<br>
> (<br>
> [name] => id<br>
> [label] => lineitem id<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => autogenerated<br>
> )<br>
> <br>
> [editable] => <br>
> [nullable] => <br>
> [default] => <br>
> )<br>
> <br>
> [10] => Array<br>
> (<br>
> [name] => tax1<br>
> [label] => VAT<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [11] => Array<br>
> (<br>
> [name] => tax2<br>
> [label] => Sales<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [12] => Array<br>
> (<br>
> [name] => tax3<br>
> [label] => Service<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [13] => Array<br>
> (<br>
> [name] => image<br>
> [label] => image<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => string<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [14] => Array<br>
> (<br>
> [name] => purchase_cost<br>
> [label] => purchase cost<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> [15] => Array<br>
> (<br>
> [name] => margin<br>
> [label] => margin<br>
> [mandatory] => <br>
> [type] => Array<br>
> (<br>
> [name] => double<br>
> )<br>
> <br>
> [nullable] => 1<br>
> [editable] => 1<br>
> )<br>
> <br>
> )<br>
> <br>
> [idPrefix] => 33<br>
> [isEntity] => <br>
> [labelFields] => <br>
> )<br>
<br>
<br>
<br>
On 06/10/2020 13:34, Martin Allen wrote:<br>
> Has anyone been able to successfully create a <br>
> Quote/Invoice/SalesOrder/PurchaseOrder record via WebService? If so what <br>
> data structure does it require?<br>
> <br>
> I am trying and keep getting a blank 200 response - I know that I need <br>
> to add a 'LineItem' array but have no idea what fields need to be in it?<br>
> <br>
> Can't find any documentation on this...<br>
> <br>
> Martin Allen<br>
> <br>
> *01392 248692 - Main Office<br>
> 01392 690659 - Direct Line*<br>
> <br>
> *signature2*<br>
> <br>
> Have you visited our website recently? <a href="http://www.clystnet.com" rel="noreferrer" target="_blank">http://www.clystnet.com</a> <br>
> <<a href="http://www.clystnet.com/" rel="noreferrer" target="_blank">http://www.clystnet.com/</a>><br>
> <br>
> <br>
> The information in this email is confidential If you are not the <br>
> intended recipient, you must not read or use that information. This <br>
> email and any attachments are believed to be virus free however no <br>
> responsibility is accepted by Clystnet for any loss or damage arising in <br>
> any way from receipt or use thereof. Clystnet Ltd (company reg number <br>
> 7164503) is based at Silverdown Park, Fair Oak Close, Clyst Honiton, EX5 2UX<br>
> <br>
> <br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
> <br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div>