Niks Blando-Oracle · Technical Support Engineer · Blue Diamond

Hello Rachel Sheng, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hi Betsy Vance, Yes. As per checking it seems that functionality is mainly used by businesses with Subsidiaries to help them with their Subsidiary Management.

Hi PaulFleetwood, As per checking the field help for costing method this is what I found: Meaning the Costing Method affects the cost in the Item Receipt and not the Cost of Sale in the Item Fulfillment. As per testing as per the Item Receipt follows the cost in the "Purchase Price" field in the Item Record or the…

Hi User_PNGR4, I believe you have the correct understanding. When a Gift Certificate is sold an unrealized income is recognized which increases the liability; and when redeemed it is recognized as a revenue which decreases liability. I will be looking into this further and will coordinate to people related to NetSuite…

Hi Kedalene, I couldn't find a documentation regarding this but I was able to confirm through testing that it is the standard behavior that when you update the Purchase Description field in the Item record, it does not automatically update the Purchase Description of the posted transactions. The change in the Purchase…

Hi Benjamin Paul - USA, Were you able to check my previous comment? Let us know if it was able to help in your concern, or if you need further assistance with this.

Hi Rumaysa Mirza, Let's see what could be causing this issue. Can you please send a screenshot of the result you are getting? It seems to be working on my end.

Hi @Rumaysa Mirza, Thank you for providing the saved search details. As per testing, what seems to be causing the issue is the formulas which include the ".id". Can you please try the below instead and verify if it pulls the correct data? Formula (Numeric) Formula: Enter case when {item.inventorylocation} = {location} then…

Hi @Benjamin Paul - USA, Thank you for the clarification. The cost of the Kit/Package still depends on the cost of its components. Since Kit/Package item inventory is not tracked by the kit, it is tracked by individual component members.

Hi @Eunice_C , Thank you for clarifying your concern. Since this involves creation of custom fields, I will be transferring this to a guru has an expertise in that area.

Hello Erez Storch, Thank you for creating this thread! Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi Benjamin Paul - USA, To update the average cost on the location level of the item record, create an inventory adjustment. For example you item currently has 50 qty on hand: 1. Create a negative inventory adjustment for TODAY'S DATE (To clear out the inventory). 2. Create a positive inventory adjustment for TOMORROW'S…

Hello Jeff Pineda, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hi Kedalene, Can you provide more details to help me better assist you? I am a bit confused with your inquiry, "Please advise is there any risk or consequences if User changes Item Purchase Description after CSV Import." You wanted to know if there's a risk on changing the Purchase Description? There seems to be no risk on…

Hi Wendy_M, I tried it using my test account and it works. Below are the screenshots of my saved search and the pulled out data. Criteria Tab: Results Tab: Data Pulled out: For Troubleshooting: Make sure that the Formula in the Criteria Tab is properly created. Make sure you have items related to items. I hope this helps.

Hi Eunice_C, Were you able to check my previous comment? Let us know if it was able to help in your concern, or if you need further assistance with this.

Hi @Rumaysa Mirza,, Were you able to check my previous comment? Let us know if it was able to help in your concern, or if you need further assistance with this.

Hi Alejandro Medina, Just following up. Can you send screenshots of your whole csv import? Thank you. Please make sure to redact any sensitive information.

Hello Wendy_M, Glad to have you with us today! Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, please feel free to share your thoughts regarding this should you have any.

Hi Benjamin Paul - USA, The price of a kit is not dependent on its components' prices and can be assigned several price levels. A kit sale posts revenue for the kit only, it does not post revenue for each component. Therefore, sales revenue appears on inventory reports for the kit, not the components. You can refer to…

Hi Benjamin Paul - USA, Unfortunately, we cannot edit the inventory adjustment record. If your concern is costing is it okay if you just edit the cost in the item record instead of editing the Inventory Adjustment record?

Hello Julien Mi Electronics, Thank you for creating this thread! Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi Eunice_C, Perhaps we can look at it. May I know what comes up once you've done the search above? We can start on that. You can also send screenshots and provide information of what data you expect to pull up and what currently is being displayed. Just be reminded to redact any sensitive information before sending…

Hi Wendy_M, As per checking the Enhancement Request this feature is still currently a system limitation. There is a documented Alternate Solution in the Enhancement Request, you may give it a try: Alternate Solution: 1. Create an item search 2. On the Criteria > Standard subtab a. add Type as a filter and set it to…

Hi Benjamin Paul - USA, The ability to update the Inventory Adjustment record through CSV import is not yet available in the standard NetSuite account. This is currently an enhancement request logged on Enhancement # 239738 You can go to SuiteIdeas page to vote for the enhancement. Apologies for the inconvenience this…

Hi Alejandro Medina, Can you send screenshots of your whole csv import? Thank you. Please make sure to redact any sensitive information.

Hi Eunice_C, You can try below saved search. 1. Navigate to Lists > Search > Saved Searches > New 2. Click Transaction 3. Search Title: Enter Title Example: Item Fulfillment per Item Sales Price 4. Click Criteria subtab 5. Click Standard sublist 6. Filter: Note: For every required Filter, use the drop-down menu to select…

Hi @Rumaysa Mirza, I agree with Tiru Chembeti, can you please provide screenshots of your saved search? Please be advised to omit any sensitive information before sending. Thank you!

Hello Joby Jacob DnA, Glad to have you with us today! Thanks for posting your concern here. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To our members, please feel free to share your thoughts on the thread.

Hello Eunice_C, Glad to have you with us today! Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, please feel free to share your thoughts regarding this should you have any.