Clarification is needed on setting purchase price in the line level of the inventory record. Solution- We may use the CSV import to update the supplier’s purchasing price. However, the purchase price cannot be updated using the standard mass update feature
Tag: Purchase price
Item search to show the preferred vendor and it’s purchase price
There will be multiple line associated with item saved search when the feature Multiple Vendors = T. To limit the Search results only to the Preferred Vendor’s Purchase Price, please follow the steps below: Create a saved search for item on the criteria tab select the type of item Formula (Numeric) > Formula: case when {vendor}… Continue reading Item search to show the preferred vendor and it’s purchase price
Updating Item Purchase Prices
NetSuite enables you to update the purchase price on selected items to the price on the most recent purchase of that item. This price reflects the most recent transaction for the item added to inventory. For example, a purchase receipt, inventory transfer, or inventory adjustment. This does not include item returns or assembly unbuilds. You… Continue reading Updating Item Purchase Prices
Function to update the vendor purchase price of the Item
Jira Code : BGGN-529
Editing the Item Vendor Prices When Multiple Vendors Are Enabled
Jira Code : BGGN-529 Scenario When multiple Vendors are enabled, item vendors are now their own subrecord, and the prices under it opens up another table so the user cannot simply use record.SetSublistValue() to set the item vendor’s data. This article shows how to edit the purchase price subrecord via script. Note: This is only… Continue reading Editing the Item Vendor Prices When Multiple Vendors Are Enabled