Hi

[Former Member]

Hi EveryOne,

I need to calculate the Current Ratio of my company which is current Assets/current Liabilities.Can any one help me how to do this through query or views or any other way.

[jitin_chawla]

Hi,

You can prepare a query taking into account the table OACT and the fields

CurrTotal = Balance in Account

GroupMask = Drawer Number for Assets and Liability which would be 1 and 2

FatherNum = To get hold of the G\L Account under a specific title where title would be your Curent Asset or Liability.

Check these fields and if problem mention in the thread.

Hope it helps.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Jitin

I have already followed the same way but the balance field gives me only the Current balance but if i want to give a condition date like i want to see for the period 01-07-2010 to 30-06-2011

Thanks

Edited by: 1206_15 on Aug 6, 2011 5:53 AM

Edited by: 1206_15 on Aug 8, 2011 6:12 AM

[Former Member]

Hi........

What do you mean by Current ratio of Assets and Liability?

Can you please explain bit?

Regards,

Rahul

[Former Member]

Hi Rahul,

Current Assets means in the Chartof accounts all the current assets cumulative balance as of given date needs to be calculated.

In the same way for current liabilities to.

Thanks

[Former Member]

You need to sum the JDT1 lines where the account code is in the required group mask and the date is less than or equal to the required date

[Former Member]

The following is the code I executed

Select T0.[AcctCode], SUM(T0.[Credit]-T0.[Debit]) as 'Balance' From [JDT1] T0 WHERE T0.[RefDate] between '[%1]' and '[%2]' and T0.[AcctCode]='[%3]'

It display the balance for the account selected which doesn't include the opening balance.How can i resolve it.

I tried with the following code

Select DISTINCT T0.[AcctName],T0.[CurrTotal] From [OACT] T0 INNER JOIN [JDT1] T1 ON T0.[AcctCode]=T1.[Account] WHERE T1.[RefDate] between '[%1]' and '[%2]' GROUP BY T0.[AcctName], T0.[CurrTotal]

If i try with the Current balance what ever the date condition i give it is just displaying the current blance as of today.

Please help how to resolve this.

Thanks

Edited by: 1206_15 on Aug 8, 2011 3:21 AM