Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
unidentified user
mtorrisi7
Posts: 1
Registered: 10-21-2011
0

Crystal reports

We are running MAS 200 version 4.4 PU 8. We are using a crystal reports for commissions. The report uses ar_invoicehistorydetail and ar_invoicehistoryheader as its fields. We have created a custom formula field to get period to date information. Crystal does seem to be picking up a line extension when the same item with same quantity exists on the same invoice (it only picks up one of line items). Our reseller has no clue wondering if anyone can help.

Sage MAS 90 Customer
blorf
Posts: 30
Registered: 11-03-2009
0

Re: Crystal reports

Can you provide your reports record source in a sql string?  From the outside, it sounds like you have "group by" turned on.

 

 

Super Contributor
Posts: 1,461
Registered: 11-03-2008
0

Re: Crystal reports

How did you link the invoice history header and detail files?