Hi @Shin W, It is great that you are making some progress! I am not clear on the request. Are you trying to add quantities for "Available", "On Order," and "Preferred Stock Level" per Location and show the sum in a new field/column? Thanks.

Hi @User_FL4CK, Here is a SuiteAnswers Article with guidance on how to do that: Create Accounts Payable (A/P) Register Report Using Saved Search.

Hi @Deb in UK, As a workaround, you can delete all the "new" imports, and run the updated Matching Rules against the applicable import. Once done, you can re-import the new bank data manually, which would trigger the Matching Rule run once again.

Hi @User_4B6IN, You aren't missing a step. The behavior you see is by design. When you create a deposit from a Sales Order, NetSuite creates a Customer Deposit transaction, which can only be applied against an invoice created from the same Sales Order. If you would like to create a deposit transaction that you can apply…

Thanks for the logs. Can you check what the "Trigger On" value for workflowaction69 is? On the above screenshot, it says "Entry," but the Log mentions "BEFORELOAD": SETFIELDVALUE [Warning: Value cannot be set in BEFORELOAD on already existing (not a new) record.] Can you try the "After Record Submit" and see if works?…

Yes, Itzik, please enable the logs and share the exports for similar transactions of "worked" vs. "didn't work" and I will see if I can figure out the cause. Thanks.

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!