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

need to test for non-item receipt transactions, but I'm using this formula (summary type SUM) to get location-level Last Purchase Price (in the receipt's currency):
`SUM({transaction.debitfxamount}) KEEP(DENSE_RANK LAST ORDER BY {transaction.trandate})/SUM({transaction.quantity}) KEEP(DENSE_RANK LAST ORDER BY {transaction.trandate})`

this is for when you want to include landed costs (i.e. Accounting Preferences &gt; Items/Transactions &gt; Inventory &gt; Include Landed Cost in Last Purchase Price)
I'm not doing any UOM conversion here (either into stock units, or purchase units), so this is only in Base Units.