General Journal Database Tables

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.

Thanks,

Dale McLain

Views: 53

▶ Reply to This

Replies to This Discussion

Permalink Reply by NATE on November 1, 2017 at 9:18am

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 :

https://sagecity.na.sage.com/support_communities/sage50_accounting_us/

Hope you find what you looking for:)

Have a great day.

Permalink Reply by Paul on December 5, 2017 at 5:06am

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

Attachments:
Permalink Reply by Dale McLain on December 5, 2017 at 6:38pm

Thanks Paul. That is exactly what I needed.

RSS

This Weeks Top Content 

1 Sage 100 : Dynamic Range Setup and Refresh buttons not visible under Tools in the Task Pane

Sage 100 : Dynamic Range Setup and Refresh buttons not visible under Tools in the Task Pane
2 SMTP Dustribution outgoing mail server does not exist or cannot be reached

SMTP Dustribution outgoing mail server does not exist or cannot be reached
3 Account Groups

Account Groups
4 SAGE market footprint

SAGE market footprint
5 Union report with different underlying Databases

Union report with different underlying Databases

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service