Hi @John Robertson Sr., I checked your concern internally and here are the information I've gathered: SuiteTax has no additional subscription/transaction price. If you can implement it by yourselves (this can be tested in Sandbox), then there's no implementation fee either. However, you could get our Advanced Customer…

Hi @SergiG, This the formula I've tried on my end to have the amount on vendor prepayments converted to base currency: TO_NUMBER({transactionlines.foreignamount#converted}) Here's what it looks like: May we know if this is what you're trying to create in workbook? If not, kindly provide us screenshots of the dataset you…

Hi @SergiG, To better understand your concern, would it be possible to send screenshots of the dataset you were trying to create? Please remove any confidential information on the screenshots you'll attach. Thank you! 😊

Hi @User_GY7YY, yes this can be done by customizing the Multi-Book Balance Sheet report. Kindly see details below for your reference: Navigate to Reports > Financial > Multi-Book Balance Sheet Click Customize button Under Edit Columns tab, expand the Multi-Book Financial folder and add Amount (Book 1) and Amount (Book 2):…

Hi @AndreaK2, At this time when creating an A/R type account, it is by design that the Revalue Open Balance for Foreign Currency Transactions box is checked and greyed. Upon checking it is currently a system limitation logged under Enhancement Request #298007 Have the ability to uncheck the "Revalue Open Balance for…

Hi @Patrick Olson, ERRATUM: Upon checking the results of the saved search, Applying Link Type and Applying Transactions Fields under criteria on saved search for Invoices work only for those Related Records under Payments subtab such as Payment and Currency Revaluation. Upon further checking, the ability to create a report…

Hi @Patrick Olson, Per my understanding you wanted to create a saved search for list of invoices with no related revenue arrangements. Kindly see details below of my testing regarding your concern: Navigate to Reports > Saved Searches > All Saved Searches > New Select Transaction Search Title: Enter Title Click on Criteria…

Hi @User_DJ8IA, just checking in if you were able to see my previous comment. Kindly let us know if it helped by marking "Yes" in the "Did this answer your question?" so that other members who might have the same concern can easily refer to it for the solution. Should you need further assistance, feel free to let us know.…

We are now ending today's session. Thank you to everyone who participated! I hope you were able to learn something. Follow AskAGuruLive for more updates. Feel free to post your feedbacks or suggestions to help improve the program. Have a nice day! 😊

Tip #3: Allow users to modify amortization schedule The Amortization Schedule is reliant on the related Amortization Template and Source Transaction. It is an automated system to help users simplify the process. Users will not be able to modify any lines UNLESS the following are ALL satisfied: The accounting preference…

Hi @User_SQM78, my hometown is located around Binan, Laguna. A famous dish in our area is called Puto Binan. It is a rice cake delicacy and has a sweet, cheesy taste. You should try one if you get the chance to visit my hometown ☺️

Tip #2: For missing transactions or transactions not revalued in currency revaluation: Here are the following scenarios which are the common reasons why some transactions are not included in the currency revaluation process: Transaction was already paid Transaction was posted in a different month than that of revaluation…

Tip #1: How to create an Item that posts directly to revenue when Advanced Revenue Management is enabled In order for items to be posted directly to an Income account, user may mark the Direct Revenue Posting checkbox for its item configuration. When this box is checked, posting transactions that include this item post…

Hi @Carmela Rosales-Oracle, welcome to NetSuite Support Community! I actually listen to a wide variety/genre of music such as country, pop, ballad, rock, and etc. Favorite artists that I could recommend to you are Taylor Swift, BTS, and My Chemical Romance. You can give them a try and I think you'll like them as well 😉 How…

Hi @User_1Z0D4, thank you for posting your question here. Currently, the ability to generate balance sheet in cash basis is a system limitation logged under Enhancement #20022 Balance Sheet>Cash basis. You may also refer to SuiteAnswers ID 8360: Setting Up Cash Basis Reporting for other lists of Reports that currently have…

Hi @Dominica Sevilla-Oracle! Thank you for that question. I think my first impression of the NetSuite Support Community is that it is a very engaging and welcoming community. Everyone here tries their best to share their thoughts and ideas and willingly assist each other on their concerns. 😊

Hi @User_DJ8IA, One of the reports you can utilize for elimination entries is the Intercompany Elimination report which provides an audit trail of intercompany eliminations for a period. You may run this report after posting intercompany elimination for a period. This report provides the source transactions marked for…

Hi @User_DJ8IA, Glad to have you with us today! Thank you for creating this thread. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To other members and users who also have insights that may help, feel free to join this thread.

Thanks for the update, @User_NC62U. You're welcome! 😊

Hi @User_V5KBL, Thank you for posting here in NS Support Community and for being with us today. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To other members and users who also have insights that may help, feel free to join this thread!

Hi @User_NC62U, We're glad to have you here. Thank you for creating this thread. Our guru/s will look into your concern and reply to this thread for any updates. To our members, please feel free to share your thoughts on the thread.

Hi @User_NC62U, were you able to check on this? 😊

Hi @User_XQ321, Yes, that's correct. The balance nets out to zero if the sum of the debit and credit line items are equal or balanced with each other. I did further checking and noted that this is currently a system limitation filed under Enhancement #115378 Transactions>Other>Make Journal Entries. Please provide a field…

Hi @User_XQOAP, Per my understanding, you wanted to have the ability to include system-generated Cumulative Translation Adjustment account on the Profit & Loss Statement so that OCI on the P&L would tie. Upon checking, this feature is currently logged as an enhancement request under #211824 OneWorld>Financial Reports: Have…

Hi @User_NC62U, I have tested your concern using intercompany allocation - kindly see details below: Scenario: I am trying to allocate the balance posted on Advances Paid account from my "Parent Company" Subsidiary to my "Holdings" Subsidiary (Root Parent Subsidiary). I want the balance to be allocated 50% to my "Parent…

Hi @Betsy Vance, Thank you for being with us today and for posting your question here. Kindly allow us to review your concern and we'll provide updates in this thread. To other members and users who also have insights that may help, feel free to join this thread!

Hi @Jerry_Morales, just checking in if you were able to try the information mentioned above? Were you able to successfully log in to your account? Kindly let us know if you still need further assistance regarding this. Thank you!

Hi @Jerry_Morales, In order for us to further help you with your concern, we would like to inquire the following: Is this happening to all users and roles or just to a specific user and role? Were there any changes in your account when this started happening? I have checked Netsuite Status via Oracle NetSuite Service…

Hi @Jerry_Morales, Thank you for being with us today and for posting your concern here. Kindly allow us to review your concern and we'll provide updates in this thread. To other members and users who also have insights that may help, feel free to join this thread!

Hi @User_GY7YY, Glad to have you with us today! Thank you for creating this thread. Our guru/s will look into your concern and reply to this thread for any updates. To other members, feel free to share your insights on this too should you have any.