What Tables should I be referencing? <Crystal Report>

[Jcfx]

Hello!

Using CR 9 against GP 8.

I've been given the task of creating Financial Statements in Crystal report to check against FRx and reports from the originating Transaction source.

All of our transactions originate from a third party application and are integrated into great plains.

Because of this, alot of the tables I have seen referenced in this forum are generally empty for me .

The only thing that is marked as History are AP transactions that have had a check cut.

All AR are open.

For example I wanted to try to see all AR transactions for the year. The only two tables that had data were RM10101 and RM50101. What exactly is the RM50101 table?

Also is Dex_Row_Id the primary link between all of these tables?

Sorry for the newbish questions. I am just trying to find what tables would primarly be used for AR and AP when all the transactions orginate externally. All the user does is verify the integration balances <distributions etc> then posts. Cash receipts are the only thing applied manually.

Thanks

Julie
CR 9,10 CE10 Sql DB

 

[barbola]

Dex_Row_ID is a unique identifier for each record in the table.

In Great Plains you can find all the table names/descriptions under Tools > Resource Descriptions > Tables and select Great Plains as the Product and SALES as the series. You may even be able to see your third party product on the list as well.

 

[markajem]

When you go to Tools>Resource Description>Table and select the table you want you can look where it says KeySegments. These are the keys that you would link the tables with.

Example:
For open sales orders you would use SOP10100 and SOP10200 linking by SOPTYPE and SOPNUMBE