How is Last Purchase Price tracked for Non-Invento...
# ask-stanley-ai
m
How is Last Purchase Price tracked for Non-Inventory Items?
c
AI generated answer (using internal Slack threads):
The Last Purchase Price for Non-Inventory Items in NetSuite can be tracked using a few different methods. One way is to use a saved search with a JOIN criteria or transaction.type. You would look for the most recent (Max dated) transaction and return the price. This can be done by using the Results column Amount / When Ordered By. Another way is through inventory transfers. If you have Multiple-Location inventory setup, the Last Purchase Price should update automatically based on the last "positive-inventory" transaction for any location. If this feature is unchecked, it will update based on the transaction location. However, if the location it's going to doesn't have any transactions, the Last Purchase Price might show as $0. Lastly, the Last Purchase Price might be set by an Item Receipt from Return Authorization or an Inventory Adjustment. This could explain why the Last Purchase Price is displayed as the recent Sale price of the Item even though the item has a Purchase history. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.854980528
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843444943
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829162657
Please provide your feedback on this answer.
Thank you for your feedback