@Patrick Fresnosa-Oracle I'm trying to create a transaction (bill) for our US subsidiary, and we're using Avalara for tax calculations. We've configured "Disable tax calculation for Vendor Bills." However, when trying to save the vendor bill, this error is generated. We can't make the transaction tax-exempt because we need…

@Vajrala Madhu Reddy Which script should be used? Could you please provide more details or clarify how to achieve this? Specifically, we need to know how to add a Department column at the line level by fetching the Department name from the Bill or Journal, where the amortization schedule originates. Any guidance or…

Hi, @NApiVersion 2.1 @NScriptType UserEventScript define(['N/record', 'N/log'], function (record, log) { function beforeLoad(context) { var newRecord = context.newRecord; var lineCount = newRecord.getLineCount({ sublistId: 'apply' }); //log.debug('Line Count', lineCount); for (var i = 0; i < lineCount; i++) { var…

Hi @tech work Use saved search: Let me know if want to have any other fields/filters/conditions here.

Hi @Shubham_Singh Below is the link to reach out to Netsuite for the request you have:

Hi @Tafranklin5 Regarding associating items with customers in NetSuite, there isn’t a direct equivalent to the Vendor subtab for customers. However, you can achieve similar functionality by using custom fields or other workarounds. some options I aware are: Custom Fields: Create custom fields on the item record to store…

Hi @Kedalene When a subsidiary is marked as inactive in NetSuite, the subsidiary is no longer available for selection in transaction forms and other areas where subsidiary selection is required. This inactive status means: The subsidiary won't be included in the revaluation process, so no new revaluation entries will be…

Hi @User_4W4PN NetSuite does not directly allow you to choose a different dunning recipient for each individual invoice. Instead, the recipient is determined based on the customer’s dunning settings. you cannot select different dunning recipients for each individual invoice, you can configure recipients at the customer…

Hi, Ensure that each inventory item is explicitly set to use FIFO costing. Sometimes, item-level settings can override global settings. Check the item records in NetSuite: Lists > Accounting > Items, then open an item record and verify the Costing Method field. OR ELSE Go to Reports > Inventory/Items > Inventory Detail OR…

Hi @User_RWY1B You are correct that under FIFO, the COGS for March 19 should be $8 and the COGS for March 21 should be $140, with the closing inventory valued at $300 (15 units at $20 each). Ensure that the inventory accounting method is set to FIFO in the system settings. In NetSuite, this can typically be done through:…

Hu @User_RWY1B Understood your question below is the explaination to your question: Imagine a bicycle shop, say Bike LTD. The shop operates on the FIFO accounting method. January Transactions: January 1st: The shop decides to reset its inventory to zero using the inventory worksheet. This means all the existing bicycles…

LCS access is the only way you can get the demo account.

Yes Schedule the report (post 5 minutes to current time) and test it.. It works

Hi See the above Screenshot Customise Message Subtab → and choose the format from the options Hit the "Like" if that solves your question.

Hi @User_Q3A12 Oh sorry… I meant to ask about PO / VB only. Then "Created By" field will solve your requirement. Reply back once you are done with setting up and let me know about status.

Use “Created By” field. Are you using approval routing for sales order??

Hi @User_Q3A12 Use Recipients from Results subtab: To target recipients based on values of search results fields, click the Recipients from Results subtab. I can see that users who created these PO/VB are part of this search. On each scheduled date, separate email messages are sent to all recipients who match search…

Hi @Philly_NS Consider removing the commitInventory field temporarily to see if the rest of the script works correctly. And also could you please explain why commitInveory field is here while creating Sales Orders.

Hi, Ok Thanks for mentioning your costing method. In the FIFO costing method NetSuite calculates the amount by using the costs of the oldest available inventory layers. Based on the provided data for document number IT45581:QUANTITY: 70 units transferred AMOUNT: -$86,346.40 See the below Example on how it works within…

Hi @User_RWY1B ITEM RATE: Rate per item for inventory transfers and invoices. For inventory transfers, the item rate should be calculated based on the costing method (check your item costing in item record): Let's consider an example calculation(From the data of your screenshot): For the inventory transfer on 11/9/2023…

Did you create a custom role specifically for integration purposes? (It has to be) This is because access tokens cannot be generated for the administrator role. It's not possible to create, assign, or manage tokens for an Administrator role in NetSuite.

@LisaNC Hope you got your answer. Please react to my previous comment. Thanks!!!

@MikeGodbout Below are the steps to achieve the requirement: STEP 1: Create Integration setup>integration>manage integration STEP 2: Create a role With Permissions Make sure to have these permissions for the role you would like to create token. STEP 3: Assign this role to the User, in my case it is "fixed assets manager"…

I have highlighted the portlet.

Hi @LisaNC Add the shortcuts portlet from the above personlize and then choose"new shortcut" and you'll be prompted with the popup to add the URL. Now Open the task in other tab and copy the hyperlink of the task page and paste that in the Shortcut URL field above as shown. Thanks!! Hit like if this solves your query.

Hi. @Benjamin Paul - USA For Subsidiary X: Department A Department B For Subsidiary Y: Department C Department D Now, let's consider a role called "Asset Manager" with access to Fixed Assets Management. If we assign Department A to only Subsidiary X, and then assign the "Asset Manager" role to Subsidiary X, here's what…

Hi @User_S8PAJ Could you guide me to the navigation where you made the recent adjustment in the tax settings?

Hello @User_S8PAJ Experiment with the "Set Field Value" action in your workflow, and then set it to "trigger on" before the record is submitted. Keep me updated on the results if you're testing this out.

Hi Patrick, I attempted, but regrettably, it didn't meet my needs. This specific criteria helped me find precisely what I was looking for. Thanks for the help!

Hi, Create a 0.00 tax code in netsuite: you can add this tax code to a transaction or tax group as needed. This should help you handle transactions that require a non-taxable tax code, such as the Colorado Delivery Fee scenario you mentioned.