Try asking your users if they are using the “Make Copy” button – this will inherit all the fields and attached documents from the original.

test

Are you talking about an actual field on a bank deposit? Or do you mean the posting column on the gl impact.

Please elaborate on your question.

“Is posting” if I understand what you are saying is not a status that can be changed on standard transactions without a custom GL impact script.

I would not advise fudging with make deposit as well. Perhaps a custom transaction might suit your process better.

It might be beneficial to include additional information about the business process driving this question.

You will not like the SuiteAnswer article on this topic. https://netsuite.custhelp.com/app/answers/detail/a_id/20714

hi, this link seems to be pointing to the previous generation help center? At least I’m ending nowhere. Do you have an alternative (or a copy paste of the article)? Much obliged

Can you share some screenshots of your saved search setup? Specifically the criteria and results tabs?

Navigate to SuiteAnswers and paste in 20714 in the search box. This will bring you to the above SuiteAnswer article.

Thanks for the assistance. And what a *** solution that is 🙂 …

Can you share your code where you are doing the search? I won’t be able to help you, but others who could will do better seeing what you are trying to do.

How does your Related Sales order ID get populated in the first place? If it is a select field, that should link the 2 records.

@KevinJ – Nothing more complex than this:

nlapiSearchRecord(null, ‘5893’);

or

nlapiSearchRecord(‘quota’, ‘5893’);

Can you share your selection criteria for the cogs section? It’s plausible you have not quite gotten that right.

Additionally – I often find it helps to exclude the account from the other section it normally would show in.

I have the following:

Account Type = COGS

Account Type = Expense

Account Name = none of expense accounts.  I’ve excluded the expense account I want to see from this criteria.

When I view Account Order, all the accounts I want under this section shows.  If I put these section by itself, meaning not a child of any other section, the amount shows.  When I make it a child of Cost of Sales, the amount doesn’t show.

I just tried excluding the expense account from the other sections and that appears to work 🙂

You probably need to give more details about how your form is generated and its relation to the keys you need to set on your javascript object.

can you add the screenshot?

Current 2019.2 version

https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/schema/record/account.html

can you elaborate a bit – sending email to customers what?  From the report, saved search or via customer center?

On the primary subsiiary section i have two different subsidiaries e.g one called LLC: and the other Energy LLC.. I want the filter above the customize button to give me an option of only one subsidiary because it gives both

want this to show only one either LLC or energy LLC but not both …..Thanks

Path:: Transactions => Customers => Generate Statements

Some important information is how the client script was added. Was it added by a suitelet or user event script? Or is it a regular client script.

Some other information like why you want to use log.debug vs console.log generally helps. I personally have never bothered with log,debug if you want to output values in a client script.

Even connection thru suitetalk returns the same error

Is your computer is protected/remember authentication?  i think this is related with  2FA ?

You  may consider creating a saved search of recent inbound messages. You would not have to use a workflow and could maintain some control over them within NetSuite.

You sound like you have a lot of logic trying to manipulate a ready checkbox. Im not really sure why all your logic isn’t simply in the beforeSubmit entry point. From your description, its because you needed the order internal id for something, but you don’t need the order internal id to get the value of a multi select field. You would need the item internal id for that, and that is available beforeSubmit.

Not a rev rec expert by any stretch – do you *have* to populate it at the header?

The header Start Date is explicitly mandatory. The header End Date is not but adding an item will require it regardless before being allowed to be saved.

SO either way both header date fields are needed for the Contract Renewals Module.

var thereIsNoIndentHere = 0;
for (var i = 0; i < thereIsNoIndentHere; i++) {

var thereIsOneIndentHere = 2;

}

var thereIsNoIndentHere = 0;
for (var i = 0; i < thereIsNoIndentHere; i++) {
   var thereIsOneIndentHere = 2;
}

Perhaps you should share your recognition rule setup here so that others who are more experienced can see it. It’s plausible there’s a setting wrong in the rule.

It is not

It sounds like a client script saveRecord function would be fine if you’re not processing may item lines.
You need to loop through the lines gathering the item id’s, perform a search to ascertain the item custom field values and then apply logic on the result to display /not display a message / set your checkbox (if it’s even needed).
You could return false if you do not want the record to be saved until everything is correct. 

@battk search.lookupFields is what I needed to get grab the data w/o an orderId. Thank you for the help! That allowed me to move almost everything to beforeSubmit, where it worked with the previous customizations. Appreciate it!

are people that lazy for even to scroll?

You are going to need to be a lot more details in this question. Sublist fields and body fields have different scripting mechanisms.

