Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accpac Financial Statements

Status
Not open for further replies.

Didagk

Technical User
Mar 9, 2014
12
KE
Can you use optional fields as part of the criteria to extract financial statements from Sage 6.1 SQL server 2012

If i need to use crystal reports, which accpac tables do i need to extract data from?

Thanks

 
Yes you can.
In column B use something like ="(A.ACCTCLASS = ""Bank"")"
Where ACCTCLASS is an optional field assigned to the GL account and Bank is a value.

 
True, but I was thinking from the UI, where you can only select by year, period, and segment.
 
I need the out put to be in columns so need the formulae which applies to column E ++


kindly assist ...
 
In column B use something like ="(A.ACCTCLASS = ""Bank"")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top