Ivy Lopez-Oracle NSC Guru

Hi @Sutha G, I used ADD option. Hope this works for you as well!

[UPDATE] Badges are already awarded to those who have reached the following milestones: Attended 1 Webinar Attended 3 Webinars Submitted 1 Survey Submitted 3 Surveys Congratulations! ?

Hi @User_KMB3H, It would really depend on your company's process, but do note that IR from RMA will not affect your inventory balance if the Restock checkbox is not marked. Also, the amount on the GL Impact of the IR will depend on the cost of the item and not the value entered in the RMA. The value on the RMA will be the…

Thanks for the update, Chad! I'm glad to hear that the cost of the items are now showing as expected. ? If any of the above comments helped you, we would appreciate you clicking "Yes" on "Did this answer the question?" portion of that comment as it may also help us and the other community members track replies that are…

Hi Chad, I did some tests on my account and noted that the behavior is the Landed Cost is allocated to all the quantity in the item receipt I edited. This also triggered an Inventory Costing calculation which then changed the GL Impact of the Item Fulfillment. Note that the costing calculation on your account should finish…

Hi @User_KMB3H, Welcome to the community! Thank you for posting your concern here. Note that the RMA is a non posting transaction. It will only show as part of your inventory if you mark the Restock checkbox in the Item Receipt. To further help you out, I'm looping in our gurus who have expertise on this topic: @Shamaine…

You're welcome, @JohanvL! Glad I could help. ?

It is found in the field help of the FedEx Rates Type field under Setup > Accounting > Shipping > Preferences tab > Rates. Also in SuiteAnswers 9302: ========================= 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…

Thanks for sharing your insights on this as well, @Biomerics_Admin. Hi @JohanvL, Is the shipping cost printed when you print the integrated shipping label? I tested this on my test account, but the shipping cost was not printed in the label. Are you referring to a different label? Based on the documentation, if you select…

Thanks for keeping us updated, @Biomerics_Admin. Since you aren't the one who started this thread, I'll be marking my previous comment as the correct answer so that other members who will look at this thread will find the answer much easier. Have a great day!

Hi @Biomerics_Admin, Instead of using Created From: Memo, try using Applied To Transaction: Memo field instead. This should pull the Description field from the item line of the PO. Kindly try it out and let us know how it goes! ?

You're welcome, Chris! Glad I was able to help! ? By the way, if it's not too much trouble, we'd really appreciate if you can mark the “Yes” on the “Did this answer your question?” part below the comment/s that helped you in your concern. This will also help our other members in case they encounter the same situation. Hope…

The behavior is documented in SuiteAnswers 28147: When the item is later added to your inventory again, a linked COGS adjustment entry is also created. This COGS adjustment is triggered by any transaction that creates a positive inventory level from a negative one, including the ones listed below: 1. Vendor Bill 2.…

Hi @Sutha G, I was able to try 2 separate lines, and it worked with 1 file import. Here's the screenshot of the columns in my CSV file: And here's the lines of the Inventory Adjustment record that was created: Hope this helps! ? -Ivy

Hi Chris, Thank you for all the information you provided via private message. We noted that the item receipt had 2 separate item lines with different rates for the same item: 1st line - 25 qty at £6.29 ($8.45) 2nd line - 50 qty at £1.43 ($1.92) In the Inventory Valuation Report, it only showed 1 line for the Item Receipt,…

Hi Su, Glad that it works for you now! ? If it's not too much trouble, 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. The CSV file I used is…

Hi @Sutha G, This is the error I got when I tried to do an import using an External ID that is already existing in the system: Using the same mapping you provided, I didn't encounter any error when I used a different External ID. Anyway, were you able to try the import using multiple files? How did it go? Let us know if…

Hi @JohanvL, Please check what is set in your account under Setup > Accounting > Shipping > Preferences tab > Rates > FedEx Rates Type. In this field, you can select the type of rates you want to show and charge your customers. Note that this preference applies to domestic rates only. International rates are always the…

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…