My Stuff
Comments
-
From the release notes for 2016.1 (section 'Advanced Template Reference by Script ID') it looks like this will be possible using SuiteScript 2.0.
-
I had a quick look in the debugger, it seems that the text value is in the parameters in an undocumented field prefixed by "inpt_", so you could probably do request.getParameter( 'inpt_custpage_manufacturers' ). However, it's best not to rely on undocumented stuff. I would suggest refactoring your code to something like…
-
LOL https://xkcd.com/979/
-
Not being documented makes me wary to write production code that depends on it :) FWIW if you wanted to do this in a "documented" way you could use nlapiSearchGlobal('file:' + filename); :D
-
Note that the package Sublist is not officially supported by SuiteScript. I have tried to script it and ran into many issues until finally giving up. https://system.netsuite.com/app/help/helpcenter.nl?fid=chapter_N3206326.html
-
We just use a journal entry to correct Debit the Accounts Receivable account tagging the customer the payment mistakenly entered under Credit the Accounts Receivable account tagging the customer who actually made the payment Add a memo to the Payment record referencing the journal as explanation Then you can Accept Payment…
-
I don't have an accounting background but as far as I can understand - unapplying a payment is just the reverse of applying one. If you can apply a payment from a closed period and that is not a GL change, you should be able to undo that as well.
-
Um...wouldnt the change in payment affect the balance sheet values and therefore be a GL change? I can say from experience that it works.
-
This procedure is documented at https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n2385449.html Netsuite PS also has a a paid solution under their SuiteSolutions program to automate the process http://www.netsuite.com/portal/assets/pdf/suitesolutions-vendor-prepayments.pdf
-
Instead of reopening the period, you can enable "Allow Non-G/L Changes" to the period in question, which will allow you to unapply a payment even if the period is closed. https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N1446470.html
-
That's tricky.. The usual way of doing this would be to create a custom field to source the field, however it doesn't look like it's possible to add a custom Transaction Column Field to a Bill Payment...
-
This is the top requested "Enhancement Request" in SuiteIdeas' (#41956), so go add your vote to the 1132 existing votes :rolleyes: https://system.netsuite.com/app/site/hosting/scriptlet.nl?script=847&deploy=1&custpage_ervotingviewdetail=T&custpage_ervotingviewdetailissueid=426970&custpage_votecount=1132
-
Try something like this: [LIST] [*]Posting is true [*]Main Line is true [*]Date is on or before <date> [*]System Notes : Field is any of Impact, Total [*]System Notes : Date is after <date> [/LIST] Of course best practise is to lock/close periods as soon as you pay tax to avoid these issues.
-
You can update it directly in the address sublist, i.e. not through clicking on the pencil icon to edit the address details.
-
Another option is to create a "Suspense" customer record that you can use to record the payments, and once you identify the customer, you can change the payment over to the correct name.
-
You should be able to do this by logging into your Sandbox Administrator role, and then editing the employee records in question and giving them access and the required roles
-
There's a SuiteApp you can install that allows you to make a copy of the Admin role. It's called "Administrator Role - Customizable". I've found that that Bundle doesn't include every permission and is not maintained when Netsuite creates new permissions.
-
So let's say you want to upload some items and save the file as CSV is that when you add the ' ? How does NS take it, I mean how do you remove it? Do you also use this in a Search Query inside Date fields and numbers and add ' single quote then export it. Then I assume you remove this after but won't it convert it back?…
-
The issue here is that Excel is trying to be helpful and convert what it thinks are long decimal numbers to exponential notation. Once the CSV file has been saved and Excel closed, you cannot accurately convert them back, as the numbers have been rounded off and you have lost the last 9 characters, so you will need to do…
-
Another tip for working with CSV files in Excel to avoid Excel trying to automatically format the data - instead of opening the file directly, first open Excel and use 'Text Import Wizard' (on the Data tab, in the Get External Data group, click From Text). In Step 3, select all your columns and choose Text as the data…
-
If you chose custom, by definition you will have to specify what custom price you want. If you want to have Netsuite pull up the Price Level for the customer just leave that off your mapping.
-
The column you want is "Price". You need to make it visible on the form you are using for the import.
-
It's a line level field - click on the '+' icon next to 'Invoice Items', and you should see it.
-
I've tried that out on my account and get the same results (field checked on Customize Form but not visible in the UI). It sounds like a NetSuite defect to me.
-
It depends on the account types in the Journal. Asset and Liability accounts impact the Balance Sheet Income and Expense accounts impact the P&L
-
Just a thought but maybe you could create a Discount code tied to the expense account and on the Sales Order charge out the item at cost price and a discount line underneath? (Of course this won't work if your customer sees the invoices).
-
Another option is to change the line quantity to 0, and to manually override the Amount. You will get a warning that the Amount does not equal Quantity times Item Rate which you can ignore. carl.billings 's method is useful for if a Credit is unrelated to any item, and this is what we do if the Credit ties to a specific…
-
Be nice is you could add a contact to a sales order. Not sure if there are other requests for this though. You could create a Custom Field on the Sales Order to link to an individual contact.
-
There are a couple issues with how you are filtering your results 1) You are not filtering the Main Line, so your total amount will be doubled (because your search includes the main line amount = total transaction, plus the amount on each individual line). 2) You are not accounting for stand-alone Invoices or Cash Sales…
-
Does the page come out of the printer more or less instantaneously like a regular printer? About 30 seconds delay