Using Optional fields in ACCPAC ERP?

[dbant101]

I am trying to create a report that will use two optional fileds in the report. I am wondering what is the best method for doing so. Both optional fields are attached to the gl account no. and when I try to select the desired reocrds I lose the other optional field amount. Uisng ACCAPC ERP 5.4 in sql. Would appreciate some help on this. Thank you.

 

[Jay Converse]

1. Link to GLAMFO twice, using aliases.
2. Add separate selections in the record selection formula for each alias.

 

[dbant101]

I am wondering if the optional fields can be used in the FR statements and if so how to get them to be part of the report.

 

[Jay Converse]

Read the documentation 'Sage Accpac FR Quick Ref.pdf' under FRACCT.

 

[irenavassilia]

why dont you create a filter with both option fields and use the Accpac .Browse object to select the filter. It will select both if the code is similar to this:

str_filter = "OPTFIELD = """ & pcstrARCust_OptFld_STATS & """ And VALUE = """ & pcstrYES & """"
.Browse str_filter, True

Regards,

irena