Unfortunately you cannot convert so the Rename, Recreate is your option. Difference between Other Charge and Non-Inventory is (for the most part) is that you can mark a Non-Inventory item as a drop ship and can also specify a Drop Ship expense. If you do NOT want to fulfill either of those types, under preferences uncheck…

My guess is there is an assumption that you have staff on a Friday to deal with issues but not on a Saturday or Sunday. Not saying it is right, just a guess as to why on a Friday morning.

I assume you are not on 2019.2? This is what I believe you are looking for: Additional Filter and Sort Options for SuiteAnalytics Workbook Pivot Tables and Charts Prior to 19.2, workbook pivot tables and charts had limited filtering options. For example, you could apply measure-based and value-based filters to pivot…

@"PaulFleetwood" Yes, I figured the account out to point to our Inventory account. Also changed the quantity to be a formula nvl({quantity}, 0) not equal to 0 I also noticed the sorting quirk. When run in a subtab and the item has a lot of transactions it is a little cumbersome so I just made the Item filter be visible and…

@"michoel" - love this but having an issue. In criteria, it shows: "Account is" but no value. I am trying to do the same and get an error. Also, for item fulfillments, I am getting the 3 lines for each item (how NetSuite stores the data) and am assuming it is because I don't have the account criteria? Suggestions?

Agreed. I just wish there was a way to get to the Suite Answers page without login. I have a link to the main page to I could get to the contact support but since it prompted for a login, there was no way to be able to report the problem.

One thing, if a Credit Memo/Cash Sale/Invoice were created from another transaction (usually Sales Order) then they do not impact inventory. They only do if "Stand Alone". You "might" want to have search use Posting=True and Account=your inventory asset account(s)

Things you can try. First, since it is a Matrix Option list, it is probably referenced by a custom item field. When viewing the custom item fields, you should see a column List (next to type). Once you find the field, edit it and under actions you should have Check Delete Dependencies.

Well, that is a bit of complication. We did our purchase orders as Special Orders for each sale. We also had a sales order script that filled in the PO Rate field using the same custom record (looked at Customer on SO, Item on line and Vendor in PO Vendor field) which set the rate. So in our case, yes we had full…

Olivier gave me the same advice a few years back for one of my customers. We had a custom record with Vendor, Item and Customer. All fields were listed as Parent Fields. As a result we could have: 1) a sublist tab on the Vendor of all the contracted pricing for everything we purchased from them 2) A sublist tab on the item…

Chris, Can you somehow get the user you want to send to in the results along with their valid locations? I "think" if you did "Recipients from Results" it just "might" work. You would then remove the location from the Criteria and it will only send to the user in the result line. I obviously do not know your setup but it…

If you edit the search and select Save and Email, do you then get the email? 

I currently do not but know of a former customer who might. Is there a SuiteApp link or website?

Martha, Take a look at the Inventory Activity Detail report. It shows all the Ins and Outs by item/location. It give the results as rows. Did you want a single line by item/location? If yes, then an item search where you could Group by item/location and then do a summarize of these 2 columns (Formula numeric summed)…

I was hoping that it would have indicated a different issue. Sorry.

Try this (if not already set) On the main "set up reminders" page in the very bottom left, check the box for "Show reminders with zero results" When you are on the reminders page, you probably now see zero. Click the zero to run the search from the reminders. Does it show any results?

Just in case you are not comfortable with scripting, 2019.2 has new Sublist actions including "Set Field Display Type"

When customizing the Task form, the "Store form with record" is Unchecked by default. If you check that box, the Custom form you save with the Task should stay. 

I know it has been a while since your post: After finding that NetSuite calls it Absolute Pricing, I did a search here in the forums (I love the fact we can get legitimate search results!) I found a post that mentioned a Customer Search and instead of referencing a Join or Sublist, to use the field Pricing Item <> *None in…

After finding that NetSuite calls it Absolute Pricing, I did a search here in the forums (I love the fact we can get legitimate search results!) I found a post that mentioned a Customer Search and instead of referencing a Join or Sublist, to use the field Pricing Item <> *None in the criteria. That got me to the customers.…

Mike, Hurricane not an issue as I work remote in sunny Phoenix, AZ. From what I know there was flooding inland up to 20 miles (which shouldn't reach me As for the WMS, it actually creates an Inventory Transfer in NetSuite so you could use the same transaction. We have a custom field (type LIST) for the reason codes that is…

No worries on the 20 questions... Throughout the month both the warehouse as well as customer service move items to the damaged/obsolete warehouse. Warehouse - if they find product broken/damaged they just use the WMS to move which requires a reason code and requires manager approval to move up to NetSuite. Customer…

We do similar. We have an Obsolete/Damaged Location. Throughout the month we "move" damaged product into that warehouse as well as any obsolete. At month end accounting does an inventory adjustment to our Obsolete/Damaged Inventory GL adjustment account.

Well, Because when fulfilling Kits, you are not selecting the individual components on the fulfillment. Not to be to harsh, but if someone is not reading the picking ticket and just clicking fulfilled, No system in the world would know if someone short shipped a component of a kit. 2 jobs ago I had warehouse folks who…

Well, 2 things. 1) Any transaction that used the form when the Store Form with Record was checked, will retain that even though you have now unchecked the box (I know because that recently drove me CRAZY...) 2) If you only want them to use the "preferred" form from their role, I would also check the Restrict box to they…

Not seeing Inventory Location specified in results. But since your message says Location on hand being incorrect, I would think you want to use {locationquantityonhand} in your formula and Location Available (sixth line of results)

I had exact same issue at a prior place where we had to do SmartPost outside of NetSuite. We did it with a few components First was a custom field (Checkbox) on the transaction "Bulk Mark Shipped" on the fulfillment record Second was a workflow on Item Fulfillments records On Update (not create) and if I recall the trigger…

You could create a custom field (type Currency) and then create a workflow that whenever the record is updated, you would set the custom field to the value of Shippingcost. That would log in the system notes only when the value is changed.

Interesting. I didn't think I had the module that had Contracts. Thanks John

Unfortunately there is no way to remove the fields when the custom field is part of a locked bundle. I complained about that 6 years ago as that does not modify how a field functions, on that it should default into a saved search live. We have 3 bundles that are locked that all have that checkbox checked on their custom…