Best Of

Yes @Benjamin Paul - USA ,

Click on parent records and share the screenshot.

Correct Agree with you @thussain

But you have the alternative option, Use the Invoicing Preferences page to set a default subsidiary for customers who want invoices grouped. You can set this preference for new customers.

Hello @User_HPB3I

Currently adding a specific date range on Trend Graphs is under enhancement vide # 72177.

Alternative solution: Create a custom KPI and set the date range based on your requirement.

Hello @Benjamin Paul - USA

Due to currency permission, the exchange rate field is grayed out.

Pls check the permission on your role

Navigate to Setup > Users/Roles > Manage Role

1. Edit the role
2. Click on Permission tab
3. Click on Lists subtab
4. Select currency permission - access level select Edit
5. Save and check on new transaction

Hey @User_KBEB1,

The Best Practice is to run the Month End Revenue Recognition Journals followed by the Revenue Reclassification Journals.

I found that many NS Implementation Consultants never mention the Revenue Reclassification Journals, and customers end up with incorrect financials and many manual steps.

Do you run the Revenue Reclassification process? Once you run it, NetSuite should adjust the difference between Deferred Revenue (B/S) and Revenue (IS).

Regarding the second question, there are a few ways to address it, and some of them depend on your current setup and transactions. For example, what is your setting for "Create and maintain Revenue Element upon closed Sales Order"? Also, do the RAs you are trying to close relate to Sales Orders with items set up to create Revenue Plans on Billing? Thanks.

Thanks @Tigran Shahnazaryan for your insightful comment!

That is correct. NetSuite generates Foreign Currency adjustments for such transactions to account for the variance is calculated for the overlapping foreign currency amounts for billing and revenue recognition for each revenue element (SuiteAnswers ID: 88736)

Here's an illustration:

The source transaction is a Sales Order:

2 quantities billed with CAD $500 rate amounting to CAD $1,000

With an Exchange Rate of 0.75 (CAD to USD)

I billed this Sales Order for 1 item CAD $500 with 0.73 exchange rate

Upon checking, this generated a Revenue Plan (Create Revenue Plans On = Billing)

The Revenue Plan still uses Plan Exchange Rate:

This is the exchange rate between the source currency (the Parent Line
Currency) and the base currency (the Revenue Recognition Plan Currency).

I then created a Revenue Recognition Journal Entry:

I then navigated to Transactions > Financial > Schedule Reclassification Journal Entries

This generated a Reclassification Journal Entry:

The formula for this would be: Amount (Foreign) X (Billing Exchange Rate - Revenue Plan/Line Exchange Rate) or CAD $500 X (0.75 - 0.73) = USD -$10

The general ledger impact for this adjustment is:

• For a gain – Debit deferred revenue and credit revenue.
• For a loss – Debit revenue and credit deferred revenue.

So in this case, this is a loss that is why it credited the Deferred Revenue.

As for the your second question, will you be closing the Sales Order?

You might be interested in checking these articles:

NSC | Create And Maintain Revenue Element Upon Closed Order = T in Closed Sales Order w/Partial Bill

NSC | Create And Maintain Revenue Element Upon Closed Order = F in Closed Sales Order w/Partial Bill

==========
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

Thank you for all your help Ven I really appreciate it.

It's been a few years since this thread was open. Any progress on this?

There needs to be a way to easily find which have/don't have images in SuiteCommerce. It shouldn't require a dev to check. This should be something an Admin or Marketing super user can achieve.

Hello,

In order to restrict a permission of one specific check box. you can use workflow to do so.

Thanks and Regards!!

Hi Gia My "Mei" Luc,

Since we cannot reproduce this in our testing environment, we will not be able to find the root cause of this error. I highly suggest that you file a Support Case with our Support team since they can access your replica account for testing which in this case is needed.

Thank you for your understanding.

-Lyka