Hi! I have a custom email template for statements that I want to use. How can I use this email template when sending multiple customer statements by going to 'generate statements' and ticking multiple customers to bulk email?

Can anyone please confirm if NetSuite Production (IST timezone) is working fine? We’re unable to log in and getting the following error: “Account not available despite being active.”

Is there a way to send customer statements to primary and secondary subsidiaries via workflow? It looks like it only supports the primary subsidiary. If not, is it possible via scripting without too much effort?

Hi everyone, Is it possible to have a field on the Purchase Order automatically checked based on the Inventory Detail status from the related Item Receipt using a workflow? I started building the workflow at the PO level, but when I try to add a condition that references the Inventory Detail status from the IR, I can’t seem to access it. Has anyone found a workaround for this or a way to reference Inventory Detail fields across related transactions?

Hi everyone, we provide services to our customers and we use fulfillments to track how much of the service we've "provided", then each week we create an Invoice for what has been fulfilled so far. We have "allow invoice before fulfillment" turned off, so that the invoice is only generated for exactly what was fulfilled so far. However, we have 1 customer that we invoice a custom quantity, not related to what was fufilled and so sometime that amount goes over what was fulfilled so far. Has anyone tried to generate an invoice from a sales order via SuiteScript where the invoice quantity is greater than fulfilled quantity, even what the "allow invoice before fulfillmetn" setting was disabled? Does NetSuite allow this or will we get an error? TIA

oooooOOOooo

Is there a way in item fulfillment search to show the kit name for the kit component lines ? If there is a kitA on the item fulfillment. Which has 2 components comp1, comp2. It shows 3 lines. 1 parent kit and 2 child componentines. I can filter out the kit. So it will only show the component. Which is what the user wants, but they want another column to know what is the component parent. They want output like Comp1, Kit A Comp2, Kit A Is this achievable in a saved search.

Suitebilling question. For some reason I can’t seem to activate subscription lines. After saving a new change order to activate, it still sits in “Pending Activation”. Does anything look wrong here on the change order before submitting? Why won’t it activate?

MRP question, i can't get consumption to work as expected. Example: we have weekly demand plans set on sunday weekly demand plan for 11/2 = 521 orders so far for the week = 450 i would expect to see pending forecast of 71 my location settings are: late days period: 7 past due forecast days: 6 (so 11/2 forcast stays valid all week) backwards consumption: 6 (so all orders in throughout the week are consumed by 11/2 forecast) forward consumption: 1 ( allowing orders for saturday to be consumed by the next week forecast but all other orders should go back to 11/2) but for some reason i keep seeing that the actual demand = 71 which is correct these are the open orders for the week, but i'm seeing pending forecast of 101? i just can't seem to wrap my head around what's going wrong here.

Hello! Blanket PO question: After I released the first line and processed a PO, if I view back on the blanket PO schedule that line is still available to be released again. There is also no relevant PO associated to that line, and I would have expected the release checkmark to be disabled. Any troubleshooting tips?

this might very well be relevant to those who run onmichannel commerce business and use common tech stack - NS, Celigo, webstores, marketoplaces, RMAs, inventory management, multiple channels, etc --- you know how overwhelming it can be. We are hosting a webinar tomorrow that will help you be prepared for growth. it is 35 mins but you will learn a lot from the big brands that have done it https://novamodule.zoom.us/webinar/register/WN_DECVbykBQ8GFXYXLZrFKIg?_gl=1*t607ez*_ga[…]DX*czE3NjIzOTIxMDckbzEwJGcxJHQxNzYyMzkzMjY4JGo0OCRsMCRoMA..

How can I check how much tax is applicable on an item without creating a SO?

how would I go about finding inventory/assemblies that are dead? We have lots and lots of items/assemblies(formulas) that we don't use and haven't used in a long time. I know it would be a saved search but I want to make sure that I can see the last time it was touched/used/transferred and start from the oldest and work my way up

Hi mates I just passed SuiteFoundation certification If you have vacancies that requires this certification - ping me please (and I am going to pass other certifications as well) https://catalog-education.oracle.com/pls/certview/sharebadge?id=72AFEC409EAD2B7D76B0EAD1C97BAD5C34423795C9B531931FF0E00FA19AC921

In a search of deposits, how can you differentiate Other Deposits from Payment and Cash Back lines?

