Hi Martha, Assuming that you have transactions associated with the items (even planning or inventory costing), you will probably not be able to easily (if at all) delete the existing items. If your customers are negatively impacted by an item number change, it is possible to create a different item type using the same item…

Just a couple more thoughts: When thinking about this, a Bin Search is where this needs to begin. The Bin table is the only place a complete listing of all the bins resides; so unless every Bin is assigned to a part or at least has an informal inventory record (assigned via a transaction), the Item Search and the Inventory…

I have not been able to find a way to link the appropriate tables in a way that eliminates all the erroneous data. Hopefully, someone else on the forum who is better versed in the database structure/programming may be able to come up with a simple solution. In the mean time, this is how I will determine available Bins:…

Good morning Paul, The setting is located at: Setup/Accounting/Accounting Preferences => Items/Transactions tab/Inventory sublist/"Use Preferred Bin On Item Receipt" check box. Regards, John

I use the term Inventory Location out of habit - you are referring to the same one @ Setup/Company/Classifications/Locations The Bins can also be flagged as Inactive @ Lists/Supply Chain/Bins I have worked on this is in the past and like you ran into inconsistent results. Your inquiry resulted in me picking it back up and…

Where are these set as inactive; Inventory Location level, Bin level, or both?

I'm sorry, yes this is an Item search. I have 4 locations and hundreds of BIns set up and some Bins have multiple Items in them (or did have). This search seems to work in this scenario. Is it possible for you to send me some screenshots of your search? John

Building upon Chris': See if this works for you. Sum the Bin On Hand : On Hand field (in case multiple item records associated with Bin) Summary type of Sum for Bin On Hand : On Hand field John

Hi Sean, Here is a listing of our Vendor Categories; probably not all are used. John 1099 ContractorCommunicationComponentConsultantContract ManufacturingDesignEducation/TrainingFacilityFinancialInsuranceMachiningMetalsPlatingProfessional ServiceRentalRepair ServiceSafetyShipping/FreightSoftwareSuppliesTax agency

HI Will, Thanks for your input! Oddly enough, this is what the applied filters after the initial query attempt to accomplish, but still resulted in multiple locations reported. I'll definitely take another look to see how this may work - I have some cost fields that are slightly different between some locations, which may…

Hi Robert, Thank you! This takes care of the majority of cases. I have some fields, that if added, still cause multiple locations to be reported even though their QOH is = 0. Most of the time, I can exclude them, so this will save the extra steps in Excel. I appreciate your help, John

Great! Thank you very much Robert.

From what I have seen, the Reschedule In and Reschedule out work, but only on Unapproved Orders. I do not understand the logic; perhaps this is still evolving. I need to train a buyer, who has never worked with an ERP system, to use the planning screens and this adds another level of checks to feel comfortable with NS…

I don't believe you can change your settings to prevent the duplicate planned orders. This is occurring because the Approved PO due date is outside of the Planning Time Fence. If the Approved PO due date was inside the Planning Time Fence or if this was an Unapproved PO outside (or inside) the Planning Time Fence, a…

Let me make some changes and see what happens. NetSuite logic is not very intuitive; at least not to what I am familiar with anyway. I interpreted that the Forecast from Demand Plan output was all inclusive -- would be nice to have some good examples within the documentation. I'll let you know the results. UPDATE Wow! This…

CDobbins wrote:For issue #2:If you do not use a demand plan, then consider using the "Entered and Planned Orders" option.=> I believe, without exception, sell items are set as "Entered and Planned Orders" and all dependent items are "Forecast From Demand Plan".For issue #4:Something is definitely wrong. Demand orders…

CDobbins wrote:1. Why does the demand plan not show any calculated demand for the 12 week projection?Let's mark this one as resolved.- Independent Demand: Demand Plan- Dependent Demand: Supply Plan=>Agreed2. Where is the August 2018 demand coming from; I reviewed and do not see any old orders that would drive this?One more…

Another option to accomplish BIN transfers within the same Location, if your accounting practices allow: Create a Transaction Inventory Adjust CSV Import file that performs a negative inventory adjustment from the existing BIN and then performs a positive inventory adjustment into the new BIN. The multi file CSV Import…

Unbelievable this basic inventory function does not exist. Warehouses are not static entities...

Hi, I started down this path, but had to put it aside before I came to a successful resolution. So, take this with a grain of salt - hopefully I am not sending you in the wrong direction. To gain more flexibility, you may need to switch to printing item labels using Advanced PDF/HTML Templates. Take a look at SuiteAnswers…

Good morning, I provided additional information and comments within the discussion to clarify things; and only a couple more questions. The thread is getting dense; I’ll try not to miss anything. => [Thank you, again, for taking the time to decipher and respond.] * 350-02799-0002 is a top-level assembly and has a demand…

I really appreciate you taking the time to help me out with this. It has taken me awhile to respond, as I reviewed what you said and performed more research. I must say that with 30 plus years of working with and implementing multiple MRP systems, this one is the least straight forward; probably due to what I think is…

Thank you very much for your reply. Please see below for additional comments. It just seems that something is "broken" here - the data makes sense in one screen and not in another; or the data is inconsistent between screens that should return like information. I have not checked additional items yet, but in the course of…

Thank you Robert. This test record is the first item/location that is changing to a supply type of Transfer. Do I have a correct understanding that this set at the item record level and while the location has a Bill of Distribution set up, it only comes into play when the item's location supply type is set to Transfer? Do…

Thanks again. John

Thanks for the reply. While that is an option, a basic metric such as the item standard cost should be readily visible on the item record. Since the location cost fields do not update until a transaction occurs, adding this field to the item record would solve the problem. I found the field, "Current Standard Cost", that I…

Yes, I am interested in this discussion. I have developed a process to handle this, but it is very time consuming to manage and requires the creation of both a WO and PO to capture both the component and contract manufacturing costs. The process also involves inventory transfers between our main location and a "Contract…

Hi, I am not sure if you found a solution, or if you are using bills of materials, but this is a solution that is working for us. It is not the most straightforward, but functional. A service for retail item is utilized to capture the outside process cost. At the time of creation, a decision needs to be made as to whether…