Mi contenido
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.
Comentarios
-
We do this today for our kits and assemblies under a sublist tab on our inventory and assembly items as either can be a part of a kit. Criteria: Type=Kit/Package, Assembly/Bill of Materials Inactive=False Results: Name Display Name Type Member Item Member Item: Display Name Member Quantity Filters: Component Item with Show…
-
Really???? You may have just saved my sanity. Will try tomorrow. Thanks.
-
Setup -> Company -> Enable Features In Enable Features: Company tab, scroll down to "Data Management" First entry
-
Ours turned out to be a DKIM record we added to our MX records. NetSuite sends the emails as coming from my domain but their IP address of their servers does not refer to our domain so google rejected. We have temporarily removed the records.
-
Robert, Thanks VERY much!
-
Yes. When I select filter I receive only one record (correctly) as the example it only has had one price. Also added a filter for UPC code in place of alternate number and the same results happen. If I filter on UPC, the the correct result are returned but if I enter netsuite number the results are still doubled.
-
OK, So instead of looking at transactions and seeing what items are on it I decided to look at items and then to see what Sales Order transactions they had. Same exact results are happening. Criteria: Transaction: Type - Sales Order Transaction: Date - 9/1/2012 through 9/30/2012 Transaction: Status - Sales Orders: Billed…
-
Do the search over the sale and use amount fulfilled? When looking at fulfillments you are not really fulfilling the kit, but the members. The Sales Order lists what was sold (the kit) and should give you the expected results.
-
If looking for the number of line items, group on sales order, mainline no, taxline no, cogs line no and shipping line no. Create a formula(numeric) field with a formula of just "1" and use count on summary. If looking for total quantity, use above but substitute the quantity field for the formula and sum that.
-
My search that I use is with Main Line=No because we have different margin targets for different product line. Revenue is Amount Cost of goods is Est. Extended Cost Margin is a formula = ({amount}-{trancostestimate})/{amount}
-
Kelly, Sorry it took so long to reply. Was at RetailAnywhere training last week. Thanks so much for the solution. I had never used DeCode before. Now that I know what it can do I might be very dangerous now... My last problem may not be solvable. We have a significant number of drop ship items that do not show up on the…
-
Kelly, Awesome. Never noticed the Transactions... join or used it before. Giving it a shot now. Thanks VERY much for the example!
-
I am still recovering from the conference. Great time, great people and learned a lot. Cannot wait for suitecommerce... Ok, the GL entries are definitely going to cause a snag but first things first. It is my understanding that for inventory items the cost comes from the average cost value of an item. Cannot remember if…
-
What I would like is to have a summary level (lets say customer sales totals) drill down to a summary level of items sales dollars. Then the ability to drill into that.
-
So simple yet Brilliant.
-
This is perfect for Excel because of formulas (especially date formulas). Start by doing a saved search and I assume you are creating sales orders directly from NetSuite storefront or manually entered, so include the date value from the system notes which also includes the time stamp. On criteria, select System Notes :…
-
Yes, unfortunately if doing in a saved search you get different results than if you are starting with a "View". To replicate, try this. Go to: https://system.netsuite.com/app/accounting/transactions/transactionlist.nl?Transaction_TYPE=SalesOrd and click "Edit View" in bottom right.On the available filters tab, go and add…
-
To see if an item is a matrix child, you can use the parent field on results. If not empty it is a child matrix item. Do not know how to designate parent.
-
We have a saved search giving us the top items over the last month. The user does have the ability to change the date range as well as sort by quantity or dollars. Criteria: Type is Sales Order Date is within previous one month Main Line is false Status is none of Sales Order:Cancelled, Sales Order:Closed Shipping Line is…
-
Rafe, Actually I believe they only DO go to admins. I just asked a couple of users who get production emails if they receive any with Beta in the subject and they said no. Also I receive them to my email and they have the original users name in the subject. Now if you are creating emails based upon a script and not just…
-
I created a custom field on the item record called Purchase Unit Divisor and then in my saved search results use a CASE statement. CASE WHEN {custitem_purch_unit_divisor} IS NULL THEN 1 ELSE {custitem_purch_unit_divisor} END) Every night I have a saved search alert the item team when they have entered an item with Units…
-
Interesting... I just tried to change my search to use your code. If I have a Formula(Numeric) of COALESCE(TO_NUMBER(REGEXP_SUBSTR({purchaseunit},'[[:digit:]]+')),1) it returns either 1 or the number just as you state. Now if I want to get a "cost per each" and just divide the purchase price by the above formula I get a…
-
I tried yours and got an error but got me close. {lineid} was invalid for me but this worked: Formula (Text) Count CONCAT({internalid}, {line}) Glad I followed this thread...
-
Although I think the chances are VERY slim it is still good practice so I tried to change. Using {internalid} || '_' || {line} did not work for me. Strange... But I did get this to work: Formula (Text) CONCAT({internalid}, CONCAT('-', {line})) Either way I learned something very useful today. Thanks. Didn't mean to hijack…
-
Good catch. I had gotten burned on count when mainline=yes and didn't dawn on me when reading your initial question. Sorry...
-
Add the field Internal ID to your results and under Summary Type select Count. When you run the search, all you will get is the total number.
-
I have had the same issue when I have a search that works and I then try to add filters on the footer and it will not allow yet is I recreate from scratch the check box is available.
-
Try using a formula(Date) in the criteria??? I seem to remember that worked.
-
Depending on the field/values, your best bet is probably a workflow.
-
Chris, I don't believe you can populate the second field until the record has been saved (unfortunately)