3956319 Newbie

Hello, The PO that will be generated through the Demand Planning is controlled by the Order Date generated in the Supply Plan. Currently the Demand/Supply Plan can only take Daily, Weekly or Monthly as the calculation period. The ability to select Yearly is still not possible. As for the maximum projection period, Demand…

Yes, Lot Numbers are included in the Inventory Count. The Lot Numbers are entered in the Count Detail column. Hope this helps. Thanks!

Hi, This is actually available for Demand Planning feature in NetSuite. When you enable this, you can set another Item on the Alternate Source Method field to base the calculation for demand. In details: "In the Alternate Source Item field, choose another item if you want to examine the historical sales of an item other…

Hello Laura, I see what you are saying. When you use Pricing Fields : Price Level and Pricing Fields : Unit Price on the Saved Search, the system will only show those where there is a value and therefore the previous solution will not work. On the other hand, you can use Other Fields on the Results tab and all Price Levels…

Hello Laura, I am not sure how you designed the Saved Search but if you want to show 0 instead of blank then this should be on the Results tab. Also, you need to use NVL({pricing.unitprice},0) if you are using an Item Saved Search. To illustrate, assume that I want to show Item, Price Level and Unit Price. Then to create…

Hello Jon, If you check the "Update Inventory Cost" field, then you can just mark the two Assembly Items. When you rollup, this will create the Planned Standard Cost for the two Assembly Items AND the three Inventory Items. Per the field level Help Guide, "Check the Update Inventory Cost box to set the standard cost of all…

I see what you are saying. On the Historical Analysis Duration you can only set the number of months from today's date and you cannot select a Start and End Date of the Demand Plan's Historical Analysis Duration calculation. In this case, the alternate solution is to create a Saved Search to show Sales per Month of an Item…

Hello Jim, Currently the costing method can only be assigned upon creation of the Item Record. The ability to change the existing costing method is still filed as Enhancement. The alternate solution is to mark the old Items as Inactive and create new ones where Costing Method = Standard. However, please note that…

By the way, the alternate solution is: Alternate solution: Create a custom field for the item price and show the custom field on the item label. 1. Create an custom Item label field at Setup > Customization > Items Fields > New. 2. Add the custom field as a custom element on the Item Label Layout at Setup > Transaction…

Hello, Using Demand Planning, the Order Items page (which defines how many of each item and when it needs to be created) is derived from the interplay of Item Demand Plan and Item Supply Plan. To verify, you can run Transactions>Demand Planning>Gross Requirements Inquiry page. In this page you can see how Beginning…

Hello Krish, Defect# 257500 has been filed for this. You can submit a case so that Support can attach this to the issue. Thanks!

Hello, There are a lot ways why these two reports will not be in sync. The Inventory Activity Detail Report lists all transactions where the Asset Account is used while Inventory Profitability Report lists all transactions where the Income Account is used. The difference will be caused by transactions where these two…

If you are using a Saved Search, you can use Formula(Numeric) = NVL({internalid},0) instead of using the actual field on the Results. What NVL() means is that when the field is null it will return 0 instead. NOTE: replace 'internalid' with the actual internal id of the field.

The Item Record shows Quantity on Hand including future-dated transactions while Bin Putaway Worksheet is based on the Date selected so this may be where the difference would come. Also, check if you have already created multiple Bin Putaway for the same Item. Another thing to consider is you may have negative Bin on Hand.…

Hello Brian, I apologize. There was a typo error on the Saved Search as 4d should be '= 0' instead of '=1'. As for the Work Order, your observation is correct. The Assembly is {item} at linesequencenumber = 0 while the components are {item} for the rest of the lines. Thanks!

If you these Items are using Average Cost, then another approach to this is: 1. Use Inventory Worksheet to reset Bin on Hand (moving Quantity back to null Bin) 2. Use Bin Putaway Worksheet to distribute the Quantity on Hand to the correct Bin Note that since this involves the use of Inventory Worksheet which resets your On…

