Here are some screenshots for an Advanced Intercompany JE between USD and CAD, which should give you an idea how to do for USD and JPY:

Will Subsidiary A process the exchange, get the funds, and then transfer them to Subsidiary B? If it is a transfer+exchange between subsidiaries, then you might be able to do this via Advanced Intercompany Journal, as it supports multiple currencies when subsidiary base currencies are different.

Hey @Brian Finlay, The list of all custom records is under Customization → Lists, Records and Fields → Record Types (app.netsuite.com/app/common/custom/custrecords.nl?whence=) If these records aren't locked, you can set the permissions from there. Make sure you select "Access Type" = "Use Permissions List." If these custom…

Hey @Gert Van Damme, This is a NetSuite limitation. NetSuite automatically populates the Class/Department/Location on a transaction created by the user that has these segments set as defaults. In your case, you have the segment only to use as a restriction, not to copy to transactions. You would need to create a Workflow…

Hey @Benjamin Paul - USA, What is the base currency of the subsidiary where you are processing this transaction? Let's assume the base currency is JPY. You would need to create a USD clearing account to process the conversion in two pieces. Journal 1: (No FX Rate) (Debit) Savings account 10000JPY (Credit) Clearing Account…

You have to break up the formula and get all the pieces in separate columns. Once you confirm they are accurate, you can combine them to the main formula. Again, not knowing your system configuration (e.g., is the {amountremaining} the correct field, or Subsidiary 13, etc.), I won't be able to propose the exact adjustments.

Thank you, Team!

Hey @GSONI, You can run a Saved Search to display/use the results of another Saved Search only via script. In your case, the workaround would be (high-level): Create a non-stored "Today's Exchange Rate" custom field on the Transaction Record Create a stored version of the same field Create a Saved Search and attach it to…

Yes, you can do that. Click on the Checklist Icon for the period you are trying to open Click on the Arrow icon on the last row of the "Go To Task" column Enter "Justification" and click the "Reopen Period" button Click "Ok" when you get the "Reopening will mean reopening all subsequent periods (They will remain locked…

Hey @User_LVLRS, Yes - you can do that via custom workflow. At a high level: Create a workflow to trigger the Edit Create a "Set Field Value" action for the "Date" field and set a formula to {today} Enter a condition in the action for the required Assembly Build status

Perhaps the user doesn't have access to a Saved Search that is attached to the custom field (not locked). You are probably testing this in Admin role, which has access to the Saved Search/

When you open a period, all periods coming after it must also be re-opened. Imagine a Closing Bank Balance of $10,000 in 2017, which is also the Opening Bank Balance of 2018. If you open 2017 and change the balance to $15,000, you have to have 2018 and future periods open, so the Opening Bank Balance also changes to…

I am referring to a "custom field" that is "powered by a Saved Search". Can you check if you have any custom fields on the Transfer Order record? A separate Saved Search opened in another tab won't affect this.

Hey @ONO4, You can source the Transaction ID to a custom column/line field via the formula:

Hey @MaheboobVanteli, You can trigger a Workflow action on clicking of a custom button. For standard buttons, you need a script.

Hey @Dext3r, Do you see any pattern in terms of items that are causing this? Will the same item cause the same issue for everyone? There is a chance this might be related to item configuration, default bin, quantity on hand in the specific location, etc. In my view, this is a core functionality and should be resolved…

Hey @HX_SUBHANKAR, No - there is no such practical limit in NetSuite. In theory, if we try to create 1000s of periods, we may hit some warning messages, although these won't apply to real-life scenarios.

Hey @User_TXI1Z, I need significantly more insights into the configuration and the record the Saved Search is running on to propose the exact adjustments. Based on the current screenshots, it appears the "Summary Type = Minimum" is one of the reasons for the issue. For Summary % calculations, I mainly used "Sum."

Hey @User_OGQAD, There is probably a custom field on the PO record with a linked Saved Search. The linked Saved Search is probably misconfigured, which is causing these issues.

I am 90% confident it can be done. If I knew the exact steps, I would have listed them here. It would take me some time to figure it out, and I can't spare much at this time, I have too many competing priorities. Open a ticket with NetSuite Support and mention the issue. Per the SCM Mobile guide, we should be able to add…

Agreed - the information on SuiteAnswers provides limited help. I know I tried several things before it worked. I was adding custom fields and am not sure how different it is from adding standard fields. Perhaps your issue is the incorrect "Merge" criteria. If that's helpful, I used a Saved Search for "On Load Action" and…

Hey @PatrickConrad, There is very little documentation on how to customize SCM Mobile pages. It took me a while to figure out how to add a few custom fields to the Work Order selection table. Take a look at these articles for some examples: SCM Mobile App Customization

NetSuite Consultants do everything related to NetSuite to help customers achieve their business goals. As part of NetSuite Implementation, I import multiple journals for my multi-currency and multi-subsidiary customers.

If the Supply and Demand are also empty, then the Supply Plan Definitions and/or the related MRP configuration are inaccurate. Multiple reasons can exist, such as an incorrect Supply Plan Definition, Planning Rule Groups, or mismatched Planning Item Groups. I recommend working with your NetSuite Consultant to review the…

You can only do that via Script, as Electronic Payments doesn't have the functionality to change the bank based on the transaction subsidiary.

Thanks for the answers. You can create a workflow to auto-update the Work Order location based on the Assembly default location. Would this resolve your main issue, or do you also need to impact MRP recommendations?

Hey @User_J1C00, For these use cases, the best option is to: Create the "Store Value" version of the same field Create a Scheduled Workflow to run every 30 minutes and copy the value from the "non-stored" field to the "stored" field Add the "stored" field to the Saved Search

Hey @User_V4YFI, Are you paying via the standard "Make Payment" / "Pay Bills" functionality or via Electronic Payments?

Hey @User_7VOB5, Instead of using "Name", you should use the following "join" field:

Hey @PaulRipley, This is typically done via multiple imports, impacting Parent, Child, and Elimination subsidiaries. There are multiple steps involved in the process, and it would be best to do this with your NetSuite Consultant.