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
-
When printing Picking Tickets, set the "Filter By" to Ignore Item Availability – The list shows all open orders regardless of the availability. You may also want to turn off Item Commitments on sales orders but not really needed.
-
Paul, I believe a workflow with an Event Type of COPY can be used to clear the fields needed. For the line item fields, you would need to use a Sublist Action Group to access and clear those fields
-
We have a custom field (based on a search) on the customer record with year to date sales(not stored). We also have another that is stored that is updated via workflow nightly so we can get sales by rep including customers without sales.
-
Sorry, miss read your post. That should be the report that matches your AP. Make sure you set the date in the filters.
-
Yes, under Reports -> Vendors/Payables -> AP Aging
-
there is a bundle from Suitesolutions called Effective Date pricing (166020) which is now free to download. You might need to contact you r account rep to have it made available.
-
OZLink also will take the scale weight and use on the Item Fulfillment.
-
Those are both great. Ended up finding this that also worked: <#if !record.linkedtrackingnumbers?matches("^00108.*")> So many ways to skin a cat (apologies to the cat lovers out there)
-
Learned something new, THANK YOU!. Never had a need to use the ordered by before.
-
Yes, if you are already adding workorders, instead of entering the items on an excel sheet, enter them into the BOM on the workorder and when you do the build, the inventory will be relieved AND you get an actual cost of goods.
-
No unfortunately. What is weird, when looking at the raw data (using @"michoel" great plug NetSuite Field Explorer), the fulfillment only shows the data on the packages but I get invalid field if I use that field name. And if I did the Created by, the raw data uses a field called {createdfrom.linkedtrackingnumbers} which…
-
my field ID is {trackingnumbers} which I substituted for trackingFieldID. Unfortunately I get Invalid Expression for al 3. Never been at understanding how that formula works but I will keep trying.
-
The official reply should be that you would need to create an Assembly Item that contains the "parts" needed. Then a Work Order BOM can be printed and handed over to get the parts. When the Work Order is build, the Parts are consumed. BUT given that a) you probably do not have light manufacturing and b) if this is a…
-
Thanks Robert. Now I just need to figure out what the " " actually is. It is not a space nor a <br> character. But it gets me much closer.
-
I am trying to create a formula that strips out the first of possible multiple tracking numbers So if tracking field is "1234567 4567890 89012345" I would want to return "1234567" Any ideas? I thing I need regexp REGEXP_SUBSTR but keep coming up with errors.
-
Is anyone of the SuiteGuru's monitoring this?
-
We are having a very similar issue. Also the old Undelivered Email gave a "Reason" as to why the email failed where as the new does not have that field available so we have no idea why the email failed.
-
If the role is Administrator or the role has the permission "Override Period Restrictions" under setup, then you do not need to open the closed period(s). Very risky though...
-
The Primary difference is if you drop ship items, a non-inventory item for resale can be drop shipped, whereas an other charge item is just that, a charge.
-
I believe its primary use is with inventory commitment on sales orders. In the help section for Inventory Allocation Preferences Item Commitment Transaction Ordering Select one of the following to determine which order will have items committed to it when there is an open quantity. * Order by Expected Ship Date – Commits…
-
One thing I see is you are supplying the Amount field (5 in first example), Qty (2) and Rate (178). 2 X 178 does not equal 5. That may be the root cause??? Just an observation
-
The line items set not to be fulfilled will be ready IMMEDIATELY for invoicing. Note, if you just go to Transaction, Sales, Invoice Sales Orders it will appear before the product has been shipped. We have a custom field on our orders (set via workflow) that sets a checkbox if "special charges" are on a sales order. That…
-
Odd, we just went live this morning and not happening here. Chrome Version 77.0.3865.120
-
Unfortunately you cannot convert so the Rename, Recreate is your option. Difference between Other Charge and Non-Inventory is (for the most part) is that you can mark a Non-Inventory item as a drop ship and can also specify a Drop Ship expense. If you do NOT want to fulfill either of those types, under preferences uncheck…
-
My guess is there is an assumption that you have staff on a Friday to deal with issues but not on a Saturday or Sunday. Not saying it is right, just a guess as to why on a Friday morning.
-
I assume you are not on 2019.2? This is what I believe you are looking for: Additional Filter and Sort Options for SuiteAnalytics Workbook Pivot Tables and Charts Prior to 19.2, workbook pivot tables and charts had limited filtering options. For example, you could apply measure-based and value-based filters to pivot…
-
@"PaulFleetwood" Yes, I figured the account out to point to our Inventory account. Also changed the quantity to be a formula nvl({quantity}, 0) not equal to 0 I also noticed the sorting quirk. When run in a subtab and the item has a lot of transactions it is a little cumbersome so I just made the Item filter be visible and…
-
@"michoel" - love this but having an issue. In criteria, it shows: "Account is" but no value. I am trying to do the same and get an error. Also, for item fulfillments, I am getting the 3 lines for each item (how NetSuite stores the data) and am assuming it is because I don't have the account criteria? Suggestions?
-
Agreed. I just wish there was a way to get to the Suite Answers page without login. I have a link to the main page to I could get to the contact support but since it prompted for a login, there was no way to be able to report the problem.
-
One thing, if a Credit Memo/Cash Sale/Invoice were created from another transaction (usually Sales Order) then they do not impact inventory. They only do if "Stand Alone". You "might" want to have search use Posting=True and Account=your inventory asset account(s)