Hello everyone, I'm creating a saved search to report on sales profitability. I'm having trouble understanding the Est. Unit Cost calculation for items with costs defined in a different currency than the Sales Order (SO). The item's Cost Estimate Type is set to 'Item Defined Cost' (in USD). The Sales Order's currency is ARS. The issue: The cost is converting using an unexpected exchange rate. • Item Defined Cost: 736.60 USD • System Exchange Rate (USD to ARS) for SO date: 1,205.00 • Calculated Est. Unit Cost in Saved Search (ARS): 883,920.00 The result of $883,920.00 suggests the system is using an effective exchange rate of approximately $1,200, rather than the rate of $1,205 defined in the Currency Exchange Rates table. I've already confirmed the SO Header Exchange Rate is 1 (since the transaction currency = subsidiary base currency). My question is: Where is NetSuite pulling this rate of 1,200 for the Est. Unit Cost conversion? Is it using a daily average rate instead of the specific entry?

In custom scripts, is it possible to impose both private/public key and a password at the same (sort of a 2FA) for SFTP connection?

Hi all! I was wondering for those who use shopify, if anyone invoices from shopify? We have our normal dtc shopify setup but we do have instances where we have people ordering directly through us and we need to place the order for them giving them net 30 to pay. I know there's a way to do that in shopify and I was able to bring the order into netsuite but not sure I'm understanding all of it. Anyone else invoicing in shopify and how do you handle it in netsuite?

We have a saved search that we need to send as a CSV file to an SFTP server. Which is the better approach? 1. Use suitescript to convert the saved search to a CSV file, store it in the File Cabinet and then use the SFTP Connector SuiteApp to send the data finally to the SFTP server 2. Use suitescript for everything

Has anyone used NetSuite WMS and Tally Scan and had issues or been able to get it work. I am trying to set it up with no luck, have been in touch with support for NetSuite over the past 6 weeks and still no luck (they have provided 3 conflicting setup changes to do and none work, rep keeps promising to book a call and then doesn't. Already updated bundles! Initially the rep said it was a defect but then said it was fixed (no defect number raised)

Is it posible to create a workflow that automatically creates a credit memos when an RMA is received? Ideally, in real time and not scheduled. I tried the transform record action on after record submit but it doesn't work because the RMA isn't submitted anyway when the Item Receipt is created. On Entry doesn't work either.

I have built an ai agent for netsuite and looking to test it in a demo environment. Can someone help me with getting that env? I could give them a showcase of the agent even

how do i reference the currency on the details subtab of a currency revaluation line in a saved search? i cant find it, the normal currency result shows my functional currency, i want the currency on the detail subtab that shows the currency being revalued

Does anyone know why gulp extension:local would error out while concatenating files in pre-templates? It seems that latestFileModified is undefined when it needs to have a value. If I put in a check to see if it is defined, I just get a page with an empty main div. I have never had issues setting up the extension tools before 25.1.0, now I can't get any to compile.

Hi everyone! I am wondering if anyone had issue locating the Drag and Drop suite bundle 41309? I can’t seem to locate this bundle and i can locate others. Thanks!

I am trying to use adjust Inventory to try and remove a serialised item out of inventory ( to create an asset ) and it is only using the average cost of an item and not the value of the item for the specific serial no. For example I have an AIR CONDITIONER. I have purchased these twice but the second time the cost had increased, so I have the following stock AIR CON - Serial No AC001 cost $3000 AIR CON - Serial No AC002 cost $3500 I want to create an asset out of AC002 leaving AC001 in stock. I do an inventory adjustment and take 1 out of stock and select AC002, then I propose an asset, and manage asset proposal. My problem is that the asset has the value of $3250 (the average cost) and not $3500 as required. The item is set up with a costing method of "Specific". Any advice would be helpful. Thanks.

Anyone having issues in Ash 2?

Hey all, is anyone else having issues with NetSuite's Print Check function? We have users unable to access the page as it times out after 5 to 10 minutes. 'Print Checks and Forms' -> Checks -> Fails to load. We have opened a case with Oracle but curious how widespread it is.

SuiteApp Suggestions 💡 Anyone want to suggest their favourite SuiteApp? Looking to explore new ideas and ir would be great to hear of nice findings/features. We use NetSuite for core accounting (AP, AR, GL, Revenue, FAM)

Electronic Bank Payments Is it possible to automate the batch? For example, the team do an analysis of who to include in the bill run this week. They then go to the batch screen to choose the bank account and which bills to pay. Is there a way to avoid this manual step? I’m thinking could we upload a custom field to flag as pay this week on the bill, create a saved search to filter records due for payment and a script to do the batch step… anyone achieve a way to avoid the selection and manual batch step