Sage 100 2019 Sage Intelligence Bank Account Number

Question

Wrote a Positive Pay report using the Intelligence a couple of years ago for a client. 
 The report contains the Bank Account Number from the GL_Bank file. 
 They just upgraded to Sage 100 2019 ran the report and the Bank Account Number is blank. 
 Searched the Knowledgebase and found the reported issue of the Bank Account Number showing blank in the Positive Pay report in the Bank Rec in the initial 2019 release. 
 Downloaded and installed Rev 2 release and had no affect in the Intelligence. 
 Also saw that you may need to reenter the Bank Account Number in Bank Code Maintenance. Did that and no change. 
 Has this been reported?

Doc102208 · Accepted Answer

I found a work around. 
 The reports are for individual banks so I changed the Back Account Number in the container to a SQL Expression and hard coded the Bank Account Number. 
 No need to move them to Crystal.

socasue · Answer

As David mentioned bank accounts are included in the personally identifiable data and so they cannot be included on a Sage Intelligence report. You would need to create a report using Crystal Reports and include the PII work table

Sage 100

Sage 100 2019 Sage Intelligence Bank Account Number

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING