This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Any idea how to get the Inventory Count number on the Inventory Adjustment record?

Apparently Inventory Counts create Inventory Adjustment records.

Accounting want to see the Inventory Count number on the Memo field on the Inventory Adjustment.

In a perfect world I would have used `Created From`  but that does not exist in the Inventory Adjustment record.

I hope there is. Haven't been able to find one

<@UPB6XUVQS> Not sure if this helps, but using SuiteQL and the PreviousTransactionLineLink table, it is possible to work back from an Inventory Adjustment to the source Inventory Count transaction.

For example, if the ID of the Inventory Adjustment is 26273, you'd use something like this:
```SELECT PreviousDoc, BUILTIN.DF( PreviousDoc ) FROM PreviousTransactionLineLink WHERE NextDoc = 26273```

Yeah, I'd check "Applied to" and "Applied from" transaction