https://community.oracle.com/netsuite/english/discussion/comment/16878771#Comment_16878771 Because this is a custom record instead of just a custom list field, whoever has access to set the field will also have access to add new values - a custom record is a layer onto your transactions - instead of just a custom list…

https://community.oracle.com/netsuite/english/discussion/comment/16878759#Comment_16878759 Use the location defined on the sales order. You absolutely do not need to create locations for your drop ship vendors. Hope this helps!

What a terrible limitation. Egads! https://community.oracle.com/netsuite/english/discussion/comment/16878722#Comment_16878722

Ownership transfers are not scriptable. Nor can you change the currency conversion rate. Enhancement #662573: Multi-Currency Customers/Vendor > Ability to Use the Currency Exchange Rate of Transaction Date in Ownership Transfer. Sorry it's not the answer you want.

If I'm understanding correctly, the full 11,000 search results are not sending with the email alert. 11k lines should not exceed the 25MB size limit. To help you troubleshoot this, can you please provide a screenshot of the results of your search, and another screenshot of the 'customize message' tab of the email tab?…

The error you're encountering occurs when you edit the item group. The item group on the invoice should have: Line for Item Group Name - with no costs Line for each member of the item group - with associated pricing Summary line for group, with total pricing. If you are not editing these lines, can you please provide us…

https://community.oracle.com/netsuite/english/discussion/comment/16878697#Comment_16878697 IS this before or after you edited it? Is it still throwing an error?

Wait - https://community.oracle.com/netsuite/english/discussion/comment/16878705#Comment_16878705 Perhaps I was confused previously. The drop ship function allows for a single step when you click 'mark shipped' - meaning you don't have to receive the item and then fulfill the order. You DO have to fulfill the order with…

https://community.oracle.com/netsuite/english/discussion/comment/16878716#Comment_16878716 AWESOME!!! Well done! Also good to know.

https://community.oracle.com/netsuite/english/discussion/comment/16878702#Comment_16878702 A saved search might give you this - if it's a transaction type. The search would be incredibly complex with some formula's, etc. I created one several years ago, and it took some doing. The only other possibility you might try is…

https://community.oracle.com/netsuite/english/discussion/comment/16878715#Comment_16878715 Are you testing this personally? Do you have 'global permissions' on your employee record? If not, then https://us.v-cdn.net/6032262/uploads/32ARQ04TFEGC/netsuite-basics-browser-best-practices-11-11-23.pdf the only thing I can think…

If I am understanding you correctly, you have assigned an administrator role to your vendor record. Is that correct? A long time ago - and I mean before NetSuite went public - so around 2006 , we (consultants) would do this with the vendor record to save licenses for clients. However, we learned that there are restrictions…

https://community.oracle.com/netsuite/english/discussion/comment/16878607#Comment_16878607 You are directly contradicting yourself. Forms are metadata. In your first sentence: Chelsea is correct, the Custom Form field cannot be directly added as a column in a saved search in NetSuite. This limitation is due to the fact…

https://community.oracle.com/netsuite/english/discussion/comment/16878684#Comment_16878684 A custom form is not something that can be returned in a saved search, as far as I know. Forms are ways to display data, and can either be stored with the records or relative to the user looking at the record. You won't be successful…

Thank you for the screenshots, they provide me exactly what I needed to help you. OK, you're using the custom record as a list, not as the native functionality of a custom sub record. Meaning that you have a custom field on your CRM forms that is sourcing a value from the custom record - This is VERY different that using a…

BN, The existing transactions will not change in any way. All reconciliations will stay the same, all transactions and closed periods will still apply. I think you may be mistaking moving the hierarchy of subsidiaries around with the creation of a new subsidiary. Moving subsidiaries around within the heirarchy is a very…

https://community.oracle.com/netsuite/english/discussion/comment/16878683#Comment_16878683 In that case, edit the purchase order access to create. The expense reports permissions are the same, so people can create and approve the expense reports only. Voila

The best way I know how to do this is to create an inventory numbers search. (If you're using advanced location configuration). Create a new inventory numbers search: Add results of: Item, Lot/Serial Number, quantity and location. (you can add bin if it helps). This will give you the on hand inventory by lot and by serial…

OK, I have fully tested this: I edited the employee center role, and removed the permissions for the records pending approval. I created several purchase orders that are pending approval. I can see these records in the Suiteapprovals portlet on my admin dashboard When I log into the employee center and look at the…

As far as side affects, there shouldn't be any negative affects to updating the accounts to Parent subsidiary, include children. When you perform this import to update the accounts, the accounts will be visible and usable for all of your subsidiaries. The ONLY negative possibility is that people can accidently post…

https://community.oracle.com/netsuite/english/discussion/comment/16878537#Comment_16878537 When you add the new subsidiary, you can update the accounts within your COA via CSV - I would recommend that you update the accounts to be 'Parent Subsidiary' with 'Include Children' checked. This way any new subsidiary you might…

Items can be on hand but committed to a sale or work order. If an item is committed, it is on hand, but not available. When running the inventory valuation for older dates, often the items show up but are not available. (It could be in an order in packed status) Hope this helps!

If your items are set up as dropship, when they are added to a sales order, the dropship po will be created, and you can mark the PO as 'shipped - which will also fulfill the SO. If you used a regular PO instead of a dropship PO, then you'll need to receive/fulfill the dropship, treating it as if it's a special order. Make…

The simple way to update a vendor form is to run an import, and set the form you want to use as the import form. Run an update - don't actually change anything, and when the import is finished, all vendors will use the form you set. All other forms will no longer be in use, and can be inactivated as needed. Hope this helps!

https://community.oracle.com/netsuite/english/discussion/comment/16878594#Comment_16878594 Is there some requirement to make these comments? I get notifications and there is no value to the notifications if you're repeating the exact request I made.

https://community.oracle.com/netsuite/english/discussion/comment/16878591#Comment_16878591 What role is the vendor login using?

I would ask why you want to restrict adding this portlet? Are employee center users not actually approving transactions via the employee center? If people are not approving via the employee center, you can remove their permissions to approve transactions - which would prevent them from adding the portlet.

If you're looking to present an AR aging report in SuiteAnalytics, what are you looking to capture that isn't already present on the standard AR Aging report?

When someone uses one of the expense items (set up as inventory)- you will need to use an inventory adjustment to relieve the quantity of the inventory items. If it's being used by the warehouse team, often the offsetting account for the adjustment will be either a COGS or an expense account. (Confirm with your accounting…

In that case, I believe that you have an issue with your csv import. I suggest you file a case with NetSuite support - because something may be snarky within your account.