Where would I find point in time prices for items?
# ask-stanley-ai
t
Where would I find point in time prices for items?
c
AI generated answer (using internal Slack threads):
In NetSuite, point in time prices for items can be tracked using a custom record for each item and recording your historical pricing table there. This was suggested in one of the threads where a user was looking for a way to keep historical price levels and an effective date. Another user suggested creating a script on the Item record that saves a copy of the current pricing levels to a custom record when the record is saved. If you want the price at the end of every day (even if it doesn't change), you could create a scheduled script every night to save a copy of the current prices to that custom record. This would only log when there is a change. For FIFO costing method, one of the threads suggested running or scheduling an Item Price Mass Updates every day or as needed. You can go to Lists > Mass Update > Update Prices. On the Mass Update page, you could select Average Cost, for example, in the Bases On dropdown. Enter the percentage in the Amount field. You'll have to set one up for each price level but you can run it automatically on a schedule or on demand. For upcharging items if they aren't bought by the case/box, you can use Quantity Based Pricing. However, if the client wants to upcharge any time a quantity is not a multiple of the case quantity, you may be best off just keeping it simple and using a kit for the pack and a regular item for the individual unit and stocking separately. You can always use a kit item and stock in individuals that you order in packs. Then when you sell it, you have the individual price, and then when you need to sell a case, you use the kit item. ****** 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.798616946
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.796987176
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.794348478
Please provide your feedback on this answer.