Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
create a custom field to pick up customer name from invoice and journal
Hi
Revenue is posted to the revenue nominal account from 2 sources: sales invoices and journal for release of deferred revenue, following fulfilment. I would like to run a transaction report from this revenue nominal account with the customer name from both sources in one common field. To do this, a custom field needs to be created to pick the customer name (transaction body field) from the sale invoice and also the customer name( transaction line field) from the journal. To create this custom field, do I select transaction body field and in the validation/defaulting subtab, what is the formula I should add to pick up the customer from the above 2 different sources?
0