[Vtigercrm-developers] vtigercrm-developers Digest, Vol 177, Issue 28
Tony Sandman
tonysandman999 at gmail.com
Wed Oct 7 03:10:37 GMT 2020
Come on.. stay with us!
On Wed, Oct 7, 2020 at 9:49 AM Dinishika Weerarathna <todinishika at gmail.com>
wrote:
> Please unsubscribe me from your mailing list.
>
> On Tue, Oct 6, 2020 at 6:45 PM <
> vtigercrm-developers-request at lists.vtigercrm.com> wrote:
>
>> Send vtigercrm-developers mailing list submissions to
>> vtigercrm-developers at lists.vtigercrm.com
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>
>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>
>> or, via email, send a message with subject or body 'help' to
>> vtigercrm-developers-request at lists.vtigercrm.com
>>
>> You can reach the person managing the list at
>> vtigercrm-developers-owner at lists.vtigercrm.com
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of vtigercrm-developers digest..."
>>
>>
>> Today's Topics:
>>
>> 1. Re: Creating Inventory records via Webservice (Martin Allen)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Tue, 6 Oct 2020 14:12:27 +0100
>> From: Martin Allen <martin.allen at clystnet.com>
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: Re: [Vtigercrm-developers] Creating Inventory records via
>> Webservice
>> Message-ID:
>> <CAL1vgxHB1gFF262kEDzoprYK=iZEP3LEDP0F4hRK=
>> SCZM2Otmw at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> 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!
>>
>> Thanks.
>>
>> 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!
>>
>> $params = array (
>> 'assigned_user_id' => 'administrator',
>> 'subject' => 'REST salesOrderSubject 6',
>> 'bill_city' => 'Drachten',
>> 'bill_code' => '9205BB',
>> 'bill_country' => 'Netherland',
>> 'bill_pobox' => '',
>> 'bill_state' => '',
>> 'bill_street' => 'schuur 86',
>> 'carrier' => NULL,
>> 'contact_id' => NULL,
>> 'conversion_rate' => '1.000',
>> 'currency_id' => '21x1',
>> 'customerno' => NULL,
>> 'description' => 'Producten in deze verkooporder: 2 X Heart of David -
>> songbook 2',
>> 'duedate' => '2018-11-06',
>> 'enable_recurring' => '0',
>> 'end_period' => NULL,
>> 'exciseduty' => '0.000',
>> 'invoicestatus' => 'Approved',
>> 'payment_duration' => NULL,
>> 'pending' => NULL,
>> 'potential_id' => NULL,
>> 'productid' => '14x42',
>> 'vtiger_purchaseorder' => NULL,
>> 'quote_id' => NULL,
>> 'recurring_frequency' => NULL,
>> 'salescommission' => '0.000',
>> 'ship_city' => 'schuur 86',
>> 'ship_code' => '9205BB',
>> 'ship_country' => 'Netherlands',
>> 'ship_pobox' => NULL,
>> 'ship_state' => NULL,
>> 'ship_street' => 'Drachten',
>> 'account_id' => '11x37',
>> 'sostatus' => 'Approved',
>> 'start_period' => NULL,
>> 'salesorder_no' => NULL,
>> 'terms_conditions' => 'The payment is expected within 30 days.',
>> 'discount_type_final' => 'percentage', // zero/amount/percentage
>> 'hdnDiscountAmount' => '0.000', // only used if 'discount_type_final'
>> == 'amount'
>> 'hdnDiscountPercent' => '20.000', // only used if
>> 'discount_type_final' == 'percentage'
>> 'pre_tax_total' => '1000.00',
>> 'txtAdjustment' => '25.00',
>> 'hdnS_H_Amount' => '20.00',
>> 'hdnS_H_Percent' => '19',
>> 'shipping_handling_charge' => 0,
>> 'shtax1' => 0, // apply this tax, MUST exist in the application with
>> this internal taxname
>> 'shtax2' => 0, // apply this tax, MUST exist in the application with
>> this internal taxname
>> 'shtax3' => 0, // apply this tax, MUST exist in the application with
>> this internal taxname
>> 'adjustmentType' => 'add', // none/add/deduct
>> 'hdnTaxType' => 'group', // group or individual taxes are obtained
>> from the application
>> 'LineItems' => Array(
>> '0' => Array (
>> 'productid' => '14x42',
>> 'sequence_no' => '1',
>> 'quantity' => '1.000',
>> 'listprice' => '500.00',
>> 'discount_percent' => null,
>> 'discount_amount' => null,
>> 'comment' => 'sample comment product',
>> 'description' => 'product description',
>> 'incrementondel' => '0',
>> 'tax1' => '19.00',
>> 'tax2' => '0.00',
>> 'tax3' => '0.00'
>> ),
>>
>> )
>> );
>>
>> Martin Allen
>>
>>
>> *01392 248692 - Main Office01392 690659 - Direct Line*
>>
>> *[image: signature2]*
>>
>> Have you visited our website recently? http://www.clystnet.com
>>
>>
>> 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
>>
>>
>> On Tue, 6 Oct 2020 at 13:40, Alan Lord <alanslists at gmail.com> wrote:
>>
>> > Try calling vtsw_describe for both the Inventory module you are creating
>> > AND for the "LineItem" module ;-)
>> >
>> > It will show you which fields are mandatory etc:...
>> >
>> > > vtws_describe for LineItem
>> > > Array
>> > > (
>> > > [label] => LineItem
>> > > [name] => LineItem
>> > > [createable] => 1
>> > > [updateable] => 1
>> > > [deleteable] => 1
>> > > [retrieveable] => 1
>> > > [fields] => Array
>> > > (
>> > > [0] => Array
>> > > (
>> > > [name] => parent_id
>> > > [label] => parent id
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [refersTo] => Array
>> > > (
>> > > [0] => Invoice
>> > > [1] => Quotes
>> > > [2] => PurchaseOrder
>> > > [3] => SalesOrder
>> > > )
>> > >
>> > > [name] => reference
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [1] => Array
>> > > (
>> > > [name] => productid
>> > > [label] => productid
>> > > [mandatory] => 1
>> > > [type] => Array
>> > > (
>> > > [refersTo] => Array
>> > > (
>> > > [0] => Products
>> > > [1] => Services
>> > > )
>> > >
>> > > [name] => reference
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [2] => Array
>> > > (
>> > > [name] => sequence_no
>> > > [label] => sequence no
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => integer
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [3] => Array
>> > > (
>> > > [name] => quantity
>> > > [label] => quantity
>> > > [mandatory] => 1
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [4] => Array
>> > > (
>> > > [name] => listprice
>> > > [label] => listprice
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [5] => Array
>> > > (
>> > > [name] => discount_percent
>> > > [label] => discount percent
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [6] => Array
>> > > (
>> > > [name] => discount_amount
>> > > [label] => discount amount
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [7] => Array
>> > > (
>> > > [name] => comment
>> > > [label] => comment
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => text
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [8] => Array
>> > > (
>> > > [name] => incrementondel
>> > > [label] => incrementondel
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => autogenerated
>> > > )
>> > >
>> > > [nullable] =>
>> > > [editable] =>
>> > > [default] => 0
>> > > )
>> > >
>> > > [9] => Array
>> > > (
>> > > [name] => id
>> > > [label] => lineitem id
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => autogenerated
>> > > )
>> > >
>> > > [editable] =>
>> > > [nullable] =>
>> > > [default] =>
>> > > )
>> > >
>> > > [10] => Array
>> > > (
>> > > [name] => tax1
>> > > [label] => VAT
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [11] => Array
>> > > (
>> > > [name] => tax2
>> > > [label] => Sales
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [12] => Array
>> > > (
>> > > [name] => tax3
>> > > [label] => Service
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [13] => Array
>> > > (
>> > > [name] => image
>> > > [label] => image
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => string
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [14] => Array
>> > > (
>> > > [name] => purchase_cost
>> > > [label] => purchase cost
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > [15] => Array
>> > > (
>> > > [name] => margin
>> > > [label] => margin
>> > > [mandatory] =>
>> > > [type] => Array
>> > > (
>> > > [name] => double
>> > > )
>> > >
>> > > [nullable] => 1
>> > > [editable] => 1
>> > > )
>> > >
>> > > )
>> > >
>> > > [idPrefix] => 33
>> > > [isEntity] =>
>> > > [labelFields] =>
>> > > )
>> >
>> >
>> >
>> > On 06/10/2020 13:34, Martin Allen wrote:
>> > > Has anyone been able to successfully create a
>> > > Quote/Invoice/SalesOrder/PurchaseOrder record via WebService? If so
>> what
>> > > data structure does it require?
>> > >
>> > > I am trying and keep getting a blank 200 response - I know that I need
>> > > to add a 'LineItem' array but have no idea what fields need to be in
>> it?
>> > >
>> > > Can't find any documentation on this...
>> > >
>> > > Martin Allen
>> > >
>> > > *01392 248692 - Main Office
>> > > 01392 690659 - Direct Line*
>> > >
>> > > *signature2*
>> > >
>> > > Have you visited our website recently? http://www.clystnet.com
>> > > <http://www.clystnet.com/>
>> > >
>> > >
>> > > 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
>> > >
>> > >
>> > > _______________________________________________
>> > > http://www.vtiger.com/
>> > >
>> > _______________________________________________
>> > http://www.vtiger.com/
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201006/1ec57aa4/attachment.html
>> >
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: image001.png
>> Type: image/png
>> Size: 10550 bytes
>> Desc: not available
>> URL: <
>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201006/1ec57aa4/attachment.png
>> >
>>
>> ------------------------------
>>
>> _______________________________________________
>> vtigercrm-developers mailing list
>> vtigercrm-developers at lists.vtigercrm.com
>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>
>>
>> End of vtigercrm-developers Digest, Vol 177, Issue 28
>> *****************************************************
>>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201007/31ad4673/attachment-0001.html>
More information about the vtigercrm-developers
mailing list