Hi @Dwight Schrute, When Multi Location Inventory (MLI) feature is turned on, changing values of fields in the Location sublist is not indicated in the System Notes. This is a known system limitation and is logged as Enhancement # 182106. Per further checking, I noted that there is a way to log the system notes of changes…

Hi Preethi, Were you able to get the PPV to show? Let us know if you need further assistance on this.

Hi @User_NC62U, Is the user trying to concurrently access to multiple NetSuite instances using the same email login? This is one possible reason why the user gets logged off. You can check SuiteAnswers 34570 for a documentation on this behavior.

Hi @Mathias_Netsuite, Glad to have you with us today. Thank you for posting another question here in our community. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Tagging @Micah Timbol-Oracle & @Katerina Winklerova-Oracle who will be…

Hi there @Jyoti Pillay, Glad to have you back with us today and thanks for posting your concern here in our community. ? Allow me to tag our experts on customization: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, appreciate your insights on this one. Meanwhile, can you check if the…

Hi @User_C6XDE, There is no defect for this, and I don't think there will be since this saved search (Type = Item Pricing) isn't even part of the list of the saved searches available to be created: Here's a short animated image on how you can add the Formula field: I also checked and there is no date fields related to the…

Thanks for keeping us updated! Glad I was able to help. ?

I just ran a test on this in my test account and it's working just fine. Here are the details of my testing: Item Record: Inventory Cost Revaluation Record: Item Receipt (Rate: 7.00): Item Receipt System Information GL Impact change: Old Value: Item Receipt GL Impact (current): Based on this, the entire amount is posted…

Sounds good! We'll be waiting for your updates. ?

Hi @User_C6XDE, Using that search can be a possible workaround, but note that the search results will show the history of the price changes in rows like this: By the way, adding "Item" field in the Results tab of this search results in an Error. To be able to add the Item Name to the Results, you can add a Formula (Text)…

Hi @User_NC62U, Please remove the extra curly bracket in the field ID:

Hi @User_NC62U, I noticed that on your formula, you used {memberitem.quantityavailable}. It should be {memberitem.locationquantityavailable} to be able to pull the quantity available per location.

Hi @User_C6XDE, I checked my resources on this one and it seems like this is not yet possible to get this information in a Saved Search. This is a known system limitation and is logged under Enhancement # 136721 which you can vote for in the SuiteIdeas page. At this time, there is no documented workaround for this yet. To…

Hello @User_NC62U, Can you verify please that the name of the location used in the formula is correct and different names are used in the 3 formula numeric fields? If you can, please send a screenshot of the Criteria and Results tab of the search and also the Location sublist of the Item Record that shows the different Qty…

Hi @suitethings_preethi, Please make sure that the costing is already completed. For steps on how to check this, you can refer to SuiteAnswers 84614: Ways to Check if there Is Costing Still Running.

Hi @Chad C, Try this formula and check if this will give the desired results: CASE WHEN NVL({locationquantityonorder},0)-NVL({locationquantitybackordered},0) > 0 THEN NVL({locationquantityonorder},0)-NVL({locationquantitybackordered},0) ELSE NVL({locationquantityonhand},0)-NVL({locationquantitycommitted},0) END

Hi @suitethings_preethi, This is documented in SuiteAnswers 63141: If an item uses Standard Cost as Costing Method and the purchase price of the Item on a Purchase Order is different than the Item's Standard Cost, the Item Receipt posts the difference to the Purchase Price Variance (PPV) account specified on the item…

Thanks for the update @KNason76!

Hi @Sivasubramaniam, Per checking, this is not yet possible. It is a known system limitation and is currently logged as Enhancement # 469797: Inbound Shipment > Bill multiple Purchase Orders > Consolidate in a single Vendor Bill for same Vendor. You can vote for this enhancement request in the SuiteIdeas page.

Hi @Chad C, This is not possible in the Inventory Back Order Report. However, you can create an Item Saved Search to get this information. Here's the details of the Item Saved Search I created: Criteria tab: Results tab: Formula used: CASE WHEN NVL({locationquantityonorder},0)-NVL({locationquantitybackordered},0) > 0 THEN…

Hi @User_RIB4J, Welcome to the community! We are glad to have you with us today and thanks for posting your question here! ? Kindly allow us to review your concern and we'll provide updates in this thread. To other members, feel free to share your insights on this as well.

Hi @Sonics, Glad to have you back with us today and thanks for posting your question here in our community. Kindly allow us to review your concern and we'll provide updates in this thread. To other members, feel free to share your insights on this too.

Hi @User_NC62U, I recreated the search you provided on my standard test account and had the same behavior. This is because the formula used is pulling the Location Quantity Available from the Item entered in the transaction line --- which is the Kit Item, and if you check the Kit Item Record, it does not have the Location…

Hi @Asher_123, I would just like to confirm if there is no more discrepancy after you received the items? Let us know if you need further help on this.

Hi @User_GE47I, Was I able to answer your question or do you still need help on this one? Let us know.

Hi @User_XQ321, Glad I was able to help. ? Just an added info, you can actually have "Primary Subsidiary: XXXX" or "Secondary Subsidiary: XXXX" in the Results by using a Formula (Text) field with this formula: CASE WHEN {msesubsidiary.primary} = 'T' THEN 'Primary Subsidiary: ' || {msesubsidiary.name} ELSE 'Secondary…

Hi @User_XQ321, Glad to have you back with us today and thank you for posting your question here in our community! I tested this one on my end, and here's the Results tab of Vendor Saved Search I came up with: I clicked the Subsidiary fields... then selected Name and Primary (Y/N) in the dropdown in the Pop up window:…

Hi @Charles B, Glad to have you back with us and thank you for posting your concern here in our community! ? Allow our gurus/members to check this one and we'll provide updates in this thread. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle: any ideas? To other members, feel free to share…

Hi @Keith Boatner, Based on SuiteAnswers 99527: Material Requirements Planning helps production managers schedule and place orders for items that depend on demand. Master Production Schedule helps you plan when and how much of an item will need to be produced. Currently, MRP and MPS has the same process and same behavior…

Hello @Janis001, Were you able to check my previous comment? If it was helpful in your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. Doing so will help other community members who might have the same concern find the answer easier and you will also…