[Vtigercrm-developers] vtigercrm-developers Digest, Vol 177, Issue 28
Dinishika Weerarathna
todinishika at gmail.com
Wed Oct 7 02:47:04 GMT 2020
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
> *****************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201007/a164653b/attachment-0001.html>
More information about the vtigercrm-developers
mailing list