Is there a way to add a column to show after adjus...
# ask-stanley-ai
a
Is there a way to add a column to show after adjustment totals on inventory adjustments
c
AI 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:
Copy code
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. ******
Slack 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
Please provide your feedback on this answer.