Hello, Thank you for the response, but I need the conditional based on whether a tracking number is availeble, will this do that? Thank you

Thank you for the response. Because this was installed via a NetSuite bundle, I cannot edit the work flow. I find it odd that the help wording installed via the bundle references being able to change the approver, but it doesn't work.

Hello Here you go Remove the button above if the transaction is not pending fulfillment. This is the error you get when you try to print a pick ticket on a transaction that is already fulfilled. I'd like to either prevent this error make it more descript (have it say something like "Cannot print pick ticket because order…

This account has a balance

ok, but if thats the case where is the other side of the vrma bill credit hitting? Per the screen shot below the system is crediting purchases returned not credited, what debits that account?(11520)

I like to further clarify the following: What if the Purchase Order has multiple item lines but Item A only has multiple Item Receipts, Items B and C each have only one separate Item Receipt, should this be part of the report? Yes it should. The report should return any po that has an item line with multiple receipts What…

hi although that provides a similar solution I really need it to work for a saved search as it’s part of the item record sub tab. How do we make it count the months in the date range and divide by that?

Here you go. I believe the issue to be the /12 when calculating the monthly average. If the date range is less than 12 months, that calculation is not accurate. Filtered by date sales usages from 1/1/23 to 4/30/23 monthly usage on the highlighted line should be calculated by dividing the usage of 8 by 4 months (approx) to…

Hello, Below are the requested screen shots.

the supply type should be PO unless there is available inventory in the warehouse. I have adjusted the transfer rules and now I'm getting transfer requests for every item that has demand and not enough stock at the main location. That is now causing PO requests for items to be shipping to the warehouse.. To reiterate I…

Hi they are setup for the locations in question but suggested transfer orders from the warehouse to production are not being created (our outside services are)

Thank you for the info. I do have the notification email sending already. I'm asking how to refer to all the document numbers that are attached in the body of the email.

any luck with this request?

Its an external one, I'd need a link or a form that passed the data into NS.

I have reviewed that suggestion. I'm not sure if I can make that work for a specific XML field. REGEXP_SUBSTR will look at a string of data. I can pass an argument that says for example, look for "scac" and return the data after that but before the next < character. I cannot get that to work in a saved search formula how…

Hi Again, For example, ar is mapped to a certain gl account expenses are spread out to different accounts like electricity, overhead, ect. In our legacy system, it was simple to see all of those assignments in a complete list. Screenshot below. I want to do the same in NS so I can give it to my auditors to ensure that all…

We have several custom roles that would be modified to remove the button, they are all templated from the support center role.

Thank you for the suggestion. It works but when entering the customer on the sales order form the location gets blanked out. Any ideas?

So there is no way to prevent someone from emailing a purchase order if it is in the pending approval state?

We are using advanced forms for most things.

I don't have a screen shot per say. I'm really looking for what makes up item cost. In our case as a manufacturer that is the components of the bom and routings plus the overhead rate. That is then averaged with what is in current inventory. I'm looking for a costed bom in a way. Does that make sense?

I adjusted it slightly as those criteria are returning any work order rather than work orders in completed status. Your suggestion definitely worked. Thank you very much for your help!

I see it now, so on the custom record creation I would add the formula to the default & validation tab. My next question is how to I differentiate the field name for the main line(amount paid) and the item line level (amount) ?

Hi Mikko, Thank you for the response, that sounds like good news, can you tell me how to do that?

would I need a script to populate the custom field or can that be done right in the saved search?

I was thinking I could flag the individual items but wouldn't that be the same result? If the searched has to pull the main line information to get the total paid will added information on the item level do me any good?

Thank you both for the fast reply. I am closer; one more piece I didn't share. We have item categories in NetSuite. A custom field is used to identify the item grouping on the item record page. We only pay commission on items in specific categories. I can pull that over and see the item categories, but the amount paid goes…