we use dropship/special order items. normally PO gets generated with item rate = default purchase price, per agreement with vendor. but now vendor doesn't want to use static price. vendor wants item rate = some % of the sales price. how would y'all approach this? i'm not allowed to yell at vendor.

I was excited to see i could get more info in system notes by unchecking the LOG SYSTEM NOTES ON UPDATE ONLY field, but uhhhhh... Yeah, that last line's got me scratching my head.

Hello! Anyone else on Amazon Marketplace and connected via Celigo? There's sometimes a lag between when an order has shipped vs when Amazon decides to actually release the order and send it to us because of payment issues. The business can't seem to understand why if an order has shipped, it won't come in the system. I understand it's a limitation with how the order release is setup with Amazon, but wondering if this payment lag issue happened to anyone else and what you guys did to resolve it, if at all?

12 years of the same notification - thanks NetSuite 🙂

Does anyone facing any issues when using suitecloud cli for Nodejs this week? When I run authorize, I'm facing this error.

Does anyone know if it's standard behaviour when copying an invoice that has a linked created from sales order then a revenue arrangement is not created. We have users doing this which we are telling them not to do. But curious if anyone else has this. Also logged with support for their view.

Hi All, I need some help understanding an issue I am consistently facing during an Item Fulfillment CSV import. I receive the following error: Invalid issueinventorynumber reference key "16727839". Here is what I have already checked before posting: • The lot number 16727839 is active and belongs to the correct item. • The lot exists in the same location and same bin used in the import. • There is available quantity under that lot, so quantity is not the issue. • I verified the CSV file format → no special characters, no hidden spaces, no encoding issues. • I confirmed the lot number is not being auto-formatted by Excel (e.g., stored as number/text/scientific). • Field mapping in the Import Assistant is correct and points to Issue Inventory Number (Lot Number). Even after validating all these points, the import still throws the same error. So the usual causes (inactive lot, wrong location/bin, insufficient qty, formatting) do not apply here. Has anyone experienced a similar issue or knows what additional validation NetSuite performs on issueinventorynumber during fulfillment imports? Any guidance or suggestions would be greatly appreciated. Thanks in advance!

hi all. Curious to see if any others are running into issues paying for Netsuite Invoices in the new Netsuite 360 center. Im referring to invoices directly from Netsuite for my yearly subscription or licenses for my company. Prior to netsuite 360 i would be able to pay for all my open netsuite invoices at once. Now with Netsuite 360 i have to pay 1 invoice at a time. The "apply all" button flashes for a second and dissapears. I asked netsuite support and they said that you cannot pay for multiple invoices at once in 360. I personally think its a bug and they dont know how to fix so thats their default response. Would like to hear if others are having the same issues. Thanks

Is there an alert during Bank Reconciliation or Close Checklists that alerts you if a bank account balance/register balance doesn't match the GL? In May, an incorrect bank balance was recorded during reconciliation. The accountant recorded a balance that was $0.22 off from the actual bank account balance. From May until November, they have been recording the correct bank balance, but the GL does not match that balance now. We need to adjust the GL without changing the bank balance so the accounts will match. 1. Should there have been an alert in Match Bank Data saying there was a $0.22 discrepancy? 2. How do we correct the GL?

Hi NetSuite Professionals! I am really exited to share that we are hosting a free webinar on 12/10 on "*Script Forensics: Reconstructing the Complete Story from NetSuite Logs*" with goodr and TFR Solutions. By attending, you will: • Learn how to trace NetSuite customizations from logs to actual data changes • Understand script correlation fundamentals and confidence scoring • See real-world examples of how organizations troubleshoot production issues in minutes instead of days, generate compliance-ready audit trails, and optimize performance based on actual execution patterns https://vertical.bar/webinar/webinar-2-1210-script-forensics P.S. goodr might have a little something for attendees. You know, for your eyes.

Is it possible to create a custom approval workflow for EFT payment batches? By using a workflow or script (not the approval routing tab on the company bank detail record)

Hey all, random question but is anyone here an OCI expert?

Hi, our VP of accounting is looking at wanting Multi Book. Claims he set it up in 3 minutes at his old company in 2022. NetSuite itself says it requires a Professional Service or a Partner to do the implementation. I have never used it myself, but every thread online says to go with a partner for the implementation. Was it different back in 2022?

I've had this happen a few times now. When tracking down a permission issue (a search in this instance) after switching roles from admin to the users role I'm still able to access things. If I login as a user that only has the role I'm testing then I am unable to access the search. Is this normal behavior?

