3946247 Newbie

That sounds good, but how do I figure out the internalId? Is this something where I can use getSelectValue() Out of the possible getSelectValue options inventoryItem_pricingGroup is the only one that looks relevant, but still probably not what I'm looking for. - Sosh

Finally managed to update a price! That seems a little more complicated than it really should be... [PHP] $item['pricingMatrix'] = array( 'pricing' => array( 'priceLevel' => new nsRecordRef(array('internalId' => '1')), 'priceList' => array( 'price' => array( 'value' => $price ) ) ), 'replaceAll' => true ); [/PHP]

When I go to the UI and view the record I am viewing an inventory item record that has the PriceLevel list displayed in it. Are you saying that the I'm looking for the internalId for the item? If I just need to reference the item ID getting that is easy. If I'm looking for another internalId, such as for he priceLevel item…

Mariano, Thanks for your help. I believe that we're using Price Levels and I have not seen reference to Quantity Pricing or Multiple Currencies. The code example you've given me does not produce any errors, but doesn't update the price either, but it looks like we're going in the right direction :) Thanks again for your…

I've been able to distinguish that the Price Level Base Price has an internalId of 1. I would love to be able to update the base price for an item, which seems like it should be pretty straight forward. An example of some code, or even what fields I'm supposed to be setting would be awesome.

Thanks. I've found that I can use getSelectValue() for that.

I have found one problem with this that I'm strill trying to get around. I can set the order amount, but I still can't set the price. Its defaulting to the inventory item. I have hints that I'm supposed to set the priceLevel to customer, but have found no leads on how to actually do this. This is a problem because it will…

Thanks! That is very helpful.

So far I've figured out that I can set the amount at least to make what we charge our client correct: [PHP] $orderItem['item'] = new nsRecordRef(array('internalId' => $item_id)); $orderItem['price'] = $item->price; $orderItem['quantity'] = $item->amount; $orderItem['amount'] = $item->price * $item->amount;…

I'll try this and let you know. Ah... I see what the problem is. 'type' is a SearchEnumMultiSelectField. Try this... $itemSearch->setFields(array( "type" => array( "operator" => "anyOf", "searchValue" => "_purchaseOrder" ), "dateCreated" => array("operator" => "after", "searchValue" => "2009-06-01T00:00:00.000")));

That also doesn't work. I'm also confused about how you would even know about type _purchaseOrder. I've seen other people reverence _stuff before, but when I searched for "_purchaseOrder" in the help center I didn't see anything. I am wondering if there is some documentation somewhere that I don't know about. Still any…

That worked! Thank you so much. I am still confused though where to documentation is that would let me know the various types like _purchaseOrder. Thanks again, Sosh

Thanks Mariano! I'm trying what you suggested, but I am worried that I am setting the type incorrectly because I am still getting zero rows returned. Here is the code I'm using: $itemSearch = new nsComplexObject("TransactionSearchBasic"); $itemSearch->setFields(array("type" => "_purchaseOrder", "dateCreated" =>…

I'm not sure what you mean by path The PO's do not have multiple vendors. I will try and access a vendor though web services and see if I have any luck. If anyone has any example code of a working PO search in PHP I would greatly appreciate it. Thanks, Sosh

I'm trying to figure out how to do this in PHP. Any luck yet?