Angela Bayliss · Senior Solution Architect · SuiteMaster

https://community.oracle.com/netsuite/english/discussion/comment/16881909#Comment_16881909 If I'm understanding you correctly, you have FA that are in the subsidiary you are merging from, and you'd like to bring those into the correct Subsidiary. Is that right?

A

https://community.oracle.com/netsuite/english/discussion/comment/16881564#Comment_16881564 You will need to open the periods back to december in order to load these. HOWEVER - You do not have to 'open' any of the subtasks of the period close. You only need to update the period from Closed/Locked to Unlocked. When doing…

You cannot apply bank fees (which are immediate posting, not rev rec eligible) with items that do trigger revenue recognition. As you found, this isn't possible. You cannot apply bank fees when accepting customer payments, unless they are captured on a credit memo. There is no 1 step process available. You have the option…

https://community.oracle.com/netsuite/english/discussion/comment/16881331#Comment_16881331 I did - once you enable internal ID's, all lists viewed will now have this column, and you can search for the internal ID your error file is referencing.

https://community.oracle.com/netsuite/english/discussion/comment/16881367#Comment_16881367 Step 1 - Create a non inventory item for sale, names 'Bank Fees' Apply your bank fee account. Step 2 - add the bank fee item to a credit memo. (so you aren't combining the non rev rec & rev rec items) Step 3 - accept the payment, and…

https://community.oracle.com/netsuite/english/discussion/comment/16881414#Comment_16881414 UM, I'm a little confused. When you load your trial balances, these are also your opening numbers - you would not reverse these. Load opening TB for December first. Do not reverse it. Load activity only TB for January-April. Don't…

Contacting support has changed from creating a ticket within the Customer Portal to creating a case via suiteanswers. It's kinda weird, but here is how to do it: While logged into NetSuite, navigate to Support>Go to SuiteAnswers Search: Support Cases In SuiteAnswers You'll find this: NetSuite Support Services has two…

https://community.oracle.com/netsuite/english/discussion/4503041/inbound-shipment-receipt-unexpected-error when this occurs, go to customization_scripts-Script execution logs, and see if anything is throwing an error. This may help you track down the specific issue.

Go to home-set preferences, and enable internal ID's. The error is referencing item internal id's. This will add a column on the left to all lists - including your items. Search for the internal ID's of the items, and then check the specific items.

https://community.oracle.com/netsuite/english/discussion/comment/16881268#Comment_16881268 So it's known that the bundle doesn't support standalone invoices, and this is an enhancement? In my opinion this is a flaw. THe lot/serial trace bundle should support the transactions using the lot/serial. By leaving out standalone…

https://community.oracle.com/netsuite/english/discussion/comment/16881270#Comment_16881270 Yes - the distribution of AP & AR includes loading the open details for each open AP & AR transaction, to the customer/vendor the transaction is tied to. This way open AR & AP can be transacted against following go live.

Option C

https://community.oracle.com/netsuite/english/discussion/comment/16881282#Comment_16881282 3 way match works on 1 PO, 1 Receipt, 1 Bill. More than 1 bill or receipt per PO and it doesn't work, and is a known limitation.

https://community.oracle.com/netsuite/english/discussion/4503089/is-there-a-limit-for-workflows-running Oh WOW! I bet your NetSuite page load times are slow. Also, with that number of workflows running, it can bog down your other script processing times, depending on the customer tier you're on. It's easy to disable them,…

If you have balancing Journal Entries, the best approach is: Load initial trial balance month Load subsequent trial balance activity only for following months. When you arrive at the month prior to go live month, Load the opening balances distribute AP & AR by loading open transactions only, that tie exactly to the TB (do…

https://community.oracle.com/netsuite/english/discussion/comment/16881128#Comment_16881128 That other member happens to be me.

https://community.oracle.com/netsuite/english/discussion/comment/16881134#Comment_16881134 Always fun to learn of module limitations after you've purchased it. Over the years, I've found that most things can be done in NetSuite using customizations. However, the specific customization you're asking for would require a lot…

https://community.oracle.com/netsuite/english/discussion/comment/16881210#Comment_16881210 Sorry that it's not what you wanted to hear. NetSuite is exceptionally logical. If you were to revalue things as of a specific date, everything that item is on is impacted as of that date. If your question is answered, please choose…

https://community.oracle.com/netsuite/english/discussion/comment/16881116#Comment_16881116 Hi Jeff, OK, without having the full details: When revaluing inventory standard costs, you do this according to a specific date. Lets say you revalue as of 01/01/25 All inventory on hand included in the reval will be impacted. All…

https://community.oracle.com/netsuite/english/discussion/comment/16881192#Comment_16881192 I don't know the configuration of your system, so providing you with a concrete answer with the limited requirements that you have provided. However, a suitelet could possibly work. Although it could be easier to use the saved search…

Hi Jeff, Nothing should affect transactions in closed periods. I would recommend that you file a case with NetSuite to log this as a defect.

https://community.oracle.com/netsuite/english/discussion/comment/16880171#Comment_16880171 Guys- if you click on the 'help' button at the top of your NetSuite screen, online help will open up. In the help page, click on 'user guides' tab, and do ctl-F and search for Manufacturing. If you open the 'Manufacturing' guide,…

OK< for searches, on the 'Results' subtab, you can select Output type = Report. The output then looks like this: It's not very flexible on searches. I am providing you with Native ways to answer your question. Please note that with some scripting, you can modify the output, and even set the title to be dynamic. However,…

There is not a way to use a csv import tool to delete invoices. There are several other easy ways to do this. 1- Create a saved search capturing the invoices to be deleted. 2- ensure the 'available as list view' box is checked on your search. 3- filter your search to the main line, and add the 'memo' field into your…

https://community.oracle.com/netsuite/english/discussion/4503080/customizing-pdf-output-for-saved-searches-or-reports For Reports, yes, you can add a custom title, but it won't be dynamic. on the report, click 'customize' go to more options, and adjust your report name (title) and the description as seen here Once you save…

https://community.oracle.com/netsuite/english/discussion/comment/16881038#Comment_16881038 Hello there. Let me say that I'm sorry for your frustrations, but sadly, they are common. If you did not specifically ask for this functionality to be confirmed prior to purchasing SuitePeople payroll, you're likely to end up stuck…

True

https://community.oracle.com/netsuite/english/discussion/4503070/add-date-modified-to-native-netsuite-fields-for-odbc-export-to-fivetran Hi Matthew, What you are finding is a known limitation when using a 3rd party tool that leverages tables within NetSuite. While an Oracle employee may find some enhancement request that…

You can also run the report by month, then combine the results via exporting to excel. This may help you get the results you want quickly. Not optimal, but could get the job done. 😉