Pages

2009/08/28

Hidden Saved Search Types

Have you ever had to create a Saved Search for a record type that's not available in the "New Saved Search" page?


Well, there are some workarounds to that limit, and here's an example.

NetSuite doesn't allow you to directly create a Saved Search for Messages, but there actually is a Message-type Saved Search; it's just not displayed on the New Saved Searches page. You can access it by using this link: https://system.netsuite.com/app/common/search/search.nl?searchtype=Message


If you pay attention to the link, you will see a parameter "searchtype". In this case, the type is "Message". Another record that works is "Location". Try different record types to see if they also work!

2009/08/07

Accept Payment Through Top-Level Customer - The Ills of It

In Netsuite, you have the option in your Accounting Preferences to turn on "Accept Payment Through Top-Level Customer".
















This functionality, in itself, is quite useful and a lot of people use it. It simply means that you can create Invoices in the name of sub customers, but have a Parent Customer make all the Payments. It's a functionality that makes plenty of sense when dealing with subsidiaries, sub-customers or departments or a larger client.

However, it also happens in reality that, for whatever reason, the parent-child link between the entities may be severed. One's instinct would then be to do the same in Netsuite - the system in fact does allow you to simply erase the value in the "Child Of" field on customers, thus liberating it of its parent, and allowing you to post both Invoices and Payments directly to the newly freed child.






















Bad idea.

You see, Netsuite deals very, very poorly with this situation. In the system, you have Invoices in the name of one entity (the child) and Payments in the name of another entity (the parent). This makes sense as long as the parent-child link exists. Without that link, you've got an invalid situation, from a system point of view.

What happens *exactly* at this point has varied over the last few months. Last winter, we had a customer who separated children and parents. In that case, Netsuite changed the records so that all the Invoices were now Open. The child kept all the debt and the parent kept all the credit. Considering many parent/child relationships had been severed, it took us over 60 hours to correct the data. Then their accountant had to reconcile everything again. Yeah. It was a mess.

More recently, another customer had to sever parent and child again. But this time, Netsuite behaved rather well. The Invoice remained Paid in Full and the Payment was fine. BUT, as soon as you hit the Edit button on the Payment, the invoice being paid instantly vanished. In other words, the Payment record can never, ever be edited again.

The official(ish) word on the matter from Netsuite is that you should NOT be separating parent and child records. Netsuite shouldn't allow you, plain and simple. And I can only assume this will be patched and enforced in the future.

So my recommendation to you is the same: Do Not Separate Parent and Child Records When You Have Invoices Paid By The Parent. Just create a new Customer record and start over, leave the old entities be. Yes, you lose the history. But that is probably better than the chaos you will unleash if you sever the relationship. Anyway, just be careful.

2009/08/05

How to Convert an Account from Non-Inventory to Inventory

In NetSuite, there is a Standard KPI called “Inventory” that you can monitor in your Key Performance Indicators portlet and that could also be used in the KPI Scorecard portlets. This KPI is showing the value contained in the different inventory accounts.






















By default, NetSuite is configured with an account named "Inventory Asset", of type "Other Current Asset".
If you use only one inventory account, you should be fine with it. But if you would want to use more than one account to manage your inventory, you may create other accounts in your chart of accounts. In this process, it is really important to not miss a step while creating the new accounts, in order to have their balances calculated in the Inventory standard KPI: you must check the option “Inventory”.










This option can only be applied when an account is created. If you edit an account, you will remark that the Inventory field is read-only.








If you have an account that you were using for your inventory and you forgot to check the Inventory field, there is a workaround. Using the “
Merge” feature, here are the 2 steps to apply the correct setting to an existing account:

1) Create a new account, with the Inventory option checked.
2) Edit the original account and merge it to the new account. Be very careful during this step, as it cannot be reversed once completed.