Instead of submitting a new question, please edit your previous one (https://netsuiteprofessionals.com/question/how-to-get-sublist-in-suitelet-based-body-field/).

Also, please try and make your question clearer and provide as much information as possible. Doing so will make it much more likely that you receive useful advice.

No one should have to scroll or resize the tiny little window that pops up for help, when the technology and how how has existed for decades to appropriately size UI elements based on their content and the browsers reported real estate automatically without the end user input.

I refuse to live in a weak UI/UX world and NS is no example of excellence in either area.

Could you set a custom field in beforeSubmit with whatever you need, and then get the value in afterSubmit?

Is it possible “i” is global (not declared with var)?

Well, that’s embarrassing. Yes, you’re right!

Need more details.

As @rtanner mentioned, the main issue seems to be with variable scopping and also I noted a few issues with your code.

From performance perspective, you should not create searches in loop as it would consume a lot of time and execution points and as you mentioned, you are using the above script in client script, so you should make a few changes.

1. Use search.create.promise as it won’t cause UI to lag.
2. Use single search using OR in filterExpressions.

Once you have the searchResults filter out the records which are not present and create them.

The problem is each search is unique per array index. So I don’t see any way around it. As I iterate through the array, I have to run a search with the unique index parameters. I can’t search just one time and be done with it, unless I’m missing something.

I guess maybe you’re saying to use OR to combine each index set of values/scenario into one search … but then I’ll need to figure out a way to map the results back to the array indexes so I know which indexes returned results and which didn’t, because the search is there to prevent duplicates and tells me whether or not to create a custom record for each array index.

Right now, the logic is easy. It grabs the index values, searches for an existing custom record, and if the search returns zero, then it creates a custom record for that iteration. I’m not crazy about running a search for every loop iteration, this just seemed the most straightforward way to do it.

You can simply add a searchColumn for event, attendee or training (whichever is unique) or all of them. Its just that current approach has a few limitations but you are right your approach is easy.

Have you considered turning on PO Approval Routing? (Warning – this could be more than just a light undertaking)

Thanks for the reply! We have fairly complicated workflows driving PO approvals but  what we see in the app is a generic list of open PO’s. What i don’t understand is why it says My Approvals when that is not what is being shown. We could make a saved search to view in the app but I’d rather have My Approvals work as the name describes. I can’t find any documentation on how to change these settings or even what My Approvals is supposed to show so any advice you have is appreciated.

The reason I suggest turning on PO approval routing is that this changes the behavior of the approve PO page. This would update it to check the workflow against the record to determine if the approve button is visible. I would expect this to extend to the mobile application as well.

However, turning this on will require that you make changes to your workflow so that the buttons only show up at the correct time, and what fields they set, and you might have to mark all the existing ones approved before you can turn it on.

If you have a sandbox I would try it there

Hi,

In all Oracle products,  we can add custom Banner item on the home page, like Dev, Stage or Prod, etc..  if new person login into instance they can easily identify the instance name by seeing the banner.

below is the example of Oracle Bi home page…

How can we add this in Netsuite? please help.

Thanks

Hi, In the attached image I need to set the project list/record based on selecting the customer in available without login... Thanks

Where did you change it? Where is it displaying? Screenshot?

Hi JRC,

Thanks but there is nothing in the Bin Putaway Worksheet. The bins being out of sync with the locations is I believe as a result of process, i.e. deleting transactions or transfers. Deleting these rectifies the inventory in the location but it does not reconcile the movements to and from bins. The bin quantities remains intact, hence the discrepancy between Location and Bin

Mike

Hi Mike,

I think that too hard to reconcile. my suggestion is have physical count.

Then apply to inventory.  hope this will work!

Have you tried unchecking and rechecking that box on your items?

It didn’t end up being a revenue recognition rule issue. I think it’s just a scenario in ARM (custom rev rec dates) that’s poorly documented. 

For posterity, we were able to resolve this via configuring Transaction Line custom date fields and setting them up on the Setup-> Accounting -> Revenue Field Mapping page.

SuiteAnswers Id: 61890

Yes – unfortunately that hasn’t worked.

Its not very clear what you want, primarily because I don’t know what you mean by account no. My guess is that the value in your company key is being used to lookup the internal id of the company you want to set in the company field on the support case. In which case you would use:

 objRecord.setValue({
  fieldId: "company",
  value: account_no
});

Sorry, let me try to explain. I am creating a RESTLet which is to create a case from a website. As you know the case requires a company. When customer records are created we send the customers a portion of the Customer ID. Ex: in NS we may have 10001 Test Company, but the customer is sent 10001 as their ‘account no’.

Now, when the customer submits the online form we ask for their ‘account no’. For me to set the company field on a case record I need the account no to do a lookup in a saved search and get the customer’s internal ID, which is what I need to set the company field. For now, I am just hard coding the internal ID for test purpose.

{"data":[{"customform":"121","company":"10001","title":"AAA Postman Test 6","incomingmessage":"Sending From Postman 1"}]}

Let’s assume the above is sent to the RESTLet. I don’t want to set the company value to 10001, instead I do a lookup and get the corresponding internal ID – say 106750. But I get an error as it is setting 10001.

The sort property might be read-only. It’s not actually documented as a property on the Column object, and with some quick testing in the console I was unable to change the sort order. I was essentially trying the same approach as you, using the search.Sort enum values instead.

This very useful, thanks Jen!

Thanks.  I wasn’t sure how to mark it as best but I see you’ve done that (thank you).  Still getting used to this forum.  Trying to get code to format properly is ….challenging?

Share the code that fails.

How do you have a button to email? Is it it native?

From the NetSuite Terms of Service:

“(b) HIPAA. HIPAA. Customer agrees that: (i) Oracle is not acting on Customer’s behalf as a Business Associate or subcontractor; (ii) the Service may not be used to store, maintain, process or transmit protected health information (“PHI”) and (iii) the Service will not be used in any manner that would require Oracle or the Service to be compliant with the Health Insurance Portability and Accountability Act of 1996, as amended and supplemented (“HIPAA”). In the preceding sentence, the terms “Business Associate,” “subcontractor,” “protected health information” or “PHI” shall have the meanings described in HIPAA”

https://www.netsuite.com/portal/assets/pdf/terms-of-service-v032618.pdf

In general, isn’t emailing PII a bad habit anyways?

Also – NS expressly forbids requirements to comply with HIPAA.

Opportunitistic TLS seems like it’d be a good thing, not a bad… if you have a requirement to force TLS, you’re probably emailing stuff you shouldn’t really be storing in NetSuite anyways…

@martin it didn’t worked. Still making request to production site.

Thank you. Do you happen to know why the font is so tiny on a saved search export?

What transaction are you working with? It sounds like you are working with a vendor bill and the expense sublist of a vendor bill does not have a quantity column.

Purchase Order

On the purchase order form, there is the Amount in the Item subtab and Expense subtab. I created the Quantity field and PPU field and I want the PPU field to return the price per unit by dividing the {amount} / {quantity}

Update:  In order to create a new Parent Company, you must have the “Subsidiary Hierarchy Modification Feature” enabled.  NetSuite support can enable this feature for you.  After this was enabled, i could create the new parent company and make the subsidiaries children of it.

Also, another sticking point for us was that we only requested 2 Subsidiaries when we first provisioned Oneworld.  NetSuite counts the parent company as a subsidiary as well.  So, in our case, we needed 3 subsidiaries to be provisioned.

• Parent Holding Company
  • Subsidiary 1
  • Subsidiary 2

Do you want to exclude item price from the order total amount? Also, is it just one item(meaning one fixed SKU) or can it be multiples too?

Off-loading the process to a scheduled script and/or map reduce script will not guarantee immediate execution as you will be at the “mercy” of the Netsuite queues or availability of processing pipes especially if you have multiple scheduled scripts and/or map reduce scripts running in the background. The best you can hope for by going that route is to save those generated PDFs to the file cabinet.

try {
                    var xmlStr = '<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd"><pdf><head>TEST</head><body header="nlheader" header-height="10%" footer="nlfooter" footer-height="20pt" padding="0.5in 0.5in 0.5in 0.5in" size="Letter">TEST BODY</body></pdf>';//Test string to be rendered as PDF
                    var pdfFile = render.xmlToPdf({ xmlString: xmlStr });
                    pdfFile.name = '1traveler.pdf';
                    pdfFile.folder = 616;   // folder: AM Travelers
                    var fileId = pdfFile.save();
                } catch(e) {
                    log.audit('error', e);
                }

Are you saying you want to find bills where there are no messages yet, or bills where there are messages, but certain fields on the messages are blank?

https://www.linkedin.com/pulse/how-integrate-anything-netsuite-olivier-gagnon

I want to find invoices (revenue side) where we have not sent an email/message to the customer.  I’ve tried the below, but it returns invoices that have saved messages in the record.

What you’re really looking for is not a particular field like Message. You’re trying to see if there are any message sublist records for an invoice. So, instead of using the message field for your search criteria, do a lookup of the messages record (Select “Messages … “) and select the Internal ID field from the message record, then set the value to “none”. Basically you’re looking for messages where there is no internal ID. That should give you the results you’re looking for.

Post a screen shot of what you have in mind and I might be able to help out!

I definitely do not know the answer to this, but I would bet that it heavily depends on what a workflow is doing versus a script.

If they were one for one doing the same exact thing, my guess is that the difference would be negligible. Just my 2 cents.

I believe you can edit the form and uncheck the mandatory field.

In the top right corner of the Journal Entry form. Click on Customize > Customize Form.

Then look under the Screen Fields subtab for the field in question and uncheck the Mandatory box.

I suppose that depends on what you mean by “handle”. Certainly you could design custom records and such to input and track information on Competitors, then build reports around those records.

@leacc

Hi

It is not not working for me. I tried the same way

Below is my client script

/**
* @NApiVersion 2.0
* @NScriptType ClientScript
* @NModuleScope Public
*/

define([‘N/search’, ‘N/currentRecord’], function(search,currentRecord) {
var record = currentRecord.get();

function fieldChanged(context) {
if(context.fieldId == ‘custpage_customers’) {
/* var location = record.getValue(‘custpage_customers’);

if(location == ”) return;*/

// var vendorSearch = search.create({
// type: ‘vendor’,
// filters: [[‘custpage_customers’,’is’,location]],
// columns: [‘entityid’]
// });

// var vendorSearchResults = vendorSearch.run().getRange({ start: 0, end: 1000 });
var filters = [
search.createFilter({
name: ‘subsidiary’,
join: ‘msesubsidiary’,
operator: search.Operator.ANYOF,
values: subsidiary
})
];
var paymentSearch = search.create({
‘type’:’customer’,
‘filters’:filters,
‘columns’:[‘entityid’]
});
var componentsSearch = ”;
var counter = 0;
var vendfield = record.getField(‘custpage_customers’);
vendfield.removeSelectOption({value : null});
for(var i=0; componentsSearch.length >= 1000 || i == 0; i++){
componentsSearch = paymentSearch.run().getRange({
start: counter,
end: counter + 1000
});
if( componentsSearch.length > 0 ){
for(var j=0; j<componentsSearch.length; j++){
/*var id=componentsSearch[j].getValue({name :’internalid’});
var entityName=componentsSearch[j].getValue({name :’entityid’});*/
//log.debug(“paymentSearch result count”,componentsSearch[j].getValue({name :’entityid’}));
/*customerField1.addSelectOption({value : id, text : entityName});*/
vendfield.insertSelectOption({
value : componentsSearch[i].id,
text : componentsSearch[i].getValue(‘entityid’)
});
}
}
counter += componentsSearch.length;
}

}
}

return { fieldChanged : fieldChanged };

});

Where’s the line where you’re getting the value of ‘subsidiary’? I would suggest troubleshooting the search first if it’s returning a result. Also, ensure that you’re referencing the correct Client Script.

Are you able to share the criteria?

We have a dashboard in our SuiteBundle and I’ve found it to be particularly finicky.

What type of error are you getting? What type of portlet are you trying to add?

I don’t have the knowledge to help you, but I have the knowledge to warn you to be careful because once you set those unit types on an item, you are stuck with them.

I think I would log this with Netsuite support. For the life of me, I can’t imagine why it would be trying to delete a form when you’re hitting save.

@dmashburn3 Sorry for late reply, the issue in the script is solved, But I am still not understanding how I can make a good dashboard for my bundle. Is there any tutorial for that? can we make charts and graphs with portlets aswell?

Definitely going to need some more context here Amitkr1901. What type of script are you doing this with? What does your code look like that adds the payment method? Etc.

I’m not sure we know that yet. I don’t see a ton of people using N/query, and NetSuite certainly isn’t publishing any performance data.

Likely something you’ll have to test on your own unfortunately.

Would a “SuiteApp” / “Bundle” be the solution ?

When asking a question, particularly a scripting question, the more detail you can provide, the better. Especially when it comes to scripting, it is almost impossible to help you without seeing any of your code.

can you post your item saved search code? just tried in a demo account and am getting the expected result here.

Do you want to add a custom field on the Entry form in NS  which would hold some text values? Can you clarify the question pls?

I’m guessing you looked at the standard transaction template(say invoice) for their list layout already? I feel like I’ve done this before without any extra work.

I’m not putting this as an answer, as I’d like to be proven wrong. I’m confident that there’s no native way to do this outside of lot numbered inventory or serialized inventory, or custom fields and boat load of manual work.

I am using an advance pdf layout and it doesnt work the way I needed.

Thanks for the quick response! We are using serialized inventory and bins.

What are the values in date and formatDate. If formatDate  is a Date, I prefer to know the value of formatDate.toISOString()

battk, date is like this ’01/04/2020′

I format it and formateDate is “2020-01-04T08:00:00.000Z”

Running it through the format was the only way I could get NS not to error out on setCurrentSublistValue

But I don’t think my problem is the date. I can change ‘expectedreceiptdate’ to ‘quantity’ and hard code a simple value in, and it does the exact same thing: no error, but does not change/update/set the sublist value.

Additionally, if it is helpful, I can put a log before and after the commitLine({…}) call and both of those logs will show in the execution log

Looks reasonable. You probably could have used setCurrentSublistText with date and it should work. That said, are you saving the record?

When I add rec.save() after the rec.commitLine({sublistId:"item"}); line, I get this error: “INSUFFICIENT_PERMISSION”,”message”:”Permission Violation: You need a higher level of the ‘Transactions -> Purchase Order’ permission to access this page.  

But here’s the thing  . . . I already have that permission set on the role that is executing this script (set the role in the deployment, set Transactions -> Purchase Order’ on the role). So I am not sure why I am getting that permission error when it is clearly set, and indeed, I got that error the in the GET part of this suitelet when I was building the form. So, is the POST / form submission breaking that permission?

So I didn’t have the permission of ‘Transactions -> Purchase Order’ quite high enough . . . I set it to Full.

But still, same thing: nothing happens. No errors (so setting it to high removed the permission error), but save didn’t fix it either.

Try a simple hardcoded script

var rec = record.load({
  type: record.Type.PURCHASE_ORDER,
  id: "hardcodeMe",
  isDynamic: true
});
rec.selectLine({
  sublistId: "item",
  line: 0
}); 
log.debug('value before', rec.getCurrentSublistValue({
  sublistId: "item",
  fieldId: "expectedreceiptdate"
})); 
rec.setCurrentSublistValue({
  sublistId: "item",
  fieldId: "expectedreceiptdate",
  value: new Date("2020-01-04T08:00:00.000Z")
}); 
log.debug('value after', rec.getCurrentSublistValue({
  sublistId: "item",
  fieldId: "expectedreceiptdate"
})); 
rec.commitLine({ sublistId: "item" }); rec.save(); 

Hi, I just want to clarify the question a little bit. So do you want to not show the “Pending Approval” button on the Sales Order when the Billing Schedule needed is checked?

Share the code

Hi Rikta, thanks for answering. I dont want the Junior Accountant to approve any sales order when the field billing schedule needed is checked.

Ritika, Is it possible to help me with screenshots please? Whatever rule i am creating its not working:(

Ma, could you elaborate more on “linked as other relationships”? What is the broader process you are trying to complete?  Knowing that would help in answering your question.

I don’t think you are going to get more help than what Kevin got when he asked in slack without sharing more of your script. Generally the error occurs when NetSuites evaluates a script file and determines that you are using a netsuite module outside of the define function. This evaluation generally occurs in the ui when you try to create a script or edit a file. As an example something like the code below will trigger the error.

log.debug("i", "shouldn't be here");
define(["N/record"], function(record) {/* whatever entry point stuff here */});

Hello Brad,

We have company that are both Customers & Vendors of ours. Therefore, we would like to upload companies in bulk, as vendor & customer at the same time. Except doing it manually from one of the two records, I haven’t been able to find a better way

Thanks,

Ma

UPDATE:  The issue was related to a random workflow that no one seems to know why it was added.  Changed the status to Not Initiating and it solved the problem.  Thanks!

I got this to work by adding the appropriate fields in the footer section of the pdf template.

Hi Seven,

Have you received any inventory for this item?

Thanks,

Chris

Hi,

If that’s the case then it might have to be script. Are you able to create a search that picks out only these tasks?

Thanks,

Chris

Hi,

Could you explain a little further about how the two records are linked?

Thanks,

Chris

Hi,

Whilst I think you could limit the available items based on the user, I can’t immediately think of an option that would allow you to do it based on another field.

Typically, when faced with this sort of scenario, I have needed to do some scripting of a new custom field that then feeds in to the standard field. But that may not be ideal if you have a large number of items as the scripted fields a standard drop-down.

Thanks,

Chris

Hi both,

thanks for your reply! I am not familiar with scripting, so thats challenging. @ Chris: yes I can create a search to pick out those tasks including the field that needs to be adjusted (unit price, which is per resource, 1 task could have more resources allocated with different unit prices per resources).

Hello Mohammed,

Could you please give me your email address, I will contact you as we have the opposite requirement, we want commissions to be based on gross amount (NET & VAT).

Kr,

Ma

Hi Rob,

Please provide me with your email address and I will get in touch.

Ma

You can go through the NS help and suite answers to understand how it works:

https://netsuite.custhelp.com/app/answers/detail/a_id/88180

If you have any specific question I can try.

Thanks!

Hi Chris,

I haven’t, and the strange thing is that checking its details page, Netsuite shows the “Record does not exist” page. Changing its Internal ID in the address bar of my browser(currently 1026), to the succeeding and preceding items’ codes loads them up properly.

Would this mean someone accidentally deleted it, or something else? And if so, what are the recommended solutions to restore or recreate the form while maintaining the same Internal ID?

Thanks.

Would love to see this but all sources say this is not possible.

Without seeing the filters and columns, I would try decreasing the page size

We have decreased the page size to multiple different numbers.  We also get the same timeout problem if the methodology is the search.run().each iterator (each search is return less than 10k).

What are the details in the Login Audit Trail?

In theory your approach sounds fine. Share the relevant code to see if you are missing somethinig.

Your question is easy enough that I suspect you arent fully explaining it. You can add a standard item criteria (with an anyof operator) if you want to limit items. And you can add an item result column if you want items for your invoice to appear on different rows.

@battk I was concerned I may not have elaborated well enough myself. I’ll go through my circumstance with a bit more detail.

  I have a search I have designed where we want every invoice with XXX-XXXXX Item number, the issue is that some invoices have multiple entries of this item with multiple different details (description, price, etc) The criteria of what I want to pull is correct, it is how I present it in the results.

There is multiple item filters and subfilter filters, but all seem specific to one item and do not allow any reference of different line items on a list of items in an invoice.  

An example of what I would like to be able to do is have a formula similar to:  

CASE WHEN {item.2} = XXX-XXXXX THEN ‘<font color=”#BE2625″ size=”+1″><b>’||{item}||'</font>’ END  

But I have found no information of how to reference specific line items in a list.

Ive tried reading this multiple times and dont know what you are trying to describe.

What is the impact of the various brands they supply? How does brand affect your data and/or reporting?

You can check the Log In Audit Trail details to get a better idea of what the error is.

@ apaule , Thanks for looking into the issue will check the login audit trail and try to resolve  …..

We’d like to be able to issue one purchase order, or at least pay one vendor in a single check for multiple brands. Think about Coca Cola — if we carried stock from Powerade, Vitaminwater, Sprite — different enough to want to a degree of separation when ordering inventory or classification, but the same “vendor. “

I think I figured out the answer to my own question. It looks like you can only apply the new fields to a product invoice, and I need it for a service invoice.

Did you ever figure this out? I’m running into the same issue . The parent record is a field on the child record but “Show In List” is “No” and I can’t change it because it’s part of a managed bundle. Curious if you had the same issue. Thank you!

If you get a good answer don’t forget to up-vote and “mark as best answer”.

I believe items need to be Lot Numbered in order to access inventory details and have USE BINS checked.

What is the errror?

Do you have Charge Based Billing enabled?

Does your PDF have the rest of the necessary code to render? This is just an in-body snippet, you still have the rest of the needed tags right?

1. Error Message

2. Do not have charge based billing enabled
3. Yes, the pdf does have the rest of the code, I just swapped out the table I had previously setup, with this table

Sidenote: one change I did make to the code snippet above, before trying to print a statement, was change:

<#list statement.lines as line> to <#list record.lines as line>

I would caution you concerning their price increases year to year as well as having to upgrade your website Site Builder module to a much more expensive version like SuiteCommerce if they make Site Builder unusable to do eliminating functionality. I have used Netsuite since 2006.

Hi KAJ710, thanks for the reminder 🙂 I try to do this all the time but got distracted with other matters. I’ll be looking at this today or over the weekend and I’ll update then.

That is not possible. Why do you want to do that, though? There may be other ways to achieve your ultimate goal.

You may have omitted some information from your problem. I do not see the issue. You said:

We are a non-profit and I need to be able to hide all donors and their donations (customers and cash sale records) from most roles. Only a few roles will have access to these records.

So what is the gap?

Sorry if this wasn’t clear.  I need to have roles that have access to customer and sales order, but I need to restrict a segment of those customers and their associated transactions from those roles.  So regular customers and sales orders are accessible, but donors and donations are not.  I am thinking of doing this by restricting users to their location only, but that has some drawbacks.  Just wondering if there is another way…

I’m unsure of any PDF/video demonstrating the pick/pack/ship functionality, however i’d suggest setting it up in your  sandbox account, trialing it then implementing into your live account if you’re happy with it,

We have made a custom script that brings all our sales orders to one screen once they’re ready to be picked, the whole pick/pack/ship process is done from teh one screen. Once its shipped, the sales order disappears from this one screen,

Ideally we’d like to get this into Netsuite workflow or similar setup rather than a script so it can have added functionality, but its still a work in progress project

This sounds like an error with a filter or column that’s causing a time out, doesn’t look like a size issue. Are there any deleted fields being referenced in the saved search? I would try making the search with less filters or columns until finding what’s going on.

Need more details, please. Which transaction report?

I’d be glad to help you but I need more details. Looks like something that can be done through scripting.

Line field for what? Cases don’t have a sublist section, unless you mean secondary linked records types (like time)?

I figured it out. There was some custom work done and they set up a custom record and made it into an effective sublist. Thanks!

I am having a similar problem. With Forms on Custom Record.

An unexpected error has occurred (custform_141_t2161167_331)
Details: The quickAdd value of the name field object cannot be modified.
File: ~/Objects/custform_141_t2161167_331.xml

Hi apaule,

Even i am trying the same RestWebService (beta) do u have any idea please share to me.Thank u

Share the search filter Criteria and search Results columns.

Notification to who?

Email notification to the customer.

You will want to share your code, or describe a lot more.  There are several ways you can get a button to make a request to a suitelet, and several ways you can make the suitelet display a pdf. You might also need to share the expressions used in your templates as well.

You can use different vendor codes for different items at the same vendor I believe.

Say for example you have item ‘A’ (we’ll call it a Water Bottle in this example) in your inventory items, you can add vendor codes for that item for when you order with a purchase order for example.

Will you have multiple brands at both the supplier end and yours? How would this look when it comes to your system, are you on-selling as a single item or multiple different items?

Thanks man. It is done. I used request.getParameter(recId); recid is the record id passed from beforeLoad. You can see the code below:

function addButtonBeforeLoad(type,form)
{
if(type == ‘view’)
{
var linkURL = nlapiResolveURL(‘SUITELET’, ‘customscript_suiteletforbutton’, ‘customdeploy1’, null);
var param = ‘&recId=’+nlapiGetRecordId()+’&recType=’+nlapiGetRecordType()
var finalURL = linkURL+param;
var script= “win = window.open(‘” + finalURL +”‘,’_blank’);”;

form.addButton(‘custpage_testbutton_2’, ‘Click here’,script );
}
}

Hi Can u please let me know if ur able to integrate payment page using suitelet

Hi, did you ever get this working? currently stuck with the same issue.

This error occurs when you read a property or call a method on a null object . That’s because the DOM API returns null for object references that are blank. An object is expected somewhere and wasn’t provided. So, you will get null is not an object error if the DOM elements have not been created before loading the script. In JavaScript , null is not an object; and won’t work. You must provide a proper object in the given situation.

We can resolve this type of issues by adding an event listener that will notify us when the page is ready. Once the addEventListener is fired, the init() method can make use of the DOM elements.

document.addEventListener('readystatechange', function() {

if (document.readyState === "complete") {

init();

}

Hah. I just thought that was my demo account. How annoying.

I’d be shocked to find out you could remove this without creating a custom role in a custom center.

Crazy! I also posted a question about this. https://netsuiteprofessionals.com/question/how-to-remove-suiteapps-tab-on-customer-center/

Specifically because it shows in the customer center. It’s super confusing to my customers. I don’t want it there and can’t figure any way out to get rid of it. Hoping someone comes up with an answer to this. I’ll be keeping an eye out. I’ve spent hours trying to figure it out and have given up.

Yup! That’s exactly why I was asking too… Showing up in our customer center. Very annoying.

Hi Angel,

Have you found a way to address your issue?

If so, how did you?

I have the exact same requirement and I don’t believe there an out of the box feature to support this.

Greg

Hi All, I am presuming this cannot be done?

seems to work on an update but not a create? if that helps anyone

Thanks for sharing this! We issued a fix, do let me know if this still persists.

What field does this correspond to in the UI?

Very nice go through, been using 2.1 for a while but must have missed that promises are supported server side now

What is your question?

Unfortunately, I did not.

Why do you want to store W9 info on your vendor record in NetSuite? What will you do with that information?

Did you ever find a way to accomplish this? I have the same issue. The responses below do not solve it, it just does exactly what you described above where it will return that one account alone, which is what you are trying to avoid.

You’ll probably need to share a lot of your code, specifically the field addition and the form rendering on GET vs POST.

There’s no difference really, at the end of both GET & POST just have:
`response.writePage({ pageObject : form });`

I am thinking anyone should be able to replicate this, just having a Submit button on the form and then adding an additional certain field on the Form object in scenario of request.method === ‘POST’

FYI for anyone who comes across this in the future … I ended up using a Formula (Text) field in the search results and added this formula. Depending on the record type you want to indent, you might have to change the fields.  Just modify the padding to increase/decrease the indent.

CASE WHEN {parent} IS NOT NULL THEN ‘<span style=”padding-left: 10px”>’ || {name} || ‘</span>’ ELSE {name} END

To clarify… Are you asking if the results from Search A can be used as criteria in Search B?

You probably need to share you your orders are being created in NetSuite. If via SuiteTalk SOAP, then the request xml  from the logs would help. If via suitescriptm the code used to set the shipping cost and tax would be needed.

mreser,

Did you find the root cause here? I’m trying to set taxcode via a Client Script and am finding that commitLine isn’t working.

Thanks,

Chris

abbott, I don’t recall exactly what fixed this, but I believe it was the date formatting. Sometimes when the date is not formatted correctly, I receive an error, other times just nothing seems to happen like what happened in this scenario. This seems dependent on the type of SuiteScript and maybe other factors; I honestly am not sure.

Thanks, mreser.

In case anyone else finds there way here, I think I just solved my issue with:

https://netsuite.custhelp.com/app/answers/detail/a_id/67333/kw/commitline

So now with https module and using returnexternalurl = true, I do not get the error. However, as response I get an HTML text containing “You are not allowed to navigate directly to this page” and “Log In Again”.

Use https, set external to false and add

suiteletUrl  = ‘https://YOURACCOUNTID.app.netsuite.com’ + suiteletUrl ;

before the https post. Fetch the base URL from a deployment parameter, or build it using the account ID from runtime if you’re concerned about the hardcoding.

What do you mean by attached an invoice to communication –> Files ??

Where this invoice should attached to which record, can you please verify more ?

Not to be rude – but if this is an urgent issue, you should probably be working with an NS Partner firm to find a solution. This seems more complex to me than just a short response.

If you are using suitescript 1 you can use

var internalId = nlapiGetRecordId();

if you are using suitescript use n/record or n/currentRecord 2

Record.id
CurrentRecord.id

You probably want to explain this better, I cant tell if you have a client script calling a suitelet, or if you have a suitelet with a client script. Its always best to include your code in your question. You should also explain what your data is and what you want to save it as.

So is your definition of cross-subsidiary fulfillments where the Customer OR the Sales Order subsidiary doesn’t match the IF?

If not, can you describe the scenarios that you want to cover?

Hi,

Are you doing this with multiple imports or using Import Multiple Files, as described here:

https://netsuite.custhelp.com/app/answers/detail/a_id/9939

Thanks,

Chris

What do you see logged and so you see any further messages in the Chrome console?

Hi Katrina, I’ve got a couple of thoughts here:

1. When you say “chunk just holds the value of the BAI2 file”, is that the string contents of the file? Could you share the code that is setting chunk?
2. It may not get to the heart of the issue but I’m wondering whether you could group the data before you send it?

Thanks, Chris

Hello thanks for your response. If executing via pageInit (which is working) I can see .then and .catch executed right after post.promise, when I ran javascript profiler. If executed via clicking the button, after post.promise, it does not show then and catch and jumps straight to the last debug.

Hi Chris,

1. Correct it’s the string contents of the file. It’s literally pulling the values from a BAI2 file as a string and setting it there. the addDataChunk function is from NetSuite’s financial connectivity plugin
2. Yes, I’ve tried that as well and it will just error everything out

I’ve been using NetSuite’s standard parser for BAI2 – I think that might be the issue. I’ve verified that the values of these 3 files are being sent to the parser but it seems to be able to only handle one. Unfortunately its locked and can’t be edited or viewed and I’d rather not have to go down the path of creating my own BAI2 parser.

The things that you will want to clarify are the encoding involved for the encrypted value and the decrypted value, and what they represent. The way you are using the encrypted value in CryptoJs means that it will be interpreted as a Open-SSL compatible format. If it is not, you want to create a CipherParams object. Keep in mind that that will probably involve parsing your encrypted text using an encoding.

Also be very wary about the difference between a secret key and a passphrase. A passphrase is a convenience method used to derive the bytes of a secret key. By default, CryptoJs uses the same passphrases as OpenSSL. If you are working with secret keys and not passphrases, then your secret key has been encoded and you need to use one of CryptoJs’s encoding to parse it as bytes (WordArray in Crypto Js terms)

How are you looking to print the barcodes? i.e. Is this standard document templates, Advanced PDF, or something else?

Thanks,

Chris

Could you share a little more detail on the purpose of this transaction as well as what result you are expecting in terms of GL impact?

First, identify what modules do you need.

Second, try to look for those modules on the internet. I’m sure there are bunch of resources out there 🙂

Hi Steve,

Which API are you referring to? SuiteTalk, REST Web Services, etc.

Thanks,

Chris

Chris

It’s the Rest Web Services.

Regards

Steve

OK, based on the answer given below, my colleague who started working on this was on the right track.

But we can’t get it to work and not sure what we are doing wrong.

Below is an extract of the relevant bits of code.  We create the ItemFulfillment object and assign it a RecordRef with the interanl id of the transfer order.

The for each TransferOrderItem we create a ItemFulfillmentItem and assign that a RecordRef with the internal id of the TransferOrderItem

Set the quantity.

When we try to add the fulfillment we get Unable to find a matching line for sublist item with key: [orderLine] and value: [1].

// Creates a fulfillment for the transfer order
// netSuiteTransferOrderToPost is the TransferOrder from netsuite

ItemFulfillment toFulfillment = new ItemFulfillment()
{
createdFrom = new RecordRef()
{
internalId = netSuiteTransferOrderToPost.internalId,
type = RecordType.transferOrder,
typeSpecified = true
},
tranDate = orderUpdatedDates[netSuiteTransferOrderToPost.tranId],
tranDateSpecified = true
};

ItemFulfillmentItemList fulfillmentList = new ItemFulfillmentItemList();
List<ItemFulfillmentItem> fulfillmentListItems = new List<ItemFulfillmentItem>();
fulfillmentList.replaceAll = true;

// Loop through through the transfer order items
// netSuiteTransferOrderToPostItem is the TransferOrderItem from netsuite
// correspondingUpdateItem is from our system and corresponds to the netSuiteTransferOrderToPostItem we are trying to update

ItemFulfillmentItem ifi = new ItemFulfillmentItem()
{
orderLine = netSuiteTransferOrderToPostItem.line,
orderLineSpecified = true,
item = new RecordRef()
{
internalId = netSuiteTransferOrderToPostItem.item.internalId
}
};

ifi.quantity = (double)correspondingUpdateItem.QtyReceived;
ifi.quantitySpecified = true;

fulfillmentListItems.Add(ifi);

// finailze the fulfillment and add

fulfillmentList.item = fulfillmentListItems.ToArray();
toFulfillment.itemList = fulfillmentList;

service.NetSuiteService.add(toFulfillment);

// the add returns status isSuccess false
// the status details report: Unable to find a matching line for sublist item with key: [orderLine] and value: [1].

Thanks for looking at this.

Steve

Could you please share both the URL and data that you are currently attempting to use.

Could you please share a sample of the output that you are seeing?

Could you please share a sample of the request that you are sending.

Is it possible for you to share the XML request that is being generated from this code?

Here is a sample payload.  

{
    "trandate": "2020-01-01",
    "entity":{"id":"1111111"},
    "shippingAddress":{
        "phone":"555-555-5555",
        "addressee":"Buddy Brown",
        "addr1":"11111 Home St",
        "addr2":"",
        "city":"Metropolis",
        "state":"XX",
        "zip":"90000",
        "country":"US"
    },
    "paymentMethod": {"id": 1},
    "department": {"id":1},
    "item":{
        "items":[
            {
                "item":{"id":"115913"},
                "quantity":1,
                "rate":448.99,
                "taxCode": {"id":"12345"}
            }
        ]
    }
}

Share the request xml from the web service logs.

Hi, how do you know the “as of date” ?

Sorry for the delay in replying below is the body of the xml message received by NetSuite <soap:Body> <add xmlns=”urn:messages_2019_2.platform.webservices.netsuite.com”> <record xsi:type=”q1:InventoryAdjustment” xmlns:q1=”urn:inventory_2019_2.transactions.webservices.netsuite.com”> <q1:account internalId=”1660″/> <q1:inventoryList> <q1:inventory> <q1:item internalId=”3966″/> <q1:location internalId=”34″/> <q1:adjustQtyBy>10</q1:adjustQtyBy> </q1:inventory> </q1:inventoryList> <q1:customFieldList> <customField scriptId=”customlist_reason_code” internalId=”2″ xsi:type=”SelectCustomFieldRef” xmlns=”urn:core_2019_2.platform.webservices.netsuite.com”> <value internalId=”2″/> </customField> </q1:customFieldList> </record> </add> </soap:Body>

The internal id used in the custom field is fro mthe list pulled from netsuite:

Damaged 1
Stock Count Error 2
Rework 3
Obsolescence 4
Work Order Closure Error 5
Shrinkage 6
Internal Consumption 7

although we send a 2, the stock adjustment appears on netsuite as Damaged.

I know enabling Multiple Shipping Routes allows you to put location on the line level for sales order so you can ship items to different locations for customers. I’m not sure that it applies to purchase orders. Maybe use a custom transaction line field?

I am having the same issue with a brand new SC website. Have you been able to fix it?

No, I haven’t yet, but it’s interesting that it’s happening with SC, I thought it was because we were using sitebuilder, is it also with Paypal for you?

Did you ever figure this out? I have the same issue.

Hey, have you tried using the Convert to Custom Record option within the custom list you created in the first place?

Hi, steps 1 and 2 can be merged with the use of a workflow or user event. The NCMR is loaded (if it is a record, is it?) and the VRA is added. You can also change the process by transferring inventory via a transfer order instead to a dummy location named after the vendor, since you expect the items to come back and the credit is not actually happening. Once they transfer back, you may create another transfer order for it.

I’m probably stating the obvious, but it looks like none of the existing payment processing profiles support this combo: selected payment method (this is automatically sourced when you set the credit card), currency and subsidiary. I would try to log the values of the Payment Method subtab right before saving the record just to see what’s in there. Also, try to “force” (setValue) of the Payment Method or Processor and see what happens. Good luck!

Hi Lia, when on the execution are you setting the country? Have you solved this one yet? I’m happy to help.

Hi, this error doesn’t say much, maybe you can paste your code here?

I don’t quite visualize it without the output, but I would imagine something like this:

<#list [‘a’, ‘a’, ‘a’, ‘b’, ‘c’] as record >
<#if last_dpt??>
<#if last_dpt != record>
${record}
</#if>
<#else>
${record}
</#if>
<#global last_dpt=record >
</#list>

Is it work on the client script?

How are you sending the invoice? Does the XML only contain the PO? And then you need to attach it to that particular email?

You should maybe just change the item receipt’s item category since that’s the posting transaction.

Would you send a screenshot? Any scripts? It looks like an item configuration or something missing. I would check if the items on the POs are the same, or the vendor, if they have “last purchase price” on the selected location.

Did you ever work out how to do this? I am trying to create a similar solution after recently turning on FedEx label integration. I’m trying to set it to the created from document number. I know there’s a way to do this within settings on the Set Up Shipping page, but we have multiple subsidiaries with different requirements for this field. Thanks!

I want to get the field”recordcreatedby”  by suitetalk webservice，but the response xml does not contain the filed,anyone can help?

Update: the tax code lookup for Canada shipments is still happening even though the customer’s United States tax nexus is NOT set “Enable Tax Lookup on Sales Transactions”.

I checked the options on the customer (see attached image) and it looks like it is set right

Can you provide more detail? I.e. Website? Excel? What are your requirements?

I removed your email address – given that this is a public facing website – publishing your email may be unwise.

Brad, did you figure out how to do the above. I am struggling to set it up.

You can delete the auto-populated field before saving the address.

Thats interesting. Where do you find free-form text input for dates?

A fair place to start would be https://netsuiteprofessionals.com/answer/re-print-a-custom-record-including-specified-sublists-on-an-advanced-pdf-template-2/

If your search is based on the PO which it should be, then you need to reach into the Item receipt for that information.  There is a field called. “Fulfilling/Receiving Transaction” That will get you the IR, to pull fields from the IR, you need to got to  “Fulfilling/Receiving Transaction…” at the bottom and select fields from that record.  Below is a screen grab of what my search looks like. Bear in mind that this creates multiple lines if there are partial receipts.  So if you want it all on one line and you do have multiple receipts you’ll need to do a summary search and set the date the maximum. That will get you the date of the latest receipt.

Commenting to follow! I am looking to set up something similar.

I should clarify, with the original package you can call things like L.tilelayer and so on (works fine). But this plugin lets me do things like L.geodesic so it adds the ‘geodesic’ function to the L object.

To piggy back off this question, since the manual re-authentication every 7 days requires a user to enter a valid Username/Password, does Oauth 2.0 present the same drawback that NLauth had? Basically, if the integration application automated sending the Username and Password every 7 days, that application would still need to update the NetSuite password after it expires (180 days) correct? If this is the case, I would assume that OAuth 1.0 would be the preferred method for an integration that is setup to run in the background without any user interaction. Even though you generate the Token ID/Secret associated with a User/Role, as long as that User stays active, the Oauth 1 Client ID, Client Secret, Token ID, and Token secret should never expire.

Any/all feedback is appreciated!

As a follow up to this, it seems to only be POST/PUT/PATCH requests that are throwing the error, GET requests to beta endpoints still work.   Can anyone provide more information on this please?   Thanks!

@devmatt, are your GETs still working against beta objects in Production?  If I disable the REST Record Service in the sandbox and try a GET against purchaseorder I am getting the same error as you above.  So just to confirm, based on your screenshot above you have no option to toggle Rest Record Service and yet GETs against beta endpoints are still working??

Just following up, I’m assuming this may not be possible given no responses?

Or alternatively if anyone has any way you can report on both inbound shipments and purchase orders in the same search, that would be great.

Thanks, Jordan

Did this search work?

Are you using Celigo’s FBA settlement add on or just the basic integration?

Hello, I am having the same error while to trying partially receive a transfer order using !transform/itemReceipt

I’m curious: Why would you want to? What’s your use case?

Are you using Celigo for Shopify <> NetSuite integration? If so a script in IO would be a good solution and easy.

If not or you want to try doing it in NetSuite, you can see if you can use the SQL function

REGEXP_REPLACE

https://www.techonthenet.com/oracle/functions/regexp_replace.php

i have the same question,  did you made the changes? do i have to create the items again?

What did you try? The obvious approach of getting both fields and subtracting them from each other and setting the result in another field should have gotten you very close to what you want

Have you read the SuiteScript documentation? Your question is lazy.

Can you edit your post and use the code formatting? It makes it so much easier to read

Not long ago this was a licensed module. Check with your account manager

Hey Krishaj – Did you find a workaround to your problem?

Hi Jeff, I’m using NetSuite since a few time, but I would use items in journal entries

have you found how do this?

Kind regards

Might be related to the current outage. https://status.netsuite.com/

Thanks Phil. I’ll try after some time.

Check out this app from Precisely – https://www.suiteapp.com/Precisely-Address-Email-Validation-for-NetSuite

Offers postal certified address verification directly into your NetSuite app

Please remove your secrets from the post.

What is the object you are working with?

Please post your implementation of the signRequest function — it is  likely that your error is there.

I removed characters from the secrets and tokens, so they are incomplete values

Has this been resolved already?

I’d just use the soap api to create the transactions that you need.

Share the code, preferably with hardcoded variables

Has anybody found a solution for this?  I can’t find a way to remove it for custom roles or custom centers.

If you can post sample code for your restlet, we can walk you through the suitescript to save the file to  the filecabinet.  You can also do this easily using suitetalk.

what’s the type of transaction here?

var file,log;

define( [ ‘N/file’, ‘N/log’], main );

function main( fileMod, logMod ) {

file = fileMod;
log = logMod;

return {
post: postProcess
}

}

function postProcess( request ) {

if ( ( typeof request.function == ‘undefined’ ) || ( request.function == ” ) ) {
return { ‘error’: ‘No function was specified.’ }
}

switch ( request.function ) {

case ‘fileCreate’:
return fileCreate( request )
break;

default:
var response = { ‘error’: ‘Unsupported Function’ }
return response;

}

}

function fileCreate( request ) {

// Load the file.

try {

var myfile = file.create(
{
name: request.name,
fileType: request.fileType,
contents: request.contents,
description: request.description,
encoding: request.encoding,
folder: request.folderID

}
);

// Save the file and get its ID.
var fileID = myfile.save();

// Load the file.
myfile = file.load( { id: fileID } );

// Create the response.
var response = {};
response[‘info’] = myfile;
response[‘content’] = myfile.getContents();

return response;

} catch (e) {
return { ‘error’: e }
}

}

Are you still having the issue? We are. All our users are using Incognito mode, but it’s hardly a long term solution.

Yes, still having issue. I found another thread on reddit (r/chrome) –it doesn’t look it is just Netsuite. 

It is also not every user here.  We are about 50-50 here with the stations having this problem.  Same version of chrome.  My laptop doesn’t seem to have this problem, I have tried everything I know to recreate, but can’t.   

We have a similar issue , did you find anything?

just serialize it manually

Maybe should have mentioned that we do not just set rate, other fields that are set: item, isbillable, price, rate, overriderate, class.

We have tried to use commitLine and then selectLine again and it looks ok, but then the row cannot be saved after adding description and hours due to the service item. Even though an item is added and it is visible we get an error saying “Please enter values for: Service item”.

Can you add the rate upon validateLine or does the user need to see the rate before clicking okay?

Never mind. I found the answer to my own question. Looks like Documents > Mail Merge > Bulk Merge does the trick!

Preferably they should see the rate before saving the line

Hi,

I am running NetSuite version 2021.1 with the Beta REST API enabled.  I have a working proof of concept of using the REST APIs with OAuth2 with a user available to authorize the request when the access token expires using the authorization URL.

I would also like to use OAuth2 for long-term system integrations via cron jobs where a user is not available for authorization.  I thought OIDC was the answer.  However, I have yet to get it working.

My questions are

1. Does NetSuite 2021.1 support OAuth2 long-term (meaning no user available when the job runs and no password expiration) system-to-system integration?
2. If so, is OIDC part of the solution or are my expectations wrong?

As mentioned above by the previous poster on this subject, any feedback or insight is appreciated.

I usually use this to get what exactly in NetSuite UI

<#if record.checkbox == true> [<span style=”color:green; font-size:12px;”> √ </span>]<#else>[<span style=”color:red; font-size:12px;”> X </span>]</#if>

maybe each time you are using with a different user,  and that user needs write permission/read permission for that directory.

are you using cash sales or invoice & payment.

Expect to share enough code to reproduce the problem. The code you shared is not enough to reproduce the problem. Running it would make no changes to any record.

Try few things:

1. Try updating payroll information and run a dummy paycheck to see how hours are reflected under Available Now tab of the Employee record.

2. You can always use Time-Off Changes feature to update the balance for an employee.

Can you check if approval status with id 11 is not inactive now?

I do not see approval status being setup anywhere else in the system. Any idea where I can check the active items? It is certainly providing all the values within the workflow.

Formula (Numeric) | {quantity}-{quantityshiprecv}

Kind of like this on a search but per line Item on the transaction form

Hi, We have not currently go this to work as required.

The following is from SuiteAnswers:

ChasePounders did this help?

I think your post just saved me a ton of time and effort! Thanks!

Use nlapiCopyRecord api

But this code snippet is from version 1.0, correct? Wouldn’t that cause a conflict?

thank you anyway

Sounds like you are pulling those additional lines in from the purchase order. Set the main line to true under the purchase order fields and you should be able to get rid of those dups.

Hi Liran, Can you provide some additional details? Depending upon the field type and reference to the vendor record, this can likely be achieved via a NetSuite Workflow or as part of the custom field itself, using the “Sourced From” functionality.

@Chris Abbott, thank you very much! I did stumble my way here and that link solved my issue!!!

any suggestion on this, please?

We are also looking for a solution like that 🙂
Have you received any solution ?

BR

Hakan Magnusson

Please check out this [stack overflow answer which answers your question].(https://stackoverflow.com/questions/52172297/netsuite-unable-to-get-sublist-line-count)  The sublist id will be RECMACH + the script id of the custom wbs record

Tnx. Thus, I’m not working on a custom record. “Allow Child Record Editing” is not applicable to “standard” record that I’m working on. Any other ideas?

Why won’t inventory adjustment  allow you to adjust the inventory?  That is the standard way to modify quantity on hand.

are you using the rest api or the soap api?

We’ve filed a support ticket for this to no avail.  Short answer that support will provide is that this just happens and you should build in retries.

My bad, I think what you will have to do is to search for wbs records where the project equals the project of interest.  The schema browser (https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/script/record/wbs.html) seems to imply that wbs is a first class record that you can search for directly.

But what if the quantity is over on what we actually have ?   How do i clear that extra 356pcs we have ‘On Hand’ if it does not have a Bin Location?

Are you calling window.webkitStorageInfo in your client script? Don’t be afraid to

 console.log('') 

We get the same error. It also says TokenRejected in the Login Audit Trail Search. We tried with postman using the Netsuite Postman Collection as well as in python with oauthlib.oauth1 using HMAC-SHA256.

We would appreciate some help here? We could also provide more details.

Were you able to get this working? We have been stuck on this for months now (same error).

Hi Parameswarangp,

I need the same, did you receive any answer or any workaround you have done about this case?

Thanks in advance.

Best Regards,

Ahmed Safwat.

That’s an excellent idea, count me in

Hello, I have a solution that should work in a saved search if the account structure is the same for all the accounts you are trying to pull, it will always dig into the third “:” set and display everything after it. I am going to give you the formula for this example and then give you the one you should replace your field with. making a Formula(Text) and putting the following into the formula

quick thought,

Have you tried only getting transactions that are in a ‘pending billing’  status? i.e not partially filled/pending billing

This is great and would love to collaborate further. I’ve designed and implemented many of the above (sans open source of course).

Thank you for the suggestion. Most of the orders are invoices, so they are not billed until after they have shipped. The search already filters out orders that are not fully billed (when the order requires billing prior to shipping)

I was created a custom field in Budget Code Record, through that I can limited the Budget Code based on the Department of the current user.

What do you mean by “Uploaded on the record”? Have you created a script deployment? Can you share the screenshot of the deployment?

Hi Pena,

If you still need a solution to this, there is the following option

Setting a Service Item to Create a Project Suite Answer ID:9329

I have the same requirement as you and this looks like a solution, I haven’t been able to make it work yet. The project tasks are not being created.

Cheers

Hi there,

This seems like solicitation for business, this is a community run Q&A site we prefer that you don’t post any solicitation message. Thanks for understanding

Were you able to figure this out?
I’ve been picking at SuiteTalk SOAP for a couple months, but it hasn’t clicked for me yet.

There’s ample script examples for most of what I’ve needed to figure out…but not so much for NetSuite.
Would it really be so difficult for them to issue a php library with comprehensive examples?

double check if the user has at least one role assigned to them in prod. This looks to me that they were accidently assigned the role in SB

If your still looking for support I have a team of three we can support most implementations and cleanups

have you solved this issue?

Has anyone found a solution to this request? I’m struggling to find a way to do this as well and would appreciate any help given.

Hello, Did you ever manage to sort this? We are just about to go Live with NetSuite and I am trying to do the samething. Be glad to hear how you got on?

note only bank accounts have a currency defined, others can have entries of any currency

im from PH. if you could consider me, ill send you my cv

Hi,

I’m not aware of anything but don’t use it all that frequently. How does it crash? Freeze up or any errors?

Thansk,

Chris

no errors, console will print : null and its basically frozen, until i stop debugger :/

Hi,

Did you ever find a response for this? Looking to implement the same as well.

you tried using only :

var value = 2
parseFloat(value )

You can get the lineItem Id then set it to disabled
Try this https://stackoverflow.com/questions/70863051/how-can-i-disable-line-item-field-without-disabling-entire-column-using-client-s

Hi. Were you able to print a label with composite barcode?

I’m guessing you had some rows with QTY = 0?

Are you using the advanced PDF template or the standard template? Are you trying to add the shipping address to your customer statement template, or you’re trying to add a shipping address to a customer, or both?

Hello James,

Thank you for responding. Yes we are using Advance PDF template. We have a customer which is a Parent of other customers. We can generate Individual Statement (Consolidated) for the Parent Company. What I am trying to add is the line or statement line shipping to address.

For example a line statement Invoice#1234

 I want to add the ship to or shipping address of that Invoice#1234. 

I have tried ${line.shippingaddress} also ${line.shippingaddress_text} or ${line.shipaddress } but to no avail.

I have tried to look at the NetSuite Record browser but Customer Statement, is not even there.

The Parent Company is requesting to add the shipping address of the statement line (per invoice). So they will know on which child company is that invoice items was shipped.

Hope you can give a light to my inquiry.

Thank you in advance.

What datepicker popup? Where in NetSuite? Reporting? Scripting? On a particular transaction record? A screenshot could be helpful if you’re not totally sure how to answer those questions.

Interesting – I’d expect them to be available via N/config.load(), but it doesn’t appear they are. Perhaps a gap in functionality or perhaps there’s some other way, but I’m not aware of it yet.

I am curious about the actual answer here as well. I have documented some frustrations with how time zones and scheduled deployments work when deploying via SDF in this github issue: https://github.com/oracle/netsuite-suitecloud-sdk/issues/645. Script Deployments with a scheduled component seem to adjust based on the time zone preference of the user who saved it last.