User_EPWHS Red Ribbon

Yes, using outsourced manufacturing.

Did you ever find the solution to this?

It's on the Custom Records subtab. See screenshots below.

The formula CASE WHEN ROUND(TO_DATE({today}, 'mm/dd/yyyy')-{trandate}) BETWEEN 0 AND 30 THEN 1 END does not work. I keep getting the error message, "Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit."

That fixed my problem. Thank you! Do you know how I can link the sales order and support case? I want to be able to see the support case on the sales order (specifically on the Support Cases subtab of the History tab and see the sales order # on the case record?

That fixed it! I was using Location not Inventory Location. Thank you!!!

That worked! However, there are many lines for each item and only one of the lines shows the next count date and count interval. Is there a way to only show the item once?

I don't have Item Location Configuration as a Saved Search option. Am I missing a permission?

If there are multiple POs then it should be set to yes. It could also be a free text field that lists the PO numbers.

I don't understand how I can get the field to display a value based on the purchase order status. Can you help me understand this?

Yes, or it can be blank if the PO status is approved/not pending approval. On the Order Items page, you can display fields from the item record. That's why I want the custom field on the item to be yes or no and store the value. I can put the custom field on the order items page as a filter then filter out the ones I don't…

If a purchase order is in the pending approval status, can the inventory item on the purchase order have a custom record that displays something (e.g., yes or PO #)? Is it possible that this custom field shows as an option to filter by on the Order Items page?

I don't understand the following: In step 1, I set on create as the event type but I don't see where you check Scheduled. I have the option to make it event based or scheduled. If I choose scheduled, I have to use a saved search. In step 2, I am not able to set the field value to count start date or count end date.

This worked! I have some questions: Is there a way this could be a report? What is the Applying Transaction : Buildable showing? Is there a way to show the task name and/or quantity that it's currently on? If the work order has a work order within in it, is there a way to show that work order information as well? For…

We tried a marketing campaign both ways (i.e., through an online form and campaign) but it didn't work. The online form gave an error saying needed an NLForm code, which we don't know how to do/fix. The campaign gave an error saying "Syntax error in template "content" in line 1, column 414:. Lexical error: encountered…

I put in a case earlier and showed NetSuite the issue. They just got back to me that it's fixed. I tested it and it works.

You can disregard this. It was a custom field.

Where would I put that? The PDF layout Custom Disclaimer Transaction, which is selected on the form?

Thank you. This unfortunately did not answer my question. I made separate Saved Searches but is there a way to join them together or can Analytics Workbooks have the data from multiple datasets in one Pivot table? Is there a formula that could do this? My other questions weren't answered either: While I can use the month…

I have a large number of memorized invoice and sales orders. I am looking to do the following AT ONCE to all memorized invoices and sales orders: On memorized invoices, add a markup line item and check the sales tax box. On memorized sales orders, change the item. Can I do this through a workflow or CSV Import?

A few questions: Is there not a way for the inventory of the raw material to show how many 16 ft bars we have in eaches for the base unit or the inventory of the assembly record to show how many parts we have instead of showing only in how many in inches? What if I use 2 of the 1.080" assemblies? Would the quantity on the…

Hi @Niks Blando-Oracle, Yes, that's correct. After testing, we edit the Item Receipt then check or uncheck the restock button. The ideal process would to receive the RMA without having to choose if it's restocked or written off until after testing or put it in a status that shows it's in the warehouse but is waiting on…

No, I am not referring to the ability to automatically record credit card processing fees on credit card sales transactions as an expense. I am looking for how to pass the processing fee through on the invoice when an invoice is paid with a credit card. Does anyone know how to automate this?

Thanks. I know how to set up BOMs, revision, routings, work orders, etc. My question is if I have to put in two work orders or if there's a different way I should be combining the parts to make an assembly and use that as the routing and work order.

Sorry, the base unit is in inches. If I do what you said for it to be in bars (Inch to Each 4' = 48 converstion), what would I put for the primary units, stock unit, primary purchase unit, sale unit, and consumption unit of the assembly that's 1.080"? The BOM (advanced BOM) allows us to choose the quantity and units - do…

I don't know about material loss right now. The Unit Type is Length (Imperial) with the stock and purchase units as 4' and sale and consumption unit as inches. When I look at the inventory of our raw material it shows quantity on hand 91.993125 and quantity on hand (base unit) 4,415.67. The inventory for the assembly shows…