Ramu Komireddy_9891 Red Ribbon

Hi @Divya Unnikrishnan In NetSuite, a Transfer Order is inherently tied to its Source Location (in your case, Melbourne). When you create the Transfer Order, the system looks at the source location and the item being transferred. Because the Item Receipt is generated directly from the Transfer Order, NetSuite's costing…

Hi @User_VMKUY Implementing NetSuite for a University Related Foundation (URF) is a great opportunity to modernize your financial reporting, especially because NetSuite’s dimensional architecture is perfectly suited for non-profit fund accounting. 1. Standard NetSuite Classifications NetSuite comes out-of-the-box with…

Hi @User_Z3A0R The reason the Contacts sublist is missing for this specific customer is almost certainly because the customer was created with the Type set to "Individual" instead of "Company" In NetSuite, if a customer is set as an "Individual", the system assumes the customer is the sole contact. Therefore, it hides the…

Hi @User_GXSDU 1. Can an Admin reject the Bill Payment Batch? Natively in NetSuite’s Electronic Bank Payments (EBP) module, no. NetSuite enforces a strict rule where only the specifically designated approver can see the Approve, Reject, or Edit buttons on a Bill Payment Batch that is in "Pending Approval" status. Even if…

Hi @Elina Kourouzidou Method 1: Workaround (Recommended) You can temporarily disable the automation to drop the system lock on those specific records. Go to Setup > Accounting > Intercompany Preferences. Uncheck the box for "Automatically Generate Representing Entities" and click Save. Why this works: When you disable this…

Hi @Bee Yook The reason is that a Vendor Prepayment is "locked" to the Accounts Payable (AP) account it was originally created with. When that Prepayment was created (back in Dec 2025), it was booked against 200001 LOCAL (Trade Payables). NetSuite explicitly prohibits applying a prepayment from "AP Account A" to a Bill in…

Hi @Bee Yook The problem is a mismatch in the Accounts Payable (AP) Account. Look closely at your second screenshot (the Vendor Prepayment Application screen): Account Field: It is set to 20001 LOCAL. This is the Accounts Payable account NetSuite is trying to use to find matching Bills. Now, look at your "Dummy Bill" -…

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…