Good Morning, I was able to get the formula to work on a sales order transaction search. I used a numeric formula and inserted... CASE WHEN {shipcountry}='United States' OR {shipcountry}='Canada' AND {shipstate} IS NULL THEN 0 ELSE 1 END Let me know if that helps. If not what is your saved search criteria?

Thank you I can bring this up with ACS but I figured more users may be dealing with this issue. We would like to have more options when it comes to what email is used within NetSuite and it seems limited. If you set up the email preferences to have a specific email per subsidiary you can only associate one. We have…

You can hide the rate and quantity fields on the bill form for specific users. I would ask though are you using any kind of three way match or workflow? If you use an approval process the bills can be reviewed and approved before they are paid. I would suggest the three way match rather than hiding the fields as it will…

It wont work for new records what you can do is duplicate your browser tab and then select create new if you want the original customer open.

You can see them under the related records on the sales order. If you want it on the line level of the sales order you will need scripting

You can only have one subsidiary assigned to a location it is a 1-1 relationship it is a limitation within NetSuite. There is an enhancement request you can vote on for this one as well #213239

To add the item fulfillment number on the line level of the invoice, this would require scripting.

Location to subsidiary is 1-1. If you want an item to be available to multiple subsidiaries you cannot have the preferred location or inventory location populated. You can multi-select subsidiaries or select the parent subsidiary and select include children. This will make the item available for all subsidiaries which is…

Suite approvals? I am unfamiliar with advanced approvals. Is the field the native approval status field? If you customize the form you can change the display type to open up the transaction and you will be able to see the field on the csv import.

Are you trying to send an email when the record you went to is saved? If so you may need a separate workflow on that record that sends an email after submission of the record.

When does your workflow run? Do you need it to be active on the transactions? If not then yes you just need to make sure the field is not disabled and then you can import the transaction with the status. If you need it to go into the approved state, you would need to make sure your workflow has a transition to accommodate…

You would need two other charge items that have the different costs and assign them to the bill of materials.

Yes I want to compare $ Shipped to the daily shipping goal or $ Manufactured to the Daily Goal If I add a date field wouldn't i need a record for every day or can the date field just be {today}

Absolutely!!!

Expense Limit - would need to be set up for expense reports but not purchase requests. The below fields should be reviewed when setting up standard approval of purchase requests. Purchase Limit should be completed to determine the amount an employee is allowed to enter without requiring approval. If it is none, then a 0…

Here's what we would like for emails.... User sends an email from NetSuite = user email (from) Invoices, Credit Memos, Refunds, Statements, Dunning Letters sent by the system = accounting email per subsidiary Sales Orders, RMA, and Quotes sent by the system = customer service email per subsidiary. For the billing schedule…

No we get errors on the billing schedule if we don’t have the send email selected on the customer. But when we select it on the customer it sends the sales order too. Some orders we want to send the sales order other subsidiaries we do not. Because we import our sales orders the email that sends the transaction is not who…

I want it to do that when in the print checks and forms page.

That does not work with print forms

Answer A

Answer A

Answer B

Custom fields

Bill capture

That’s not what I am looking for

I am utilizing the suite app bundle

@Richard James Uri-Oracle We are using the manufacturing traveler suite app which does use a script and files that contains css.

You can also create a custom field that is set when the user approves the bill. This way the final approver is always stored on the transaction record.

You need an approval workflow in place if you do not have one already. What is your default sales order status set as? Typically you create an approval workflow and then change the default status to pending approval.

The problem is they do not show on the close work orders screen until they are marked as built which you can do manually