Skip to main content
Question

How to get prepayment and payment details related invoice

  • 13 May 2023
  • 1 reply
  • 81 views

Forum|alt.badge.img

Hi,

I need to create a sales order invoice report below like that.

Payment Reference and Advanced Payment Reference need to get from same field in ARPayment table.

When Sales Order Invoice has Payment type I need to get ExtRefNbr field into payment Refernce column and When Sales Order Invoice has Prepayment type I need to get ExtRefNbr field into Advance payment Reference column 

How Can I get data from Report Builder.

1 reply

Forum|alt.badge.img+3
  • Varsity I
  • 205 replies
  • January 15, 2025

You need to create a subreport using the AR adjustment table since it is possible to have multiple payments or prepayments for an sales order or invoice.


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