AI provided the attached (a portion below) guidance about creating a direct method cash flow statement in NetSuite. Does the below seem reasonable? Does anyone have experience or tips with creating a direct basis cash flow statement?
Saved Search use a Formula (Date) field in your Results tabsql
CASE
WHEN {type.id} = 'CustPaym' THEN {trandate}
WHEN {type.id} = 'VendPymt' THEN {trandate}
WHEN {type.id} = 'CustInvc' THEN {applyingtransaction.trandate}
WHEN {type.id} = 'VendBill' THEN {applyingtransaction.trandate}
WHEN {type.id} = 'Journal' THEN {trandate}
ELSE {trandate}
END