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.
Best answer by dgodsill97
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.
+3You 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
