lynale Red Ribbon

Has anyone captured data submitted from the front end without using Case form, and posted directly to the customer or customer's Quote?

I got it figured out. Had to create a new custom role from scratch that does not have the "Mandatory" checkbox for 2FA.

I havea Custom role, not requiring 2FA, having both Global Permissions for SuiteAnalytic Connect and SuiteAnalytic Connect Read All. NetSuite2.com configured. When logged in or attempting access the Data Source, user keeps receiving the same error:

I tried to fiigure... but How do I move this to different functional area?

Did you create the rule while reconciling on a new file import? And your data file was in BAI2 format?

After spending sometime on python programming, the QIF-->CSV conversion does not control the Date format and that leaves us with extra step, to reformat the Date column as per CSV template and save it as .CSV UTF-8. But our controller has options, and she is moving ahead with BAI2. It is Manual either way for her.

Hi Mikko, At Shopify end, we have different web forms ("Contact Us forms" for sustomer support and Leads generation) including for returns or services. All inquiries go onto their corresponding Online Case forms (in Netsuite) which generate case(s) assigned to Customer Service/Support team. There are webforms allowing File…

Our controller prefers Manual Bank Data matching. The bank statement downloaded is always in different format, we have to reformat / transform to fit the CSV template, do you recommend a suiteapp for parsing? or a separate parser tool (written in python)?

@Robert Nedelkow-Oracle I tried that and it didnt work <td>${item.quantity-item.quantityfulfilled}</td> Error: For "-" right-hand operand: Expected a number, but this has evaluated to a hash+string (wrapper: com.netledger.templates.model.StringModel): ==> item.quantityfulfilled [in template "template" at line 165, column…

For Variance Accounting, should the component (Other Charge item) a WIP or a regular Quantity/Price Variance account?

Is this feature now supported in 2022.1 ? I have a sumission with attachment from shopify Web form, using the Case online form. The Online case external url form seems to submit with attachment sucessfully. But the submission coming from Shopify shows no attachment.

Thanks for the response. However, there are fields that really challenges me. 1. I got the date figured out: What used to be just <NLCURRENTDATE> is now a complex 3-step syntax: <#assign aDateTime = .now> <#assign aDate = aDateTime?date> ${aDate} 2. However, With the instruction for the sublist I follow the format to pull…

I found Free Marker does not support the join of records, or custom records at item level (I want to be able to bring up the columns fields for Related Asset, e.g.). Is this correct? it is too much to grasp (as it is new to me) for updating just a few templates. Is there a training Free Marker course specific to NetSuite?…

As of Release 2019.1 . Is custom field of Address record accessible from script or Web Services yet?

Yes, I had it. Actually the email was bounced, all went the integration user, who acted as a "Logged in User". I verified and found the User was not set up a dedicated Web Service user.

Downloaded new ODBC driver version 6. Uninstalled version 5.5. The new version was configured as User DSN; whereas the previous version was installed as System DSN. Is this what it was supposed to? After having the network guy to open port 1708 for me; telnet command keeps giving me "Connecting to…

I got thetelnet port opened. Testing the NetSuite ODBC driver 6.0 failed and threw me this msg (OpenAccess SDK:2310). [FONT=Times New Roman][DataDirect][ODBC OpenAccess SDK Driver][OpenAccess SDK Client]TCP/IP, connection reset by peer </span> --- I figured out what was missing: The "Encrypted" box needs to be checked.…

Yes, finally I got the ODBC set in, after re-configuring the Internet firewalls to allow the port 1706/tcp inbound from static wan ip and outbound from our network. It depends on how complicated your network config is. The simpler your network (such as latop connecting from home, with no firewall), the easier the setup.…

Have anyone done a "Retroactive" commission based on Qty sold? If the partner sells less than 10 last month, for example, we pay 25% (at 45days after payment received); if partner sold the 10th item in this month, all 11 items are eligible for 50% commission. What is the best approach for this structure?

Thanks for the ideas. That's true on the nvl / null Days Overdue. I tried the greater than or equal to and ended up getting customers with invoices that are more than 10-day overdue. This is not wanted. If I have equal to 10, the SS would miss out any invoices that are 11day or more overdue, only the 10-day invoices of the…

John, My SS still doesnot produce what's expected. This is more of a mixed-case scenario. How or if possible to do this union : customer A: 120-day overdue, multiple open invoices from the beginning ( <10day, =10 day, and >10day overdue) ; and customer B: 1 invoice, 10-day overdue but not customer C: w no 10-day overdue…

Exactly. thanks. So are you wanting to set this up so that you produce a list of invoices for any customer that has at least one invoice that is exactly 10 days overdue. So you can run this daily but only list customers on that 10th day?

Ahh... that was my can't think moment. You have it with filtering by customers. If I have to pull the SS by invoice, this should do the same, customers: days overdue=10 ? Let me try. Thanks. There is a field on customers "Days Overdue" that can be used for this. When setting up your saved search criteria on transactions…

I tried that and the logic seemed not working with If the condition is not met, then proceed to next condition. Thanks. Hi, I can quickly see that the structure of your CASE is wrong. After a ELSE xxx you must put END Good => ELSE 10 END WHEN ({... you (wrong) = > ELSE 10 WHEN ({ "the END is missing after your 10

I wish the same for that capability in the report. For RSS, I would start from the saved search, using the formula. You can not just sum the column_name, have to repeat the formulas of the two columns, as in Chris' comment.

it seems the MINIMUM in Results and Criteria does all the tricks. I tend to over-think or over-complicate to begin with.

Hi dsj - We want to implement this for every single customer, it can be overwhelming for over 1000 customers with multiple "FirstReceiptDate" each if using your suggestion. Any coming suggestion would be appreciated. THANKS. use expressions regarding the created date - (Blue striped-Uniform/Clothing, created on or after…

It's not a same fixed Date created for each Item/Item Option.

I am trying to LEFT JOIN 2 item saved searches. The result should have Items from 1st saved search (GL Inv by Location ) that have different qty/value or not present in 2nd saved search (items count by location). Is this possible?

From NS Support, can't do that yet for the 'location' at transaction and item level. We need your votes, for these are such important fields. :cool: