MAS 90 and Crystal Reports GL Detail Posting 1

[MBGuidry]

Can someone please help me identify which tables I need to link in order to pick up the expense accounts for specific depts and a time frame? I have never written a report in Crystal for the GL and am having a hard time finding the table relationships. What tables do I need to link to obtain the expense breakdown out of MAS 90?

 

[AndyMc]

Depending on the level of detail needed:

GL_DetailPosting linked to GL_Account

or

GL_PeriodPostingHistory linked to GL_Account

 

[AndyMc]

If before 4.0:

GL_DetailPosting = GL5
GL_PeriodPostingHistory = GL8
GL_Account = GL1

 

[MBGuidry]

Thank you very much, this was just what I needed.