My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comments
-
Hey Niks, Apologies I was away on vacation. The NS_Concat solution worked - thank you for helping me find the solution!
-
Update: I was able to figure it out - correct formula is CASE WHEN {trandate} BETWEEN TO_DATE('01/01/2023','MM/DD/YYYY') AND TO_DATE('06/30/2023','MM/DD/YYYY') THEN {totalamount} ELSE 0 END
-
Hey @Tris Mendoza-Oracle Thanks for reaching out! The date filter in criteria is just to shrink the report size while I am testing. See attached