Hi David, NetSuite does not allow negative quantity in the Item Fulfillment record. In the UI, if a user tries to add a negative number in the quantity field of the Item Fulfillment, a pop up message will appear that says: Invalid number (must be positive). Hope this clarifies your concern. ?…

Hi Johnny, I got the message below in the Oracle NetSuite Support Community Inbox: Ivy, Thank you very much!! Now it works as before. Much appreciated! Johnny In future communication, it would be better to reply to threads instead of replying via email. Anyway, thank you for confirming that it works for you now and for…

Hi Johnny, The List View has a sticky feature and the previous saved search used as View mode when pulling up the item list might have had an invalid formula or summary, hence the error message when trying to pull up the item list again. To be able to use the correct saved search when viewing the item list, you must first…

Hi Harry, Here's the formula that the system uses to compute for the Work Order Lead Time when MRP is enabled: {Fixed Lead Time} + ({Variable Lead Time} * Rounded up ({Work Order Quantity}/{WO Lead Time Lot Size})) Below are the definition of the fields: Work Order Fixed Lead Time (Assembly Item) - Fixed days required for…

Hi @paula.courtemanche, How does adding the criteria Main Line = False affect the results of the search? Is it still showing duplicate lines or do some of the lines not show when you add the Main Line = False? Since this is a transaction search, try adding the following on the Criteria and check if it will help give you…

Hey there Kyle, Glad to have you back with us today! I am tagging my colleagues who specialize on this topic. @Jack Daryl O Espiel-Oracle / @Pauline Joy Cac-Oracle, any ideas? ? For our other members, feel free to comment your suggestions.

Thanks Micah! Hi Jessica, Upon checking my resources, I noted that it is not yet possible to close or void inbound shipments. Users only have the option to delete. This system limitation is logged as Enhancement # 476349 and you can vote for this via the SuiteIdeas page. Hope this clarifies your concern. ?…

Hi Jenny, I was testing this on my test account and this is the closest thing I came up with for the results tab: Formula: CASE WHEN {binonhand.quantityonhand} > 0 THEN {binonhand.binnumber} ELSE NULL END Since the formula field's summary type is Maximum, then it will show blank if there is no bin numbers with positive…

Hi David, Let me tag my colleagues @Erick Dela Rosa-Oracle and @Mikko De La Fuente-Oracle as they are the experts in SuiteScript and they can further help you out in this. ?

Hi @EarnestC, Glad to have you back with us today! This is called the Status or Transaction Status. You can check SuiteAnswers 9219 for the definition of the various Sales Order statuses. Hope this helps! ? ====================================== If you find this reply to your question as helpful, others with the same…

Hi Eunice, Upon checking my resources, I noted that the ability to close inbound shipments that are partially received is not yet possible in the system. This is logged as Enhancement # 476349 and you can vote for this via the SuiteIdeas page. Below is the documented workaround which you can try: Click on Receive on the…

Thanks for updating us, Jay! Glad that you have it working as needed! ?

Hi Jay, great job on finding the Reallocate Items page! I checked this on my end, and noted that the minimum requirement to access this page is at least Edit level on the Sales Order permission (SuiteAnswers 23475). So if the role has this permission, it will be accessible to the role. You may consider customizing the…

I found the following enhancements related to LTL in shipping integration: 50081 - Provide a shipping integration with freightquote.com for LTL or Light Truck Load shipments 85372 - FedEx Freight (LTL) Services > Allow Freight users with valid FedEx accounts to integrate with the Real Time Rate calculator Since the…

Thanks Erick! @JohnCirocco Thank you as well for your experience regarding this. ? Hi Tom @farrago, As suggested by John, you can try Pacejet. I also found SuiteAnswers 50731 which has an attachment that mentioned LTL is included in Pacejet. ====================================== If you find this reply to your question as…

Hi @dbetlow, Thank you for posting your concern here in the community! Since you mentioned that the price needs to be independent, then Kit/Package items are the most suitable for your requirement. I checked on my resources and noted that it is possible to add serialized items as a component of Kit/Package. In order to use…

Hi K, maybe you use the System Notes Fields... as a a criteria on the search: By doing this, you can have a list of items wherein the handling cost was updated.

I'm really happy that it's now working as required. ? I actually tested your requirement on my test account and I was able to create a Custom Item Field for Inventory and Assembly items which showed the total Qty in Planned Work Orders. For more information, refer to SuiteAnswers 31727 - Creating Custom Fields with Values…

Hi K, In Item Saved Searches, you can use the Shipping Rate. Note that Shipping Rate will pull up the sum of the Shipping Cost and Handling Cost fields. For other searches with item fields as joining fields, under Results tab > Columns subtab, select Item Fields…. In the pop-up window, select Shipping Rate in the Item…

You're welcome, Maurice! A big thank you as well to @CDuf for sharing about the website. ? Take care and happy holidays to you both! ?

Hi @VirtusX, Glad to have you with us today and thank you for posting your concern here in the community. Let me tag my colleagues @Erick Dela Rosa-Oracle and @Mikko De La Fuente-Oracle as they are the experts on this topic. To our other members, feel free to comment your thoughts regarding this.

Hi Liz, In the Item Record > Purchasing/Inventory tab > Shipping section, you can set the Default Shipping Method which is the shipping method displayed by default when adding the item to a sales order. It is important to know that this applies only when the Enable Line Item Shipping checkbox on the Sales Order is marked.…

Hi @Sonics, Can you try to add this expression on the Criteria: Add Item Source is not Phantom below Item: Is Phantom is false and enclose them in an OR expression. Let me know if adding this removes the Phantom Items.

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

To remove the Phantom Assembly, add this on the Criteria: Item : Is Phantom | is false Regarding your concern about the Column Assembly 3 Series, please note that the Quantity On Order column will reflect the Location Quantity On Order reflected on the Item Record. This column shows the Quantity in Approved Purchase…

I have also coordinated this with our expert on this topic. @Amir Alinaghian-Oracle -- we really appreciate your help on this. ?

Hi Maurice, Glad to have you with us today and thanks for creating another thread in the community! Upon initial research, I found SuiteAnswers 8044 which confirms that NetSuite does not support 1099–MISC forms. Instead, NetSuite provides customized saved searches to help you report 1099–MISC vendor payments to other…

Hi there Tim (@NetSuite4All), Glad to have you back with us here in the community and thank you for posting your concern here! Is the Vendor Bill posted on a closed period? I'm tagging my colleague @Shamaine Chan-Oracle who is the expert in this topic. Any thoughts on this? To our community, feel free to comment your…

Hi @User_6USCS, I checked this on my end, and noted that there is no functionality like this in the system. With Demand Planning, this might be possible since users can manually enter future demand in the Item Demand Plan record. The closest thing I can think of which might help is setting the Transactions to Consider…

Hi Liz, The Flat Rate option should be in the Shipping Item. ====================================== 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 able to aid the community to find the…