Heya folks, our small office is getting occasional errors from Netsuite saying "429 - Too Many Requests An error occurred while processing your request because the client has sent too many requests in a given amount of time. Slow down please." I read that these are Akami CDN errors. Has anybody found a way to resolve this without going through Netsuite Support? I'm pretty sure we are not sending a huge number of requests to Netsuite... so I'm not sure why we are getting these, to be honest.

Hi, does anyone know or receive the NetSuite yearly release quiz yet this year?

Has anyone managed to copy forms for custom record types to a different account (that already has the same custom record type deployed to it using SDF)? I used the Copy to Account feature, but the preview was empty and it seems the deployment just did nothing. Has anyone found a way that works? Unfortunately SDF can't do it. Is SuiteBundler more likely to work?

Does anyone have an alternative to Celigo for integration? Trying to pull data out of NetSuite into AWS

Hi team, one of the customers is using FarApp and now they want to turn on pick/pack/ship. What would be some impact on the FarApp side. I searched around and seems like there is a setting "*Check here if you have Pick/Pack/Ship enabled"* on the FarApp side that need to be checked as well. Anything else needs to pay attention to? TIA!

Is anyone having issues creating projects from a project template? We are getting an error & then no tasks are being assigned.

Has anyone made an Accounts Receivable dashboard? I’m having trouble building anything useful

Hi Team, Could you please tell me "How to create BUDGET record via suitescript ?" (Map/reduce). Cause record.create() dont support BUDGET record. Thanks in advance.

Hi, I am confused about the types of journal entries and how they show up in NetSuite. I read that transactions have auto-generated general entries, but I cannot access or see them in the Journal Entries list like manual JEs. What other behavior makes transaction-generated general entries different from manual JEs? i have only rad about this but wanted to be sure about if i understand it correctly

Hi, can anyone please confirm how approvals work for Time Bill and Weekly Timesheet in NetSuite? There are many options, and I am not sure how they all work together. There is Approval Routing, Workflows, and Advanced Approvals. From what I understand, Approval Routing is standard and only works for certain transactions. You define the hierarchy on the Employee record, and NetSuite handles the routing. I believe this also works for Time Entry, but not for Weekly Timesheets. The other option is Workflow. If Approval Routing is enabled, should we disable it before using a workflow for time entry approvals? Can both be used at the same time? This seems confusing because it may cause conflicts. Time also has two more approval options: “Require Approvals on Time Records” and “Advanced Approvals on Time Records.” I’m not sure what the difference is between “Require Approvals on Time Records” and Approval Routing — they seem similar to me. Advanced Approvals on Time Records provides more granular control, and also appears to use NetSuite’s standard approval process (Approve, Reject, Submit buttons). If we customize, we may need to hide those buttons and implement our own approval actions. Please confirm if I am understanding this correctly.

Hi, does anyone know what the difference is between Inventory Location and Location? In my case, the Sales Order has only the Inventory Location defined, location is blank. After the Fulfillment is created, the Item Fulfillment shows the location from which each line was fulfilled. why is the name of that field is not inventory location as this creates confusion? and the Invoice does not even show that field. I am trying to figure out how all of this ties together.

Hi! I have a query regarding SuiteQL. Here' the Dataset exported SuiteQL text for fetching customer's data. Upon running the same query in postman, I am not getting the City, and State fields populated. What could possibly be wrong? SELECT Customer.entityid AS entityid /*{entityid#RAW}*/, Customer.companyname AS companyname /*{companyname#RAW}*/, Customer.phone AS phone /*{phone#RAW}*/, Customer.salesrep AS salesrep /*{salesrep#RAW}*/, EntityAddress.city AS city /*{defaultshippingaddress.city#RAW}*/, EntityAddress.state AS state /*{defaultshippingaddress.state#RAW}*/, Customer.searchstage AS searchstage /*{searchstage#RAW}*/, Customer.custentity27 AS custentity27 /*{custentity27#RAW}*/, Customer.lastsaledate AS lastsaledate /*{lastsaledate#RAW}*/ FROM Customer, EntityAddress WHERE Customer.defaultshippingaddress = EntityAddress.nkey(+) AND Customer.phone IN

Hello. Am I able to insert a table in an email template where it can dynamically list the transactions I am sending using said template?

i dont know if this is correct

image.png

Is there a field to pull a locations last purchase price? If not I'd assume I have to do a sub query on the transaction table, and select the first record.