Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

You can go to Asset -> Depreciation History -> View (Asset Status = Depreciating) and delete the Journals that were posted. The other option would be to reverse those Depreciation JEs and inactivate the Asset.

Hi @User_8ZIY6, On a high level, the Automated Intercompany Management will eliminate intercompany transaction lines with the "Eliminate" = "Yes". For example, if you create an Advanced Intercompany Journal and use GL accounts with "Eliminate Intercompany Transactions" checked, all lines will have the "Eliminate" = "Yes"…

Hi @Varonis inc., Did you check the logs when the Workflow didn't work as expected and compare to the ones when it worked correctly? They may pinpoint the issue. The workflow is probably missing a required Condition, or a Trigger/Transition needs an update. Based on my experience, Workflows work 100% of the time if set up…

Hi @User_L5OG3, You can delete the Asset once you delete all related transactions and other dependent records if there are any.

Thanks, @User_CNLH5, I have a few more questions: Does the drill-down work correctly on the unmodified AR Aging Report? Also, did you run the client's modified AR Aging report, and the issue still persists? If yes, what happens if you click on "View Detail" instead of clicking on individual lines?

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.