Skip to Content
0
Dec 12, 2011 at 06:48 PM

OACT Account Type

427 Views

Is there a way to determine the account type, "Balance Sheet" or "Profit and Loss" account from OACT?

It seems like there should be a Parent > Child relationship OACT > OACG but it seems that "Category" column values in OACT is null.

I was hoping there was a way to determine the account type from a data column or relationship of some kind that could be used in a SQL query.

SAP B1 8.8 on SQL 2005

Ken Worst

Edited by: Ken Worst on Dec 12, 2011 7:49 PM