Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) How to query for the A...

How to query for the Amount Paid in the Details section of the Manual Check/Payment Entry screen

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, how do you pull the Amount Paid in the Detail section of the Manual Check/Payment Entry screen? In customized mode it says it comes from the APTran table - curytranamt field. I was able to trace back to the APTran record but the amount is the original amount of the voucher and not the paid amount in that particular check.

*This post is locked for comments

All responses (1)

Answers (0)

Bill Degnan 650 on at

Like (0)

Report

RE: How to query for the Amount Paid in the Details section of the Manual Check/Payment Entry screen

The amount paid is recorded in the apadjust table. the reference number field for the voucher is apdjust.adjdrefnbr.

The reference number for the payment applied in adjust.adjgrefnbr

The amount of the payment applied to the voucher is adjust.adjamt

Be careful since there can be multiple payments applied to a voucher.