Most probably, this is a permission issue. If the search is built by someone with an Admin role, all users will be included.

I understand that part. Where do you see the difference? Is it on a Transaction, a Saved Search, or somewhere else? Some rates are auto-populated and then manually updated; others might be displayed differently in Saved Searches, depending on the criteria, etc.

Hey @Nickoletta Gounaris, Could you clarify what you mean by "depending on which entity we look at"? I am unclear if you see different rates on transactions, Saved Searches, Financial Reports, or elsewhere. Note that you can update the Consolidated Exchange Rates used for consolidation if required.

Hey @BM136, What role are you using to create the Saved Search?

There is no specific guidance on this, as this would be a custom solution. Avalara doesn't natively support what you are aiming to achieve.

I understand what you mean. If you are using Use Codes, you can create a script or a workflow to add the "Parent Customer's Use Code" to transactions related to the Unit (Custom Record) so it runs through Avalara and exempts it accordingly. It will be harder to do if you are using Exemption Certificates.

Thanks for the additional information. Questions: I don't see the "Contract End Date" on the screenshot. Does it match the "Contract End Date" of the Contract Item? What is the "Target Renewal Date" and "Status" of the contract from the screenshot? Can you check the "Execution Logs" for the R05 script after you run it and…

Avalara has several ways of processing the exemptions. Do you use Avalara Use Codes or Exemption Certificates? One way to find that out is to open the Customer record and check the Address tab. If you have a Use Code there (e.g., "C"), then you are using those. If you are using the "Exemption Certificates", you should…

Hey @Wee Ming, Yes - your understanding of the setup is correct.

No - the number of columns in standard NetSuite Trend Graphs cannot be adjusted. If you need more columns, you need to build a custom SuiteLet or display the Chart in iFrame (sourced from another database to a custom portlet).

Per my above comment, you can update the value of a custom Item field via Scheduled Workflow. To do that, you need two custom fields: one non-stored field showing the results of a Saved Search (aka, the limitation) and another stored field that will be updated via scheduled workflow ("set field value" of the stored field…

Hey @User_K51C7, Depending on your setup, the "Document Number" column may show the Check # if the Vendor Bill was paid via Check. Can you check if that's the case for you?

Hey @Karanjot Singh, I assume you refer only to "Closed Won" Opportunities, not any Opportunities. Do you create Sales Orders only from Opportunities? Or do you sometimes create Standalone Sales Orders or Quotes/Estimates?

Hey @User_2LD8N, Do you use Avalara Use Codes or Exemption Certificates?

Would you be able to send a screenshot of the Contract record that also shows Contract Lines and related statuses? Also, can you send a screenshot of the "Options & Log" subtab of the related Sales Order? What happens when you run the R05 for a contract that doesn't have the button? If it renews, you can always delete the…

Hey @Sue Carstens, I have seen this happen for several reasons. Contract Renewal scripts hide the "Renew Now" button when no Contact Items on the Contract record are eligible for renewal. The most common reason is the hidden "Renewals Exclusion" sublist field on the related Sales Order Custom Form. Because of that, the…

Hey @User_JN952, Would Electronic Remittances work for you? One of my customers has FISPAN for JP Morgan, and it has Electronic Remittance functionality: You can check with them if they can do the same for TD Bank. If you want to print a Payment Remittance PDF, that would require customization.

A few more questions. Do you need to send invoices to Customer A, Customer B, etc? Or, can the invoice be generated for Generic Customer 1, which comprises Customer A, Customer B, etc? From a GAAP perspective, do you need the Revenue to be attributed to Customer A, Customer B, etc.? Or can we have accurate financials and a…

Option 1 would require selecting an Invoice rather than checking a box. Because any Vendor/PO can relate to any Customer/Invoice, it will be difficult to build logic to link them automatically. Alternatively, your team can select the related PO when they are creating the Advance Invoice. That would also establish the link…

Hey @Johnny Cash, The "Enter Completions" page is functional. It only works if the Assembly you are building doesn't require "Inventory Details" to be populated, such as Bins, Lot Numbering, Serialized Inventory, etc. This makes the "Enter Completions" page significantly less useful. The workaround is to build a script…

There are multiple ways this can be addressed. Here are some of the options: Option 1: Create a custom "Related Advance Invoice" field on the PO. Select the related advance invoice on the PO. Create a Saved Search to send an alert every time the PO becomes "Fully Billed", showing the "Total Billed" vs. "Total Invoiced".…

Thanks for the answers. Do you invoice the customer the differential only when the related Purchase Order is "Fully Billed"?

Thanks for the answers. Natively, you can do this in NetSuite only if you create an individual Project for each Entity. Even with that, you may need to create additional projects when extra funding is provided. I am familiar with all leading ERPs and don't think any of them can do this out of the box. The beauty of…

Hey @User_8AEA1, I have a few questions: Can the total funding amount change after creating the project? Can the number of funders change after creating the project? Can the funding contribution ratio change per entity after creating the project? How do you recognize Project Revenue (i.e., Milestone, % Complete, etc.)?…

Hey @User_WI6QA, Could you provide an actual example of the issue? If you want to control field behavior (e.g., making specific fields non-editable for a specific custom role), you can do that via Workflow.

Hey @HC22, NetSuite sets a pre-defined amount of columns to display in Trend Graphs. When the setting is "Weeks", it displays 14 columns. When the setting is "Monthly" or "Yearly", it displays 13 columns. The column numbers are the same if you build charts via Analytics Workbook.

Hey @Lisa Mosrie, I have several questions: Do you use drop-ship Purchase Orders? Is the differential you are invoicing equal to "Bill Amount - Advance Invoice Amount," or do you also add a markup? Does "Advance Invoicing" apply to every customer or only specific customer types? Does "Advance Invoicing" apply to every…

Hey @Iain Cruden, NetSuite Reminders Portlet only supports "Summary Type = Count" Saved Searches. You have to either make the Saved Search non-summary or choose the "Summary Type = Count".

Hey @Hans de Molenaar, What is the base/reporting currency of the new/merged subsidiary?

Correct, NetSuite doesn't have a feature to apply bundle functionality to a custom record.