How to add the Customer name to the "Marked Transactions Report" in Microsoft Dynamics GP

(0) Share

Report

Posted on by Rosess

Hello, our customer are requesting to change the customer ID to customer name in Marked Transaction Report. I realized that for type Dep, the report is showing the customer id instead of customer name. Our setting for the cash receipt is auto deposit for reconcile. Anyone know how to add the Customer name?

So far I have tried to do relationship for the CM Transaction and CM Receipt. In the Table Definition, for Restriction Expression: CM_Receipt.Received From = CM_Receceipt.Received From.

Conditional Field expression: CM_Transaction.Source Document = /RMCSH/, true case: CM_Receipt_Received From. False Case: CM_Transaction.Paid toRcvd From.

However when generating the report, some customers that have the same CM-Trx no will repeating showing in the report. Anyone can help me to solve this issue?

Categories:

Management Reporter