[GGregg]

As NetSuite allows the purchase prices of items to be updated via purchase receipt, inventory transfer or inventory adjustment, I want to build a report / search to show me what items have had changes in purchase prices.

Ideally, output would show:

Date

Item

Old Value

New Value

Internal ID (of posting transaction)

Employee

Any ideas on how to achieve this? I can’t find where to pull the values from. The don’t show up in System Information, but do flow through to the price field.

Thanks.
This is a cached copy. Click here to see the original post.

[SteveTaylor]

I’m seeing changes in purchase price in sys info on my system. Use the field filter and select either All or Purchase Price.

How to get these into a search would probably require a formula of some kind.

[amiller88]

GGregg, Assuming you mean last purchase price I don’t see it in system notes either. SteveTaylor, where do you see it?

[SteveTaylor]

You all are correct. I was looking at purchase price and that will show up in sys info. But it doesn’t look like Last Purchase Price is available as a field. I think it would make more sense to have Last Purchase and/or Average Cost changes.

[davidjhope]

RE: Monitoring Changes in Purchase Prices

This is something we are looking for as well.

[pguevarra]

Hello All,

I just want to ask what Purchase Price are you pertaining to? There is a Purchase Price Field in the Item Record but this field can only be changed manually, Mass Update or via CSV Import Update but not by Transactions. Changes done to this field are logged via System Notes.

If you want to create a report to see the changes done on this field, You can create an Item Search. Enter Filter in Criteria Tab for System Notes Field…> Field > Purchase Price. Enter Fields in Result Tab > System Notes Field…> Date, New Value, Old Value, Set By & Type.

There is also a Last Purchase Price Field which derives its value from the latest transaction that posted a value on the Asset Account of the item. While this field updates as posting transactions are entered, it does not store historical state. Therefore, there is no reference as to what the previous values are. It follows that changes to this field are not logged in System Notes.

You can create a Transaction Saved Search to show which Transactions used a different rate other than the Item’s Purchase Price

Create a Transaction Search. Add a Filter under Criteria > Formula (Numeric) > Formula: {rate}-{item.cost} is not equal to 0. You may also add a Type Filter to specify transaction types you want to include. Under Results Tab, add Item Rate and Item Fields…> Purchase Price.

Hope this helps. Thanks.

[GGregg]

I don’t think your suggestions really take me where I want to go.

We don’t use set purchase prices for all items as there are frequent purchase price changes from suppliers. We work off Last Purchase Price.

Since there are multiple opportunities to update the Last Purchase Price and this impacts on the GL, I want to be able to see when this happens, by whom and by what amount.

We have had instances where a staff member inadvertently change the value of an item which flowed through to the GL. It was only by chance that we discovered this. We don’t want stock valuations to be impacted.

If no report can be written (since data is not stored), is there a way to restrict the Last Purchase Price updating methods to fewer transaction types? Ie., only item receipt?

[pguevarra]

By design, the Last Purchase Price Field does not only come from Purchasing Transactions but rather, it comes from the latest transaction that increased the value of your Item’s Asset Account. Thus it may come from Standalone Bills, Receipts, Revaluations, Adjustments among others (for as long as increased the value of your item’s asset account and is linked to the item record)

It is also sorted per Location.

[Author]

Posts