netsuiteprofessionals #general

02/25/2022, 4:31 PM

Hello - what is the best way to cancel transfer orders from previous closed periods? Can they be closed?

Shannan Brown

02/25/2022, 5:53 PM

Anyone have any updates about the defect that impacted the HTML editing capability. Case # 659366. We cant get a straight answer on how long it will take. Maybe 3 months? Thx!

AXP NS

02/25/2022, 7:27 PM

Making an Advanced HTML Template and says template cannot be saved due to the following errors: The parser has encountered more than "100,000" entity expansions in this document; this is the limit imposed by the application. Seems like it started doing it when changing these two lines:

Copy code

<body padding="0.0in 0.0in 0.0in 0.0in" style="width: 4in; height: 3in;" >
    <table padding="0.0in 0.0in 0.0in 0.0in" style="width: 3.95in; height: 2.95in;">

Here is the full HTML if that helps.

Copy code

<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
<pdfset>
  <#list results as label>
    <#assign cartonCount=label.custcol_countqty>
    <#list 1..cartonCount?replace(',','')?number?ceiling as i>
<pdf>
<head>
	<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
	<#if .locale == "zh_CN">
		<link name="NotoSansCJKsc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKsc_Regular}" src-bold="${nsfont.NotoSansCJKsc_Bold}" bytes="2" />
	<#elseif .locale == "zh_TW">
		<link name="NotoSansCJKtc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKtc_Regular}" src-bold="${nsfont.NotoSansCJKtc_Bold}" bytes="2" />
	<#elseif .locale == "ja_JP">
		<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />
	<#elseif .locale == "ko_KR">
		<link name="NotoSansCJKkr" type="font" subtype="opentype" src="${nsfont.NotoSansCJKkr_Regular}" src-bold="${nsfont.NotoSansCJKkr_Bold}" bytes="2" />
	<#elseif .locale == "th_TH">
		<link name="NotoSansThai" type="font" subtype="opentype" src="${nsfont.NotoSansThai_Regular}" src-bold="${nsfont.NotoSansThai_Bold}" bytes="2" />
	</#if>
    <style type="text/css">table { font-size: 9pt; table-layout: fixed; width: 100%; }
