Posts

Showing posts with the label netsuite guru

How to create Journal Entry in Netsuite Suite Script 1.0?

Image
Hi All, Today I got chance to work on creation of Journal Entry using Script. What is Journal Entry Record? A general journal entry records debits and credits to be posted to ledger accounts. General journal entries adjust the value of any set of accounts without entering transactions such as invoices or bills. Basically Netsuite does all those things but if ledge is not proper then you can do this manually using amount only . There can be many source of data for getting amount and account, there are 2 field where we have to enter debit amount and credit amount . Debit and credit amount should be same, only difference is that Account should be different. So lets say one is " Revenue from Amazon "  and second one is " Revenue from Partner ", and you want to Add First one as Credit and second one as Debit account. Now lets say you have invoice of USD104.33 then you have to add 2 lines , one for Credit of 104.33 for account Revenue From Amazon second ...

How to make 16 character alphanumeric url for security like in Netsuite Suitelet? Or How to hide internalid's or number from Suitelet URL?

Hi Everyone, Can we have 16 character alphanumeric URL to stop user's to see internal id and other stuff from URL? To Achieve this functionality we need below stuffs in Netsuite:    1. Custom Record for Storing 16 character Alphanumeric code and related parent record and employee id etc , basically here we have to store all required filter which we uses to show Parent record to user.    2. On Save of record , user event should create unique code . Set required value to custom record.and add unique code in suitelet's URL , so that when user click on that he /she will see only unique code in URL.    3. Lets say we are creating Suitelet to show form then we have to add search based on unique code and other filters if any. Now based on result you will get one parent record and you have to either load record or add another search(or inside first only you can add result) and show data in the fields . If you are submitting data and showing on other...

Netsuite Search is opening the record it self when there is one result. How to fix this?

Image
Hi All, while making reports, most of the times situation comes where there is only one record is result BUT netsuite is not showing columns ,inspite of this showing record it self. How to deal with this? Like mentioned in previous post, go to Set Preference and then click on A n alytics Tab, There you will see one checkbox field " Show List When Only One Result " Click this checkbox and next time on-wards you will see columns you mentioned in search result if 1 result is satisfying criteria. Thanks Abhi   

Simple and Short Example of How to create Form in Netsuite's Suitelet

Hi , This is one small part of my work where I have to show message that some required parameter is missing. You can add logic to check if you are getting all required values or not otherwise it will case Suite Script Error on Form. function showFormDate(request, response) {     var someid= request.getParameter('someid'); if(someid) {  //do something , add your logic } else {       var form = nlapiCreateForm('Parameter Missing');         var field1= form.addField('custpage_message','inlinehtml');         field1.setDefaultValue('Parameter is missing');         response.writePage(form); } }