Angela Bayliss · Senior Solution Architect · SuiteMaster

In Transit inventory is very different than drop ship inventory. Drop ship inventory is never owned in NetSuite - the value of the asset is not captured by design.

https://community.oracle.com/netsuite/english/discussion/comment/16878842#Comment_16878842 OK- Custom Record lines do NOT apply to the Monthly Transaction Lines. One example of a custom record within NetSuite is a Fixed Asset Record. You can have hundreds of thousands of Fixed Assets within the Fixed Asset Module. The…

OK, you have 'view record link' checked, please try making these changes: Send as CSV = true Send as Microsoft excel = false Include View Record Link = False Once you make those changes, please test and let me know the results? 11,000 lines with a single line as column names should be included.

https://community.oracle.com/netsuite/english/discussion/comment/16878772#Comment_16878772 When you create any customer deposits, they will all be impacting the system generated Customer Deposit account. You cannot 'specify' any other account - although you do need to specify the bank/undeposited funds account. I hope this…

https://community.oracle.com/netsuite/english/discussion/comment/16878736#Comment_16878736 Hi BN, Note that you won't be able to share Bank/Credit card accounts in the COA and locations. Both of these are subsidiary specific. Otherwise, you should be successful. Glad I could help!

https://community.oracle.com/netsuite/english/discussion/comment/16878784#Comment_16878784 Sadly, the date of the ownership transfer is driven by the dates of the inbound shipment. You could try testing - update the date on the inbound shipment prior to the ownership transfer, and see if the date is captured correctly.…

I agree with Chelsea - the only way to achieve this is with scripting and/or a workflow. This is not something NetSuite will support natively.

It's hard to guess based on the information you have provided, and here's why: Discounts can be applied to the entire transaction Discounts can be added as a single line item Discounts can be applied to a summary group of items, on the line level. Line level discounts are found when main line = FALSE Transactional…

There are a lot of things that could be driving this, it is very difficult to guess. If you could provide screenshots of your import file and the import map - we can help you faster.

While this is possible, it's a complex solution. You would need to write scripts to read the csv file to automatically load it. Importing the CSV file should be using an import template - which means that the import process should be 4 clicks in the UI - so the cost of engaging a scripted solution may not be cost…

https://community.oracle.com/netsuite/english/discussion/comment/16878799#Comment_16878799 If you provide the screenshots - this is doable. Just fyi 😉

You are fulfilling a sales order, with zero GL Impact. So the customer doesn't own the inventory, the inventory is never on hand at any location. Not as an asset on the books nor as 'customer owned'. I'm not sure where you're getting that idea. Whichever location is listed on the sales order will be the location on the…

https://community.oracle.com/netsuite/english/discussion/comment/16878809#Comment_16878809 This is the entire purpose of 'enhancement requests'. Often, these types of bugs and limitations are lumped together as 'enhancements' until enough people vote for them. In my humble opinion, this kicks rocks. This is clearly not…

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