-
Payment Saved Search with amount of the payment applied to each invoice
Hi All, I'm building a Transaction Saved Search in NetSuite to report on Customer Payments (CustPymt). The search is set to Type = Payment and Main Line = False. My goal is to list: Each payment The total payment amount The invoice(s) the payment is applied to The amount of the payment applied to each invoice The challenge…
-
Bill saved search to print Amount gross foreign currency for all bill lines
Hi, Am trying to create vendor bill saved search , to print all bill lines , I see there is option to use field amount (foreign currency) that prints net Amount in the currency of the subsidiary the bill belongs to but I dont see a field for Amount Gross ( Foreign currency) , is there a formula that can help. Looked at…
-
HOW TO COMPUTE FOR THE PERCENTAGE IN SAVED SEARCH
We want to get the percent of the first column based on the total amount please see the formula on the photo and its result.
-
SAVED SEARCH: Pull field from Payment in Invoice Record Saved Search Type
We want to pull the custom date field from the related Payment record in Invoice record type. Is that possible? Please help
-
How add the 'Item Last Purchase Date' to the Saved Search
Hello! I have a saved search with the type 'Transaction', and I need to add the 'Item Last Purchase Date' field to the results. I'm not entirely sure if such a field exists, as it's not mentioned in the documentation. Saved Search: Criteria: Results: I also saw an article that seems to be related to my question, but I…
-
Saved Search - formula (text) - custom field vs workflow field
Hi, We have a WF that changes a field name "Order state" in a Sales Order transaction. For some reason, we have cases when the WF state is advanced to the next state while the actual value in the SO field stays with the previous one. I would like to monitor those cases. I used the formula below in the Criteria of the Saved…
-
Deviation between 2 aggregation columns in saved search
Hi All, Is there any option to divide between two sum aggregation columns in saved search? See screenshot below
-
How to create Formula to get earliest open period on transaction search nonpposting transactions?
We need to use CASE WHEN formula when posting period is Null (in case of unposted transactions), it will display the earliest open period, I can use: CASE WHEN {approvalstatus}='Pending Approval' then (to_char({today}, 'Mon YYYY')) else {postingperiod} end However it will only display period based on today's date not…
-
WATCH: How to create a Sample SuiteLet to Mass Delete Transactions?
This video shows how Suitelets are used in creating a Transaction Mass Deletion page. Hope this helps! Thank you!
-
Find subscriptions with multiple subscription lines with the same item
Hi I would like to pull a list of subscriptions with multiple subscription line items with the same item? Is this possible? Regards