-
NSC | SuiteQL: How to Fetch a Transaction from a Specific Date
Scenario: A NetSuite user wants to design a SuiteQL query that effectively filters Vendor Credit transactions occurring on a specific date, ensuring precise data retrieval for financial analysis. Solution: The following query can be ran to extract Vendor Credits from a specific date. NOTE: Replace the first parameter on…
-
NSC | SuiteQL: How to Get the List of Existing Transaction Types Being Used in a NetSuite Account
Scenario: A NetSuite Client wanted to filter transactions based on their types via SuiteQL, that will later be a basis for their other business processes. Solution: Sample query that can be used as a reference: SELECT DISTINCT type, BUILTIN.DF(type) as type_description FROM transaction; The sample code described herein is…
-
Cancel Sales Order button not Appearing
Hi There I am using the administrator role on a sales order that is pending billing and cannot see the cancel sales order button despite this being visible on the custom form. Does this button only appear for sales orders pending fulfilment? Also, related to this, is there an equivalent function to cancel purchase orders?…
-
Show PO/Check, Paid In Full Date on Vendor record
Good day. Can someone please help me with my concern? I would like to show the PO/Check on the Vendor record but it is not showing I have checked the View and the PO/Check Number is added correctly I would also like to add on the View the date once the Bill has been Paid in Full. Thank you in advance :)
-
NSC | What is the Purpose of the PO/CHECK # Column in a Vendor's Transactions List
Scenario In a Vendor record, under the Financial subtab > Transactions list, users are able to see a list of transactions related to the Vendor. In the Default view, one of the available columns is the PO/Check #. The user noticed that this column is blank and it does not show Purchase Order number nor the Check number.…
-
UNEXPECTED_ERROR transaction
Hi, since this morning we have been receiving the following error when we try to open or create a transaction, for example purchase order, estimate, oportunity, cash sale, credit memo, journal entry, etc. Aviso (SuiteScript){"type":"error.SuiteScriptModuleLoaderError","name":"UNEXPECTED_ERROR","message":"","stack":[]} We…
-
How to restrict the records from redirecting back to homepage ?
Hello there, Whenever we are creating a transaction (after we submit or save the record),the system redirects us to the dashboard. How do we stop the transactions from being redirected? Is there any feature we need to update or any preferances we need to add. Any suggestions why this happens and any solutions are greatly…
-
Why the same item can be added twice in transaction?
Hi, When we create a purchase order, it allows us to add the same item twice in the transaction. each with its separated quantity. Can we prevent this, or is there something in settings to merge them instead of adding in separated lines? Or at least display a message telling that the item already in the transaction? Thanks…
-
Displaying sub-departments on transaction records
Hi, I have a requirement where our instance has parent-child relationship on departments. Our parent departments are not posting departments and hence we don't want to display that on transactions like PO and SO. Is there a way to accomplish this? Thanks, Preethi
-
Inactivate subsidiaries and Move Open Transactions to other subsidiary
Hello Gurus, We have three subsidiaries those we want to inactivate and move the open transactions to one of the existing subsidiary. Any ideas/best practices to do this? Thank you.