Main Line Location field is actually the From Location. On Inventory Transfer, the system will create two separate lines for the originating Location and the moved to Location. Therefore, if you have one Item on the Inventory Transfer the second line the From Location while the third line will show the To Location. If you…

There is a related SuiteAnswers article (ID# 27027): "Creating a Saved Search to track total amount of allocated Landed Cost per Cost Category which may provide some insights on how you can generate a Landed Cost Reporting. If you want a report to show Transaction#, Vendor, Item, Amount (Purchase Price) and Amount columns…

Hi Andy, You can use this formula in your Criteria: Formula(Numeric) = CASE WHEN {isdefaultbilling} = {isdefaultshipping} AND {isdefaultbilling} = 'T' THEN 1 ELSE 0 END is equal to 1 Then, on the Results tab you can add Address. By doing so, only Addresses that are both the Default Shipping and Billing will show up. Hope…

Hi Aaron, I believe this is currently not possible through Saved Search and is filed as Enhancement# 124404. You can vote for this request though so that you will be notified if there are future workarounds. Hope this helps. Thanks!

Hello mchen, As what George has mentioned, this is by design. Please note that in SQL, you can have multiple rows for the same Item provided that there are unique values for each line. There is a documentation in our SuiteAnswers (ID# 26914) : Saved Search to track Quantity and related transactions for Transfer Orders…

Hello tavanpat, To ensure that you are using the correct internal ID, you can use any of the following methods: 1. Use the Formula Picker then select a specific field on the Field dropdown. Automatically, the internal id is copied which is enclosed in {}. 2. Use the SuiteScript Records Browser found in our Help Guide. 3.…

Hi Mchen, The Saved Search will display Quantity in Base Units while the transaction will show Quantity in Stock Units. In this case, you may be using Dozen which is why Saved Search shos 200 while Bin Transfer shows 16.667 (Conversion = 12:1). Currently, the ability to show Units of Measure in a Bin Transfer is still…

Hello Carlyn, You can create an email alert for changes in the Purchase Price on the Item Record. Please see below: 1. Navigate to Transactions>Management>Saved Searches>New 2. Select Item 3. On the Criteria tab add the following fields: System Notes Fields>Date = today System Notes Fields>Type = Change System Notes…

Hi mchen, Another approach is to modify your existing Customer List View then by adding a Filter for Zip and using contains instead of is as a paramater. By doing so, if a value entered is found within a given Zip Code then potential Customers will be listed. For example, if the Zip Code is 777030 then entering 777 or 770…

Hello Carlyn, Now for the changes on the Item Rate on the PO, this is not possible. The System Notes only tracks changes on the Main Line (header information) and does not track changes on the line items. As an alternate solution, you can create an email alert whenever there is a change on the GL Impact (although this may…

Hello Dan, The number of formula that you add on the Saved Search depends on the number of Location columns you want to include on the results. Therefore, if you do not intend the Locations marked as Inactive to be displayed then you skip this. Thanks! Hi there, Thanks for answering this question and also thanks to Natalie…

Hello, Quantity Backordered is actually a derived field. Therefore, you can use Formula(Numeric) = Quantity - Quantity Committed - Quantity Fulfilled or using Internal ID: {quantity}-{quantitycommitted}-{quantityshiprecv} Hope this helps. Thanks!

Hello Natalie, When Multi-Location Inventory feature is turned on, Location data (e.g. On Hand, On Order, In Transit, Committed, etc.) is displayed on a per-row basis when used in an Item Saved Search. The ability to use Location as a column in a Saved Search is still filed as Enhancement# 120472. As an alternate solution,…

Hello, For Hierarchical Inventory Locations, you simply use the actual Location Name (without the hierarchcy/parent). For example, if your Location is named Missouri : St Louis (i.e. St Louis is a sublocation of Missouri) then you can use Formula(Numeric) = DECODE({inventorylocation}, 'St Louis', {locationquantityonhand}).…