Is it possible to insert into supplier prices without going through the worksheet?

Hello James,

I’m not sure about rest API… but we CAN directly type into Vendor Prices screen without a worksheet, and we can Import with Import Scenarios, directly into Vendor Prices without a worksheet…  I expect rest API would have similar capabilities. 

Worst case, I’ve added a post to yours and my action will push your post back to the top of the Active threads list so a developer will be more likely to notice it and confirm for you.

Best regards,

Laura

Thanks Laura, yeah I just realised the worksheet is for “last purchased price”, I can directly type into VendorPricesInquiry screen. I am trying to do it over REST API so I can process pricebook imports automatically every night, but i am shooting in the dark at the moment.

This is a strange screen, and I'll admit, I had to dig a little, but it is possible to add records to it.

It is an inquiry screen, which means that it behaves differently than other screens. To GET the records, you actually do a PUT. And to CREATE records, you also do a PUT 🙂

Here's a 'get': 

PUT: ~/entity/Default/24.200.001/VendorPricesInquiry?$expand=VendorPriceDetails

{
    "InventoryID": {
        "value": "AAPOWERAID"
    }
}

This gets all records for 'AAPOWERAID'

Here's a 'create':

PUT: ~/entity/Default/24.200.001/VendorPricesInquiry?$expand=VendorPriceDetails

{
    "InventoryID": {
        "value": "AAPOWERAID"
    },
    "VendorPriceDetails": [
        {
            "Vendor": { "value": "ACADOIT" },
            "InventoryID": { "value": "AAPOWERAID" },
            "UOM": { "value": "EA" },
            "Price": { "value": 123.0 }
        }
    ]
}

This creates a new record for the 'ACADOIT' Vendor. This will also return all 'AAPOWERAID' records. I believe the parameters could be used to reduce the returned records.