-
Can we create excel file with formulae column?
Hello, We are creating excel file with suitescript having dynamic formulae column and it is shown properly like given below but when it is converted from xml to excel then it changes to different version and formulae does not work. We need this to work when excel is downloaded and values to shown as per given formulae when…
-
Excel Unable to Open Saved Search Export (.xls) – File Reported as Corrupted
Hi everyone, I’m experiencing an issue when exporting a Saved Search result as an .xls file. When I try to open the file in Microsoft Excel, it fails to open and displays a message indicating that the file is corrupted or unsafe. Has anyone else encountered this issue? If so, were you able to identify the cause or find a…
-
Search Exports in Prod but Not Sandbox
Hello, I have a rather large saved search that exports and opens in XLS just fine in Production. However, in Sandbox the file doesnt open, instead errors with "The file is corrupt and cannot be opened" message. This seems to be effecting a handful of users at the moment. The same saved search even errors out in Production.…
-
MS Excel Add-in
Hi, I need to connect Microsoft Excel to NSAW to create pivot tables with refreshable data. Is this supported? If yes, what are the steps (eg. Excel add-ins, connection URL)? Are there any limitations I should be aware of?
-
Sales taxes to multiple shipping locations on one order
A change in SOP now requires us to charge sales tax. Our current operations charges CA sales tax if the ship-to address is in CA. No sales tax if the ship-to is outside of CA. Now, we need to charge sales tax on NY and FL ship-to locations. For online orders, this is straightforward. However, with complex orders requires…
-
Automatic Excel or email by location
Hii all i want to know, i have client with until 200 location, i want to ask how to get income statement by location with 1 click export excel (200 excel / location) , or email per locaiton each?
-
How to add pictures in the exported Excel file, can provide to add pictures code? Thank you
I want to make an export to Excel and add pictures, but I can't find a sample reference?
-
NSPBCS Mac SmartView
Mac SmartView users after an initial pivot-like action is executed, all subsequent SmartView actions are held up for exactly 5 minutes according to the SmartView and network logs. I have reproduced this on every Mac i have access to, company and non-company owned, so i don't think its VPN or client related. using add-in…
-
Connecting to ODBC through PowerPivot
Hi All, I have been trying to connect to our NS with MS Power Pivot through the ODBC driver with no luck. I have successfully connected to the ODBC driver with my login credentials but every time I try the connection within MS I receive errors that my username/password or role/companyID are incorrect. Could anyone please…
-
Inventory On Hand Report - Excel Web Query
I want to get some NS reports into Excel for external use using the Excel Web Query option. For some reports this works fine, but I have one report for Inventory On Hand by location that has several columns for locations. When I open the web query in Excel the format of this report is different. The columns in NS are…