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.

Hi everyone! I’m trying to list Journal Entry transactions using a SuiteQL query. The same query works for other transaction types, but it returns no results for Journal Entries. I suspect this might be a permission issue. I’ve already added

Make Journal Entry: View

and

Journal Approval: View

, but I can’t find a permission explicitly called

Journal Entry: View

. Has anyone run into this before, or knows which permissions are required to query Journal Entries via SuiteQL? Thanks in advance!

i noticed that i cant summaries certain column in Saved Search, mainly join fields. this is a new change?

Is there any way to edit the Approve Journal Entries screen when using a Workflow?

Hey! Has anyone had luck connecting Celigo to NS for Amazon Vendor Central to download shipping labels? If so how long did the project take to complete?

hello, has anyone here figured out a process to automate the run of allocation schedules?

what might be the reason of getting rcrd_doesnt_exist when using record.load and the record already exist in netsuite and the id and type passed properly?

is there way to avoid copy to accounts adding translations to saved search after it is copied?

Can someone please confirm that it's not possible to set this up in MRP? If Location A requires stock, take it from Location B if there's stock in that location. Otherwise, raise a PO in Location A. It appears that the supply source is either a TO (through Planning Rule Group) or a PO/WO but never both for a particular location.

Hello everyone. If you are interested in

PARTNERSHIP

with me, please DM me. What you need is to have some basic NetSuite development experience and open mind. I have rich experience in NetSuite technical side Thank you in advance.

How many decimal places do percentage fields use?

Hi everyone, I’m looking to connect with NetSuite users who have experience with multi-tier or hub-and-spoke deployments (for example, separate regional NetSuite instances consolidating into a single corporate or group NetSuite environment). I’m interested in comparing notes on real-world experiences and exchanging learnings. If you’ve worked with this type of setup, I’d welcome the chance to connect. Thanks in advance.

I am looking for some advice or possible ways to handle this issue, we have a very large complex workflow that every sales order goes through, whether it was manually entered or created via an EDI transaction. This workflow does a bunch of evaluations on the sales order and if it finds a match it puts the sales order into Pending Approval for someone to review, when this happens, the order basically stops moving through the workflow until it is Approved, either by click a button on the sales order or manually clearing a certain field. There are times when a large number of sales order gets put "On Hold" and someone will use the "bulk" Approve Sales Order screen. The issue is, this sets the order to Pending Fulfillment, but the order never completes the workflow, and there are actions in some of the final states that are needed to flag the order and enter values in certain fields that are used to perform other actions, such as communicate data back via EDI. Has anyone or does anyone know how I can get the sales orders that get "bulk" approved to run and complete the workflow.

can our suitecommerce my account site pick up orders created from netsuite or shopify or is it only website orders? the internet said website orders but that's not making sense to me. I created an order in Netsuite, went over to Suite Commerce and the order isn't there not even old historical orders.

For anyone who's ever stared at NetSuite logs trying to piece together what actually happened, we put together a webinar on reconstructing the full picture from script execution data. Happy to share the recording if it's useful. https://vertical.bar/webinar/webinar-2-1210-script-forensics

Hi team, hopefully quick one - do matrix items play nicely with WMS and Smart Count?

is there an import option for doing inventory counts? dealing with ~11k item skus and multiple locations here.

Hi All, Does anyone know how I can update the Group Invoices checkbox on a customer record? I tried using a CSV import, but the field doesn’t appear in the mapping options. I also attempted a Mass Update, but the field isn’t visible there either.

Anyone using NetSuite and doing business in Denmark, how do you handle Denmark specific accounting requirements? NetSuite is not certified for Danish accounting, and SAP neither.