Mark
07/31/2025, 5:21 PMCeligo AI
07/31/2025, 5:21 PMAI generated answer (using internal Slack threads):In NetSuite, the First in Day option is used when posting an Inventory Worksheet. This option allows you to post the worksheet at the beginning of the day, and it will not include any additional inventory transactions that are entered during that day for this worksheet. An Inventory Worksheet is a tool used to adjust the inventory levels of items in your warehouse. It is different from an Inventory Adjustment, which is relative to your current inventory level. For example, if you have 10 items in stock and enter an adjustment for -2, your stock will be 8. If you later enter a backdated transaction that is before the adjustment date, then the stock in hand will take that into account as well. On the other hand, an Inventory Worksheet is an absolute value irrespective of previous history. This means that it sets the inventory level to a specific number, regardless of what transactions have occurred in the past. However, it's important to note that if you're trying to revalue inventory items backdated to a previous date without changing quantities, you might face some issues. The GL impact (actual adjustment) seems to be based on today's inventory value, which could be lower if some of the items have sold since then. This could result in an overstatement of the adjustment. One workaround suggested in the conversations is to bring the inventory to 0 on a day with no inventory transactions, wait for a full calendar day, and then bring the inventory back up to the correct value. This requires a full calendar day at 0 on hand for it to work. ****** 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
07/31/2025, 5:22 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.797517955
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.792888701
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.791944921
Celigo AI
07/31/2025, 5:22 PMMark
07/31/2025, 5:23 PM