Ramu Komireddy_9891 Red Ribbon

Hi @User_7ANL6 In NetSuite WMS, there is no standard configuration that disables the “tap-to-select” option for bins while still showing the list of bins on the handheld screen. In the WMS Mobile picking screens, the bin list is part of the standard LOV (List of Values) behavior. When the bins are displayed, operators can…

Hi @Kedalene Why the Phone Format Did Not Change General Preferences → Phone Number Format only defines the expected format pattern. NetSuite does not automatically insert separators like - or spaces when entering phone numbers. Existing phone numbers in Vendor records will not be reformatted automatically after changing…

Hi @Arina L First Check: Approval Routing Must Be Enabled For Pending Approval to work, Sales Order Approval Routing must be enabled. Go to: Setup → Accounting → Accounting Preferences → Approval Routing Check: ✔ Sales Order Approval Routing = Enabled If this is disabled, NetSuite will never allow Pending Approval status,…

Hi @Craig_Verde Because NetSuite’s Period Close Checklist is strictly sequential (Lock A/R ➔ Lock A/P ➔ Lock All), you cannot natively lock the General Ledger for inventory while keeping A/P and A/R open for your clerks to finish their month-end processing. Your idea to create a custom flag on the accounting period and…

Hi @User_S6FVQ The reason you are getting two separate lines is that NetSuite is finding two different location records for the item, so it returns a row for each location. To combine them into a single line, you need to Group the item and Sum the formulas. Step 1: Fix a small syntax error in your formulas You have an…

Hi @Jet Zhang The issue with the Date/Time Created column is caused by a timezone offset between your personal NetSuite preferences and the NetSuite server's underlying timezone. Here is the breakdown of exactly what is happening: 1. The 16-Hour Time Difference If you compare the Date/Time Created column to the time…

Hi @SILJA K C Having implemented this for numerous logistics and fulfillment workflows, here are a few best practices: Create a Dedicated "Commercial Invoice" Form: Do not clutter your standard Customer Billing Invoice. Create a secondary Advanced PDF/HTML Template explicitly titled "Commercial Invoice". This document…

Hi @Bee Yook Instead of using the "Pay Bills" screen, go directly to the source transaction. This is the most reliable way to link them. Open the original Vendor Prepayment transaction record. Look at the buttons at the top. Do you see an Apply button? If YES: Click it. You will be taken to a "Vendor Prepayment…

Hi @Bee Yook Yes, your understanding is 100% correct! You have summarized the change perfectly. To answer your specific questions: 1. "Therefore these changes wouldn't apply to the work order?" Correct. Work Orders are entirely unaffected by this change. The whole purpose of a Work Order is to show the components needed to…

Hi @User_IBB5P , You can build this without code using a Transaction Saved Search. Create a New Search: Go to Reports > New Search > Transaction. Criteria Tab (Filter the data): Type: is any of Invoice, Cash Sale (or Sales Order depending on when you consider it "sold"). Date: is within Last 6 Months (or use a relative…

Hi @Bee Yook Here is the cleanest solution: The "Wash Bill" Method. This method creates a dummy transaction to "use up" the prepayment in the system, but it codes the impact back to the Prepayment account so the net GL effect is zero. Step 1: Create a "Dummy" Vendor Bill You need a Bill to apply the prepayment against. Go…

Hi @Nursalim The "Why": Retroactive Cost Adjustment This specific GL entry happens when you sold or fulfilled this item before you officially received it in the system. Here is the sequence of events that triggers this: The Sale (Past): You fulfilled/shipped this Assembly Item to a customer (or used it in another build)…

Hi @Bee Yook The Correct Way to Adjust If you need to adjust that balance without a standard bank transaction (for example, importing opening balances or correcting an error), you must simulate the transaction logic: To Increase Balance: Create a Vendor Prepayment transaction. If no cash actually moved (e.g., an…

Hi @User_5FWNK This is the easiest way to report on these figures without writing scripts. Go to Reports > New Search. Select Transaction. Criteria Tab: Type: is Item Receipt Main Line: is False Tax Line: is False Item : Landed Cost: is not (none) (This filters for items that track landed cost). Results Tab: Add the…

Hi Oracle NetSuite Family, My self - Personal Profile Name : Ramanjaneyareddy.komireddy Marital Status : Married Nationality : Indian Languages known : Telugu, English Hobbies : Photography, Travelling, Music. My Experience, Having a solid experience on NetSuite Implementation, Customization, Suite Builder, Suite…