Hi I’m under training with NetSuite and they gave ...
# accountingg
Gabriela Marie
03/30/2023, 10:42 PMHi I’m under training with NetSuite and they gave me this as assignment. Can anyone explain further the scenario and where do I go from there? Thanks
t
Tristan Day
03/31/2023, 5:57 AMIf that is on the same record you've based your saved search on, it doesn't need a join
m
MGBC
03/31/2023, 12:58 PMAlso why use 3 separate formulas? Why not just use TO_CHAR({trandate}, 'YYYY-MM-DD')?
MGBC
03/31/2023, 1:00 PMbut yes assuming startship date is on your purchase order there is no need to add the purchaseorder. at the front of your field ID's
MGBC
03/31/2023, 1:00 PMJust use TO_CHAR({custbody_startship},'YYYY-MM-DD')
g
Gabriela Marie
03/31/2023, 11:24 PM@Tristan Day thanks I’ll check about join. I havent learned about it at this point in my training. Im just confused with whole scenario here, how does one build PO report by exporting file? Sorry no prior netsuite experience
Gabriela Marie
03/31/2023, 11:26 PM@MGBC thanks for the tips ill test those out