I want to get the Vendor’s Bank Name, Bank Address, Account No, and SWIFT Code for the the Purchase Order report as shown in the below screenshot.
I know these attributes are in the CSAnswers DAC. But it is somewhat confusing. I need to add these bank details as shown in the below screenshot.
Can I know how to accomplish this as in above?
Best answer by miguel80
Hi!
I don’t think you need to neccesariy join the CSAnswers table. The attributes generally appear in the table you added them. For example: here’s an image of the Customer table:
You can find them there.
Don’t forget to refresh the fields in the report. It’s possible that you don’t see them because you haven’t refreshed them. First reload the schema and the click “refresh all”:
I hope this works.
Thank you so much
+19Hello, Please see the below link that shows how to add Vendor Payment details to a report.
Laura
+3Hi!
I don’t think you need to neccesariy join the CSAnswers table. The attributes generally appear in the table you added them. For example: here’s an image of the Customer table:
You can find them there.
Don’t forget to refresh the fields in the report. It’s possible that you don’t see them because you haven’t refreshed them. First reload the schema and the click “refresh all”:
I hope this works.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
