Accpac Financial Statements

[Didagk]

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

 

[Jay Converse]

No.
GLPOSTO.

 

[ettienne]

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.

 

[Jay Converse]

True, but I was thinking from the UI, where you can only select by year, period, and segment.

 

[ettienne]

The question is a bit fizzy then...

 

[ettienne]

Meant fuzzy, not fizzy

 

[Didagk]

I need the out put to be in columns so need the formulae which applies to column E ++


kindly assist ...

 

[ettienne]

In column B use something like ="(A.ACCTCLASS = ""Bank"")