Best Of
Re: Approve Vendor Payment page's bug
Checked this at my end by customizing the user role. It works absolutely fine with this setup at role level.
Did you Try clearing browser history once. If you have multiple roles, sometimes switching between role might cause cache issue.
Re: Shortcuts lost
Hi SanjeevV
This could have been because of dashboard re publishing. Was this activity recently performed at the user role end.
Re: Migrating NS ARM Configurations
HI User_EKY01,
NetSuite has a native functionality of using SDF (SuiteCloud Development Framework). Can you try it.
Re: I need to retrieve Dunning Recipients through Web services
I figured it out. After confirming the name of the Custom Record with the Customer (this is found in Netsuite under Customizations -> Records, List, etc) of customrecord_3805_dunning_recipient
I then extracted all of the Custom Record records using the function getCustomizationType of the NetSuiteService and extracting the scriptIds, and Internal Ids
Once I had the internal Id, I used a CustomRecordSearch to read all the custom records. The data contained within the custom Records can be found in the customFieldList. The Custom fields I was looking for were
custrecord_3805_dunning_recipient_cont (the contact)
custrecord_dl_recipient_email (the email for the contact)
custrecord_3805_dunning_recipient_cust (the customer for the contact)
This gave me all the information I needed. I have attached the vb.net code from my tester so you can use it as needed
Thanks
See code below (attachment does not appear to be working properly)
Private Sub LoadCustomizationList()
Dim nsCustomizationType As New CustomizationType
Dim RRList As ReadResponseList
Dim nsResult As String = ""
Dim strGetValues As String = ""
nsCustomizationType.getCustomizationTypeSpecified = True
nsCustomizationType.getCustomizationType = GetCustomizationType.customRecordType
‘Set up connection to NS (nonce and token signature)
SetupNSCredentials()
Dim nsGetCustIDResult As GetCustomizationIdResult = NSService.getCustomizationId(nsCustomizationType, False)
For Each gcir In nsGetCustIDResult.customizationRefList
If gcir.scriptId.Contains("dunning") Then
strGetValues = strGetValues & "|(" & gcir.scriptId & ":" & gcir.internalId & ")"
End If
Next
End Sub
Private Sub LoadCustomRecord()
Dim nsCustomList As New CustomRecordSearch
Dim nsRecRef As New RecordRef
Dim nsGet(0) As RecordRef
Dim strGet As String = ""
Dim CustRT As New CustomRecord
Dim sContName As String = ""
Dim sContEmail As String = ""
Dim sContCust As String = ""
Try
nsCustomList.basic = New CustomRecordSearchBasic
nsCustomList.basic.recType = New RecordRef
nsCustomList.basic.recType.internalId = 260
'Do this to get a new nonce for token purposes.
SetupNSCredentials()
NSSrchResults = _NSService.search(nsCustomList)
If NSSrchResults.status.isSuccess Then
If NSSrchResults.totalRecords > 0 Then
For Each CL As CustomRecord In NSSrchResults.recordList
sContName = ""
sContEmail = ""
sContCust = ""
If Not IsNothing(CL.customFieldList) Then
For Each cfl As CustomFieldRef In CL.customFieldList
Select Case cfl.scriptId
Case "custrecord_3805_dunning_recipient_cont"
Dim slctCol As SelectCustomFieldRef = cfl
sContName = slctCol.value.name.ToString
Case "custrecord_dl_recipient_email"
Dim strCol As StringCustomFieldRef = cfl
sContEmail = strCol.value.ToString
Case "custrecord_3805_dunning_recipient_cust"
Dim slctCol As SelectCustomFieldRef = cfl
sContCust = slctCol.value.internalId.ToString
End Select
Next
If Not String.IsNullOrWhiteSpace(sContName) AndAlso Not String.IsNullOrWhiteSpace(sContEmail) AndAlso Not String.IsNullOrWhiteSpace(sContCust) Then
'Process this as a contact
strGet = strGet & " | " & sContName & ":" & sContEmail & ":" & sContCust
End If
End If
Next
End If
Else
_Common.LogSyncMessage("An issue occurred retrieving Custom Record Info. " & NSSrchResults.status.statusDetail.FirstOrDefault.message, Common.SyncEventLogType.Information, System.Reflection.MethodBase.GetCurrentMethod.Name())
End If
Catch ex As Exception
_Common.LogSyncMessage("Error Loading NetSuite Custom Record Data: " & _Common.HandleExMsg(ex), Common.SyncEventLogType.SyncError, System.Reflection.MethodBase.GetCurrentMethod.Name())
End Try
End Sub
Re: INVENTORY TRANSFER IMPORT ERROR
Hi Aldarmseu,
If your CSV Import fails and you see the error: Please enter value(s) for: Status, check the item record and make sure that the current quantity on hand is not zero or already underwater and that you are not making a negative adjustment.
The error prompt is related to the quantity on hand. You cannot do a negative adjustment when you no longer have any available quantity. The reason why the error is related to Inventory Status is because it is the next field needed to be populated after the item line level but the system can no longer proceed.
The solution is to remove lines in your CSV Import that will process negative adjustment for inventories without enough quantity.
This is also documented under SuiteAnswers ID: 78035.
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 help other community members who might have the same concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.
NSC | Sales Order > Difference Between Next Bill and Bill Remaining
Some users are reporting that they are encountering unexpected amount when billing a Sales Order. One possible cause is the button they used when billing. Here's the difference between the Next Bill and Bill Remaining buttons you see on Sales Orders.
Both the Next Bill and Bill Remaining button relates to the Billing Schedule. When you view an open Sales Order that has an attached Billing Schedule, you can use the Next Bill and Bill Remaining buttons to generate Invoices as follows:
- Click Next Bill to generate an Invoice that bills the next cycle.
- Click Bill Remaining to ignore the Billing Schedule and issue a single Invoice for the total outstanding amount.
I hope this helps! ❤ Feel free to share your own tips and tricks under NetSuite Admin Corner to help other members as well. Thank you very much! 😊
Re: Hide Last Sales Activity
Hello @User_75YL8,
Good day!
Is this the Last Activity field found in Customer record? You can hide this by undeploying a script by following the steps below:
- Navigate to Customization > Scripting > Script Deployments
- Locate customdeploy_lsa_ue_customer (internal ID: 11)
- Click on Edit
- Uncheck Deployed
- Click on Save
After making this modification, you will be able to see that the field has dissapeared from the Customer Forms.
Kindly discuss this first internally before undeploying the script.
Note: Please, consider that if you undeploy this script you will not be able to track the last sales activities for Customers (Leads, Prospects and Customers).
Re: WRONG INVENTORY DETAIL VS QTY ON ITEM RECEIPT RESULTING IN DIFFERENCE IN ON HAND AND AVAILABLE QTY
Thanks for sharing your insights, @Matrim! Appreciate your help.
Hello @Aldarmseu,
Since I am not able to change the quantity in my item receipt and could not force mismatch between my On Hand and Available quantity (unless I turn Use Bins on and off which would not be relevant in our investigation since solution would also be turning Use Bins on and off), can you check on your end if Inventory Status Change is feasible?
As far as I know, we won't be able to proceed with an Inventory Status change if the quantities are not assigned with any status since the Previous Status field is required.
Let us know how it goes.
Just in case the Inventory Status Change would not work, can you also share the screenshot of your Item Record (both Purchasing/Inventory > Location sublist and Inventory Detail > Inventory Statuses sublist). Just make sure to hide confidential information when sharing screenshots.
Thank you!
Regards,
Joy
Re: Is there any way to notify an user when the billing milestones are checked in the sales order ?
Hi Raghu007,
Users can navigate to Transaction -> Sales -> Invoice Sales orders. This page will show only transaction against which Invoices can be created as per Billing Schedule.
Re: Standard field to be made disabled
Hi User_MHNLE,
On customizing the form, I set the TERMS field to disable and refreshed the page. I was able to disable the field.
PO form :
