Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Intercompany Journal would impact the Elimination subsidiary. You can create a script to reverse a specific GL impact after the main JE was created. Or, you can create a script to create JEs (not IC JE) with Locations as standard JEs in the required subsidiaries. There might be other ways to accomplish this, but it will be…

Hey @User_J2V0H, A workflow can populate the list/record field type only from a related field that has the Internal ID of the record. If you could populate the Internal ID of the Customer, then you can reference that field to populate the Customer in a list field on the Custom Record.

Hey @Alexis Atrizco, Perhaps the best option is to create a script that runs nightly and sends alerts for new deployments.

Yes, this seems like a defect. Can you ask the users to clear the browser cache and try again? Also, can you uncheck the "Available As Dashboard View", save the Saved Search, and then check the box again? Are you having similar issues with other Saved Searches or only this one? If other Saved Searches work, then you can…

I see what you mean. Based on the original post, I understood your request differently. It appears you are trying to pull the layered cost data, which isn't straightforward, which is why we recommend our customers not use FIFO. The Average Costing is the best option. You have a couple of options if you need to use FIFO and…

Hey @Bee Yook, I agree that it would have been useful if NetSuite had such native functionality. Currently, it isn't possible to approve POs and RFPs in bulk simultaneously via NetSuite's design. That can only be achieved through customization.

Hey @Maria Gabriela Barbosa-Oracle, By design, NetSuite Elimination Journals should impact the Elimination Subsidiary so that the Parent and Subsidiary Financial Statements are accurate.

Hey @User_LVLRS, You can export the Line Unique Key. If you want to impact the line with that specific Line Unique Key on the invoice, you should use the combination of the Document Number and Line ID to impact the required line.

Hey @ybeaucage, Can they run that Saved Search directly from their Role if you give them the reports URL?

Here is a screenshot from the Inventory Valuation Detail report that shows Item's Opening Valuation, and Unit Value for each transaction, including Item Receipts, and the final Valuation:

Each instance has a unique configuration and may require a different set of steps. If this was a quick customization, it would have been easier to define in a post. I recommend using NetSuite's official customization guides as a reference to build this customization.

Yes, you have to run the Amortization Process monthly:

The best option is probably to create custom fields that reference those Tax Rates and then create GL Plugins or Scripts to reclass the GL Impacts accordingly. If you move to SuiteTax, you should have the required functionality as part of the newer Tax Engine.

Hey @User_BQX47, Yes, we mostly use Boomi iPaaS to build such integrations for our customers.

Hey @User_L6WBE, No, you won't be able to achieve that via Saved Search without customization. You might be able to do that via SuiteQL, too. The customization would mark the custom checkbox on eligible transaction lines, and you would use that checkbox in your search to show the amount.

Hey @User_5OTRX, The "Text Area" won't keep the line breaks. Try using the Rich Text field type instead, which should keep the line breaks.

Hey @User_MJPN8, Yes - you can build a Transaction Saved Search for "Item Fulfillment" as a Type with "Main Line" = "False". The Created From will show the Sales Order.

Hey @Elizabeth Vance, That might be possible by using a formula field as an Available Filter. Or, you may need another custom field that is dynamically populating the required Internal ID that you can use as a filter.

Hey @User_1D0ZP, I agree it would have been very useful to have access to that record. For some reason, NetSuite doesn't give access to the Billing Information record, and we can't create a report to see that information there. You might be able to get that information to a Saved Search via scripting, which would extract…

Hey @User_6R76W, You need a customization to achieve that. You need to create a custom stored field (e.g., Related PO) on the Vendor Bill record and populate the PO Number there via Workflow or a Script. Once done, you can add the custom field from #1 to the AP Aging Report

You are using the classic/legacy tax engine, correct?

You should have a "Schedule" field on the Journal Line where you can choose the required Amortization Schedule. Here is a reference screenshot:

Typically, the "Vendor Name" field on the Purchase Order line displays the "Vendor Code" if the Purchase Order is for the Vendor that is selected as a Preferred Vendor on the Item Record. NetSuite populates this value and can't be modified. I suspect the "Vendor Number" field in the screenshot is custom. You can create a…

You can do that via Saved Search. Depending on your configuration, you would need to use specific criteria and results, and potentially, some formulas. Here are some reference screenshots to help with the Saved Search:

Thanks for the clarification. The Assembly in your example may have a Quantity Available of 200. Is that what you want to show, or only up to the maximum of "Available to Unbuild"? If you want this to be visible primarily on the Form UI, you can achieve that via a custom field and a linked Saved Search. Here is an article…

It might be related to the missing DKIM setup or another step. You would need to go through this in detail and ensure all applicable steps are completed: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_162516600357.html#subsect_162517444872

Hey @Lee Ann R, Are you referring to Component's "On Hand Quantity" or something else?

Hey @User_ZTPD3, I suspect the "Vendor Code" that you have is a custom field. Can you check that? Also, is it on the Purchase Order header or the line? Please share a few screenshots from your Item and PO records to facilitate the troubleshooting.

Hey @User_14Q68, Yes, you can do that. One option is to create Amortization Journals for each Vendor Bill, with the required amounts, and reference the Bill # in the memo. The JE will reverse the Expense and move the amount to the defined Deferral Account, and post to the Expense every month. You can also do it via actual…

Thanks for checking. Do you have the related profile populated as an "Associated Payment Processing Profile" for applicable "Payment Methods"?