I am trying to develop a custom job cost report using Crystal reports. I know Crystal fairly well but I know very little about table architecture of GP / Wennsoft.
The environment we use is both Great Plains and WennSoft for job cost. I am most interested in ALL CUMULATIVE DETAIL transactions that effect the actual cost of jobs. My question is which Great Plains and/or WennSoft table(s) will provide me with the detail I need? Also, is there any documentation available to me that explains the architecture of data flow within the GP/WennSoft system? Apparently some types of transactions originate in Great Plains, then are "posted" to WennSoft. This is what I mean by "flow", despite the direction.