Can anyone tell me the names of the tables in the Sage 50 Canadian Simply Database that pertain to the General Journal Entries? I am using the Sage 50 Intelligence Reporting module. I am using MS Excel with MS Query to create a report in Excel that lists all the General Journal entries c/w details in the database but I do not know the names of the tables that contain this data.


Dale McLain

Views: 103

Reply to This

Replies to This Discussion

Good day

Kindly note that it would be better to post this question to Sage 50 specialist as they have their own community on the link found below :

Hope you find what you looking for:)

Have a great day.

Here the latest version I have of the data dictionary.

The answer to your question depends on which year of data you want to retrieve.

This year is tjourent

Last year is tjently


Thanks Paul. That is exactly what I needed.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service