プロフィール
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.
コメント
-
Forgot to Mention if you want the sales amount, you need to use the Account = NULL as those are the Fulfillment Lines that join back to the sales order Here is the criteria to get Empty Account Here is a screen shot of my test search for the Applied to fields for results
-
To filter just to the COGS account in a fulfillment search, you can use the "Account fields.." Join and use Type = Cost of Goods FYI - If you want to get the selling price from the sales order, you can use the Applied To fields... Join and get Item Rate or Amount for the revenue
-
Make sure you filter the lines to his your COGS account only (there are normally 3 lines for each Sales Order Line) then your "value" is the Amount (Debit).
-
If you are referring to the "General Ledger" report, I believe that you do not have access to that field because the line being reported is the SUM of the lines on that transaction for that account.
-
Instead of using the Custom Field, your search can use the formula to retrieve the same value which can also be used to calculate the Amount unbilled Unreceived quantity = {quantity}-nvl({quantityshiprecv}, 0) Amount Unbilled = ({quantity}-nvl({quantityshiprecv}, 0)) * {rate}
-
OK, I think I may have figured it out but would like confirmation as I cannot find this in SuiteAnswers. In order for an item to be available through the Customer Center: 1) The Display in Webstore box must be checked 2) The item must have a price for the Price Level the Customer has assigned
-
Kenny, Yes (see the last part of my comment above - "I seem to remember that you need to update with 1 component first with the Clear Sublists set to yes, then add the rest of the components with Clear Sublist=No") If you import with Clear Sublists=Yes, then for every line in the CSV it clears, so line 2 clears the line…
-
I know I answered this in the old forums but cannot find the thread here At one of my old customers, we did this with a Custom Record and scripting If I recall, the custom record was similar to: Vendor ID (because we purchased the same item from multiple vendors and they did not all give qty breaks) Item Break Qty Unit…
-
Correct, you would need a scheduled workflow then to store the value in another field (unstored fields ARE available in workflows) if you want to do any manipulation
-
Not sure if you are using the fields on the Location Record for "Make Inventory Available" or "Make Inventory Available in Web Store" If you are (for instance using "Make Inventory Available in Web Store") Create a custom item field for available using an item search Criteria: Inventory Location : Make Inventory Available…
-
Rachel, Is this created from a sales order? If yes, Is the sales order the same? Also, both fields are available for input. Is a user enters a rate and ALSO an amount, then they would see this warning: If they click OK, then you will get the miss matched values
-
One option is to set the Obsolete Date field on the components. Not sure if this applies to Advanced BOMs) If they were created incorrectly and just want to "fix", you can do a CSV import and use the CSV Import Advanced Option to Clear Sublists. Try in your sandbox OR if you do not have a sandbox, create a new "test"…
-
Well, If 1 requirement was to NOT create inventory, then no, it would not accrue quantities.
-
If you will not be using these items in a BOM/Assembly, just make them Non-Inventory Items for Purchase so you can add them to a PO.
-
Yes, @"michoel" has a great one for seeing the data on forms (in place of doing &xml=T) called netsuite-field-explorer And @davidsmith Has the Script export as well as a great one calls Show Field IDs where you can search a form for either a field ID or a field label and it will find anywhere on a form even if you are not…
-
Yes, definitely. If you use chrome, definitely check out the chrome plugin called "NetSuite Saved Search Code Export". You can create the search (using you and/or logic), save and run to verify what you created. Then go back to edit mode and there will be an "Export to Script" link in the top right. It will pop up a window…
-
GreaseMonkey is the one we used when I was at a previous company and even created something similar to the reconcile bank statement WAY before Netsuite had a suiteapp.
-
There is also a non-netsuite way if that is not possible. Check out the plug ins (depends on browser) GreaseMonkey and TamperMonkey
-
When using the Administrator role (and other highly privileged roles) , that person needs to log in with the Admin role and go to the settings portlet on the home page and use the option "Manage Access Tokens"
-
Yes. You would need to create a saved item search that will retrieve only the 15 items. Then on the Customize form page, under Sublist Fields, select the saved search in the Item Filter drop down.
-
One item with different units of measure.
-
Martha, We have a customized Inventory Activity report we use when this happens. Almost ALWAYS, it is a rogue Inventory Adjustment to add items back into inventory when A) the quantity On Hand was zero and B) The Inventory Adjustment did not have a Value for the adjustment. Just customize the Inventory Activity Detail and…
-
Here is what we do (works for us...) We have a custom item field for Case UPC code so we can report that to the customers on ASNs and Invoices. We have a workflow that will populate a custom transaction line field with the proper UPC. If the selling Unit of measure is Case, then we populate the custom Case UPC, If the…
-
The field ID for PO/Check Number is actually {otherrefnum} typically.
-
I know it is a few extra keystrokes but you could use "IS" and then use a wildcard like %Apple%
-
My first guess is that the field for Check Number on the results is different than the filter. Second guess (and this is a stretch) is that there is a trailing Blank???
-
It is normally on the Web Store tab. For the demo they must have moved to main page
-
Click your name in top right. When the list comes up, make sure that your production account is Checked as default
-
You actually should try the join to the "Inventory Numbers" on hand or available. That is by serial number (What they refer to as Inventory Number)
-
That's good. Normally a stand alone does. But apparently not if you copy one originally from a sales order. One new thing learned today!