Minha área
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comentários
-
Unfortunately this is not possible. I have a customer that as moving to SCA and needed all their items "converted" to Matrix. We ended up exporting all the item attributes and re-importing as Matrix Child records. We renamed all the old items first before importing. We also added a new Custom field on the items for report…
-
I have a customer that uses at least 90% including SCIS and SCA and then have some that barely use 50% at present but they just went live April 1. The balance of them are also in the 75% range.
-
If you add directly to an item fulfillment, it is just a "value" going to a Landed Cost category
-
We have custom fields on our items for Case Quantity which we then populate on the sales order line. We do the math in another Custom Field via workflow to divide the quantity by the case quantity to store the number of cases.
-
This sounds exactly how NetSuite Item groups would function. If the PTO kit component is marked as a drop ship item, NS will generate a separate drop ship PO for each item in your example.
-
you could try Case when {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} > 0 then {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} else 0 end
-
We had the "As of Date" the same and the period was closed when it was initially run. I even ran a search to see any transactions created in April with a date On or Before 3/31/19 with zero results... Odd...
-
Yes, easiest way is to create another custom field (as stored) and a scheduled workflow (which can read unstored fields) and populate the Stored version of the field.
-
It's handled exclusively within PayPal like any of their other user options (like PayPal balance, credit card within PayPal. Bad news is, they do not give you metrics on what the customer selected. You have to infer from your sales metrics whether you think it is generating additional sales.
-
Instead of Country, you should have Shipping Country.
-
Also, FYI, I believe you could have included the customer name in the results and used the tab Recipients from Results. That way they would only get the segment needed for them?
-
Anybody? Bump...
-
Well, One important issue is that you can only setup DKIM email signing for one domain.
-
Sorry for the false alarm. In all my years dealing with Customers, I have never had one with the Marketing Preference checked to have new entity records default to Soft Opt-Out. Once I realized that and flipped the setting on the contacts, they all showed. The warning (incorrectly showing) that I did not have that feature…
-
We have the DKIM setup. I know most of these are invalid addresses as my custom imported a ton of contacts from a "list" they purchased. I just want the repeated entries going to the bounced email list. I look at my stats and do not see any additional emails going out and since they are Opted OUT, NetSuite should not be…
-
This one is great (at least it was for me...) https://netsuite.custhelp.com/app/answers/detail/a_id/21517/kw/Lead%20Nurture
-
You must be using ODBC. Try doing the initial search using a saved search. Not sure if ODBC might be different.
-
I am doing a 3rd party integration between CData & Netsuite. I am trying to access data from SalesOrder_ItemList (a CData table). This generates: Your formula contains a reference to a field for which you do not have a permission. I am wondering what permissions I need to add to role I am using. I have added every sales…
-
I am assuming it is a custom record? So under Custom Record under permissions, you can add that table.
-
That is why I added the "Assuming the Invoice is created the same day as the fulfillment..." part... As long as what has been shipped is also invoiced it will give you the gross profit of that partial shipment. If you only want to see completed orders, you can add the Criteria CreatedFrom.Status = Sales Order-Billed
-
I was only making an assumption that it was a custom record. I do NOT know CData or how it stores the data.
-
I have been able to convince my customers to do the profitability by sales order (assuming the Invoice is created the same day as the fulfillment which we do via workflow) Search would be transaction search type = Item Fulfillments, Invoices, Cash Sales Posting is True add a date range if needed Results Created From…
-
They should be in the normal transactions table. If you go to Transactions, Purchases, Receive Orders, List. Bring up a receipt and note its Internal ID. (?id= in the URL) Create a Transaction Search and have one Criteria: Internal ID (Number) and set it to the internal ID of the receipt noted above. Click preview. Does…
-
Go after the Quantity Rcvd/Fulfilled. I believe that is only populated on the "prper" fulfillment line. It is also the 1 line out of the 3 that the account field is null
-
I am curious how you specify the parameter within the MS/SQL. Any insights?
-
Not sure of the answer to your question BUT just remember the new release is coming out soon so you can use the Release Preview as a sandbox.
-
Unfortunately you cannot convert an existing normal Inventory item to a Matrix Child Item. You will need to: 1) Rename the old 2) Recreate them as Matrix items 3) Move any inventory with value to the new item 4) Update any open Sales Orders and Purchase Orders with the new items 5) disable the old
-
You could do either but I prefer 1 for each case size. That limits the drop down on the Purchase Orders/Sales Orders to just the U/Ms valid for that item
-
If you are stocking them as both plain and also as Branded, they are in reality 2 different items. If you are doing the printing after a customer orders them, you could use a Kit Item which consumes the plain generic.
-
Yes I have. We created a custom field "Converted to Matrix" and then we used a script to move the inventory. I used CSV import to do open sales orders and PO's. I also created a custom field "Reporting Item". On the old item it pointed to the new. On the new Matrix item it contained its own item number. When we wanted to…