[gsf]

We ran two Income Statement report (one for user A and user B) each has full access license. User A can enter a date range manually (031609) at the bottom of the report. User A can only select months with the quarter and can NOT enter dates manually. How is this happening?

Secondly we get two different values for one of our accounts! User A’s report states x amount of dollars in a specific account, and user B is about 40K short of that.

What is going on here?
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: Income statement date range problem

User A has Reporting By Period Preference Enabled.

User B does not.

Navigate to Home->Set Preferences

Click on the Reporting/Search Tab

Select the “Report By Period” preference that best fits your needs.

The 40k difference is more than likely a transaction that is posted on a different period than its transaction date.

[gsf]

RE: Income statement date range problem

Originally posted by ivan.parra

The 40k difference is more than likely a transaction that is posted on a different period than its transaction date.

This is a defect! Reports should be looking at posting period not date of transaction. I cant controll what user(s) “prefer” when selecting a range in a report….thus everyones reports will reflect diff values. Thats a problem!

[tomdewerff]

RE: Income statement date range problem

This is something that NetSuite definitely needs to address…anytime that a transaction is recorded, there is a possibility that the date of the transaction may not relate to it’s accounting period and vice versa. This is the cause of several mind-numbing searches and reverse searches to find the error.

My recommendation is that anytime a transaction date does not match the accounting period entered, that there would be a warning…or better yet, the accounting period would be automatically selected based on the accounting date entered (i.e. grayed out and calculated).

[bboese]

RE: Income statement date range problem

This is a case of “you can’t have your cake and eat it too”, since there are pros and cons with this, like many things in life, and this issue should not be classified as a “defect”.

We have found reporting via exact dates allows for more consistency / accuracy when drilling down from KPIs, reports, etc into detailed reports, etc. For companies that are smaller than mid market size, this can work well. However for companies that want quick month end closes, with no edits to transactions in past periods, this can be time consuming and frustrating, so some reasonable compromises may be in order.

Please remember that accountants (and/or unreasonable policies and/or staff that are still on the learning curve) should not force the company to run a certain way, just to please them.

The accountants that work the best with NetSuite try to see the company from the operational and stakeholders (owners, shareholders, vendors, customers) perspective, and then accommodate everyone involved, including the year end tax specialist. It’s not easy to do, but can be done with some effort.

[Author]

Posts