hi @Francesca Nicole Mendoza-Oracle thanks for taking time to respond to my question. Case i had raised is closed, with a note that my script is "kind of optimized", but i still see error for certain large pdf..hence wanted to see if anyone else have a better solution in this forum. thanks, Veda.

hi @Francesca Nicole Mendoza-Oracle thanks much for taking time to respond to my query. Am using this NS feature: "Control visibility of Expense Receipt only to the owning employee. You can enable Setup->Company->Enable Features->Company->Data Management->Enhanced File Security" this needs the file to be attached to the…

hi, careful choice of unique fields looks to be the only option at this point to remove duplicates. thanks.

hi @Patrick Fresnosa-Oracle thanks again for your inputs. i've proceeded with using SuitAnalytics workbook for my needs. One last question on this topic: Is there a way to remove duplicate data in the dataset. Pls let me know. thanks, Veda.

yes, we have billable expenses shared through customer invoice and Customer wants to see the associated receipts in the same invoice pdf. thanks, Veda.

hi Patrick, hope you are having a good day! Thanks for taking time to provide these info. These definitely help. Is it possible to use Workbook or Suite QL for better analysis instead of search….can you share your thoughts. I would like to check out one of this option, based on your feedback. thanks, Veda.

hi, NetSuite Support team helped resolve this issue. When we recreated the search and modified the Customer is Any criteria, issue was resolved. thanks, Veda.

hi @Patrick Fresnosa-Oracle thanks for quick response. Here are couple of Qs: Referring to Resource Allocation Date to a Project Task. If an employee is allocated to a Project Task, how to find if time has been submitted beyond this Resource allocation date to Project task. Pointers to: Search/Query would help. Can Project…

hi, per NS Support team, defect still exists. thanks, Veda.

True

hi Judith, thanks for this info. Is there any other suitescript option which we can use , other than rest API, to create vendorBill from Multiple PO. thanks, Veda.

hi, is there a way to create VendorBill referencing multiple PO, using rest API. thanks, Veda.

hi, we would have liked have the error email to the user with more details, but we now understand how this works and this query is good to close. thanks for your help. thanks, Veda.

ok. We can manage with this. In case of errors like, attachment more than 10MB or total email size greater than 25 MB or any other issues , email address returns an error like: Unable to Process, without much details. This is definitely a cause of concern, as the user doesnt have details of error. In this scenario, error…

hi, we dont use Email Case Capture. As mentioned earlier, we use a emailCapture plugin custom script. Once we create this script, we get a emailID to send emails. Would like to know the emails that has been received at this email address in NetSuite. thanks, Veda.

hi, csv import is not supported for Customer Deposit. Refer: SuiteCloud Supported records in help section. thanks, Veda.

hi, can you change <td class="right-align">${groupTotalBalanceContractSAR?string('#,##0.00')}</td> to <td align="right">${groupTotalBalanceContractSAR?string('#,##0.00')}</td> and let me know if it works. thanks, Veda.

hi, you use hard-coded values in the script to get to the line causing issue. thanks, Veda.

<th style="width: 10%;" colspan="5" align="right">Unit price</th> <td style="white-space: nowrap;" colspan="6" align="right">${item.amount}</td> hi, i've used above for aligning table header and table data and this has worked for me. thanks, Veda.

hi Paul, there were some recent issues with mail delivery especially for na3 data center. Not sure if yours is related. Its better to check with support. Refer: https://usergroup.netsuite.com/users/forum/general/errors-troubleshooting/425981-netsuite-generated-emails-and-replies-going-into-spam/ thanks, Veda.

Looks like there is no direct option to find these JE. You can do a transaction search for type Journal and filter for memo contains "Rev Rec Destination", you should be able to get the JE list. thanks, Veda.

hi, transaction search with criteria: type: salesOrder, MainLine: F, Shipping: False and tax line false, should get you items sold to customer. thanks,

Do a transaction Search with:["type","anyof","SalesOrd"],"AND", ["mainline","is","F"],"AND",["taxline","is","F"], "AND",["shipping","is","F"] Basically its a transaction item search and add a filter for product line. Have the results grouped by Customer, followed by Sales Order. I believe this should meet your requirement.…

Issue you are seeing could be due to the active records count being > 1000. Pls see this link: https://netsuite.custhelp.com/app/answers/detail/a_id/18280/kw/unassigned%20mine thanks, Veda.

/app/common/entity/employee.nl?template=F&r=T&id=44064&machine=accesshistory is the url which provides history info (where id is the employeeInternal id) We are also trying to see if we could connect to this url and get the info. But this url needs login access and hence giving an error thanks, Veda.

hi Mujeeb, As per design, Disc. Taken should get populated, if the payment date is before Discount date (and there is Disc. Avail amount). You would need to check if the invoices selected are within payment due date. thanks, Veda.

Fine i got your need now. Fields checked in Printing Fields tab in the transaction form appears for Customer Center role. Pls see: https://netsuite.custhelp.com/app/answers/detail/a_id/64591/ thanks, Veda. Netsuite Consultant Skalable Technologies.

hi Sam, these could be due to browser caching issues. Pls clear browser cache and check if changes are reflected on the customer center form. thanks, Veda.

You can create a search to restrict the fields. Pls see: https://netsuite.custhelp.com/app/answers/detail/a_id/22026 thanks, Veda. Netsuite Consultant Skalable Technologies.

hi, pls look at: Campaign Response Summary report, you can find number and percentage of email messages opened. thanks, Veda.