Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Best Of
How to calculate Vendor Bill Variances?
Hi Guru's,
I don't quite understand how the Match bill to Receipt works on the item.
I have tested various purchase orders, receipts and vendor bills, but I do not really understand where certain bookings come from.
Example 1 (INK23.0033 - Match Bill to Receipt = True)
PO - Quantity 20, Rate 285
IR - Quantity 20
Bill - Quantity 20 - Rate 290
Expecting a Journal entry 20 x €5 (Difference) = €100
JE amount - €5800
Example 2 (INK23.0036 - Match Bill to Receipt = False)
PO - Quantity 20, Rate 285
IR - Quantity 20
Bill - Quantity 20 - Rate 295
Expecting a Journal entry 20 x €10 (Difference) = €200
JE amount - € 200 (this is correct in my opinion)
Example 3 (INK23.0037 - Match Bill to Receipt = True)
PO - Quantity 15, Rate 285
IR - Quantity 16
Bill - Quantity 20 - Rate 285
Expecting a Journal entry 1 x €285 (difference) = €285
JE amount - €4560
Example 4 (INK23.0038 - Match Bill to Receipt = True)
PO - Quantity 15, Rate 285
IR - Quantity 17
Bill - Quantity 20 - Rate 290
Expecting a Journal entry 2 x €285 ( QTY difference) = 570 AND 17 x €5 (Price difference) = 85 (in total €655)
JE amount - €4930
What effect does the Match bill to Receipt have on the journal entries if there are differences. I only see that the full amount is posted in the journal entry and not just the difference.
How does this work?
I hope someone can explain this to me.
Regards Toanne
Re: How to link Analytic Data Set with summary data?
Hi @Betsy Vance,
Good day! Hope you are doing well. 😊
Please be advised that you can link two datasets if they each have at least one field that shares common data, such as date. You can do this even if the datasets are based on record types that do not have predefined relationships in the analytics data source.
To create a Link, the user must define at least 1 set of Common Keys between 2 datasets. Common Keys contain the same types of data. Recommended Common Keys are highlighted in blue and automatically defined based on the datasets you choose.
You can also define your own common keys using fields from either dataset.
You may check the following SuiteAnswers Articles for more information:
- Dataset Linking in SuiteAnalytics Workbook | Answer Id: 100992 (with video)
- Link Datasets in a Workbook | Answer Id: 104215
- Common Keys | Answer Id: 104216
- Create Visualizations Based on Linked Datasets | Answer Id: 100993
I hope this helps! 😊
=========================
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 solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.
Re: GL transaction details not matching with deferred revenue by customer sub ledger
Hi @User_05DQT, per checking, unfortunately, it seems that this can't be corrected in the UI. You can try to file a case and report an issue and see if the Support team could help you fix it on their end. Apologies for the limited assistance. Thank you for your understanding.
Latest updates in the NetSuite Support Community (UI/UX edition) – December 2025
We’re excited to announce several updates to the NetSuite Support Community designed to create a cleaner, more intuitive experience for our users! These improvements are aimed at reducing clutter, streamlining navigation, and making support resources easier to access.
What’s New
- Smaller Top Banner
The top banner across all pages is now shorter, so users can see key content sooner and navigate the site more efficiently.
- Added “Contact Us” KB Link
A new “Contact Us” Knowledge Base link is now in the footer, providing a quick way to access support instructions and contact details.
- Added a link to the Knowledge Base article about the registration process on the NetSuite Support Community homepage.
Users can now quickly find helpful information and step-by-step instructions for registering, making it easier for newcomers to join the community.
- Updated the look of the "Refer a Member" button for improved visibility and a modern appearance.
The refreshed design makes it easier for users to find and use the referral feature.
- Multi-Factor Authentication (MFA) now available for the Oracle Community
Last November, the Oracle Community started to require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account (and the community data) by adding an additional layer of security during sign-in. To know more, please visit the article Multi-Factor Authentication (MFA) for All Oracle Sites.
Bug Fixes
- Fixed the issue where some embedded videos do not display properly
Deprecated
- Login Button Removed from Guest View
The Login button has been removed from the Homepage Banner for guest users to improve layout and free up space for more relevant content. Login and Register buttons are still accessible from the navigation bar at the top of the page.
- Removal of Redundant Search Bar & Refer a Member Button
Duplicate Search Bar and Refer a Member buttons that are visible when logged in have been removed from the banner to reduce clutter and improve page spacing. Both features remain available in the top navigation bar.
We want to hear from you!
Help us continue to improve the NetSuite Support Community by sharing your suggestions or ideas for enhancing your user experience by commenting below. Your feedback will help us continue to improve the Community to better meet your needs—let us know what matters most to you!
Action Required: Reauthorize Shopify Connector to Support Reverse Order Edit Sync
This notice is intended for customers who use the Shopify B2B Connector.
What’s Changing?
Shopify B2B Connector has introduced Shopify Reverse Order Edit Sync, allowing order edits made in NetSuite after order creation to be synchronized. To enable this functionality, a new API scope, write_order_edits, has been added to the Shopify B2B Connector.
Required Actions
To take advantage of this new functionality when it is available in NetSuite Connector, you will need to reauthorize your Shopify B2B Connector. Notes:
- This feature is already available in Shopify and NetSuite Connector support for it begins after the enhancement is released on .
- After the enhancement is released, you need to reauthorize your Shopify B2B Connector as soon as possible to enable the new functionality and avoid sync interruptions.
To reauthorize your Shopify B2B Connector in NetSuite Connector:
- Log in to app.farapp.com.
- From the left menu, select the Shopify B2B connector and account.
- Go to Settings > Credentials.
- Click Account Authorized.
The system takes you to the Shopify website. Follow the instructions on the Shopify website and when the process completes, you should get a success message in NetSuite Connector. If you see a failure message, contact NetSuite Support. After reauthorization, a new Shopify access token is granted and stored in NetSuite Connector. If you have multiple Shopify connectors, repeat this process for each connector.
If you have any questions, contact NetSuite Customer Support.
Re: Introduce Yourself!
Hey Everyone
I'm located on the Gold Coast, Australia.
I work for a theme park as their NetSuite Admin. Have only been here a few months so working towards certification while learning a whole new ERP (previous experience with other ERP's just not NetSuite).
I have 2 Maine Coons who are of course in charge. I also have a love for timber and building / repurposing items thanks to my old job, so they are always getting new custom things (due to their size most cat stuff just doesn't suit them haha) 😼
And yes, in case anyone was wondering we can go on rides at lunchtime at work 😎
Jodes
Re: Introduce Yourself!
Hi !
I live in Buenos Aires, Argentina.
I am NetSuite Developer, My experience is primarily focused on NetSuite ERP, OneWorld, SuiteScript, Saved Searches, Custom Records, Custom Fields, Workflows, Advanced PDF/HTML Templates, and customizations (including new implementations). I am happy to answer questions in the forum to the best of my ability.
I like playing soccer.
Re: Introduce Yourself!
Hi Oracle/NetSuite community,
My name is Ian. I currently work as the Financial Controller for a telecommunications company located in South Florida, USA. NetSuite is our primary ERP platform which we have used since 2023; however, I just started working for the company earlier this year. Though I have utilized several other ERP platforms , this is my first time utilizing NS and I am definitely enjoying it. Hopefully, I can continue to learn more about the NS platform by reaching out through this medium.
Re: allow alterntive 2FA apps
Hello @kastnerd, You’re right that email-based 2FA is weaker than app-based TOTP, and NetSuite (the application) does support third‑party TOTP apps. The confusion comes from the fact that the NetSuite Support Community is a separate Oracle‑managed identity property with its own MFA policy. That property enforces Oracle Authenticator for app‑based MFA and may allow email as a backup or fallback factor based on its risk and recovery policies. If needed, you can create a Support case to get deeper insight into the specific policy for your account and clarify available options or exceptions.
________
In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the most out of their NetSuite journey. Click here for more details.