th { font-weight: bold; font-size: 8pt; vertical-align: middle; padding: 5px 6px 3px; background-color: #e3e3e3; color: #333333; padding-bottom: 10px; padding-top: 10px; }
td { padding: 4px 6px; }
b { font-weight: bold; color: #333333; }
</style>
</head>
<body padding="0.0in 0.0in 0.0in 0.0in" style="width: 4in; height: 3in;" >
    <table padding="0.0in 0.0in 0.0in 0.0in" style="width: 3.95in; height: 2.95in;">
    	<tr height="30px">
			<td width="5%">&nbsp;</td>
			<td width="90%"><#if label.custcol_gu_next_tag?length != 0><barcode codetype="code128" showtext="true" value="${label.custcol_gu_next_tag}"/></#if></td>
			<td width="5%">&nbsp;</td>
		</tr>
    	<tr height="30px">
			<td width="5%">&nbsp;</td>
			<td width="90%"><#if label.item?length != 0><barcode codetype="code128" showtext="true" value="${label.item}"/></#if></td>
			<td width="5%">&nbsp;</td>
		</tr>
		<tr height="20px">
			<td width="5%">&nbsp;</td>
			<td width="90%">Lot# ${label.custcol_gu_lot_number}</td>
			<td width="5%">&nbsp;</td>
		</tr>
		<tr height="20px">
			<td width="5%">&nbsp;</td>
			<td width="90%">Size: ${label.custcol_width}&#34; x ${label.custcol_lengthft}&#39;</td>
			<td width="5%">&nbsp;</td>
		</tr>
		<tr height="20px">
			<td width="5%">&nbsp;</td>
			<td width="90%">Received: ${label.duedate}</td>
			<td width="5%">&nbsp;</td>
		</tr>
		<tr height="20px">
			<td width="5%">&nbsp;</td>
			<td width="90%">Remarks: ${label.mainname} ${label.tranid}</td>
			<td width="5%">&nbsp;</td>
		</tr>
 </table>
</body>
</pdf></#list></#list></pdfset>

KevinJ of Kansas

02/25/2022, 7:28 PM

Anyone ever seen quantity break pricing on service hours? Client charges a flat rate for up to the 1st hour, and then after that charges a different rate in 15 minute increments. Unfortunately - there's no quantity break pricing on service items that I can find. We're also limited to using service items as we are charging time from a case/project. Any suggestions for handling? I'm thinking we'll have to force the service item on the time entry and then cut the time into two entries after it's been submitted. i.e. "Service Item is placeholder" - change item to "1st hour" then change quantity to 1. Subtract quantity from placeholder entry time and change to "2nd hour" item However - if someone has a better idea for handling it, I'm open to suggestions.

Luis

02/25/2022, 9:33 PM

Is it best practice to use a custom role with all the appropriate permissions and assign it to the custom GL plugin record?

mike74

02/26/2022, 3:02 AM

Any planning and budget module experts/Consulting firm in the southeast us?

Ahmed

02/26/2022, 6:56 AM

Hi everyone I am trying to customize standard AP Aging Report, I want to show results for only one specific account. But when i use Account Filter , i can not see Journal Entries While when i use Account (Line) filter i can only see journal entries , When I use both filters , i get no results . Is there any way to solve this issue , I need journal entries as well in the AP Aging report along with other transactions.

Luis

02/26/2022, 9:22 PM

In our external system where we get our purchases and sales data for at least 2 of our subsidiaries, a Vendor may have 2 or more IDs (one for each Subsidiary). It's already like this before we include them in our NS instance. And I was told that it would be unlikely that we can change these IDs. In NetSuite, the Vendor is created as one record (multi-subsidiary Vendor). Apparently, we can only assign one External ID per record. I'm just wondering if it's possible to assigning multiple IDs in NS through scripting or my other means, so that we load out purchases and sales data, NS knows that CUS01, CUS02, CUS03, etc. are all the same and pertain to a single record, say CUS01. Basically, it's a many-to-one relationship (external system to NS).

Alex Geller

02/27/2022, 2:57 PM

Anyone have experience with the Instor POS module? We are looking into it for a small retail store. 1-2 registers. From everything I have read seems decent for smaller applications. Hoping to get any insight from users. Thanks in advance.

KingDaGreat

02/28/2022, 3:28 AM

Does anyone know how to get the difference between today and a custom date field in netsuite using SQL? currently using JDBC. I've tried multiple syntax from online and history from here but can't get it into work.

Amtoj

02/28/2022, 4:26 AM

NVL(ROUND(({locationquantityavailable}-{custitem_esp_shopify_reserve_qty})*.8),0) I am getting too many zeros as result. Do I need to change the expression to something else?

Karan

02/28/2022, 5:37 AM

Hello everyone, In invoice record I have custom field contains array value that values need to print by advanced pdf so how can I do that ?

Karan

02/28/2022, 6:35 AM

[Ljava.lang. Object;@3 e256681 getting this error in advanced pdf what is that errror?

02/28/2022, 12:46 PM

any one can correct this i getting issue while compairing record type

Livio

02/28/2022, 2:04 PM

When we send out an email from netsuite, we have to click "SOURCE" to switch from HTML to plain english. is there a way to make netsuite emails default to text, instead of HTML? I know this is happening because of email signature thats written in HTML.

screnshaw

02/28/2022, 4:11 PM

Anyone know how to import lockbox deposits?

Brian

02/28/2022, 5:51 PM

Can I inactivate the SuiteApprovals bundle without uninstalling the bundle? I dont want it to run right now, but may want it down the road.

02/28/2022, 6:05 PM

Hello All, I am getting issue with xml parsing for ‘&’ while passing parameters to suitelet,. So I tried like - var xmlEscapedDocument = xml.escape({xmlText : xml}); context.response.renderPdf({xmlString: xmlEscapedDocument}); Its printing the pdf but giving error like escape cannot be found in an object Can anyone help ?

Matias Bonifacino

02/28/2022, 6:34 PM

Hey everybody, does somebody know how to add a portlet to the home dashboard of the customer center? I'm interested in adding this for all customers that have a certain role

Cory Weiner

02/28/2022, 7:16 PM

Has anyone used the “Auto Bank Statement Import” or the “BankFeeds” suiteapps? They are both from Oracle. We are looking to automate the import of our bank data into the reconciliation process, and I’m not sure which of these tools is better or how they are different…

Simon

02/28/2022, 9:27 PM

Can we connect Share Point MS List with Netsuite and vice versa ?

Michael McNamara

02/28/2022, 10:05 PM

Hey all. Anyone ever come across a Purchase Order that can’e be edited by the user who created it? Normally they can but this one cannot. It’s the right subsidiary, pending approval, and user role has full permission for Purchase Orders.

Craig

02/28/2022, 10:53 PM

Can we pull an items base price, in a transaction line field, in the same currency of the transaction?

7px

03/01/2022, 6:43 AM

does anyone know how to make an Advanced Template force-resize an image to fit inside a cell, and not have it expand to accommodate the entire image? for context, I have an image field in a record, and when printing, I'd like the image to fit within the boundaries of the cell in a table. i've tried table-layout="fixed" and setting a width value to the <td> to no avail.

shree sashti

03/01/2022, 7:05 AM

How to call a restlet from a schedule script within the same account ? I used https module but authentication failing .! What are all the auth headers needed ?

Luis

03/01/2022, 10:36 AM

I created a custom record to store multiple external systems' IDs per vendor (fields are ID, vendor and the external system). Then, I created a custom entity field (multiple select) to store those custom record instances in the related Vendor record. When I try to create the custom record from the multiple select entity field, it's automatically selected or "linked" to the Vendor record. However, when I import the custom records, they are not selected or "linked" through the multiple select entity field. How can I make sure that the custom records are selected in the multiple select entity field?

c c

03/01/2022, 11:29 AM

I want to insert some text here, where do i modify the form. I looked around but i cant seem to find the form, or where you edit the text

mrunali

03/01/2022, 1:53 PM

Create a custom record with the Basic Customer Information like Name, Phone Number, Email Id and Address after that what is your task is after selecting Customer, remaining fields(Phone Number, Email Id and Address) should populate automatically from the selected customer record. How to do this using client script ? how can we do it using post sourcing also

Livio

03/01/2022, 2:32 PM

Any idea what this error means: trying to do an inventory adjustment - The number of serial numbers entered (0) is not equal to the item quantity (-1.0).

Livio

03/01/2022, 3:16 PM

how can i enable "Make a copy" on Purchase Orders?