John Griffin Silver Trophy

Thanks Chris. This is worth pursuing; I need to check the Brady printer specs, but I believe it recognizes ZPL. John

In follow up; it appears NetSuite performs the automatic lead time calculations over the weekend time frame. John

Very powerful and useful tool!

Glad it worked out. Those types of issues can drive you crazy. John

Hi Chris, As a point of reference, are you able to IA out something less than the whole quantity; perhaps -186.0? John

I have confirmed that the calculation is performed for each receipt and averages up to the last 3 receipts. I cannot determine when the calculation occurs, but appears to be complete for my receipts through 6/28. I have receipts from 7/1 & 7/2 that are not in the calculation yet - will keep an eye on them to see when the…

HI, I was out of the office the end of last week and could not get back to you. Your settings look correct. How long has your NetSuite been live? I recall thinking it took a long time to start seeing calculated lead times. Do any items you are looking at have multiple receipts? And are the POs closed or fully billed? The…

Chris, I agree. I have also seen where the lead time is extremely exaggerated when you have a "Blanket" PO set up with multiple lines of the same item with weekly or monthly scheduled receipt dates. The lead time gets progressively longer at each receipt. John

A couple of things to check: Make sure the Lead Time and Safety Stock Per Location box is checked. Setup > Accounting > Inventory Management Preferences. Make sure that the POs have a Location associated with them. If those are not the issue, let us know. John

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…