My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
Please note that on Friday, September 19, 2025, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

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