My Stuff
Comments
-
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.
-
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 number of Assets a company has will never impact the number of Transaction Lines within 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.
-
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 answers your question.
-
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!
-
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. Otherwise, this sort of makes the entire process unusable.
-
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…
-
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…
-
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 just a system limitation - but if enough people vote for it - it'll get fixed.
-
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 field - which could be restricted. If you remove the 'UI Access' you may interfere with the…
-
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!
-
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…
-
IS this before or after you edited it? Is it still throwing an error?
-
Wait - 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 the information provided by the vendor. So what you are describing is native NetSuite…
-
AWESOME!!! Well done! Also good to know.
-
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 the Physical Inventory Worksheet. Customize it to not show zero's, add in the lot/serial…
-
Are you testing this personally? Do you have 'global permissions' on your employee record? If not, then the only thing I can think of is - have you cleared your cache lately? If not, I'm attaching a document for your review. When personally testing, I clear my cache a couple times a day - because NetSuite and browser cache…
-
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…
-
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 that the Custom Form field is metadata and is not treated as a regular, searchable field. Then…
-
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 adding the form to a saved search. I know it's not the answer you want, but it is the…
-
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…
-
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