CM Transaction 1

[PTina]

I'm using smartlist builder to pull data from the CM Transaction table. However the amount fields do not indicate whether it was a positive or negative adjustment.

There are no DR and CR fields in this table either.

Any suggestions welcomed.

 

[barbola]

The Transaction Type (CMTrxType) and number (CMTrxNum) can be found in CM40101 as follows:
CMTrxType DOCTYNAM DOCABREV
1 1 Deposit DEP 1
2 2 Receipt RCT 2
3 3 Cheque CHQ 3
4 4 Withdrawal WDL 4
5 5 Increase Adjustment IAJ 5
6 6 Decrease Adjustment DAJ 6
7 7 Transfer XFR 7
101 101 Interest Income INT 8
102 102 Other Income OIN 9
103 103 Other Expense OEX 10
104 104 Service Charge SVC 11

Does this help?

barb.

 

[PTina]

Thanks Barbola, this does help. I'll try to see how to get it to work.

 

[PTina]

I got it to work except for when the Trx Type is a Transfer. With this type it could go either way - still looking for a work around for this.

Thanks.