Hi Sylvester

Find attached an article that you can refer to help resolve your query. 

Please note the article refers to the fact that this matter should be handled by a professional Evolution business partner or Evolution Support consultant, if you can't upgrade to the latest Evolution version (10.1.2)  

Kind Regards

Bennie 

‘FIELDS IN _BVGLTRANSACTIONSFULL AND _BVGLTRANSACTIONSHISTFULL VIEWS DO NOT MATCH’ GL REPORT ERROR.PDF

Thank you Bennie for this wonderful answer.

Quoting some sections from your file:

"These steps should ONLY be performed by a professional Evolution support consultant
(e.g. in Evolution Support Department or your local Evolution Business Partner).
1. Get all users to log out of the company.
2. Backup the company.
3. Within MS SQL Management Studio, run a SQL script to delete
the _bBvGLTransactionsHistFull view.
4. Rename the existing _bvGLTransactionsFull view to
_bvGLTransactionsHistFull
5. Obtain the MS SQL script from the Sage Evolution Support Department that .
recreates the _bvGLTransactionsFull view.
6. When done, log back in and re-open the Evolution company.
7. Run a GL | Maintenance | GL Relink and wait until done.
8. Users should now be able to run any type of GL related report without any further
issues."

Items 3, 4 and 5 are so clear how I can proceed with them. Please let me know how I can perform actions 3, 4 and 5. I really appreciate.

Rgds,

Thank you Bennie for this wonderful answer.

Quoting some sections from your file:

"These steps should ONLY be performed by a professional Evolution support consultant
(e.g. in Evolution Support Department or your local Evolution Business Partner).
1. Get all users to log out of the company.
2. Backup the company.
3. Within MS SQL Management Studio, run a SQL script to delete
the _bBvGLTransactionsHistFull view.
4. Rename the existing _bvGLTransactionsFull view to
_bvGLTransactionsHistFull
5. Obtain the MS SQL script from the Sage Evolution Support Department that .
recreates the _bvGLTransactionsFull view.
6. When done, log back in and re-open the Evolution company.
7. Run a GL | Maintenance | GL Relink and wait until done.
8. Users should now be able to run any type of GL related report without any further
issues."

Items 3, 4 and 5 are so clear how I can proceed with them. Please let me know how I can perform actions 3, 4 and 5. I really appreciate.

Rgds,

Hi Sylvester

Unfortunately it will not be possible to advise you on this platform how to achieve steps 3 and 4 as it require a deeper knowledge about working with MS SQL Management Studio and Evolution SQL database  tables, views. This kind of deeper knowledge cannot be explained on Sage City as its really very complex for someone who is not knowing how to work with Management Studio and Evolution DB tables and views.  

For that reason the article actually refer to rather consult with your Evolution Business Partner to accomplish it.

Else, the only other advise I can offer here is that, if you're a South African end user client, to rather log this query with Evolution Support by opening the following link 

https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465

If you're business is based outside of South Africa, please contact your Evolution Business Partner who should know exactly how to accomplish steps 3 and  4 above. 

Kind Regards

Bennie 

Thank you Bennie once again.

I have been able to achieve steps 3 and 4. I have deleted the _bBvGLTransactionsHistFull view. And renamed the existing _bvGLTransactionsFull view to_bvGLTransactionsHistFull.

However, I'm stuck with step 5. How do I recreates the _bvGLTransactionsFull view?

My business is based in Nigeria. We are also talking with a business partner. But as matter of urgency, we need to resolve this while agreements are completed with Business Partner. So please help me with steps 5.

i also nee the script to recreate

hi Elsee 

1. Are you also observing the same error below? 

: "Fields in _bvGLTransactionsFull and _bvGLTransactionsHistFull views do not match! Please contact your Administrator!". 

2. Evolution version?

3. When exactly is the error observed?

Kind Regards

Bennie 

Hi Bennie.

I have data on 7.20.4 that is showing differences between cashbook report and  transaction report . i was therefore trying to resolve it by refreshing views ie downgrading the version and upgrading it. I how ever got the error when i try to print the report after refreshing views.

if i upgrade the same data to 10.1.2 my cashbook and transaction report is showing correctly. we do not want to upgrade the client at the moment as they are also using xpedite. 

Regards

Elsee

Thanks Elsee

I wish I had an easy answer for you.... 

I think the bets way forward is to log this query with Evolution Support using the link below.

Then at least you know a dedicated consultant will assist you with this one.

https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465