[Lindy]

We created a customized income statement which worked fine until the upgrade to V2008, release 1. Now when we ran April’s there is no rhyme or reason as to the accounts & amounts it is picking up. We break it out by dept., account, entity then amount. If we run just a basic income statement out of NS it is correct. Has anyone else run into this and is there anyone who can tell me why this is happening and how we can correct it?

Thanks so much for any help I can get.

Lindy
This is a cached copy. Click here to see the original post.

[carrie.roesner@centro.net]

RE: Customizing Income Statement

A lot of our customization was lost/changed with the upgrade as well. I would recommend just re-doing it as support has not been much help in determining the cause or helping to fix it.

[rchamberlain]

RE: Customizing Income Statement

Folks,

A little more detail around the situation Lindy describes. We actually have 2 significant issues – first, the report detail is no longer complete or accurate (while the section subtotals are correct), and second, the export to Excel or CSV produces completely different information than what is shown in the report in Netsuite.

In order for us to properly report by department and customer type, we added a couple of custom fields to the transaction headers. We automatically pull the customer type from the customer record when we load the transaction record. We assign a department to all expenses, but we have no need to track revenue by department.

Until the upgrade to 2008.1 (on 4/18), we were able to correctly produce an income statement with the following layout:

Report Section – Operating Income, e.g.Department – Marketing, Admin, Warehouse, etc.Income/Expense account

Relationship (customer type) – Dealer, Contractor, Consumer, etc.

In March and early April the report looked like this:

Each section is pulling correctly. You’ll have to take my word that the numbers per line are correct and that the final tally is also correct. Also, note that we have a number of detail lines per department.

In May (first report since the upgrade to 2008.1), our report looks like this:

Note that we are missing entire sections (Accessory Billings, for example). Another significant problem is that each line has an incorrect total. We did have transaction data for the same accounts, departments and relationship types in both months.

In each case, you’re seeing the result of the Excel export.

I am going to file a case with NS Support on this and will post the case/issue number here when I receive one. In the meantime, if anyone is using custom financials by department or drilling down by entity data, please review your reports.

I have recreated the report from scratch, and get the same (bad) results.

Thanks in advance,

[Author]

Posts