Best Of
Re: Saved Search or Report to show GL Impact of Projects
@Niña Camille G. Paule-Oracle Thank you for the information. :)
Re: Saved Search to show all invoices approved by a user
Could you check the "System Information" for one of the approved invoices and share the screenshot?
Do you see something like this?
If yes, you should be able to create a Saved Search with the "System Note → Set By" = "Mine" filter, along with additional criteria on the related System Note field changes, to dynamically show Approved Invoices to the approvers.
Re: FIFO Calculation in Netsuite
@User_WA9MO you'll need to drill into the detail of the report to understand the drivers on this. Your own assessment is correct, the goods out should result in a value of 137,500,000
Re: Changing Default VAT on Purchase/Receivable Account in NetSuite
Hello @Adinath_Bodakhe , were you able to check Angela's comment above? For additional information, you can also check these SuiteAnswers articles:
29986 Change Tax Control Accounts on Tax Codes for Nexus other than United States and Canada
75946 Change Purchase Tax Account and Sales Tax Account of a Tax Code
Hope this helps! :)
SuiteMaster January 2026 Challenges
📢 Get ready to take on exciting new challenges and become the next SuiteMaster of the Month!
Conquer this month's challenges to earn fantastic rewards! 🤩
Unlock your potential and join us now!
Get at least 2 accepted answers by providing helpful insights to the members of the Community.
Provide helpful comments on 4 unique threads of other members.
Create 1 valid content.
Re: Merge Oracle Community Accounts
Hi @User_BCKYD
This is to let you know that your request to merge your old account with your new one has been completed.
Please do let me know if you have questions.
Thank you!
I'd like to hide cost, EST. COST and total value of an inventory adjustment from certain roles
Hello, I am trying to block certain roles from seeing the value of an item, the total value of an item, the estimate cost, and the estimated value of the inventory adjustment, from certain roles when performing an inventory adjustment. I am in the customization of the transaction forms however I cannot seem to find the fields to uncheck to remove the cost, est total value, est cost. and estimated total value.
Re: Analytics Workbook: Data Labels on Charts & Custom Color Themes
Hey @ABDUL HANNAN,
Great questions and observations.
NetSuite Analytics Workbook isn't a full-fledged BI Tool. It covers the basic BI capabilities and something that most ERPs don't have at all.
The features you are requesting are standard in BI Tools such as Looker. They aren't available in NetSuite.
I don't like the current color theme, especially when there are only a few results. One workaround I found was to change the result sorting, which reverses the color sequence. I also introduced "empty/hidden" results that would "consume" the first few colors, so the actual results show up in the colors that were a bit more acceptable.
Re: Due to a concurrency issue, our connectors are broken and hurting our ability to do business.
Thank you for sharing your insights on this Angela!
Hi @Tom Dalton,
For the Service Tiers, here are some SuiteAnswers articles that might help:
- SuiteAnswers 102415: NetSuite Service Tier Structure
- SuiteAnswers 86930: Concurrency Governance Limits Based on Service Tiers and SuiteCloud Plus Licenses
Also, you've mentioned that you've opened a support case. We would highly appreciate it if you keep us updated on any resolutions you receive, as this will help others in the community who may be facing similar issues.
Thanks!
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
