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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Custom Transaction Record Needs Negative Values
Hello!
I have a custom transaction record with List Style set to basic.
The goal of this custom transaction record is to display a list of invoices and credit memos, the items associated with both, and have the invoice totals add up with the credit memo totals subtracting to show a net value in Amount in the header.
I'm successfully able to bring in the positive values associated with the invoices into the Amount field but when I try to bring in the negative from the credit memo I get "Value must be positive."
I've tried testing out if a Journal list style would work but the problem is that the debit and credit values have to balance.
0