It is possible to complete this action via the UI with the 'Advanced Add' button. Therefore there is a possibility that the 'unzipping' functionality is there somewhere in NetSuite's API. You will notice the field ID is 'unzip'. I experimented with nlobjFile.setUnzip(true) without success but there might be another way. If…

The main body fields related to the default shipping address will only source once the record is fully saved. Now it appears that this main body information is not updated when you fetch the values. My suggestion would be to iterate through the address list and find the address marked as 'Default Shipping' and use the…

You will need to create a Customer search and join on Pricing. I'd suggest experimenting with it in the UI via the 'Pricing fields...' to see the format of the results it will return.

You will need to use insertSubList to have a consistent behavior. The example below will put the item tab BEFORE the lot tab: itemForm.insertSubList(itemTab, 'custpage_lot_sublist'); The first parameter is your sublist object you want to insert in front of the second parameter (which is the ID of the second sublist).

Here is sample code to create a note tied to a transaction record: var noteRecord = nlapiCreateRecord('note'); noteRecord.setFieldValue('note', 'This is a test note'); noteRecord.setFieldValue('title', 'Title'); noteRecord.setFieldValue('transaction', TRANSACTION_INTERNAL_ID); nlapiSubmitRecord(noteRecord); Just plug in…

Good afternoon Keith, If you use the basic PDF layouts you will need to edit your Statement form (Customization-Forms-Transaction Forms) and under the Columns tab make sure that Open Amount is shown. This will show the amount remaining of your invoices. If you use advanced PDF layouts you will need to edit your advanced…

Good morning, Depending on your volume and frequency of changes you might want to look into automating this process. If the volume/frequency is low enough then CSV imports will work well. The solution would be a user event script deployed on the customer record triggered on after submit. If the current customer is a…

Good morning, I think you might have Approval Routing turned on for Bills. On the bill, try changing the Approval Status to Approved and that should unlock the Posting Period field. Best regards,

It looks like the 'Default Vendor Payments to be Printer' setting was activated. You can find this under Setup-Accounting-Accounting Preferences-General. However you can define the 'To Be Printed' value via your CSV import and flag it as FALSE for each vendor payment.

The key to make it work is to map the 'Internal ID' to the 'Invoices : Invoice (Req)' field. Mapping it to the Invoice number will simply not work. You will need to export the Internal ID of each invoice you want to pay and cross reference them in your CSV file. Also, do not map the 'Line' field unless you know for certain…

Good morning, One thing you could do is use a different column field as the printing Item field on your customer facing form/printout. For example, you could use the Description field instead. Customize your transaction form and under Printing Fields, uncheck Item and tick in Description and move it as the first element…

Lists-Financial History-View should grant access

There is a couple of settings you can tweak to prevent duplicate numbers: 1. Under the Accounting Preferences-Items/Transactions you can activate Duplicate Number Warnings (This will pop up a confirmation box when the user enters a duplicate number). The user can still enter the duplicate number but he has a warning before…

Hi Dave, The Execute As Role is indeed locked on scheduled script deployments. The majority of scheduled scripts require to be ran as Admin in order to be able to accomplish their task. One option would be to add logic to the scheduled script in order to select the Posting Period based on the logic you described: - Trigger…

Hello Ryan, Ship Date is not available to inline editing. The 'Supported in nlapiSubmitField' column of the Records Browser is usually accurate to identify inline editable fields https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2013_2/Records/salesorder.html If inline editing the Ship Date is crucial, you…

Hi Jim, Are you using standard or advanced promotions? If you are using an advanced promotion (item-based), what is the Item criteria? Is there any chance that the Customer and/or Item(s) combination of the order make them non eligible for the promotion discount? What is the discount item associated to the promotion? Can…

Good morning, One option would be to look into installing the Advanced Promotions SuiteApp. This would allow you to create Item-Based Promotions based off an item saved search. Instead of having to input items one by one, you'd simply create your saved search with a filter identifying the items eligible for a promotion and…

Good morning Jarrod, You will need the Internal ID or External ID of the Item to be included in your import file. Then set up a CSV import of type Update. Since the Categories sublist does not contain a mappable ID any Category you map will be added at the end of the list. What you will need to do is check the 'Overwrite…

It looks like the -Not Taxable- tax code has been inactivated (it is the native tax code with internal id of -7) 1. Go to Setup-Accounting-Tax Codes 2. CheckShow Inactives (checkbox at the bottom) 3. Re-activate -Not Taxable-

This is likely to be related to existing defect #415810. I would suggest filing a case and have it attached to the defect to expedite its resolution. Best regards,

I'd recommend reading up on DEV2520 which included interesting and detailed tips on setting up this type of customization (SuiteAnswers #42473). There is an example with the exact library you referenced (chartjs) but the presented method can use any library of your choosing. Best regards,

Good morning ACarter, To debug, add the following line at the end of your .bat file: PAUSE That will give you visibility on the error to troubleshoot. (And it can be removed from the .bat once the issue is resolved) A common issue is that your Printer Share Name or Computer Name has spaces and/or special characters. I…

Good morning, You will need to edit the Sales Order you want to memorize. Under More Actions you will find the Memorize action. You press this button and then you can set up your memorized transaction. You can decide to have it automatically created or have it set up as a reminder. Define the frequency and save. You can…

Good afternoon, If you don't want to have to manually select the right .bat file each time you download a FedEx or UPS .epl file, you will need to build logic within your .bat file. Using 'FINDSTR /i' to search through the EPL file for 'fedex' or 'ups' you will be able to determine the right printer to use. Sample code:…

Good morning, As of right now Schedule B Number ('schedulebnumber') is indeed not accessible for sourcing at the line level. Even using the advanced PDF templates will result in the same issue. A viable workaround would be the following: [LIST] [*]Create custom text field at item level called 'Schedule B Number (Print)'…

Good morning Gabriel, Since we can assume that the credit card has been validated outside of NetSuite (via Moneris) you should check the 'CC Approved' checkbox (as well as unchecking the Charge Credit Card checkbox, as you are doing now). This will effectively move the Payment to 'Not Deposited' instead of 'Unapproved…

Hi Bednar, 1) You will need to customize your form and go under Lists. You will find your parent subtab there. You can reorder your child subtabs by dragging them up and/or down. 2) Indeed they are locked. Best regards,

Jay is right. The only way this can be done without scripting is to use the Mass Update under Transactions called 'Bulk Email'. That however only allows you up to three email recipients: Transaction Email, Customer Email and Contact Email. You could experiment with it and see if it fits your requirements. We customized…

You will need to set the link inside the <head> section: &lt;?xml version="1.0"?&gt; &lt;!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd"&gt; &lt;pdf&gt; &lt;head&gt; &lt;link type="stylesheet" src="stylesheet.css"/&gt; &lt;/head&gt; &lt;body&gt; &lt;/body&gt; &lt;/pdf&gt;

Good morning cgiselman, I would suggest the Custom Mass Update approach. Since your action is based off search results the Mass Update approach gives you the ability to output your search results and then Perform the Update on selected records. Since workflows do not support line items editing without a Workflow Action you…