Angela Bayliss · Senior Solution Architect · Silver Crown

I mathed wrong Use {amountpaid}+{amount}

Question - Do you have a preferred location set on the item? If so, does that location use bins? Setting a preferred location on items messes with a lot of other item features.

Ugh. Creating a project from an estimate is a Native NetSuite process. Look on the estimate for a project link. If there is a project link - that project is what processed your quote. It's weird, counter intuitive, and Native NetSuite. We call it a 'NetSuiteism' which basically means that it makes no sense, but that's how…

An Estimate can be 'processed' without a sales order if a project is created from the estimate. You should see this under related records.

As far as having an issue with the internal ID, you shouldn't have any issues with the internal id map if you don't include the item internal id in your search.

Here's what I do when I have to map to these records: Create a search type = Item Location Configuration type, In the results, include the Item, the Item Location Configuration internal ID, and the Default Cost fields. Do a vlookup to pull the default cost into this exported search. Voila- now you can import the 'default…

Item Location Configuration is a subrecord of the items, and will have it's own internal id. Any information you want to update on the Location will be a different import - not items, but the item location configuration import.

Setting the field as 'email' to create the workflow and then setting it back to free form or long text is EXACTLY the solution! Very well done, @User_CTPVH

THe difference is Canada. Any vendor bill for Canada may require you to populate the tax code for use taxes. The US doesn't do this. Vendor Country=Canada - Tax Code Required Vendor Country = US - No tax code required. Is the company using Avalara?

Hello try changing your formula to {amountpaid}-{amount}

You will have to: Mark any accounts in your COA as reportable. IE- Outside Consulting. (this step is critical to prevent reporting on reimbursements, but still report against non employee income) Mark your 1099 reportable vendors (Note that you cannot hide SSN's from users if you fill out the tax id of the vendor) Install…

For your users, the Permission of 'Export Lists' must be enabled to email any searches. You can check if this is the missing permission by looking at the search results to see if the export options are available. If these icons are not visible for your users, they need the 'Export Lists' permission. I'm still a little…

If you're using the standard administrator role, you should see the email option on saved searches. In your screenshot, the email option is seen. How did you create the screenshot if you can't see the email tab in the admin role? Was that from your demo account? What type of search are you not seeing the email tab as an…

Hello, If you are setting the field on the sales order, it should flow through to the invoice, if you create the invoice from the SO. How are you creating invoices? Billing Operations? Invoice Sales Order screen? What steps do you follow?

The comment above shows you exactly how to customize your BS financial report. You should be good to go!

You will need to import trial balances for each subsidiary. In the trial balances, you will need to include the due to/due from accounts, just like they appear in the trial balances. You cannot use advanced intercompany journals to import your historical balances, and you won't be able to 'eliminate' the intercompany…

Is the user able to email from NetSuite otherwise? From a transaction for example?

In that case, you will need to create the invoice from the item fulfillment record, not from the Sales Order. Natively, NetSuite provides 'Invoice Sales Order' functions, that create invoices from the sales orders. To source the value from the item fulfillment, the invoices must be created from the 'Bill' button on the…

This is your issue: All the Vendor Bank Detail records in the system has the Subsidiary field left blank since they will be used for multiple subsidaries. You need to apply the subsidiary to the bank details on the vendor records. If a vendor will be paid by multiple subsidiaries, you need the banking information listed…

It is absolutely possible to customize balance sheet reports. Your screenshot shows 1 type of fixed asset - What are you trying to do?

Have the user clear their browsing cache. THis sounds like a typical example of what can happen if the user never clears their cache.

I don't believe that you can change or update the numbering for Inbound Shipments. They are assigned integer numbers, beginning with the #1. They are not editable at this time.

I am aware that once it has a gl impact, it can't be edited. We aren't using the 'pending approval' status since the status cannot be edited even by an admin. I think the only way to use this status is to configure the approval rules. Thanks for your help.

Step 1 - Update the asset to Depreciation Active = No, Include in Reports = No Step 2 - Reclass the depreciation amount for this asset from the monthly depreciation Step 3 - Set the Asset to 'Inactive' Step 4 - Create another JE removing the asset value from the FA Account and expense it to where it should go. This is the…

THe shipping cost on the invoices comes from the shipping cost set on the Sales Order. I assume that you're using integrated shipping with either fedex or UPS. Since the cost is calculated on the SO, based upon item weights and the ship from location and the ship to location, it should be accurate. You can set it to…

C

In our case, even an admin has the field inline. Hence the issue.

How did you resolve it?

Setup>Company>Billing Information. On the top left, you'll see the product you have, the anniversary date, and the Tier. Someone from NetSuite can chime in on the different tiers, but they go up to 5. Someone with Tier 5 has 5 different operating queues, allowing for large numbers of different processes to be running at…

I guess I just don't follow. I'm not understanding the need. If you assign the item a new class, you can easily add that filter into the AR Aging (item fields>class). Anyway - good luck!