Best Of

Re: Foreign Currency Transactions

The value you select in the Subsidiary Context list for a report determines the data and currency to be used for amounts. The currency is the base currency of the subsidiary you select.

There are two types of financial reports that you can generate.

1. Subsidiary Level of Report - These reports pull out the amounts based on the transaction amount at the time that the transaction was created

2. Consolidated Level of Report - These reports shows the consolidated data for all child subsidiaries of the consolidated parent subsidiary, including elimination subsidiaries. As such, The consolidated exchange rate types and the types of accounts that use them are as follows:

  Average – The weighted average of the currency exchange rates for all transactions posted during the period to accounts with a rate type of Average. This rate is used to translate accounts in the income statement and to build retained earnings.

  Current – Also referred to as ending rate. This rate is the currency exchange rate that is effective at the end of the reported upon period. This rate is used for most asset and liability accounts in the balance sheet.

  Historical – Same as Average rates, except for accounts with a rate type of Historical. This rate is used for equity accounts and owners’ investments.

Viewing the Financial Reports at a Consolidated Level, the system would be using the Consolidated Exchange Rates (Lists > Accounting > Consolidated Exchange Rates) depending on the General Rate Type of the account (Lists > Accounting > Accounts > Click Edit on a specific account to view).

For more information, you can check out SAID 7752.

Hope this clarifies! :)

Clarisa De Torres-Oracle

1

Re: SuiteScript/SuiteCloud communication with MS Dataverse (Dynamics 365)

Hello, everyone! Feel free to participate in the discussion and share your valuable insights.

In the meantime, you might be interested in participating in our Weekly Quiz. You only have until April 18, 2PM ET to comment on your answers and earn rewards! Click here for more details.

Clarisa De Torres-Oracle

1

Re: Change table in Bill of Materials printout

As you can see, I was able to get the Item number to show up before the Description in the top table, but I cannot find any indication where the bottom table comes from or how to edit it:

Ken Davies

1

Re: Apply Discount Code To Item Automatically

@Grace Catabian-Oracle Thank you for the information!

Martha Hakes

1

AskAGuruLive with Tris about Supply Chain Management (April 17, 2024)

Hello, Everyone!

I'm Tris, one for the NetSuite Support Community Gurus for Supply Chain Management, and I will be live for an hour today starting from 1 PM to 2 PM EST to answer your questions.

Before we start, there are some of our house rules:

Post your questions by commenting below. 1 comment = 1 question.
Some questions may be complex so I would appreciate your patience as I look into it.
Let me know if the solution works for you or not. That way, I can check again.

You can also ask me non-NetSuite-related questions about my hobbies or interests outside of work and I'll be happy to share.

Be sure to stay tuned for additional tips and tricks coming your way soon! 😊

I would also like to greet the following members who have RSVP'd for today's session:

@Robert Nedelkow-Oracle @Michelle Jabanes-Oracle @Able Wilson @Niks Blando-Oracle @Mike Begalle @Richard James Uri-Oracle @Tammy Stewart @User_8TNOB

Tris Mendoza-Oracle

1

Re: Error when merging customer records

One of the records has a 'represents subsidiary' defined. This makes this record an intercompany entity, which can never be merged with a regular entity.

Hope this helps.

~angela

Angela Bayliss

2

New Corner Page - New to NetSuite!

Welcome to our brand new corner, "New to NetSuite!"

New to NetSuite is designed to provide customers who are new to NetSuite with all the information you need to make the most of your NetSuite journey. We understand that learning something new can sometimes be overwhelming, but don't worry, we've got you covered! Our articles are written with you in mind and are easy to follow and understand. Whether you're looking for troubleshooting tips, step-by-step guides, or general information about NetSuite, New to NetSuite has everything you need.

So take a look around and don't hesitate to reach out to our team if you have questions or feedback. We're here to help you succeed. We will continue to update this corner with new contents every week so make sure to follow and set your notification preferences, link.

You can find the New to NetSuite in our main menu. Please see the provided GIF for a visual representation.