Hi All,  I'm am searching for a cheque spec that includes the account numbers for the Invoice (If there was one).  Does anyone have a lead on such a spec?  It's hard to link the APADV and the Invoice tables taking into consideration credit/debit notes, misc payments etc.  I've tried a few different methods ...

 SQL Authentication.   One other weird thing that we just saw, in changing the datasource in the subsequent files in Crystal, by going to Set Datasource Location-> Clicking on the new dataset and hitting Update-> The datasource name changes, but the catalog remains the original datasource, an dthe report deosn't bring any ...

 They use 3 Citrix Servers, each one has all datasources on ODBC.  Not sure if that complicates the matter but I can't think of why it would.  

 Yes.

In the Accpac Desktop, I am right-clicking-> New-> Report and connecting to the path where the report is.  It still will not pick up the new datasource.  Normally that's all I need to do, but that is not working.

Hi Report Gurus!  For most of our clients, I can create reports in Crystal XI using the SAMINC datasource, and when I drop them into ACCPAC they automatically attach to the datasource that the user has logged into.  We have one client where we need to create 3 of the same report set to their particular datasources (they have 3 ...

 Hi Group! Does anyone know how to delete User Authorizations from an old company that no longer exists?  These errors keep showing up in the Data Integrity Log, so I'd like to resolve that issue. "Damaged Data.  Authorization for Undefined Database  XXXX" Thanks, Laura

 It works fine on Pervasive in our office.  I have not installed another database platform at their office.  Since we did not do the inital install, we're wondering if it is some sort of program corruption.  We have plans to upgrade to 5.5, so we're going to start over again and see if that straightens it out.  ...

 More information: This issue occurs in this circumstance: only  When mutliple changes are made where both changes and combines are in the list.  The corruption only occurs on those accounts touched by the combine, the changes seem fine.  It gives errors in the data integrity of these: In the Combine from Account: Orphan ...

 We now have narrowed the issue down to this: The corruption does not happen if a single account code change is done, however, happens each and everytime an account code change is posted which has more than 1 change in the list. I tried to duplicate the error here with a stand-alone Pervasive Environment and I cannot - it works fine.  ...