Angela Bayliss · Senior Solution Architect · Silver Crown

Question - and it may sound odd, but give it a chance - when you are logged in, and you navigate to transactions - Employees - Expense report, and the ER loads, is 'Multi Currency' enabled already? ~angela

This error may be due to the open transactions - if you are merging the vendors into a record with a different primary subsidiary and you have open transactions with a different primary subsidiary, you won't be able to merge them. You'll need to inactivate those vendors once the transactions for those vendors are migrated.…

No. Any open Purchase Orders for any items from the subsidiary you intend to inactivate will need to be migrated to PO's for the new Subsidiary. You cannot change the subsidiary on purchase orders. You should be able to create a search for all of these open PO's, and then export them, and import them under the right…

Will you take a screenshot of the Bill Payment GL Impact, please? ~angela

Gotta love NetSuite Sam! Glad you were able to get your PO's imported! ~angela

Hi Sam, This may seem like a really dumb question, but have you cleared your internet Cache? When making config changes, I clear my cache multiple times a day. I'll explain why if you'd like, otherwise - trust me? Give it a try, and let us know? ~angela

Hi Sam, When I import Purchase Orders, I never map the 'amount' column. That column should calculate to be the rate * quantity. Will you try your import without the amount column and see if that helps? ~angela

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?