Hello Experts,
I have created a saved search which...
# administrationn
Nawarain
02/02/2023, 5:45 PMHello Experts,
I have created a saved search which is pulling data related to vendors from different transactions. I am using formula text to pull vendor name from transaction and using summary type group but I am unable to view detailed result when try to click on vendor name doing nothing. Please guide what I am doing wrong. Also guide on is there any formula to insert/add commas to amount result column?
m
Matt L
02/02/2023, 6:00 PMdid you disallow drill down in the results tab when editing the search?
Matt L
02/02/2023, 6:00 PMmessage has been deleted
Matt L
02/02/2023, 6:03 PMyou may need a top level field to allow drill down as well
n
Nawarain
02/02/2023, 6:29 PM@Matt L No disallow
Nawarain
02/02/2023, 6:29 PMWhat do you mean by top level field?
Nawarain
02/02/2023, 6:36 PMI believe that drill down to detailed results only work if we use group as summary type on NetSuite native fields rather than using any formula.
m
Matt L
02/02/2023, 6:36 PMwhy don't you use Vendor : Name? What does the formula pull that vendor name doesn't?
Matt L
02/02/2023, 6:37 PMtop level as in a basic field on the txn you are accessing and I believe that would allow you to drill down, but looking at your ss I'm not sure what other field you would add without adding more lines
Matt L
02/02/2023, 6:38 PMVendor : Name makes sense to me unless you are pulling/formatting the name in a certain way
Matt L
02/02/2023, 6:39 PMmessage has been deleted
Matt L
02/02/2023, 6:39 PMThen selecting Name
n
Nawarain
02/02/2023, 6:44 PMI am using formula to remove NONE as vendor name in results because you know that on some transaction vendor select on body level and on some select as line level.
m
Matt L
02/02/2023, 6:45 PMTry adding that formula to the criteria then and run a normal Vendor : Name in results?
Matt L
02/02/2023, 6:46 PMas for commas you can try to_char({amountpaid},'$9,999,999')
Matt L
02/02/2023, 6:46 PMand just change the field to your needs
Matt L
02/02/2023, 6:47 PMUSD symbol changed to your needs as well
n
Nawarain
02/02/2023, 6:51 PMTO_CHAR only works for formula text field and sum summary type can't be used for this formula.
Nawarain
02/02/2023, 6:52 PMIt's NetSuite standard validation
✅ 1
Nawarain
02/02/2023, 6:56 PMI have tried your solution and it's showing value against NONE but when I click on NONE to details, it's shows nothing.
Nawarain
02/02/2023, 6:56 PMmessage has been deleted
m
Matt L
02/02/2023, 10:31 PMdoes your formula use is NULL?
Matt L
02/02/2023, 10:31 PMwhat are you doing to filter out -none-
Matt L
02/02/2023, 10:38 PMI would also try using in criteria: Vendor :name is not empty. as a selection. if that doesn't do it, I'm lost without being able to test myself. hope you figure it out!
n
Nawarain
02/03/2023, 6:29 AMNot using NULL
w
Watz
02/03/2023, 4:16 PMI don't think formulas are drillable
n
Nawarain
02/03/2023, 4:45 PM@Watz Yes, that's what I also believe.
m
Matt L
02/03/2023, 4:47 PMyeah you can't drill into formulas hence why I recommended trying to add in Vendor : name as a solution and filtering out -none- in criteria. did you try that method? @Nawarain
n
Nawarain
02/03/2023, 4:48 PM@Matt L Tried this but for NONE it's showing values on summary page but when try to drill down it shows blank.
3 Views