Look at the user role creating the PO. If their role has restrictions of 'Default to own' on departments, the departments are being set based on the role restrictions. Make sense? ~angela

Hi Sam, If memory serves, to import, you must default your expense reports to use Multi Currency. For each line, you will select the currency and amount for that expense - I don't think exchange rate is importable, it's sourced by the exchange rate in NetSuite. The billing subsidiary is coming from the feature - multi…

Hello Mark, This platform is for all NetSuite users to help each other, for free. I don't believe that Partners and Solution Providers are allowed to offer services in this community. As Tris mentioned, there are a plethora of places where you can request solution providers to reach out to you. Be advised - there are a LOT…

Hello Again, When you go to setup>Company>Subsidiaries - Do you see values for 'representing Customer' & Representing Vendor? Let me know? We can troubleshoot together one step at a time, if you like. ~angela

Can you manually add this item to a Sales Order using the subsidiary you want to use in the pairing? You don't have to save the SO, just see if you can add the item to it when the customer is using the same subsidiary that you are trying to create the pairing into. ~angela

It sounds like you are using Arms Length inventory transfers (paired sales order/purchase orders). If it is a non inventory for purchase, or service item for purchase, these can't be used on intercompany transfers. See SuiteAnswer 60846: Scenario This error is normally encountered when the item used on the intercompany…

Their question is answered. Clearly they are creating credits from bills, so they simply want to not apply the credit automatically. I'm not sure what value your response is providing? Regardless of the way they are doing things, they have the answer they need for their use case........ ~angela

Hello There, I've never seen a NetSuite Bill Payment that doesn't have anything applied to it. Very odd. Can you provide us with a screenshot of the GL Impact of the bill payment? ~angela

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