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.