Hi, we have a custom form that prints customer payment receipt and I want to pick up the branch details (Branch Name, address, ABN, phone) from the invoice. This is because they have invoices from different branches and pay it to the main branch. In this example, invoice branch is HCCVIC and the payment branch is in their main branch HDDDD
+9Hi
You should be able to adjust this in the relationships on the schema for your report. In the standard report SO643000, the joins are:
ARInvoice.BranchID = Branch.BranchID
Branch.BAccountID = BAccount.BAccountID
BAccount.DefAddressID = Address.AddressID
BAccount.BAccountID = Address.BAccountID
Note that the Address DAC is aliased as CompanyAddress.
I think something similar should work for you scenario. Take a look and let us know.
Hope this helps!
Laura
Hi
Just an update: I’ve managed to get the branch description, but not the branch details of the invoice yet.
+9Hi
You could join on ARPostTran to get the BranchID from the application history tab
However, because there can be multiple records in ARPostTran.BranchID, you may need a subreport. The subreport should incluce parameters for the payment document type and reference number. The subreport will select from ARPostTran and include the other joins as described above to print the branch address info in the subreport report header or report footer.
Hope this makes sense and helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
