プロフィール
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.
コメント
-
That would be a NetSuite Kit item type. A group is nothing more than a collection of items that can be edited after the group is entered on a sales order..
-
For a Purchase Unit in Cases of 100 but stock and sell in eaches, see the screen shots below. The first screen is setting up the Unit of Measure (Lists->Accounting->Units of Measure). The second screen is the Item record.
-
I wish I had the link from my previous job. I was having issues where it appeared to incorrectly calculate preferred stock level and reorder point. We made a few changes then the support rep gave me a link that did the recalc in real time (all items, not just the one). If you contact support and ask real nice... :rolleyes:
-
Robert, Unfortunately they cannot go directly to Shipped. 1) They use both SPS Commerce and Pacejet for their EDI customers. Pacejet needs the order to be already fulfilled to Picked or Packed so it can get the number of cartons. 2) The "Inventory Adjustment" to fix is actually 5 distinct steps (because NetSuite "keeps"…
-
The cost it uses is based upon the Costing Method for the component at the time the assembly is built and what ever that value is.
-
Thank you! Do you have an answer for the second part of my questions about the reorder points & preferred stock level? Thanks again. Sorry, missed that... Since the Purchasing Unit is in Case 100, it "should" default to purchasing in cases. Unfortunately, the drop down is there such that a user could change it to the…
-
My customers have an Non-Inventory type item with a "Cost per Unit" (example Labor) of $1.00 They then specify a quantity of (for example) 25 Units to specify $25 per assembly
-
I had a customer do exactly the same thing. We used search to export out all the needed fields and reimported as Avg cost. We created a custom field on all items that we used for reporting. First rename all old items and use the original item number in the new custom field. We then imported all the items back and have the…
-
Curious how long ago you went live? It's not just Zero Value you may need to look at. If you have received anything in for those items, your value will not be zero but significantly less than it actually should be. Item XYZ - Purchase Price $.75 Original Inv Adjust Qty 50 at zero cost Another PO Receipt of 100 @$.75 Now…
-
If you use Bins then I believe the ONLY way is for a transaction to be delete after the fact. If you do an inventory activity report for that item, it "might" point you in the right direction. Also do Transactions -> Management -> View Audit trail and look for Deleted transactions during the month you see this happen. If…
-
Assuming this is an Item Search you are doing. If you want: Item # Warehouse 1 Available Warehouse 1 On-Hand Warehouse 2 Available Warehouse 1 On-Hand You can use the Decode function to group onto 1 line Results Name (Grouped) Formula Text DECODE({inventorylocation}, '1', {locationquantityavailable}) (Grouped) Formula Text…
-
We just delete the fulfillment when returned BUT you could Issue an RA. When the item returned, Complete Fulfillment, Invoice, Receive RA back to stock, issue credit and apply to short lived Invoice to get full audit trail. (Easier to delete the Fulfillment...)
-
One possible way: Do you already use Pick/Pack/Ship steps on a fulfillment? If you do not, you can repurpose one of the steps and change it to "On Trial" (we do not use Picked at one of my customers so we used that one). Do an item fulfillment ONLY to the on trial step. Your inventory stays in you warehouse but is…
-
John - Run Unrestricted does not blow through Subsidiary restrictions. Just Class/Location/Department restrictions. Bummer...
-
Could you do a custom sublist search attached to the item records and check the Run Unrestriced box to allow them to see. From the help: "Check this box to make search results available to users who normally do not have permissions to see the underlying records. This option allows administrators to provide restricted users…
-
They wanted to do a single count of their entire warehouse at year end and adjust the inventory as needed. They have advanced Bins turned on.
-
Are you joining to the Bin On Hand join or the Inventory Detail join?
-
You can go to Customization -> Lists, Records, & Fields -> Transaction Item Options if you want to specify on an order. If you just want to capture something like Color or Size you can create custom fields based off of a list.
-
The field Unit is just a reference to the type of units of measure available. Typical is Eaches (counted by a qty), Ounces (measuring items by wieght, Feet (by linear measure). You then have the units the item can be stocked in, sold in and purchased in. So if using your above example, under Units of Measure for the unit…
-
It is 1 location with 1,300 Bins
-
You might try looking at the Inventory Activity Detail report and adding the column for running balance
-
Actually, there is a report called Inventory Turnover that gives you a result of how fats items are turning over in your locations. Make sure he reads the help on how it is calculated. Run the report and on the results page, click help in top right corner. Inventory turns happens to be a financial metric...
-
You can print the picking ticket associated with a transfer order but not the order itself (like a Sales Order). Also, under related records you can get at the fulfillment but, alas, you have the ability to only print the Packing Slip.
-
That link just goes to main help page. Any ideas?
-
Jim, Good to hear. Let me know when it starts snowing there so you can visit the desert down here as "training"...
-
I believe if you reduce the quantity by 3 on the sales order, the PO will be updated automatically. Then add a line item for the 3 instock making sure it is not Special Order and you can commit
-
My customer has a very similar issue as you do. I am also trying to figure out how to use the Commit Orders function for them and am running into a weird issue. I enter the Location and the Order number that I wish to commit. I select the transaction type and check Reallocate Open Quantities. I have buttons at the top to…
-
Jim, Is the vendor marked as Preferred? If yes, what if you manually over-rode the reorder point? Does it show then? To see if happening for others, a quick search of Backordered >0 and On Order < Backordered should show.
-
Jim, First check to see if you have anything in Bin Putaway worksheet that might relate. If yes, run that. If not, check out the thread: https://usergroup.netsuite.com/users...nd-stock-count From that thread: We have had the very same issue and because the bin adds/changes/deletes do not log to the system notes we…
-
If my memory is correct, Yes, there is a setting under Setup -> Accounting -> Accounting preferences. On the order management tab, if you uncheck "Perform Item Commitment After Transaction Entry". If you uncheck that it then allows the Commit Orders function. It went too far to the extreme (no allocating anything) that it…