[dylanr]

According to the Financial Ratios KPI Scorecard, we have a large negative Current Ratio. That surprises me, because we didn’t go out of business several months ago.

The NetSuite formula appears to be current assets over current liabilities… but the liabilities are added together and credit card totals are represented as a negative number.

That means that credit card totals reduce total liability… which produces very weird results if your credit card debt is slightly larger than your other current liabilities.

Is this a bug or am I doing something terribly wrong?
This is a cached copy. Click here to see the original post.

[dylanr]

RE: Current Ratio on KPI Scorecard is wrong?

For what it’s worth, I was able to work around this by creating a custom KPI Scorecard and changing the formulas to use ABS on Credit Cards, eg:

Current Ratio:

({BANKBAL}+{RECEIVABLES}+{OTHERCURRENTASSET})/ ({PAYABLES}+ABS({CREDITCARDBAL})+{OTHERCURRENTLIAB })

That seems to produce correct results.

FWTW…

[skennedy]

Dylan, can you log a case and post the number here. I’ll follow up with QA on this.

Thanks,

Sean Kennedy

NS Product Management

[dylanr]

RE: Current Ratio on KPI Scorecard is wrong?

This is case #774414.

[skennedy]

Thanks Dylan. The problem is that the sign for this component is negative whereas the other credit balances are stated in absolute value, which is tracked in issue 146606. You are applying the proper function to get around the problem until it is resolved.

Thanks,

Sean

[Author]

Posts