Angela Bayliss · Senior Solution Architect · SuiteMaster

Hello There, Suiteanswer 78857 may be what you're looking for: Answer ID 78857 Applies To Product: NetSuite 2020.1 Scenario User wants to create a report showing available items and their custom prices. Solution A. Create an item saved search to display the items on stock and their custom prices (instead of showing Base…

Actually, it's not the same. A standalone vendor credit is very different from a credit created from a bill that they don't want to apply to the bill. 😉 ~angela

Once you have defined your 'cutover' date (the date you intend to stop using the subsidiary), you will need to create a saved search for all inventory on hand for the deprecated Subsidiary. you will need to adjust the inventory out of the old subsidiary, and adjust it into the new subsidiary. (even any inactive on hand…

No worries!! Just doesn't sound logical to me. 😉

Yes. It will show as applied to the bills, once it is included on a bill payment. It will no longer show as open on your aging reports. (will you choose your 'best answer' so that this thread doesn't appear to remain open?) ~angela

I went into a test account, and found that I was WRONG! You can't set a purchase price per subsidiary. The value of the item should have the 'purchase price' from the item record, not the preferred vendor by subsidiary. I am so sorry for misleading you.

Hi Sam, I don't think the vendor purchase price is going to apply to your unbuilds, unless there are serial or lot numbers that were purchased, and you're using Specific costing. I believe that an unbuild will always use the purchase price defined on the item record, not purchase prices assigned to vendors. If you go down…

This tells you that your costing engine won't run until after 6pm each day. As you are testing, the values will be average until the costing engine runs. Are you factoring this in as you're testing? ~angela

You can create 'standalone' vendor credits, by unchecking the 'apply' fields. It may default like this: By clicking on this subtab, and unchecking any transactions showing with a checkbox, it will then show as 'unapplied', and can easily be included on a check run. I hope this helps! ~angela

My pleasure. I hope it helped! ~angela

Let me know if you need anything else by commenting? ~angela

If you already have the project id, can you source the internal ID of the project within your field sourcing? ~angela

Hi Dex3r, If you navigate to setup>accounting>Inventory Costing preferences, how often is your inventory costing engine running? Let me know what your setting looks like? ~angela

You won't be able to add the internal ID, and I don't think the internal ID will provide you with value. If you're looking for the project ID, the native field provides this functionality natively. ~angela

Hello there, I'm a little confused, because there is a native field on PO lines that is available to capture the Project ID. If you navigate to create a new PO, and edit the form to 'Standard PO' do you see this field?

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.