Ryan Longenecker
03/14/2025, 12:03 AMCeligo AI
03/14/2025, 12:03 AMAI generated answer (using internal Slack threads):In NetSuite, when you do an inventory adjustment or transfer, the last purchase price from the old location is not automatically added to the new location. The last purchase price field on the inventory record is not updated by the transfer order even if the transfer cost was checked. This is because the transfer order is not considered a purchase transaction, hence it does not affect the last purchase price. However, you can manually update the last purchase price by editing and saving the inventory record. This will require you to manually input the last purchase price from the old location to the new location. As for the inventory revaluation, it seems that the GL impact of the inventory worksheet adjustment is based on the current inventory value, not the value at the time of the adjustment. If you need to backdate the revaluation, you might need to bring the inventory to 0 on a specific date with an inventory adjustment, then bring the inventory back up to stock at the correct value on the next day. This requires a full calendar day at 0 on hand for it to work. Please note that this will change the financials in that period, and you need to use an appropriate expense account or a holding account for both inventory adjustments. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
03/14/2025, 12:03 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837837398
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822709203
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817929447
Celigo AI
03/14/2025, 12:03 AM