Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hi @User_L7PTK, Could you check if you can post a Journal Entry to the same elimination GL account with the other GL accounts that are being used to record labor cost? Typically, the "unexpected error" points to an error that isn't handled / isn't designed to occur. Let's see if the standard Journal would help to identify…

Hi @Anaelena Zerpa, Can you check if the Elimination Subsidiary (ID: 23) will be used for the iC elimination for the Columbia subsidiary? If yes, do you have the "Include Children" checked for the GL Accounts you use to set up Tax Types / Tax Codes for the Withholding Tax? Thanks.

Hi @User_CNLH5, You are correct - there should be a way to drill down from the Summary version to the Detail version of the AR Aging report. Could you check the "Expand Level" and "Drill down Report" values under Customize -> More Options and see if they look correct:

Hi @User_7C8GF, I am not sure about the override. You can undo all the reconciliations and start from scratch to include pre-Go-live open balances.

Thanks for the update, @JamesHuntley, Once you populate the Purchase Approver, it should take precedence over the Supervisor for approving purchase transactions. The native Supervisor field has several functions within the system, so you should be careful by leaving it blank. In some cases, I needed to create a custom…

Can you confirm the unmodified AR Aging report works correctly every time? If yes, the issue might be caused by: One of the custom criteria/filters used in the customized report Browser related issue, such as corrupted cache or extension

No problem at all, @User_4SFC6, The other manual option would be the Bank Transfer - would this work for the auditors? Quickbooks could do this and a few other things that NetSuite can't because it doesn't need to comply fully with the requirements of publicly traded companies and various international jurisdictions. It…

If you are the owner of the Custom Record / Field / Workflow, then the testing using a Custom Role is often inaccurate, as NetSuite is still treating you as an Administrator. Could you ask someone else to test it with a Custom Role? Or, can you temporarily set someone else as the Owner?

Could you check if you have "Access Type = Use Permission List" on the custom record: Also, could you remove the "View" from the field itself and try again? Thanks.

@User_JJC0O, Are they getting an error message, or do they see no values? Could you please share the related screenshots for the field/segment in question?

Hi @User_TRQT3, For "TEST US | Total OH", could you please replace the {inventorylocation} = ** (name is currently entered) with {inventorylocation.internalid} = ** (enter ID) and see if that works?

Hi @Ted Stout, There is a workaround around this limitation by using the "Customers and Contacts Together": The high-level steps are: Create a Test/Temp Customer Import all Contacts with the required roles and assign them to the Test/Temp Customer. Export the list of newly created Contacts with Internal IDs Replace the…

I created a Custom Segment called Market Segment with three of the values from your screenshot: I can now show its values on the Income Statement as persistent columns: Could you compare your setup to mine and let me know if you have any questions? Thanks.

Thanks for checking, @Shin W, Some native fields are hidden from the custom sublist, and we would need to use a custom field to display the required value. Do you have Saved Search where you can see the Carton Quantity? If yes, can you share the criteria and the result? I would then recommend how/where to create the custom…

Thanks for the additional information, @Patrisja Nuguid-Oracle Could you confirm the Market Segment is a Custom Segment? If yes, could you check if it is applied to all transactions (Application & Sourcing tab > Transaction Columns subtab)?

Hi @ZShah, We should be able to do it via Saved Search. Could you please share the Criteria and the Results from the search? Thanks.

Hi @Shin W, You should be able to add the required columns by clicking "Customize" on the sublist: Let me know if it doesn't work or if you can't find the columns you need. Thanks.

Hi @Varonis inc., The filters for "Account" and "Transaction Type" show as "multiple" on the screenshot, so we can't see what is selected. Could you double-check to confirm the report is run with the exact same filters and still shows different results? Also, do you run the report in sequential order and get a different…

Hi @zshah, Here is the link to start the process of becoming a NetSuite Partner: https://www.netsuite.com/portal/partners/become-a-partner.shtml. Good luck!

Hi @Kedalene, Can you double-check if the user is logged into the correct role? Also, can you check if any of the permissions changed for the role that had access to the reminders? Thanks.

Hi @User_JJC0O, For each of the Field/Custom Records, you can set the Access Level = View for any of the applicable Custom Roles. Once done, they can view and select the values but not create them.

Hi @User_SVIBU, The journal shows on the Bill Payment page as it probably credits the AP account for a specific vendor. Is this intentional? NetSuite allows creating the AP via Journals and paying them through a Bill or another Journal. The JNL-5172 will disappear from the Bill Payment screen if the GL for the Credit is…

Hi @Patrisja Nuguid-Oracle, Could you check if you can use the Market Segment as persistent/matrix columns if you run the Income Statement Summary report? The "View Columns By" option doesn't work for the "Detail" version of the Income Statement.

No problem at all - I am glad to help! By design, the Intercompany AR and AP accounts are used for Intercompany Sales And Purchases and can be set to IC Customers and Vendors. The Intercompany Cross-charge mainly moves actual expenses/time from one subsidiary to another. It doesn't natively support the addition of a…

Could you please open a NetSuite Support Case and ask them to investigate this? They have the tools to help identify what is locking the Purchase Approver field on the Employee Record. I am curious to know what would be their answer. Thank you.

Sure - @kees.netsuiteadmin, If you open the Customer Deposit that has 18+ lines/checks, there should be a Print Summary option there:

Hi @Mathias_Netsuite, Yes - you can do that via the "Transactions -> Financial -> Create Intercompany Adjustments" process. For example, you have an employee in Subsidiary A who entered an Expense Report for a project in Subsidiary B. You can cross-charge that expense via the "Create Intercompany Adjustments" process. When…

We could have done this with a Saved Search if you had a direct link between Sales Orders and Purchase Orders. Because they aren't linked (which is a valid business use case), the only way I can think of to do what you need in an automated way is through customization. The script will run on a scheduled basis, record all…

Thanks for checking that, @JamesHuntley, What is the display type of other similar fields on the Employee Record, such as "Expense Approver", "Purchase Limit," and "Purchase Approval Limit"? The field is grayed out due to one of these: Display type setting on the field itself (this shouldn't apply as the field is native)…

Hi @Vernita, The detailed example that @Patrick Fresnosa-Oracle kindly provided would apply if you have the following: Parent (AUD) Child (USD) Grandchild (AUD) If you only have Parent and Child, and both have the AUD as their base currency, then the Consolidated Exchange shouldn't impact it. I would expect the Amount to…