プロフィール
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.
コメント
-
@User_KKDTH If you do not use Bins and the item is not serialized/lot controlled you can do an Inventory Adjustment worksheet If any of those are NOT true, then you can Inventory Adjust them out and then back in with the correct unit rate/average cost
-
@OliverK No worries! That is what the group is for
-
@User_GGRJN When we receive a large number of serialized items, we are able to have the vendor send us a CSV of the items with associated Serial Numbers. We do a CSV import into the Inventory Detail of the Purchase Order so that when the PO is received, the Serial Numbers are automatically created
-
@OliverK Sorry, but the only way I can replicate your fields is if it starts as a Transaction Search For an Item search, here is a sample screenshot (note my Item Number field is called Name): Now if I do a Transaction Search: If you scroll to the top of your search definition screen, my guess is you will see Saved…
-
Here is what looks "odd" to me. On a number of result lines, you are somehow join back to an Item record. If you change the second and 3rd and 10th lines from Item : Description to just "Description" Item : Item Classification to just "Item Classification" Item : Special Work Order Item to just "Special Work Order Item"…
-
@OliverK Would you mind posting a screen shot of the Criteria page? Also, is this an Item search?
-
Instead of the CASE statement, try NVL({item.quantitycommitted}, 0)
-
Martha, Take a look under Setup - Company - Email Preferences. Under the Email Options tab. It might be set to Do Not Send Emails (Or logged in user-which is the owner of the search)
-
When you add a new result field, scroll WAY down to the end and select "Applying Transaction ..." and that will get you to the join of the vendor bill. Here are the additional result fields:
-
If you start with a Transaction Search on Purchase Orders, that transaction contains both the Quantity Shipped as well as Quantity Billed Criteria: Results: If you need more data from the vendor bill, the Applying Transaction join will get you there
-
Josh, Definitely check out "Supply Allocations" SuiteAnswer 87874 I allows you to allocate future inventory from POs and Transfer Orders. We have just started using a few months back and is working as we had hoped.
-
We have been using Strongpoint https://www.strongpoint.io/ for about 2 1/2 years now and love it. Their Free version handles the documentation but we have the Change Management version which also includes Change requests and compliance reporting. If you already use a common Change Management system they can integrate into…
-
You should be able to add a Formula criteria Formula (Numeric) nvl({quantityshiprecv}, 0) - nvl({quantitybilled}, 0) is Greater Than 0 Along with Type = Sales Order Mainline = False Shipping Line = False Tax Line = False This should give you only lines that have been shipped but not invoiced
-
I sent you a PM with full screen shots of Criteria, Results and my data
-
@farrago It "should" still work. If you look at the GL Impact on a fulfillment when sold in your 10Pack, do you see the COGS lines there?
-
@farrago If you just need Quantities, you can do a transaction search on Item Fulfillments. If you include in your Criteria: Account: Type = Cost of Goods, you will return all fulfillment quantities of the KIT Components as well as when they are sold individually
-
Unfortunately you cannot change the NetSuite default screen BUT you can create your own sublist saved search and arrange the columns to what you like.
-
Actually if do 2 things you can still apply the payment 1) Make sure the Accounting Preference "Apply Payments Through Top-Level Customers Only" is UNCHECKED (it is under Setup -> Accounting -> Accounting Preferences - General - Accounts Receivable) 2) Create a Nordstrom PARENT account and use CSV to import that to each of…
-
Also, there is no way to join to the Item custom fields directly from a customer search.
-
@Toanne Here is our Subtab Search It is a Customer Search Criteria: Result Fields: Filters:
-
We did a similar view. Use a Customer Search For Criteria: Pricing Item is Not NONE The fields for results would be: Pricing Item Item Pricing Level Item Pricing Unit Price That should get you started
-
Currently no, BUT there are some great enhancements in the next release notes
-
You should have a new column called "Allocated Supply"
-
@farrago Actually 2 possible ways I use (probably more) but both are valid when Mainline = NO First option I find easiest Criteria: Applying Link Type = Drop Shipment Result field "Applying Transaction" has the PO If you do NOT use Special Order POs Criteria: Purchase Order is not - None - Then the field Purchase Order…
-
It is a new feature called "Supply Allocation" Setup -> Company -> Enable Features -> Items & Inventory Check out SuiteAnswers 87874 https://netsuite.custhelp.com/app/answers/detail/a_id/87874/kw/Supply%20Allocation
-
Funny, I just needed to figure this out last week. In a transaction search, do a join to "Project (Main Line)" Name gets you the Customer concatenated to the Project. Project Name is just the Project Name without the Custom field
-
I believe one of the reasons there is no official "Created From" is that a vendor bill can actually reference multiple purchase orders. We have an arraignment with our drop ship vendors to give us a summary invoice for Drop Ship Purchase Orders. So we now only have 1 bill in place of a normal 25-30 (if one for each PO)
-
Actually, you are importing into the 3 Landed Cost template Custom Records. The way I do it: We do ours in 4 imports: We have 2 custom fields on our items that, if populated, represents the amount of Duty and Freight once we know the values. We have a nightly search that retrieves items missing a landed cost template and…
-
Jim, If you edit your Custom Transaction Line Field, go to the Sourcing and Filtering tab. For Source List, select "Item" and for Source From, select your custom Item checkbox field Make sure the "StoreValue" is checked on the Custom Transaction Line definition otherwise you cannot see the value in a saved search
-
Yes, copy to account would be the logical other option. Too many restrictions. We have a number of Custom Segments, these fail if used in a Saved Search with Copy to Account. We have many third party bundles that are locked so if we are trying to move a related object, these tend to fail also. The help doc on Copy to…