In NetSuite, the Last Purchase Price and Purchase Price fields on item records serve distinct purposes, yet they often intersect in purchasing processes. Understanding these differences is crucial for effective procurement and inventory management. Here’s a breakdown of these fields and their functionality. Last Purchase Price The Last Purchase Price reflects the most recent price… Continue reading Differences Between Last Purchase Price and Purchase Price in NetSuite
Tag: Purchase price
Purchase Price Value is Different in the Saved search from the Amount in Item Record
If the User is using the Multi-Currency feature, then the Purchase Price shown on a saved search may be different from what is shown on the item record. The reason for this is that the purchase price amount shown on the saved search is converted to your Base Currency, while the purchase price showing on… Continue reading Purchase Price Value is Different in the Saved search from the Amount in Item Record
Update the purchase price of the vendor in the inventory record
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
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