User_TRQT3

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

Comments

Hey Niks, Apologies I was away on vacation. The NS_Concat solution worked - thank you for helping me find the solution!

in Saved Search : Concat all item description on a Sales order to a single line Comment by User_TRQT3 Sep 3, 2024 7:11PM
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

in Saved search Formula for date ranges Comment by User_TRQT3 Apr 25, 2024 8:42PM
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

in Saved search Formula for date ranges Comment by User_TRQT3 Apr 25, 2024 7:27PM

User_TRQT3 Red Ribbon

Comments