-
Is it possible to create either a saved search or analytics report that shows unapproved time sheet
I can create the saved search which shows data using "previous week" as the custom date option, but this starts on a Monday. One of our subs working week starts on a Sunday. I need to combine into 1 search or Analytics report but am struggling. i don't want to manually have to go into the search every week and change the…
-
Suiteflow Advanced Approvals Approve Button Missing
We have installed the latest Advanced Approvals bundle 108404. The next Approver is not seeing the approve button although they are the dynamic rule approver {purchase approver} on the approval rule
-
Pipeline By Sale Rep Summary Troubleshooting Request
Sales Manager is pulling Pipeline by Sales Rep Summary Report (Native) No customizations There is a Sales Rep Yvette Winter, who is no longer with the company. When Yvette left the Sales Team/Primary Sales Rep was changed to a different Sales Rep. The report is pulling Yvette with 1 customer... $0.00; however I can't find…
-
Missing timesheets in version 19.1.
Under NS version 19.1 missing Timesheets are now automatically created for the current week and the previous five weeks on the first day of the week for active employees with ZERO hours. My question is if I already have a timesheet filled in for that week, will the system override the current sheet with a zero hours entry?
-
How to complete a PO/bill/expense report without Permission List>Accounts?
Hi there, does any one know how to complete a PO/bill/expense report without Permission List>Accounts? (I'm using Netsuite 2020.1 version) As our group companies have many purchase staffs, some of them may take care of purchase activities of two companies, the role they are using are all granted permission to Bill for…
-
Advanced Approval based on category
We have a requirement that POs with items with Product Category Spares go through a different approval routing than POs with items with product category 'Finished Goods'. Further, the approval people and the dollar amounts (minimum amounts) will be different in both of the above scenarios. The approval rule groups in…
-
How to apply credit from Customer Invoice 'discount' to original account on Customer Invoice
Hi there! We have an issue related to COVID-19 where we cannot deliver on certain donor milestones so their Customer Payments are going to be less than the Invoices originally recorded for them. The best way I can think of to record this is using the Discount Taken field on the Customer Payment (since they're not issued a…
-
I can't deactivate a deferred expense account for some reason
Our professional services team suggested that we set our Accumulated Depreciation account to a Deferred Expense account type, but we're having an issue because in our reports it groups with Other Current Assets rather than Fixed Assets. So, I created a new account Accumulated Depreciation with the account type Fixed Asset,…
-
How to add page numbers to exported to PDF?
I'm trying to add page numbers in the footer of a report that is exported to PDF and emailed out on a schedule. Is this possible? I know I can change the orientation and font in my preferences from the help files but I don't see how I can go about adding something like page numbers in the footer. Thanks, Loren
-
Saved Search that Shows Multiple Item Group of Member Items in One Line
Saved searches allow users to incorporate SQL expressions to conform with their business reporting needs. There are other users that needs to track which Item Group a member/component item belongs to. This is to determine which Item Groups may be affected by a specific transaction. By simply exposing the Item Fields ... >…
-
How do I create a NetSuite mass email campaign to each Customer Primary Contact that contains a list
Customers are not always diligent at keeping Contact information current. We may send an invoice to a contact and it may be Undelivered or Bounced, delaying payment and collections. How do I create a NetSuite mass email campaign to each Customer Primary Contact that contains a list of all Contacts for that Customer? I need…
-
Create a saved search to get subtotal from corresponding sales order for transaction which are fulfi
I'm trying to create a saved search for transaction. The criteria is type is item fulfillment. In result tab, one of the requirement is to get subtotal from corresponding sales order. As we have applied coupon code, the total of sales order is 0. The field used to get record from sales order created is created From…
-
Project Task Import - multiple resource assignees
We are using quite a few features of Netsuite Projects including, projects, Project management, advanced project profitability and several suite apps. We are using Activities > Scheduling > Project Tasks > Import to import tasks. Each task could have multiple resources assigned. Our issue: when we import the tasks with…
-
{deliveryinstructions}
Can anyone offer some insight as to where this field is stored / how it is accessed? It's available as a field under Transaction saved searches but its not on any forms or available in the XML view of the transaction. Thanks!
-
Accessing Customer Fields from Sales Order Suitelet
I have created a suitelet to create sales order from html page . How can I Access Customer Fields from Sales Order Suitelet. I need to get a value from linked customer record and update it after sales order is successful for that customer. We are suing Suitescript 2.0 Thanks
-
Email Campaign - linked images do not display on Mobile Devices
I created an email template in order to send mass email campaigns to subscribers. The HTML editor I am using (Mail Designer) creates both a Desktop and Mobile version of the code. I import the Code into Netsuite -> Email Templates. The images are all hosted on our Google Cloud Storage with public permissions (tested…
-
Setting the Memorized Transaction Definition
Scenario: The user would like to post the Memorized Transaction twice every month. Solution: Here are 3 options on how the user can achieve this: Option 1: On the Recurring tab > Set the Repeat Every = 2 > Time Period = Week > Click Save Option 2: On the Custom Dates tab > Add the Desired Dates of when you want the…
-
Memorized transaction frequency
The functionality to memorize a transaction to occur twice a month seems to be gone, is there another to create this frequency? Custom schedules is not feasible and every 2 weeks creates too many. Having to create two means I have doubled the amount of memorized transactions I have to maintain. The below verbiage indicates…
-
Show Supplier Name at Line Level on Sales Order Special Order items
I have created a transaction body field to show the Company Name on a Purchase Order when the Supplier ID is selected using the Sourcing and Filtering option on a custom field: I want to do the same with a Custom Line Level field on Sales Order Items so that when a Special Order item is selected and a Supplier chosen…
-
List declaration editing
I've declared a list in my custom advanced pdf and when I add item.item, instead of the list going from row to row, the list only displays one item per page. So instead of eight items displayed on one page, the eight items are displayed on eight pages. <td colspan="3" style="width: 572px; vertical-align: top; text-align:…
-
Prevent Sales Order save when payment information is incorrect when creating a transaction using Sui
When creating a Sales Order via SuiteScript (then transform it to a CC Sale) for a credit card transaction is it possible to prevent the save of the Sales Order if the payment card is incorrect? If I set the 'getauth' to true, both the Sales Order and CC Sale are created but they have a payment hold. If I do not set it…
-
Work order issue component
When I create work order is Sandbox and save and print the BOM, Qty required is filled for the same item, but when I do the same in production it is blank.
-
Problem in Bulk Asset Transfer via CSV
Hello NetSuite Gurus, I'm trying to do Bulk Asset Transfer via CSV (avaiable in Fixed Assets -> Transactions -> Asset Transfer -> Import CSV). I'm choosing my CSV file which looks like this: Asset,Location2,100. Бургас But the CSV file get never imported with this error: MISSING_MANDATORY: The data for asset transfer is…
-
Having more than 125 subsidiaries in a one world instance
Hi all When designing a sub structure have you found any clever ways around the 125 subsidiary limit imposed by NetSuite. Where performance and reporting degradation is encountered. For instance have you used custom segments? Thanks Chris
-
Purchase Order custom status
Hi, We are using advanced approval purchase order workflow. The process that we have is requestor creates PO and clicks submit button then it updates the next approver/next role approver but, the problem is if any of the requestor forgets to click SUBMIT button then it wouldn't show the approver details. I have created a…
-
Making date.parse work for user's time zone
There is a nice formula in SuiteAnswers which provides the number of days between two dates. The problem for me is that in the user interface we are entering dates in DD/MM/YYYY format and the formula assumes all dates are MM/DD/YYYY. Here is the formula that I am using to set a field via Workflow.…
-
Marketing Template
Hello, I'm having trouble saving my pdf file on to the marketing template I created. When I go to save it this is the message I get below snapshot. Any suggestions on how to convert the pdf file to the file types below? Thank you! Liz Madrid
-
how to make Assembly components display in picking ticket and packing slip only?
We would like to display assembly components in picking ticket and packing slip only? And in Quote, Sales Order and Invoice, we don't want to show components. Is it possible to achieve that? If check "Display components in transactions" in Assembly item record, it will show components in all transactions. I appreciate your…
-
Wrong UPS package dimensions
hello everyone, I am trying to do a bulk fulfillment of sales orders for a customer and also bulk print the integrated UPS shipping label. But the package dimensions coming on the shipping label through Net suite are wrong. our product dimensions are 19x6x6 and the box dimensions on shpping labels are coming in as 12x3x3…
-
SuiteScript 2.0 - Can we create a gift certicate from a script?
Hello Guru team, I'd like to create a gift certificate from SuiteScript 2.0, however, the script got the error GIFT_CERT_CODE_REQD 04/01/2020 22:17:43.282 {"type":"error.SuiteScriptError","name":"GIFT_CERT_CODE_REQD","message":"You must specify a gift certificate…