Angela Bayliss · Senior Solution Architect · Gold Crown

https://community.oracle.com/netsuite/english/discussion/comment/16879201#Comment_16879201 You will need to: Delete all reconciliations that were created using the match bank data screen. To do this> Transactions>Banking>Reconcile account statement>List - and delete each recon for the account. Once all reconciliations are…

https://community.oracle.com/netsuite/english/discussion/comment/16879285#Comment_16879285 Whether the Oracle employees here agree with you or not, you're asking for their judgement, and they aren't able to provide that. Please understand that this user group is for users to ask for help - or clarify things they don't…

Hi Katie, Note that your system is heavily scripted, meaning that the processing times will be affected significantly. When you moved from scheduled scripts to scripts that run all the time, this will impact the processing time of your system - for everything. Your script activity bogs down the system.

https://community.oracle.com/netsuite/english/discussion/4502287/possible-divide-by-zero-error-one-user-only Hi Katie! Have you tried clearing your cache> It sounds dumb, but that's the only thing I can think of as to why 2 different admins are getting different results for the same search. Note that you don't have to…

Workflows don't recognize data in fields that do not store value. If payments are applied as customer deposits, the solution could be simple. Once the customer deposit is made against the SO for the full SO amount, a checkbox can be added to the SO of 'SO paid'. With that field, once it's checked, you can source this onto…

The issue that you're having is that the projects are a type of entity - and you cannot source transactional information onto an entity record natively. Your only option in this case is to script it, or have the user follow the process of populating the values on your project. Sorry it's not the answer you want.

When you run the search, there are more results. WHat happens when you email the search (email it to yourself) directly from the search results? Also, please check 'run unrestricted' on the results tab. My suspicion is that some of your users may be restricted from seeing all of the results for some reason. This is easy to…

https://community.oracle.com/netsuite/english/discussion/comment/16879027#Comment_16879027 If you clear your cache, you will see that it does, in fact, move. :)

https://community.oracle.com/netsuite/english/discussion/comment/16879019#Comment_16879019 The amount of time in this task is due to the system connecting to the exterior shipping system, communicating with it, and getting back to your system. One way you can check is to click on the NetSuite logo in the upper left of your…

https://community.oracle.com/netsuite/english/discussion/4502186/ns-1099-misc-boxes-have-been-wrong-since-2021 The boxes are the boxes, and you can now add custom entries into the 1099 List. Marking the account and the vendor has ALWAYS been required. Otherwise, how can you tell the difference when you reimburse a 1099…

C

https://community.oracle.com/netsuite/english/discussion/comment/16878870#Comment_16878870 You should be able to pull the discount item and rate into your searches, since it clearly applies to the entire transaction. The field names are Discount Item and Discount Rate.

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?…