Payables Reporting at GL Level 1

[Jcfx]

I've been assigned the task of creating a dynamic report that will allow the user to delve into Payables down to the GL level. Basically the accounting department is fed up with haveing to follow hot links in the inquirey windows to figure out where a gl amount has originated from. We are starting with payables first.

Long story short, there are too many tables for something that should be so simple, and the link set up is a nightmare.

Right now I am working through PM2xxxx and PM3xxxx, as well as the GL tables.

We are using GP 9.

Has anyone else attempted this? Any recommendations?

The most efficient linking options?

Julie
CRXI CE10 / RS2005 Sql DB

 

[klewis10367]

Just use the GL20000 for YTD info and GL30000 for History and focus on the fields that start with orm*. These fields reflect the originating info.