Tapendra Singh Bronze Medal

Hi @Audrey G. Yes, NetSuite hard-blocks this specifically for Invoices. The error code APPROVED_1_CANNOT_BE_SET_TO_PENDING_APPROVAL_OR_REJECTED_STATUS is thrown at the engine level and there is no native way around it - even SuiteScript hits the same wall. This is Invoice-specific though. Other transaction types like POs…

Hi @Kevenale The Next Check Number field is a native integer field in NetSuite, so it will always display with comma formatting (12,345,678) and strip any leading zeros. The stored value itself is correct (12345678) without commas. A quick question first, are you seeing the comma issue on the actual printed check, or is it…

Hi everyone! Happy to be part of this community. I am based in San Antonio, TX. I work as a NetSuite Techno-Functional Analyst managing NetSuite across multiple subsidiaries. I primarily work across ERP, OneWorld, Manufacturing, WMS, SuiteScript, SuiteQL and building custom application and integrations using technologies…

Hi @Jet Zhang The Fixed Asset Transfer and Disposal form is a Suitelet within the Fixed Assets SuiteApp and the underlying scripts and files are locked, so unfortunately custom fields cannot be added directly the way you would with a native NetSuite record. I would recommend reaching out to NetSuite Support to see if there…

Hi @User_UFWLI Thanks for sharing! Could you please share the execution log ? It would really help narrow things down since INVALID_REQ can mean different things depending on whether it is throwing in the input, map, or reduce stage. Also were there any recent changes to the script or deployment around June 8th? Thanks…

Thanks for the tag @Clarisa De Torres-Oracle Hello @Mary Rivas I have used Unapplied Customer Payments for this in the past and it worked well. Just create the Customer Payment records and leave the Apply sublist blank. The credit sits on the customer account, shows up in aging as a negative in the CURRENT bucket, and when…

Hi @Kevin60175 This is a known platform limitation. NetSuite's Legacy Tax engine does not support independent tax codes for shipping vs. handling. A couple of things worth checking: 1. Are you on SuiteTax?If yes, handling can be taxed separately from shipping natively. If you're still on Legacy Tax, migrating may be worth…

Hi @User_APXUW We ran into the same issue and found two ways to identify the offending item without opening every pick task. SuiteQL (fastest): Run this against your wave in the SuiteQL tab: SELECT pt.id AS pick_task_id, pt.name AS pick_task_number, BUILTIN.DF(pt.item) AS item_name, pt.quantity AS pick_task_qty,…

Hi @Kevenale I think you already have it. Is the below formula not working? (CASE WHEN {account.type} = 'Income' THEN {amount} ELSE 0 END) - (CASE WHEN {accounttype} IN ('Cost of Goods Sold', 'Expense', 'Other Expense') THEN {amount} ELSE 0 END)

Hi @Bee Yook Looking at the script execution log, the flow appears to be: Work Order Completion > Transfer Order (ID: 18630106) > Item Fulfillment (SrcLocation=537) > Item Receipt > JE Creation (Approval) The error is failing at afterSubmit_JE_Approvals which is the last step. This suggests something upstream in the Item…

B

Hi @User_R01AW The amortization schedule only gets created if the template is attached to an approved Bill. Once approved, you should see the schedule number populate on the expense line and clicking it will show all 12 periods with amounts. Amortization journals do not run automatically by default. You need to trigger…

Hi Scott (@User_F5QAS) We run into this frequently as well. For customers on Microsoft 365, emails from NetSuite's shared sending infrastructure can get silently quarantined by Microsoft Defender. No bounce or NDR is sent back, which is why NetSuite shows a successful send and you never hear anything. Worth asking those…

Hi @Kevenale A Transaction Saved Search might be right approach here. There is a NetSuite Answer ID 89639 that walks through building a GP saved search, but it will need a few adjustments for your use case: Transaction Types: Include all relevant types (Invoice, Credit Memo, Vendor Bill, Vendor Credit) not just Invoices…

Hi @User_S8PAJ Can you check how your integration is setting the shipping address? Specifically: Why is it setting the Override checkbox? Is it populating the structured address fields (addr1, city, state, zip) or just the free form addrtext field?

Hello @Didik_Rohadi Could you clarify a few things: What is the source transaction type (e.g., vendor bill, prepaid expense, journal entry)? What exactly needs to be revised: the amount, account, date range, or something else? Are the amortization JEs already posted, or still unposted/pending?

Hello @User_G88KI A few things to check: TBA is no longer supported in SuiteCloud CLI v3+. If you're passing NS_TOKEN_ID and NS_TOKEN_SECRET, that's your problem. You need OAuth 2.0 M2M authentication. Your deploy step is missing the required environment variables. Every step that touches NetSuite needs both…

Hi @User_W8HUT That sounds like it could be a caching glitch or an issue with how the workflow evaluates under certain conditions. Since they were editing in the UI, did you happen to ask the user exactly what steps they took to make the edit? It would also help to know if your lock logic is using a standard workflow…

Hi @Richard Appleford OB If your custom role already has Full permissions for Sales Orders, the issue is likely a custom script or workflow throwing an error in the background during the CREATE/EDIT event, rather than a standard NetSuite permission blocker. A few ways to narrow this down: Check Script Execution Logs: Try…

Hi @User_K51C7 if you want to go the technical route, you can just use a User Event Script to automate this. You’d use the Before Submit Function event to compare Old Record vs New Record. Just subtract the old quantity from the new one and have the script set the value in your custom transaction line field. it works…