-
Give Manage Accounting and Tax Period permissions to custom role
I have a custom Role for my new Financial Controller. I have given this role the "Manage Accounting Periods" and "Manage Tax Reporting Periods" permissions, however he still does not have access to these pages or even the submenus on the Setup Menu. Does the role require additional permissions or can only Administrators…
-
Problem with scheduled reports
When I click on the report it shows me the data I want to see, but when I schedule it I always get an email that says the following: NetSuite encountered an error while trying to generate your scheduled report. Please click here to notify NetSuite Support. Trying to find out if anyone has had any similar issues and…
-
Search filter by individual employee names (solution post)
Was doing some enhancement voting and came across the following with 42 votes... "Employee Available Filter on footer of Saved Search is restricted to [ All, Unassigned, Mine, My Team, Mine and Unassigned, My Team and Unassigned] -- please list individual employees as well." To do this, create a custom entity field against…
-
Fixed assets depreciation correction
Hi, I run the monthly depreciation in the module, and after that I needed to make changes to assets. How can I cancel the last depreciation and create a new one?
-
Tax periods in US account
Hi, I have a one-world account containing a US subsidiary. I noticed that the tax period is populated only on unapplied Customer Payment and Customer Deposit. Could anyone explain the meaning of the Tax Period for the US subsidiary?
-
Saved Search Email Attachment Naming
I have a scheduled saved search which sends the report as an attachment. I want to rename the attachment appended with date . How to rename the email attachment generated from a saved search?
-
Quantity In Transit (External) Negative Balance
Hi, I have an Inbound shipment as per screenshot below where one of the lines has expected received more than the received: And for that particular item of that location there is a negative quantity on the quantity in transit (external). The status of the Inbound shipment is "Partially received". How to correct this from…
-
Finding the date of when a Vendor Price was set for an Item
Hello Gurus, I am trying to create an Item Search that would include Vendor Price information from the item record. I am not able to locate the ability to show the date in which the Vendor Price was updated. Does anyone have a resolution for this?
-
Why does the exported Saved Search result is different from the UI?
I am doing a transacton search on invoices. The search results are what I expect, on the screen (70 results). When I export to either Excel or CSV, I am getting duplicate lines for every invoice. (732 results). If I select print to pdf, the correct lines show up but excel/csv is what I need. Criteria: Results: I see there…
-
Possible Divide by Zero Error - One user only
Hi folks, Wanted to see if anyone has run into this before. I've been created some formulas in a saved search to run ratios but continue to receive the error possible divide by zero. I have quadruple checked my formulas and I have accounted for all possible scenarios. I then discovered that my other system admin can run…
-
Other name multi currency
Hi Is there an option to apply more than one currency to an Other Name record in order to be able create transactions with different currency
-
Saved Search to Show What Discount Was Applied to a Sales Order
I am trying t display what discount in the head was applied to a sales order. I can't seem to find the discount item used to display in the results. Anyone out there have any ideas? Thanks for any help. 😊
-
Specialized User: WMS
Hi , I have assigned the specialized wms role and am not able to login. Below is the error message received: Please help as we are have a go-live. Thank you
-
In need of a search/report/workbook that will show me sales of two items that are on the same order
I am looking to create a search, report or workbook that will show me sales of item A and item B when on the same sale. I want to see the item, qty sold and sales amounts only for those two items in the results. I have tried "item on any line" in a search but the results pull all the items on that sale and I only need the…
-
Adding GL report to workflow email
I have created a workflow that automatically sends an email after and Assembly number is made for a work order, I would like to add the GL impact of the WO's to the email. How should I go about doing this?
-
Line breaks or carriage returns removed in list view?
Users are telling me that there's been a change to how Long Text field data renders when viewing those fields in List View (editable Saved Search). When the user clicks into the column that contains the long text data, NetSuite removes all line breaks and renders all the data in a single line; ignoring the existing…
-
Pulling Account Period and Account Internal ID into a Budget saved search?
Does anyone know what the budget saved search is so limited on available fields? We need the account internal ID and the account period. Right now it only outputs the total amount of a budget line, but the budget is broken out by periods. Somehow NS is grabbing the period (since the budget vs. actual reports work…
-
Print Labels with Price Level matching the Subsidiary Currency
Hi Community, When printing Item Labels from Purchase Orders, we get the USD Pricing instead of the CAD Pricing on the Canadian Subsidiary PO. PO Details: Item Label Printed Out: Expected Price: Weird thing is, when you use the Prints Checks & Forms Page > Print Item Label, it can print correctly. It's most likely because…
-
Scheduled Email Saved Search
I am trying to have a daily email that is sent out each morning, I have created a custom saved search that pulls all created/ changed transactions from the prior day based on what has been last modified. I then edited the custom transaction search and on the email subtab, I added myself and one other to the "Specific…
-
How to create Saved Search for Sales Orders with more than one line item?
Hey gang- I'm having trouble creating a saved search that display sales orders that have more than one line item. We're having an issues with our tax calcs. are off due to order level discounts- which we have fixed- but we need a way to reconcile the old orders to make sure we've corrected everything. I can get to all of…
-
can I add button on a saved search?
Hi, I was trying to see if its possible to add button on a saved search? I wanted to add Bill button on a purchase order transaction saved search? thank you for your help
-
Defining text formula in the Available Filters section of a saved search.
Hi, I'm writing a saved Case search where I want the user to be able to type a SO# into a filter at the bottom and have it return the related case info in the results. The SO# has to be substringed out of the custom field in our implementation (e.g. "Sales Order #12345"... the formula is SUBSTR({custevent_sale_order}, 14,…
-
Save search Formula Issue
Hello Team, I am facing an issue with formatting a date in the YYYYMMDD format within a saved search using the NVL function. I want to ensure that the date appears in the specified format, but I'm encountering errors whenever I run my formula. Can anyone assist me with this? Thank you! My formula: CASEWHEN {type} =…
-
Unable to report on Location when entered at the Header AND Line level
We have a custom transaction form which displays a required Location field at the Header level AND at the Line level*. However, when reporting on these transactions, we have only been able to find the Header level Location field as a filter criteria or column heading. (How) Can we report on the line level Location on these…
-
Customer Prices on Customer Dashboard
Hi Guru's, our customer is using the Customer Dashboard. We've created a saved search for them that will show all the Item pricing that is set on the customer record (most of them are 'custom' Prices. There are some customer with subcustomers and when i open the search on the parent customer I also see the prices of the…
-
Getting Installments collected in Payment using SuiteQL
Hi , I am trying to prepare a report that would retrieve all the Sales Invoices along with its Payment Schedule linking those installments to the Payment details (Apply Section). The business team wants an export for all the collected amounts to identify patterns in the past as of a certain date. Our schedule per customer…
-
Custom Sublist for inbound shipment record
Hi, I am trying to add custom sublist to inbound shipment record, please suggest me how to achieve this. P.S - I don't see inbound shipment in transaction tab of custom sublist definition. TIA.
-
Non-Admin Users to Edit Reports?
Is it possible to allow people to edit a report when they are not the owner or an admin? How is that done? Are there permissions necessary? Thanks!
-
Purchase Price (from Item Page on Vendor Line) vs Vendor Price (from Vendor Page on Item Line)
Greetings Everyone, I've couple of questions with these 2 Fields: Purchase Price (from Item Page on Vendor Line) Vendor Price (from Vendor Page on Item Line) Ideally I would assume that these 2 fields are same, but please look at these snapshots for 1 Item (GUN-TG2332-PN) on Vendor 02721… So, question here is why there is…
-
How to enable IP address to be able to access with Admin role
After enabling "IP ADDRESS RULES" features with admin role , we were not able to login now as we didn't define the IP address on the company information. Its urgent can you please help us disabling that feature or please provide any other way to resolve this issue. Error message getting when login on admin role: " Invalid…