プロフィール
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.
コメント
-
I just found that if you set the Output Type to "Report" it also removed the links.
-
This might be a stretch but how about: 1) Create a test customer with a shipping address to the location you want 2) CSV import a quote/estimate for each item on its own quote and specify the shipping method you want to use. Not sure if the calculation of freight will occur but worth a shot. If it works you could just…
-
Group the lines by Document Number and Item with a Count of LineID. On the Criteria, SUMMARY tab, use Count of LineID greater than 1
-
Did that from memory so the join names may be wrong...
-
I'll be darned. Just imported a test quote into my demo account with UPS Next day and it matched exactly shipping amount from a manually entered quote. In hind site I would date the quote with an expiration in the past if you currently use quotes so as not to make the sales manager crazy or screw with your analytics. This…
-
In criteria Formula Numeric Case when {transaction.item} <> {transaction.displayname} then 1 else 0 end Is equal to 1
-
i ALWAYS have to futz with it...
-
On results, how about: Name Summary type GROUP Formula (Currency) - Summary type SUM, formula= nvl({memberitem.averagecost}, {memberitem.cost})*{memberquantity}
-
We actually created a custom checkbox field that we populated on the memorized transaction that we then used to report. Short of that, the Context of a memorized transaction is "usually" Bulk Processing. If it is an automatic memorized transaction the user is -System- but if it is set as a reminder, the user is whoever…
-
Using Summary Criteria will do it: Main Criteria Type = Sales Order Main Line=False COGS Line=False Shipping Line=False Tax Line=False Summary Criteria Count LineID Greater than 1 Results Document Number Summary Type=Grouped Line Sequence Number Summary Type=Count You can add a date filter if you need it on criteria
-
I am assuming you are doing a Customer Search? For Criteria If you go down to the Joins, you will see Billing Address... Under that Join you should see "State/Province" As a side not, are you using the Sales Territories? (Setup -> Sales -> Sales Territories). You can set up the rules by State (or many other fields like…
-
Under Communications tab, you should see "Messages" usually as the first tab. As for saved searches, unfortunately they are different tables. You could create a Customer Search for Messages, Activities or events but a single Customer search has joins to all of what you normally see under the communications tab.
-
Not sure at all if this might be it BUT... Do you have a custom Address Form that might possibly not be showing the State/Province? I am not at a location to check NetSuite but I have seen stranger things
-
It is definitely something that could be done via scripting. Had this at a previous place I was at.
-
Something like SUBSTR({zipcode}, 1, (LENGTH({zipcode}-3))
-
Never mind, I found the "Is Lot Coded" field. Doh...
-
Interesting, I JUST posted almost the exact same question. I thought this used to work also.
-
Darned, knew it would be easy... Thanks! I don't do summary criteria nearly often enough.
-
Thanks... ya I was actually considering trying that, just making sure I wasn't overlooking some more obvious solution. Might try it with a closed PO to keep the transaction joins the same type of record, then criteria would be Open POs OR this one closed PO. I'm no expert on what is best for load time of report....will…
-
The formula went something like: DECODE({transaction.type}, 'Purchase Order', CASE WHEN NVL({transaction.quantityshiprecv}, 0) < {transaction.quantity} THEN {transaction.quantity} - NVL({transaction.quantityshiprecv}, 0) ELSE 0 END)
-
That's exactly what this search should do. (The last row in the results). That rocked! I am not sure why I could not get the Applied To working before (unless I was starting at the SO?) but it is exactly what I needed. Thanks again and sorry for the confusion.
-
Sorry, I was not paying attention. I will give it a shot...
-
John, yes, finding out both...
-
I know this is going to sound a little nuts but I had the same issue back in 2010. What we ended up doing was to create a "fake" $0 Invoice to a dummy customer whenever we created a new item. That way you could create your item search using the Transaction Join including both PO's and Invoices so you will always get at…
-
When you created a Filter for Lot code, you can specify multi-select.
-
JohnCCole , I tried to create a custom transaction column field, store data was off but for the life of me I could not find a field to source from (Item Rate and Amount didn't work). To make matters worse, when I had it as Store Data False, could not make it show on fulfillment form even though it was checked to be…
-
Michoel, Thanks. If you look at initial question, I am trying to get the Sales Amount from the Sales Order so I can calculate actual Profit at time of fulfillment.
-
Oh, and another interesting bit... When viewing the XML of the Fulfillment, there are 2 fields for each item the DO link back. <orderdoc>345989</orderdoc> <orderline>2</orderline> Orderdoc is the internal ID of the Sales Order Orderline is the LineID of the Sales Order
-
This should work... CASE WHEN {item.class} IN ('Implementation Services', 'Consulting Services',, 'Managed Services', 'Third Party Implementation', 'Third Party Consulting', 'Third Party Managed Services', 'Third Party Services', 'Training', 'Professional Services', 'Residency', 'Service Desk' THEN {altsalesamount} END Me…
-
You hit the nail on the head there JCirocco I had no idea I could create a custom field on Class. That would have saved me so much time writing these CASE WHEN statements. Thank you! You are very welcome. That is why this group is so helpful!