Hi Olivier, Is it possible to do show alert message from user event? As far as I know, user event cannot show alert message. CMIIW thanks

Hi Frederic, You got my flow correctly, I have tried your solution and it works nicely. Thanks a lot.

Hi Michael, Thanks for replying, could you let me know how to use the nlapiSetLineItemValue? Code: // filter var filters = new Array(); filters[0] = new nlobjSearchFilter ('custrecord_mto_project', null, 'is', stProjectId); nlapiLogExecution('DEBUG', 'Fill Filter', 'Fill Filter'); // return column type, total amount var…

Hi Michael, Thanks for replying, I'll try your suggestion. Thanks

Hi Bernard, Could you let me know how to write in html to show the image? Is this the correct line to show the image? "h += '<p><img src="/core/media/media.nl?id=5&c=...." width="126" height="45" /></p>';" I have tried using both below link and still not working. is this the image url like this one?…

ok, thanks Olivier & idreesz

Hi Olivier, According to support, it's in enhancement request : Enhancement #135651 - Lists>Accounting>Accounts>To be able to select specific General Ledger accounts to be viewed by a particular role via the Permission Functionality on Setup>User/Roles>Manage Roles** could you share the concept how you do it? Thanks Let's…

Hi Olivier, According to support, it's in enhancement request : Enhancement #135651 - Lists>Accounting>Accounts>To be able to select specific General Ledger accounts to be viewed by a particular role via the Permission Functionality on Setup>User/Roles>Manage Roles** could you share the concept how you do it? Thanks Let's…

Hi Ryan, yes, finally I am using script with nlapiDeleteRecord to delete the record and you are correct that it happen during initial testing and implementation thanks

Hi Olivier, Nope, the status written on the top right side is "Cancelled". There isn't any button showed on this record either edit, delete or void.

Hi Olivier, In the cancelled bill, there is no edit button or delete button. So I cannot do that. (I open the cancelled vendor bill record using administrator role) Thanks

Hi Jennifer, Yes I have create the custom entry form, but the subtab "sales/price" is lock by netsuite so I unable to uncheck it. Netsuite support said it was in enhancement list no.95763 Thanks

You're probably better off creating a custom record with the inventory item as the parent record, and then create a unique record for each vendor for that item along with the a field for having/not having the certificate. Hi Rodriguez, this mean I have to create one custom record, that will have 2 parent relationship (to…

Hi Olivier, ok, Thanks

Hi Thomas, Okay, got it. Thanks

@Richard : you must have permission to publish dashboard for your role. Setup - manage role, choose your role that will publish dashboard - tab permission - tab setup - publish dashboard - level set it to Full

Hi, @Lorna : 1st you must keep lead source value in the your customer record 2nd create search based on transaction record with filter type : sales order and lead source : desired tradeshow x result mainline : 'T' , group by customer and count sales order number @Tom : I don't think you could get number of orders using…

oh ok, this scenario might work for my case. thanks a lot

so this mean your internal sales order status will always in pending billing after has been fulfilled?

@The Wizard of Oz : hmm.. ok, could you please elaborate more about what account is effected if using invoice and what account is effected if using inventory adjustment at your side?

@The Wizard of Oz : ok, thanks

what about the invoicing part? did you generate invoice if the customer is internal?

I believe transfer orders only moving stock from one location to another location, not deducting the stock qty. CMIIW

have tried to create shortcut using this link https://system.netsuite.com/app/site/hosting/scriptlet.nl?script=847&deploy=1 which is the suiteideas url but it returned "That Suitelet is invalid, disabled, or no longer exists" anyway just for update, the defect already fixed by NetSuite support team. search by enhancement…

@Guayaki : which form are you refering to? I did not found the account button during this step: "Do another "accept payment" for that sales invoice and instead of hitting the discount field for $20, click the account button and pick the correct account (expense) number that pertains to bank fees. "

Hi Peter, you can use script before save to loop the item line and set value on you custom column. example: var dLineItemCount = nlapiGetLineItemCount('item'); for (var c = 0; c < dLineItemCount; c++){ //Set you custom field //nlapiSetLineItemValue(subListType, fldName, line, fldValue) nlapiSetLineItemValue('item', 'your…

@NatalieLynn : if you already have location set to the customer record and want set the location when pull up customer for transaction then for simple way you could create a workflow for that transaction. for example new sales order : recordtype : transaction subtype : sales order event : on create trigger : before load…

Hi Caren, Thanks for replying, your solution works like I want it. Thanks Regards, Andry Wang

Hi NatalieLynn, is it contact or customer? probably you could try update the customer using import, there is password field there.

Hi Jay, Thanks, the weird thing is the value appear normally in saved search but showing "ERROR: Field Not Found" in the "Purchase Order" record detail level.