Discussions
On Thursday, February 13 at 12PM to 2PM EST. Oracle-NetSuite Support will be holding an All Hands Meeting. We will be able to assist with Emergency cases and calls during this time. All other cases will be responded to upon our return. Thank you
[SOLVED] Secondary Book Value for Inventory in Item Record
How do I show the inventory value in Item Record but the currency will be in Secondary Book currency?
I created a custom field for Item Record and in the Custom Item Field Record, under validation and defaulting, I selected a saved search
But after I create this, when I check the item record, there is no value in the custom item field.
The saved search is like this:
type: transaction
criteria:
account is Inventory Asset
Multi-Book Accounting Transaction is Secondary Book
results:
Multi-Book Accounting Transaction : Amount (sum)
filter:
item
UPDATE: I have found why it is not working. There's a field in custom item field record called 'field'. I originally selected a value for this field but for my case I should leave this empty. So when I updated the custom item field record, my field is not correct.