Ivy Lopez-Oracle · SCM Guru · Red Diamond

Thank you for letting us know, Jessica! ? We'd 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! ? -Ivy

You're welcome, @dle_35705! I'm glad I was able to help! ?

Hi Jessica, Just wondering if you were able to hear back from UPS about this.

Hi Igor, Have you already done the Bar Code Setup for NS WMS for either Composite bar code or GS1 bar code? If not, then you can check the following SuiteAnswers articles for information about how to do this: 91417 - Bar Code Setup for NetSuite WMS 87054 - Creating Composite Bar Code Templates 91419 - Setting Up Custom…

You're welcome, @Tina_the_AP Guru! I'm glad I was able to help! ? We'd appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a great day! ? -Ivy

Hi @Tina_the_AP Guru, Glad to have you back with us today and thank you for posting your concern here in our community! Kindly check the item type of those other items that you are unable to receive. If they are Non-Inventory Items, check if the "Can be Fulfilled/Received" preference is enabled on the Item Record >…

You're welcome, @Martha Hakes! ?

Hi @BWM- Shem, I agree with @Dominica Sevilla-Oracle. In saved searches, that is the standard behavior. The closest I could come up with using the NS_CONCAT function is something like this: The formula I used: Item: REPLACE(NS_CONCAT({item}), ',', '<br>') Description: REPLACE(NS_CONCAT({item.description}), ',', '<br>') The…

Thanks for the update, Jessica! ?

Hi @BWM- Shem, Per my understanding, you want all the item descriptions in the invoice to be contained in only one row or one line. If so, then you can try this for your Results tab: Formula (Text) = NS_CONCAT({item.description}) The results should look something like this: You can add other fields in the Results as…

Hi @David_NSI, I looked for another way to remove a duplicate Item Receipt, but found none. The only way is to delete the duplicate Item Receipt record, but as you mentioned that this is not possible since the period is already closed. You can reopen the period in order to delete the transaction, but we do not recommend…

Alright! As I am also not an expert on customs and international shipping, I'd love to know what you did to resolve the error and be able to ship the order. I'm sure that other community members will also benefit from this in case they encounter the same error.

I tried to search for related cases or issues with the same error message you provided, but only found very few results. The only issue I found was filed last 2012 and was already fixed. There is also only 1 related case, wherein they made use of the code "70" in the field in the Item Fulfillment. The number 70 is from…

Hi @User_LMOEN, Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other…

Hi Jessica, I was not able to find any documentation regarding In Bond Codes in our SuiteAnswers articles however, upon further checking, the requirement of In Bond Code for shipments is a case to case basis as part of import/export regulations. It's possible that this is required because your shipping to Australia or the…

You're welcome! I'm glad the information provided was able to help! ? If it's not too much trouble, we'd appreciate if you can click the "Yes" on the “Did this answer your question?” in my previous comment. By doing so, you’ll be able to aid the community to find the solution much easier and faster. Have a great day! ? -Ivy

Thanks for providing the formula, @User_K4KNC! Kindly check if the formula that you paste in the Formula (Text) field is complete. When I tried it on my test account, the formula you provided got cut. It seems that the Formula (Text) field has a character limit of 4000 and when I checked, your formula has more than 5000…

Hi Andrea, If you have a Purchase Contract with the Vendor which indicated the price breaks or the Quantity Pricing Schedules, then you can use the Purchase Contract field so that it will be applied in the Purchase Order which will be created from the Order Items page. If you don't have a Purchase Contract record, or if…

Hi @User_K4KNC, I did a test in my standard test account, and I was able to confirm that it is possible to show the results of 2 Case When statements in the same column of the saved search. The Invalid Expression might have something to do with the formula/syntax you are using. You can share the formula here so we can…

Hi @User_LYA61, Glad to have you back with us today and thank you for posting your concern here in our community! @Shamaine Chan-Oracle and @Dominica Sevilla-Oracle will be helping you out on this one. To other members who have ideas or suggestions about this, let us know by commenting in the thread! ?

Hi @User_K4KNC, Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other…

Hi @User_EKY01, Thanks for creating another thread in our community! Allow me to tag our gurus who will be helping you out: @Micah Timbol-Oracle / @Patrick Fresnosa-Oracle, need your expertise on this one. ? Other community members may freely share insights here as well

Hi @dle_35705, Glad to have you with us today and thanks for posting your concern here in our community! Let me coordinate your concern to our gurus who have expertise on this. In the meantime, you can check the following SuiteAnswers articles: 30666 - Payroll Errors During Setup 21223 - Common Payroll Error Codes

Hi John, I'm glad you were able to track down the field affecting this and thank you for updating the thread! I'm sure that this will also help other members who might encounter the same behavior. ? -Ivy

Hi @User_5KM0Q, I believe you have 2 options to resolve your concern. 1. Edit the transaction wherein the serial number was entered incorrectly (this might not be possible if the transaction is already in a closed period) 2. Create 2 Inventory Adjustments - 1 negative to remove the incorrect serial number and 1 positive to…

The only preference that users can change regarding the rates used in UPS Integration is the one found under Setup > Accounting > Shipping > Preferences > Rates > UPS Rates. This is where users can select either Standard List Rates, Retail Rates, Daily Rates or UPS Negotiated Rates. This will then be the basis of what…

Hi @Martha Hakes, There are accounting preferences which affect the item's commitment on orders. These are found in Setup > Accounting > Accounting Preferences > Order Management > Sales Order section: However, these preferences will apply to all items. The ability to apply these preferences to specific items only is not…

Hi Tom, Note that the shipping cost in the webstore is also based on the UPS Rates preference which is setup under Setup > Accounting > Shipping and the Discount Rate entered on the Shipping Item. Also, as documented in SuiteAnswers 9284, the real-time rate quoted at the time of sale is only an estimate. The actual charge…

Hi Dirk, I checked on this, but there seems to be no standard/native way to limit the decimals for the quantity on Work Orders. However, this may be accomplished by using scripts/workflows. We suggest to reach out to your developers or your account manager regarding a customized solution for your requirement. If anyone has…

You're welcome, @User_65ZKL! I'm glad it worked for you! ? I'll be marking my previous comment as the correct answer so it will also help other members who might have the same need. Have a great day! ?