Hi @Ancana! Thank you for posting your question here! ? You need to set the custom template you created in Setup > Company > Email > Email Preferences > Templates tab > Customer Center Email Template. Hope this helps! ? ====================================== If you find this reply to your question as helpful, others with…

Glad I was able to help out, Roberto! ? I agree with you and I actually think this is a great idea for an enhancement. You can submit an enhancement request by going to the SuiteIdeas page. By doing so, other NetSuite users can also vote for this and it may be considered in future implementations.

Hi Roberto, Per checking, we can use the Rate field in the Inventory Count record to get estimated value of the variance. Note that this field is editable until the Inventory Count is approved, so users can make manual changes to this field. Based on testing, this field is auto-populated by the Location Average Cost.…

Glad I was able to help, Meherin! ? May I know if Product Line is a custom field on your item record? Also, are you referring to updating the Pricing Group on the Item Records? If so, then this can be done via Mass Update or CSV Import. Here are some relevant SuiteAnswers articles about these topics: 8429 - Mass Changes or…

Hi @Meherin, Thank you for posting your concern here in the NetSuite Support Community! You want to setup a multiple price levels for a customer: 50% discount for a product line (specific items) All other items will get 35% discount First thing, we need to create Price Levels. Go to Setup > Accounting > Setup Tasks >…

Hi @davidd039, Welcome back and thank you for posting your concern in our community! ? Based on my research, I have found that this preference does have a limitation when used with WMS. This limitation is documented in SuiteAnswers 87137: Releasing Orders to the Warehouse. On the Limitations section you can find “Allow…

Thank you for sharing the workflow you created, @paula.courtemanche! ? Just an added info, you can also set the default value for this field on Custom Transfer Order Forms. You can Edit the custom Transfer Order form and set the default value in the Screen Fields tab > Use Item Cost as Transfer Cost > Check Box Default…

Hi there Debbie @djg05478, Thank you for posting your concern here in the NetSuite Support Community and good day to you as well! ? I'm tagging our Guru with expertise on this. @Michelle Jabanes-Oracle, any ideas? Other members can also hop in this thread and share your thoughts that may help.

Glad to know that it is now working as expected! Thank you for updating us, David! ☺️

Hi @User_N55OM , I got the below details in the Oracle NetSuite Support Community Inbox: I checked my WMS version is 2020.2.0.4.a, not sure that last digit "a" make any difference, but I am still having this issue. By the way. when you mention Defect 590717 or any issue code, where can I find those? I search from NS but…

Hi there Pete! Please try this formula: CASE WHEN ({billofmaterials.name}) like '%24100%' THEN '24' ELSE '' END Let us know if this works for you! ? ====================================== If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the…

Thank you Pauline! Hello @paula.courtemanche, Thank you for providing screenshots! However, can you check as well the Transfer Order #EQP-MOV-SOCAL372 has the Use Item Cost as Transfer Cost checkbox marked? Note that the Use Item Cost as Transfer Cost preference found under Setup > Accounting > Accounting Preferences >…

Hi @Sonics! Glad to have you back in our community! ? Based on my understanding, you want to be able to do an Inventory Count for Available Quantity instead of On Hand Quantity since this includes Committed Quantity. Per checking, this is the standard behavior when doing Inventory Counts in the system. As per SuiteAnswers…

As per SuiteAnswers 94156, here are some of the most common reasons why the quantity is not committed on the Sales Order: Perform Item Commitment after Transaction Entry preference is not enabled Location column on the item line is blank Commit column in the item line is set to Do Not Commit There is a Special Order…

Hey there Bob @User_HMKHV! Glad to have you with us in the community! ? Please note that whenever a user edits an Item Record to change any GL account such as Asset, Income and COGS accounts, it will have a retroactive effect. If there are transactions from closed periods, user will need to reopen such periods to make the…

Hello Roberto @User_LAGAM and welcome to the NetSuite Support Community! Based on my understanding of your post, you want a way to compare the snapshot quantity and the count quantity on the Inventory Count before an Inventory Adjustment is created. Note that the Inventory Adjustment is created only once the Inventory…

Hi @User_N55OM, just wanted to verify if it Is still reproducible on the account with WMS version 2020.2.0.4.a? If so, then you might need to create a Support Case so it can be further investigated. ====================================== If you find my previous reply to your question as helpful, others with the same…

What I meant regarding the Commit column is this one: This is different from the Quantity Committed column.

Can you clarify please what you meant by: "...In one instance the SO is location1, and three special order items are location2." Do you mean that the Main Line Location on the Sales Order is set to Location1 while the Item Line location for 3 special order items are set to Location2? You can check as well what is set on…

If you are using the Drop Ship Purchase Order form, then maybe you can make use of the Ship To field under the Shipping tab. Per checking, this sources the list of customers. Then, on the Ship To Select field, you can select what address to use. However, if what you require is Ship To Address which is based from the…

Hello @JoshPNW! Glad to have you with us here in the community! Thank you for posting your concern here. ? First thing that came to mind when I read your concern is the Location that is set on the Item Receipt, Purchase Order and the Sales Order. When dealing with Special Orders, the SO location and Special Order PO and…

Hi there @User_N55OM! Have you had the chance to test out the plan that you mentioned? If yes, we'd appreciate if you can share with us what the result was. ? Also, I think that using the same UPS account number that you have setup under Setup Accounting Shipping as the 3rd party billing account might not work as you may…

Hi there Betty @User_65ZKL! Just want to confirm what address you are referring to. Is it your company's address (different locations) or the customer's address? Also, is this for a dropship/special order purchase order linked to a sales order or a standalone purchase order using a custom form which has the shipping tab…

I see.... so it was a custom record that was causing the error message. I'm glad that you were able to find the culprit and delete the PO! By the way, thanks for sharing this with us! I also tagged your comment as the best answer for this thread to help other users in the community to find the solution much easier, ?

Sorry, my bad. I thought you were not able to delete the Item Receipt. ? Anyway, a possible reason why you are unable to delete the Purchase Order is that there may be a custom field with field type List/Record or Multiple Select that need to be re-configured. This custom field might have been applied to other transaction…

One possible reason I can think of on why you can't delete the Item Receipt is that the Serial/Lot Number used on the Item Receipt is also being used/referenced to in another transaction. I think this SuiteAnswers article might help: 41077 Unable to Delete Item Receipt Let us know if it worked for you. ?…

No worries, David! These inventory mismatches or negative quantity are quite tricky. Anyway, let us know the results once you deal with the negative inventory quantity or if you would need further assistance with this. Note that I have also edited the discussion title so that other users who encounter the same error…

Hi @JCronin, I got the below details in the Oracle NetSuite Support Community Inbox: "I've looked at scripts and workflows and didn't find anything that should affect this. Everything I have looked at has fedex/more and a trucking company set on the Sales Order and the changed fulfillment. The Problem apparently is not…

I would, if I could. ? Unfortunately, I can't submit a vote for you. If you can't access SuiteIdeas, maybe you need to ask your account administrator if you can be given access. You may refer to SuiteAnswers 10038 - Accessing the NetSuite Account Center for more information. Hope you have a great day! ?…

Thanks for providing a sample format of what you require! However, upon checking, this is not yet possible when using the Inventory Valuation Report. This is logged and tracked in Enhancement # 94651 : Inventory Valuation Reports - ability to display value by location in columns for the selected date. You can cast your…