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.
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.