Hi @Amjad Kasem, Glad to have you with us today and 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. @Elychelle Gulen-Oracle / @Dominica Sevilla-Oracle / @Leonard Mallare-Oracle,…

Hi @JJ Lucarelli, Glad to have you with us today and 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. @Mikko De La Fuente-Oracle, any ideas? To other users, feel free join in the…

Thank you for keeping us updated with your progress on this one. ?

Hi @Atticus, The search provided here will not work for your use case since this is an Item Search which shows only those items that are still on hand. You can try to modify the "Inventory Number: is On Hand" and set it to "False". This will then show the serial numbers that are no longer on hand. However, note as well…

Hi @John Griffin, thanks for sharing your insights on this! ? ---- Hi @KNason76, I found a related enhancement request for this one which you can vote for in the SuiteIdeas page: Enhancement # 168834: Transactions > Manufacturing > Build Assemblies > Components: to have a pop up list to show the lot number/serial numbers…

Hi @User_HPB3I, Try setting it up under Customization > Forms > Transaction Forms, then look for the Preferred form for the Packing Slip. If you are using Advanced PDF Template, you need to change the Print Template and/or the Email Template to the new one you created. If you used Basic, then change the PDF Layout. You can…

The other logic that is included in the formula I provided are comparing if the following details in the Warranty Registration record and the related Invoice No. record are the same: Item Serial Number You can try exposing those fields to check which lines were filtered, but was supposed to be included.

Can you try and check the results which lines were filtered out? Maybe some lines did not use Account Type = Income?

You're welcome! Glad it works now on your end! ?

Hi @Jay Schwausch, Can you set the description of that Formula (Numeric) field to is equal to 1 instead of is not empty?

Hi @Jay Schwausch, Try adding this formula in a Formula (Numeric) field in the Criteria tab of your search: CASE WHEN {custrecord_wrm_reg_item} = {custrecord_wrm_reg_invoice.item} AND {custrecord_wrm_reg_serialnumber} = {custrecord_wrm_reg_invoice.serialnumber} AND {custrecord_wrm_reg_invoice.accounttype} = 'Other Income'…

Hi @Gavrah Rabba, Were you able to rerun this? Let us know if you have been successful in changing the Average Cost of the items or if you need further assistance on this one.

Hi @ssilveri777, Let us know if we were able to answer your question or if you need further help on this.

Hi @Charles B, Thank you for posting your concern here in our community! ? Allow our gurus/members to check on thus, and we'll get back to you with our findings. To other members, feel free to comment your insights on this as well.

Hi @Jay Schwausch, Glad to have you with us today and thank you for posting another question here in our community! Allow us to check this one and we'll get back to you with our findings. To our other members, feel free to share your insights on this one as well.

Hi @Sivasubramaniam, Let us know if you need further assistance (from NS side) on this one.

Sounds good! Let me know how this goes. ?

Hi @ssilveri777, Thank you for posting another question here in our community. A calculated measure is a measure that you can create in your pivot tables and charts using arithmetic operations with base measures. Unlike formula fields which are built at the dataset level to evaluate results on a row by row basis,…

Hi @Gavrah Rabba, Is the Positive Inventory Adjustment on a different date than that of the Negative Inventory Adjustment? Note that for the Average Cost to be corrected using this method, the Positive Inventory Adjustment should be dated at least 1 day after the Negative Inventory Adjustment. Also, make sure that the…

Just to make sure we are on the same page, please provide some screenshots of when using Administrator Role and the Custom Role.

In your Custom Role, under Forms tab > Transactions subtab, check if your Custom Invoice form is enabled.

Hi @Asher_123, Can you confirm what you meant by "the second form is not in drop down list"?

Hi @Roman S, Kindly check the comments of @JohnCirocco and @John Griffin and let us know if any of these resolve your concern. Note that since these are preferences, they might affect only on newly created transactions after the preference was enabled, so make sure to try it on new transactions or newly added lines.

Thanks for the update! I'm glad you figured out what was causing this behavior. By the way, if any of my previous comments helped in your concern, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community…

Hi @Gavrah Rabba, I went ahead and tried to replicate your scenario on my test account but was unable to reproduce the error. The CSV Import was successful and the Inventory Adjustment was created. For your reference, here is the CSV File and Mapping that I used: Kindly try importing a with similar settings such as mine.…

What I find weird is that the "Assembly To Build" field on your form is not mandatory. When I try to customize my Assembly Build form, the "Assembly" field is a required field: Can you also please check the Field ID of the "Assembly To Build" field on your custom form? Just to see if it is a standard or custom field.…

Can you share a screenshot of your CSV file? I'll try to replicate it on my end to see if I get the same error.

Can you share some screenshots of how your custom form is setup?

Is the Adjust Qty By column on your CSV file a positive or negative value?

Hi @JohnCirocco, Let us know if you need further assistance with this.