Thanks for the additional information. Is this behavior only happening in the Invoice form? or are other transaction forms affected as well? Like the Sales Order perhaps? I tried it on my test account but unfortunately was unable to reproduce the behavior you mentioned. Have you already raised a case with Support regarding…

Hi Loran, Another option is to check if a Custom Form is used in the Invoice, or if there are any scripts or workflows deployed in the Invoice record. If possible, you can also send us some screenshots of how it looks like in both Prod and in SB so we can further check on what might be causing the behavior. -Ivy

Hi @lilywu, Did my previous comment help in 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 have a great day! ?…

Hi there @User_XQCKI, Can you try comparing the value set in the Maximum Entries in Dropdowns preference in your Prod and SB accounts? You can find this under Home > Set Preferences > General tab > Optimizing NetSuite section. In this preference, you can enter the maximum number of records you want to appear in dropdown…

Hi @HertsChris, I further checked on what might be causing this. Kindly check the Item Receipt. Is there perhaps more than one item lines on the Item Receipt with different rates? It is possible that the system took the rate of the 1st item line first to calculate the COGS Adjustment. The formula would be: = (Ave. Cost at…

Hi Chris, If you can send me the whole Inventory Valuation Detail report via Private Message, I could further look into it for you. Just from the screenshot that you shared, it looks like there are a lot of times that the inventory went underwater. We need to get the running balance of the Quantity and the Inventory Value…

Hi @Sutha G, What is the exact error message that you are receiving? Also, since you use External ID as the unique key in your mapping, then the External ID in your CSV file should not yet exist in the system. We have a video guide on how to import Inventory Adjustments with Inventory Detail. You can watch it here: The…

Hi there @lilywu, For the Options field on the item line of the Sales Order, you need to select a Matrix Item. Check SuiteAnswers 28202: Matrix Items for more information about this. You also mentioned that you wanted to create a "smart assembly". Based on my understanding of what you discussed, you want to create an…

@HertsChris, Note that when you ship a sales order item when you do not have the item in stock it is known as an underwater sale. Inventory is in an underwater state when the on-hand quantity of the item is below zero. Whenever an item is shipped, even if it is underwater, an inventory costing calculation is initiated.…

Hi there @SWSearcy, Welcome to the community! ? Allow our gurus/members some time to check on this concern. Tagging our guru who will be assisting you on this: @Michelle Jabanes-Oracle, any ideas? Anyone else have insights or suggestions? Feel free to comment on this thread!

Hi @User_PXLWF, Did my previous comment help in 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 have a great…

Hi @User_JO77B, Regarding your concern on the Inventory Report, the costing might be slow or stuck (since you mentioned that it has already been days), so it would be best to create a Support Case in order for this to be further investigated as a potential defect (if already stuck). As for changing the avatar, there should…

Hi there @User_FHV73, Welcome to the community! We are glad to have you here with us! ? Regarding the concern, allow our gurus/members to check on this. Tagging my colleagues @Shamaine Chan-Oracle and @Dominica Sevilla-Oracle who will be collaborating with you on this one. It would also be helpful in our testing if you can…

Hi there @KNason76, Just want to clarify if what you are referring to is the Ship Complete checkbox on the Sales Order Shipping tab or the Respect Ship Complete option in the Filter By field on the Fulfill Orders page? Anyway, I did some tests in my account and here are my findings: Based on my test, I was still able to…

Hi @HertsChris, Generally, the COGS adjustment calculation would depend on the costing method set on the item record. You can run an Inventory Valuation report for the specific item and expose (specify the location as well) so you can have an idea on how the system calculated the cost. If you can provide us more details…

Yes, that is correct. We can't specify the inventory detail per line since we can only import sales order numbers and not the line items. That being said, check the type of item you are trying to fulfill. For Lot Numbered Assembly Items and Lot Numbered Items you must configure the inventory detail on your Sales Order…

Hi @User_PXLWF, Thank you for providing the error message you encounter. Error Message: "Please configure the inventory detail in line XX of the item list." As documented on SuiteAnswers 50033, this error happens if the Item being fulfilled does not have sufficient Available quantity on its Preferred Bin on the following…

Hi @Sonics, It is Transaction: Internal ID is -None-. I clicked the Post Comment button too quickly earlier, as I was excited to share with you my findings. I already edited my comment earlier as well as soon as I noticed my mistake. ?

Hi @Sonics, I tested this on my end, and here's the saved search I came up with: 1. Go to Lists > Search > Saved Searches > New 2. Select Customer 3. Under the Criteria tab, add at least the following: Transaction: Internal ID is -None- Status is Customer-Closed Won Note: You can add other filters if needed. 4. Enter a…

Hi there @Sonics, Thank you for creating another thread here in our community! Let me do some tests on my end, and I'll get back to you with the search criteria as soon as I can. Anyone else have ideas or suggestions? Feel free to comment on this thread!

Hi there @User_PXLWF, There is a link in the Import CSV page where you can download a sample file. You can check SuiteAnswers 9224 for more information on using this functionality. If you need further assistance, it would be much appreciated if you can send other details like what error message you are encountering and a…

As I've mentioned in my previous comment, changing COGS and Asset Account in Transaction records is not yet possible in the system. The standard behavior is that the COGS and Asset accounts used in transactions are those set on the item record. Since the account is linked to the item, it will be used to post the COGS and…

Hi Toanne, Thanks for the update! If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you have a great…

Hi @Biomerics_Admin, Upon checking, these enhancements have already been closed and released in 2021.2 version. You can check the discussion I created regarding the new preference:

Hi Kenny, By default, the view this page has the Main Line = True filter. You need to customize the view. Click the Customize View button Click the More Options button Ensure that the Available as List View checkbox is marked Under the Criteria tab, remove the Main Line filter (or set it to False) Under the Results tab,…

Hi Kenny, Are you referring to the Receive Orders page? or is it the list of Item Receipts?

You're welcome, Jay! Glad I was able to help! ?

Hi @Jay Schwausch, Try this: CASE WHEN {name} LIKE '540-%' THEN 'KVH P/N'ELSE 'REVIEW' END Hope this helps! ? -Ivy ========================= 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 “Did this answer your question?”, you’ll be…

Hi Toanne, Just curious as to why you still need to update the Planned Standard Cost record? If you upload new Inventory Cost Revaluation records for the items, then it will be the same as doing the revaluation manually via Transactions > Inventory > Revalue Inventory Cost. The standard costs of the item will be updated to…

Glad I was able to help! ?