Go after the Quantity Rcvd/Fulfilled. I believe that is only populated on the "prper" fulfillment line. It is also the 1 line out of the 3 that the account field is null

I am curious how you specify the parameter within the MS/SQL. Any insights?

Not sure of the answer to your question BUT just remember the new release is coming out soon so you can use the Release Preview as a sandbox.

Unfortunately you cannot convert an existing normal Inventory item to a Matrix Child Item. You will need to: 1) Rename the old 2) Recreate them as Matrix items 3) Move any inventory with value to the new item 4) Update any open Sales Orders and Purchase Orders with the new items 5) disable the old

You could do either but I prefer 1 for each case size. That limits the drop down on the Purchase Orders/Sales Orders to just the U/Ms valid for that item

If you are stocking them as both plain and also as Branded, they are in reality 2 different items. If you are doing the printing after a customer orders them, you could use a Kit Item which consumes the plain generic.

Yes I have. We created a custom field "Converted to Matrix" and then we used a script to move the inventory. I used CSV import to do open sales orders and PO's. I also created a custom field "Reporting Item". On the old item it pointed to the new. On the new Matrix item it contained its own item number. When we wanted to…

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.