You're welcome, Dallas! I'm always glad to help! ?

Hi Paul, If you use the Customer Saved Search, does it provide the complete list for you without timing out? The only problem you have with the Customer Saved Search is the Price not being shown in Sale Units, right? If so, can you provide the criteria you used on your Customer Saved Search? I'll try to further test and…

Hi @PaulFleetwood, Are you using Quantity Pricing Schedules? This might be the reason for the multiple lines in the search results. In the Pricing Saved Search, kindly try adding a Formula (Numeric) field in your criteria with this formula: CASE WHEN {customer.itempricinglevel}='Custom' AND {pricelevel} =…

Hi there @Hormese Paul, Have you checked SuiteAnswers 99471 - Packing Items into Cartons ? I have also checked in a test account, and in the Pack Station App, the users will be asked to select the Sales Order that they will pack. Upon selecting Sales Order/s, users will be shown a list of the items to be packed. At this…

Hi @paula.courtemanche, Upon further testing, I noted that using the Inbound Shipment to allocate the landed costs is also possible, even without the Supply Chain Management bundle. However, please note that the Landed Cost Templates are only available if the Estimated Landed Cost feature is enabled (this is part of the…

Hi Dallas, Just from the screenshots, I can't really see any difference between the items that could cause item 64646 to not be shown in the search. ? Can you verify if this item already has transactions for the location? Also, confirm if the other item has transactions as well. The next troubleshooting step would probably…

Awww, thanks Dallas! ? Showing the internal ID in the Purchase Order is possible by using a Custom Transaction Body Field. Here's what I did: 1. Go to Customization > Lists, Records, & Fields > Transaction Body Fields > New 2. Enter a Label 3. Type = Free-Form Text 4. Store Value = F 5. Applies To tab > check Purchase 6.…

Hi Dallas, For the Purchase Order: Internal ID, it should be the Internal ID of the Purchase Order that you are updating. May I ask if you are trying to add new lines or update existing line items in the Purchase Order? Can you try using the Internal ID of the Item for the mapping for Purchase Order Items: Item? Make sure…

Hi @User_OPUDV, That is unfortunate since the Scrap field is also not yet available in saved searches, so we can't compare it to other fields. If you are reviewing Work Order Close transactions, the only other workaround I can think of is to use the "Applied To Transaction" join fields to be able to get the quantity from…

Sounds good, Toanne! ? Let us know if you need further assistance with this.

Hi Toanne, I'm glad the information helped! ? We appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a great day! ? -Ivy

Hi @dle_35705, Thank you or creating another thread here in our community! ? I tested this on my end and was unable to find the "Taxable" field as well. Upon further checking, it seems that the field is not yet available in saved searches. This is tracked in Enhancement # 183917 - Ability to have the Taxable box available…

Hi @User_LYA61, Glad to have you with us today and thank you for posting your concern here in our community! ? Allow me to tag my colleagues who will be able to help you out on your concern: @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle / @Michelle Jabanes-Oracle, any insights on this one? Other members who have ideas,…

Hi Maurice, Glad to have you with us today! ? Our gurus who handle this type of concern will be reviewing your post and will reply to this thread for any updates. To other members who might have ideas, feel free to join this thread!

Can you share a screenshot of an Item Record > Inventory Locations sublist of another item (DCH273P2DHO) which is showing on the results of the search? Also, kindly add Inventory Location Available in the search results and try to run the search again. Send a screenshot of this as well. I just want to compare the…

Hi Dallas, Have you checked if the item meets the other criteria, like the Vendor Name, Vendor Code, Special Order/Drop Ship, Inactive and other custom checkboxes? Also, I have edited the screenshots you provided in your previous comment and removed the URL part of the browser. This is because the URL contains your account…

Hi Toanne, Can you check the Schedule Inventory Costing preference in your account? You can find it in Setup > Accounting > Inventory Costing Preferences. Verify if the costing is running every hour or on a custom schedule. You can check SuiteAnswers 65659 for more information about this. Regarding the GL Impact changed by…

I'm glad it helped! ? Kindly refresh the thread. There should be a Did this answer the question? and "Yes" link at the bottom of the comment. ?

Hello @paula.courtemanche, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern.…

Hello @rburns515, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you…

Hi @User_QHG6U, Have you been able to try out the saved search in SuiteAnswers 32302 or in the related thread? Let us know if it worked for you or if you need further assistance with this. We'd also appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped…

Hello @User_OPUDV, Were you able to try out the workaround provided in my previous comment? Let us know if it worked for you. We'd also appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community…

Hi @PaulFleetwood, Have you tried using a Pricing Saved Search? This type of saved search has join fields for both the Customer record and Item record. I tried it, and it seems that the Pricing search gives the correct price based on the Sales Unit. You can also check out this thread which is related to the Pricing Saved…

Yey! ? I'm happy I was able to help achieve your desired search! ? Hope you have a great day! -Ivy

Hello @BWM- Shem, Can you change the summary type of the Amount field? Kindly change it to Sum then check if it still results to multiple lines.

Hi @BWM- Shem, Glad that the formula provided worked for you! ? The other fields are not showing because they do not have any Summary Type set on the Results tab. Try using Maximum, Group or Sum as the summary type for the other fields, depending on the field type. For Text fields, you can use Group or Maximum, while for…

Hi @rburns515, When creating Assembly Builds, only the components of the Assembly are added to the sublist. There are no standard fields wherein users can enter the labor costs or shipping costs associated with the Assembly Build. There are 2 possible options I can think of on how you can approach this: Add Other Charge…

Hi @User_OPUDV, You are correct, this is logged as: Enhancement # 252217: Manufacturing > Work Order Completion > Please expose Operation, Quantity and run time fields to transaction searches and/or reports This enhancement also includes the Scrap Quantity in the transaction. You can vote for the enhancement in the…

Hi @paula.courtemanche, The Landed Cost Templates are part of the feature called Estimated Landed Costs. This feature becomes available if the Supply Chain Management SuiteApp (ID: 47193) is installed in the account. For a guide on how to install the bundle, please refer to SuiteAnswers 41906. If this bundle is not…

Thanks, Micah! ----- Hi @User_QHG6U, Have you tried the transaction saved search documented in SuiteAnswers 32302? There is also a related thread here in the community which you can refer to: Saved Search > Landed Cost per Cost Category per Item on Item Receipt Let us know if you need further assistance. Hope this helps! ?…