Skip to main content
Question

Generic Inquiry: APTran to APPayments


bwhite49
Pro I
Forum|alt.badge.img+1

Hello,

I’m trying to get the subID (sub account ID) from the APTran connected to APPayments.

This GI works fine, but for the majority of records, the bill and associated sub accounts are not displaying even though there is a bill and a sub account associated with the payment. I can’t figure out why these records are not displaying this information correctly. I’ve tried merging this information several ways. Most of the records not showing a bill were payments of the type check or voided check, but not every check or voided check is missing. Most of the debit adjustments are showing, but not every debit adjustment. 

Below is an example. The payment has one bill connected, and the bill has one payment. Any ideas why this would not show in the GI?

one check under bills
One bill in checks and payments

Attached I have the xml available.

Thank you!

2 replies

aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • 1202 replies
  • June 6, 2023

There is no one to one relationship between APTran and APPayment. An APInvoice can have multiple lines and it can be paid fully at one or partially multiple times. What we pay is the APBill not AP lines (APTran) 

you can join APTran to APInvoice and APInvoice to APPayment but you will need to understand that a payment can be repeated in your report equal to the number of AP lines multiplied by number of payments (if paid partial). 
 

Not sure what are you trying to achieve but there is no direct and clean link and relation between APTran and APPayment and it shouldn’t be. You pay the bill not the bill items after all


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @bwhite49 

Could you please check if the below attached helps you


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings