Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

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: https://support.fispan.com/jpmorgan/remittance-advice-netsuite You can check with them if they can do the same for TD Bank. If you want to print a Payment Remittance PDF,…

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.

Multiple variables affect the GL impact, including how you process the transactions (e.g., do you have a WO Issue or use WO Completion with Backflush), Item configuration, Routings, Cost Templates, etc. Typically, issuing components debits the WIP, and completing the assembly credits the WIP. The WO Close will make the…

Hey @User_DFQMH, When we create Work Orders with Routings, we "activate" the Work In Process (WIP) accounting. Routings can have multiple steps, and each Manufacturing Operation Task may have a unique GL impact. In this case, the manufacturing process is multi-step. Between various steps, the Item Costs and other things…

I mistyped and meant to say Allocations. I resolved similar issues for Allocations, Amortization Schedules, Revenue Recognition Journals and more. Most of those journals contain the "Entity" or other relevant information only in the memo section, which is not optimal. I built customizations with my team to add the required…