Adam Weaver
10/15/2024, 3:41 PMCeligo AI
10/15/2024, 3:41 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems that adding a column to show after adjustment totals on inventory adjustments directly is not explicitly discussed. However, there are mentions of using SuiteQL and the PreviousTransactionLineLink table to trace back from an Inventory Adjustment to the source Inventory Count transaction. This could potentially be used to calculate and display the after adjustment totals. Here is the SuiteQL example provided:
SELECT PreviousDoc, BUILTIN.DF( PreviousDoc ) FROM PreviousTransactionLineLink WHERE NextDoc = 26273
This query selects the PreviousDoc and its display form from the PreviousTransactionLineLink table where the NextDoc is the ID of the Inventory Adjustment. This could be adapted to calculate the after adjustment totals.
******
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
10/15/2024, 3:41 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82202
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821184397
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819279909
Celigo AI
10/15/2024, 3:41 PM