Best Of
Re: How add the 'Item Last Purchase Date' to the Saved Search
Hi @Ivan Babiichuk,
Good day! Hope you are doing well. 😊
Item Last Purchase Date can be added to a Saved Search by adding the Formula (Numeric) below:
*Formula: case when max(trunc({trandate},'month')) = max(trunc(add_months({today},-6),'month')) then 1 end
* Formula (Numeric): Select equal to
* Value: Enter 1
You may check and refer to SuiteAnswers ID 73184 Create a Saved Search to Pull Last Purchase Date for Every Item for more information.
I hope this helps! 😊
========================
If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.
Re: efax failure email recipient
Hi @Meherin, the 'Return Email Address' field under Company Information is typically used as the default email address for various outbound communications from the system, including the return address for failed faxes.
I'm not sure, if we can alter the behavior through customization.
Re: CSV Import Templates - Did you know?
If it is not readily available within your account, your initial configuration may not have used SuiteSuccess as it's foundation.
~angela
Re: Bank Reconciliation History information
Thank you for your input!
Re: User needs to re-enter order because save is not successful
Thanks for input both of you. We are looking into the scripts now.
Re: Regarding the translation issue of customer status
Okay, thank you for the above response!
Re: Sales Rep on Customer Payment Form
Hi @User_PNL62,
Thank you for providing this. Per checking, the Display Type is set to Normal.
With this, I would like to confirm if the main concern is that you can type within this field however, after saving the record the values are not being kept?
If yes, this is because the Store Value field is unticked. If you want the field to be editable by the User, you'll have to set the Store Value enabled.
Please note: Once you've enabled the Store Value field, it will remove the values of this field in existing record/transactions.
Also, would you be able to share a screenshot of the Validation & Defaulting and Sourcing & Filtering subtab? So that we can find out how this field is being populated.
Thanks!
Re: Custom Field For Currency Revaluation/Transfer Transactions
Since Currency revaluations are system generated, I don't believe that you can add custom fields to it. I may be mistaken, so hopefully someone from NetSuite can confirm.
~angela
Re: How to link Invoice to Project?
Thanks, Angela! That is correct 🙂
If there are no transactions in this subtab, then the Consolidate Projects on Sales Transaction may be set to False.
As per SuiteAnswers Id: 33679 related transactions are not normally displayed in Projects when this is disabled, this is logged under enhancement 135548 Project > Related Records > Transactions > Show transactions (SO, Invoice, Purchase Order, Bill, Expense Report, Inventory Adjustment) when Accounting Preference "Consolidate Projects on Sales Transactions" = F
I hope this helps 🙂
New to NetSuite | SOAP Web Services: Add Operation
After successfully following the steps detailed in the following articles related to SOAP Web Services Integration:
- Enabling SOAP Integration, as explained in the article New To NetSuite | Pre-requisites to Setup SOAP and REST Web Services;
- Creating a SOAP Integration by following the instructions in the articles New to NetSuite | How to Create Integration Records and New to NetSuite | How to Create Access Tokens: For Administrators;
- Including the header tag in SOAP Web Services by referring to the article New To NetSuite | How to create a header using TBA in SOAP Web Services?
You are now ready to interact with records within NetSuite. One of the key operations available in SOAP Web Services is "add" operation which is typically used to create a new record or entity within the NetSuite system.
When you perform an "add" operation in NetSuite's SOAP web services, you are essentially creating a new data entry in one of the supported record types. This could be a new customer, vendor, sales order, purchase order, item record, or any other entity that NetSuite supports. The specific details and parameters required for the "add" operation will depend on the type of record you're creating.
Here’s the sample SOAP Request in adding a customer record.
<soapenv:Envelope xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:platformCore='urn:core_2021_1.platform.webservices.netsuite.com' xmlns:listRel='urn:relationships_2021_1.lists.webservices.netsuite.com' xmlns:platformCommon='urn:common_2021_1.platform.webservices.netsuite.com' xmlns:platformMsgs='urn:messages_2021_1.platform.webservices.netsuite.com'> <soapenv:Header> <tokenPassport xsi:type='platformCore:TokenPassport'> <account xsi:type='xsd:string'>**</account> <consumerKey xsi:type='xsd:string'>**</consumerKey> <token xsi:type='xsd:string'>**</token> <nonce xsi:type='xsd:string'>**</nonce> <timestamp xsi:type='xsd:long'>**</timestamp> <signature algorithm='HMAC_SHA256' xsi:type='platformCore:TokenPassportSignature'>**</signature> </tokenPassport> </soapenv:Header> <soapenv:Body> <add xsi:type='platformMsgs:AddRequest'> <record xsi:type='listRel:Customer'> <companyName xsi:type='xsd:string'>N2N Employee</companyName> <email xsi:type='xsd:string'>N2NEmployee@nsc.com</email> <altPhone xsi:type='xsd:string'>123456789</altPhone> <addressbookList replaceAll='true' xsi:type='listRel:CustomerAddressbookList'> <addressbook xsi:type='listRel:CustomerAddressbook'> <defaultShipping xsi:type='xsd:boolean'>true</defaultShipping> <addressbookAddress xsi:type='platformCommon:Address'> <country xsi:type='xsd:string'>_philippines</country> <addressee xsi:type='xsd:string'/> <addr1 xsi:type='xsd:string'>San Pablo City</addr1> <state xsi:type='xsd:string'>Laguna</state> <zip xsi:type='xsd:string'>4000</zip> </addressbookAddress> </addressbook> </addressbookList> </record> </add> </soapenv:Body></soapenv:Envelope>
Note:
- Use listRel:Customer type to add customer records. It defines the criteria and filters that you can use to search for specific customer records.
- You have the option to add extra fields in the "Add" request to incorporate additional information into the customer record. See this article to check all the field ID used in SOAP Web Services, New to NetSuite | Navigation in SOAP Web Services Schema Browser
Stay tuned for upcoming articles where we will explore SOAP Web Services under SuiteCloud Product Area. Stay updated by following the New to NetSuite > SuiteCloud category to receive notifications whenever new articles are published.
