Thanks @"4200533"! Can you verify the location you selected when running the Supply Plan? Is this location associated to a Vendor designated as an outsourced vendor? From what I've tested, this error is reproduced if the location in the supply plan is not designated as an outsourced location and the BOM Revision includes…

The formula would be in units. The formula above would include all sales orders 2 months prior from today and divide these by 60 days to get the average units sold. May I know if SO001-38746 was the only sales order for the item last 2 months? Oh! And can you also reattach the photos/screenshots? seems like it was not…

In troubleshooting the gl impact of inventory transactions, you may use the Inventory Valuation Report 1. Navigate to Reports > Inventory/Items > Inventory Valuation > Customize. 2. Under Filters tab, set the following fields: a. Location = Specific location of the Work Order Issue b. As of = Date inclusive of the Work…

May I know the Demand Source of your Outsourced Assembly Item? On my testing, I used an Assembly Item with a Demand Source of Forecast from Demand Plan, I created a Demand Plan first for the said Assembly: When I run the Supply Plan, the system then generated a Work Order based on the demand plan and the on hand of the…

Sure thing! My bad, I didn't specify which type of saved search * Navigate to Lists > Search > Saved Searches > New * Click on Transaction * Under the Criteria tab, select the following fields in the dropdown* Type > then select Sales Order (or other transactions you would like to use as your sales base) * Formula…

Hi @"lisaham", This is interesting, @"Shamaine Chan-Oracle", do you have any inputs on this one? Other users can also join the thread ! Let us hear your thoughts! @"Herdi Rana-Oracle"

Hi @"Martha Hakes", the estimated extended cost in the Gross Profit feature reflects the cost estimate at the time the of the transaction. The said field provides the snapshot value of the cost estimate which is derived from the Cost Estimate Type upon creation of the record. You may refer to SuiteAnswers: Est. Extended…

Wow! Thanks@"JCirocco" for your input! Hi @"Nairolf", At first glance, what I could think of for this is the usage of the Multiple Units of Measure to allow the stock, purchase and selling units be different based on your use case. This, however, would convert the cost, not having their own cost per units of measure.…

Hi @"4200533"! Let me try this one on my end Just to confirm, you would like to know if the supply plan can generate Work Orders/Purchase Orders for the Outsourced Assembly Items right? After my testing, I'll be updating this thread with my insights. @"Herdi Rana-Oracle"

Same sentiments @"Nairolf"! I understand the efficiency this would provide in the business processes . Nonetheless, you may visit SuiteIdea to file an enhancement request so that our product managers can consider this in the future releases. @"Herdi Rana-Oracle"

I was able to check on this one. With my testing and verification, there are no LPN function in the NetSuite WMS bundles. You are correct that the closest functionality in WMS is the usage of cartons. This, however, is limited to outbound processes after picking, in which its purpose is for the shipment itself. With your…

That's good news! Glad the report is what you needed For other references as well, you may refer to these articles: Inventory Valuation Report Inventory Valuation Detail Report @"Herdi Rana-Oracle"

What I could think of for this matter is for us to have a saved search that would show us the Daily average Sales prior two months wherein the Item has no available in the said location. This would, however, can retrieve information real time, meaning it would pull out the items with no available by the time we run the…

I'm still looking into this On top of my head, we can pretty much pull out the average daily sales of an item. However, what I am concerned with is the parameter '2 months previous to running out of inventory'. The reason for this is because historical stock outs/back orders cannot be traced backed through reports/saved…

Glad to be ofhelp @"4283453"! @"Herdi Rana-Oracle"

Pretty much spot on @"4283453" Without the shipping method (shipping items) you cannot set the shipping cost/rate for the order @"Herdi Rana-Oracle"

I don't see any issues in that one. However, should you use the item in a sales order transactions and there would be no shipping items yet, users cannot set a shipping rate for the said order. Nonetheless, the two aspects (shipping method and the GRI) complements each other but is not a prerequisite of one another @"Herdi…

Let me check this @"Nairolf"! On top of my head, cartons in WMS will only start on the picking process (unfortunately, LPN is not a feature available in the WMS core design). I'll double check that as well Other users that had implemented different processes for the said use case? Feel free to share your thoughts! @"Herdi…

Hi @"Nairolf"! With regards to the SCM bundle's Item Substitution, may I know what issues you are currently facing? Are there any errors you encountered when trying to utilize the said functionality? @"Ilija Budimir" thanks for your blog post! That is really informative If you have any insights to share as well for the…

Preferred Location in essence, is populated by users so that if the item is entered in a transaction, it would default to the said Location. Users may always override this if needed. For instance, if I have Item A, with Location 1. If I entered Sales Order, the location would default to Location 1. If the said order should…

Hi @"3677020"! May I know in which transaction the GL impact is not seen? Sales Orders and Work Orders (since you are using special work orders) are non-posting. The GL impact that will be reflected in the books is upon Assembly Build (if WIP = F) If the Assembly Build has no GL impact, you may need to check if there are…

Glad to be of help! @"Herdi Rana-Oracle"

With regards to your first question, I think this can be done by setting the When ordered by Field. In your search's Results: The Item Rate is set to Maximum, in which the When Ordered By field is set to Date. This would return the rate of the transaction with Maximum Date (the latest transaction) (see: Using When Ordered…

Just to provide my input, based on my understanding, the rate's decimal precision in your Sales Order is not enough in your use case so that your custom field/order would show the desired Total Amount. The decimal precision for Sales Orders in the Item rate would be 8 decimal places. I think you mentioned that the decimal…

Hi @"Wendy Branham"! Let me check this one on my end On top of my head, the best report that would show you the inventory cost movement of the items would be the Inventory Valuation report. I'll double check if the Parent Matrix is exposed in the said report and not just the child matrix. Other users who have customized…

Unfortunately, if the item is associated for multiple subsidiaries, preferred location should be blank. This is as designed. The reason for this is because when users assign a Preferred Location in the Item Record and the item is used in a transaction, NetSuite will not be able to use that Preferred Location across all…

Hi @"Martha Hakes", The creation of the reallocate recommendation in 2020.1 version will be available if the Supply Allocation feature is enabled. Can you verify if the said feature has been enabled in your end? You may refer to the following articles as well in testing the functionality of the Supply Allocation (let me…

Hi @"e25bd062-f80b-4000-ba69-fd18c36bfb5e"! Let us see if this is possible through saved searches. Nonetheless, do you have specific parameters in determine the lost sales? (e.g. do you base these to Sales Order transactions that are closed? Or Sales Order that has backorders?) @"Herdi Rana-Oracle"

You're welcome @"Shelli"! @"Herdi Rana-Oracle"

Hi @"kschraft"! Thanks for creating this thread! Let me endorse this to our Guru who specializes in this area. Other users may also jump in and share their insights! @"Herdi Rana-Oracle"