megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Don't miss out on our Question of the Week ! You only have until tomorrow, March 12, 2026, 2:00PM ET to comment your answers.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here!
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
No Limits. Just possibilities. Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

User_WV14V Green Ribbon

Comments

  • Hi @Joahnna Given Uy-Oracle Thank you for your response! You are right, it is most likely empty, however, even if it is empty, I would expect that the line for Gross Profit for the Amount Fixed rate line 2 would be 1253491,01 Gross Profit = Total Sales - Total Purchases. My concern is more related to the formula row than…
    in How to add Formula in report for custom fields Comment by User_WV14V Jun 9, 2023 7:51AM
  • Hi @Elychelle Gulen-Oracle Thank you for your answer! We solved this issue. We have this custom field twice in the records, one in the main line and another in the transaction line. Even if I use {line.custseg1}, the system will get it from the main line, that's why it is not getting the correct result. Thank you!
    in How to create A/R Aging in Saved Search? Comment by User_WV14V Jun 9, 2023 7:10AM
  • Hi @Joahnna Given Uy-Oracle Sure, the multiplication mentioned previously is not set up, it was calculated beforehand, the field records are simple currency type fields. Transaction line field: Transaction body field
    in How to add Formula in report for custom fields Comment by User_WV14V May 31, 2023 6:05AM
  • Hi @Joahnna Given Uy-Oracle Yes, in the record it is shown correctly, because we are still testing, not all transactions have it yet. However, as you can see in my first message, in the screenshot the only amount that is calculated in the formula is the standard amount field. The formula used is the standard from a Income…
    in How to add Formula in report for custom fields Comment by User_WV14V May 30, 2023 6:05AM
  • Hi @Ivy Lopez-Oracle The field has Store Value, in the report we are using Add Grand Total. Nothing looked weird to me, but I could be missing something Thanks in advance!
    in How to add Formula in report for custom fields Comment by User_WV14V May 29, 2023 1:13PM
  • Hi @Elychelle Gulen-Oracle! Yes, it is a custom segment in transaction line and values are: shorten version or months + year. Using saved searches to test, I used my formula just as normal fields in the criteria subtab, I get the same result, however, it is not even close to the AR Aging report. When I check each…
    in How to create A/R Aging in Saved Search? Comment by User_WV14V May 29, 2023 6:25AM