megaphone
SuiteWorld 2026 registration is now open—save $300 Register now
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
What if your ERP could help surface the next step before you go looking for it? Watch here to learn more!

My Stuff
Avatar
See All the Unlockable Badges See All the Unlockable Badges
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.

Ramu Komireddy_9891 · Senior Oracle Netsuite Functional Consultant · Bronze Trophy

Comments

  • 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…
    in Results of 2 saved search case statements to be displayed on one line? Comment by Ramu Komireddy_9891 Mar 4, 2026 6:54AM
  • 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…
    in Date/Time Created in Balancing by Segments Processes is not correct. Comment by Ramu Komireddy_9891 Mar 4, 2026 6:47AM
  • 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…
    in Dual Currency Values on Invoice for Shipping / Customs Requirement Comment by Ramu Komireddy_9891 Mar 4, 2026 6:04AM
  • 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…
    in Prepayment balance in vendor master Comment by Ramu Komireddy_9891 Mar 4, 2026 5:57AM
  • 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…
    in RP 2026.1: Update to Storage of Assembly Components for Advanced Bill of Materials Comment by Ramu Komireddy_9891 Mar 4, 2026 5:48AM
  • 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…
    in Sales Report by Item Qty / Customer / Month Comment by Ramu Komireddy_9891 Mar 4, 2026 5:42AM
  • 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…
    in Prepayment balance in vendor master Comment by Ramu Komireddy_9891 Mar 4, 2026 4:37AM
  • 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)…
    in Cost of Adjusment in item receipt Comment by Ramu Komireddy_9891 Feb 27, 2026 8:29AM
  • 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…
    in Prepayment balance in vendor master Comment by Ramu Komireddy_9891 Feb 27, 2026 8:26AM
  • 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…
    in Landed Cost Per Unit Comment by Ramu Komireddy_9891 Feb 26, 2026 9:15AM
  • 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…
    in Introduce Yourself! Comment by Ramu Komireddy_9891 Feb 3, 2026 6:11AM