Angela Bayliss · Senior Solution Architect · Silver Crown

At some point, you will need to migrate the trial balance from the old subsidiary, and at that point, you'll need to ensure that all inventory is moved to the new subsidiary at the same time. This will truly 'migrate' all data off of the old subsidiary, and allow you to inactivate it. ~angela

Curious - Why wouldn't you customize the 'Current Inventory Snapshot' report, that has most of this data within it?

Primary Units type

I would recommend that you take an actual bank statement from the month BEFORE you want to begin the reconciliations. Using that statement, enter your ending bank balance with the date, and clear EVERYTHING except uncleared checks for that account. This will clean up the 'historical' data and clear it out of your way to…

Hello There, While it may not be possible to merge subsidiaires, you're well on your way to consolidating them! Well done so far, as this is quite the undertaking. Your process sounds feasible, but there are many steps you may be missing. I'll do my best to help you through the process. Before we start, what is your end…

Hello, Internal Id is created and stored automatically when records are saved. It will not show up in 'Standard' reports, but you can easily customize a report to add the internal ID into the report: I hope this helps, ~angela

Bounced

You can set the purchase price by subsidiary if you set a preferred vendor for each subsidiary. Good Luck! ~angela

Angela is not a developer. 😉 Sorry I can't help.

Hello there, I'm not 100% clear on the difference license names, but Having a higher tier license means that you will have queues for running data streams. The higher the tier, the more queues available. IE- When importing csv records, you can choose the queue you want to leverage for that import. When you are upgraded,…

If you are trying to populate fields on item records with quantities fulfilled, and quantities committed or on backorder, these are native fields on the item records. If you're using advanced item location configuration, then the quantities on order, backorder, available and committed show natively. Is this the information…

My apologies @Angelica Mae Segador-Oracle - I didn't mean to be so harsh.

I would also like to be able to unsubscribe from Notifications on some threads. IE- Where I am tagged by a NetSuite employee on a post, and I have no value to add to the post. I get notifications on those posts that fill up my 'notifications' list - and I have to filter through my notifications to find posts where I am…

Hello, Did you assign a purchase price for the components? The item defined cost field is what drives the profitability on sales transactions. It doesn't drive anything on the item itself. ~angela

The Suiteapprovals app supports this, but I don't think Suiteapprovals works on electronic bank payments.

Hi Sam, At a high level, a work order that has been 'released' has items committed to the work order and it is ready to have components 'issued' or the assembly 'build' - (depending on whether you use WIP). A released work order is expected to be ready for the manufacturing process. A firmed work order has not yet been…

I would REALLY like to see less of the Oracle : NetSuite employees commenting on posts where their comments add ZERO value. When I respond to a post, and am having a conversation with the poster - and NetSuite employees respond to the post repeatedly - with nothing more than 'Someone in your community needs help' - IT ADDS…

@Dext3r - do you still have questions about this? Not sure what the point of @Angelica Mae Segador-Oracles is- but it notified me - 🙄 ~angela

LOL- Yeah, it would sure be nice if it was! However, having a place here where we can discuss these things is quite helpful. Keeps us from wondering if we're losing our minds with NetSuite. 😏 ~angela

These comments make it difficult to track when people actually do help and are waiting for a response from the person who posted the question. What is the point of these, @Angelica Mae Segador-Oracle ? ~angela

To natively reference a sales order number on a purchase order, you must create the PO from the SO. As you are trying to link these manually, that won't work either, due to the employee center limitations. When creating a purchase request from the employee center, you won't be able to have a user manually link a sales…

Happy to help! ~angela

You can't delete a work order that has been built. Closing the SO line, or the entire SO, will remove the commitment of the special order item from the sales order. Since it's a special order item, it will remain in stock. On the item record, to commit the special order item to a different order, uncheck 'Special Work…

Cancel the sales order, and the item should then show as available. You can also re-allocate it, if it 'fits' another order. ~angela

Hello, This report is designed to reflect a period of time, not a specific snapshot. On the first date of the report, you may have multiple FIFO values, so the report is designed to show you the average cost for the date selected. Same with ending balance. The report would become unmanageable if you have 100 of 1 item with…

On your search, scroll all the way to the bottom, and look for 'item fields...' - this allows you to link to the fields from the items within your search. Any option with the ... after the selection is linking you to another record. ~angela

In setup- accounting - accounting preferences, there is this setting: If 'Limit to committed' is selected, you cannot 'steal' items committed to other orders. Having the setting set to allow uncommitted, or ignore commitment - WILL defeat the purpose of committing items. So while you can choose to 'steal' those items, the…

Actually, my apologies - when looking a bit deeper, it doesn't appear that external ID's exist for addresses. At least you can't access them in any searches. Not sure you'll have much luck in this area. You can use the internal ID if updates, etc are needed to existing addresses. You can also map the address label - which…

What does your import template look like? Are you adding customers and addresses, or adding them to existing records? ~angela

Are you in the phoenix area?