Skip to Content
0
Apr 26, 2009 at 01:30 AM

Crystal Reports and Great Plain (Microsoft Dynamics GP)

42 Views

HI I am having this issue with obtaining item Qty's for a report. The way this company is set up it appears that QTY's sold are saved obtainable from the history file, since this is a monthly recap report sure.

It would likely be called something like, SOP Line History.

It needs to be joined to SOP30200 which has the Doc Date. Just like 10100 and 10200 are joined.

My main need is likely to need to understand more about GP but in the meantime, I am very close to implementing a new automated process. If I can get the right table.