cancel
Showing results for 
Search instead for 
Did you mean: 

PLD Customer Bank Details

Former Member
0 Kudos

Hi all

I am designing a PLD - based on AR Invoice document. I require my customer bank details fully

1. customer bank address

2. customer bank city

3. customer bank state

4. customer bank country

5. Customer bank zip code etc

Which table i have to selct to get all the above details for the source type : Data base.

I checked BP table - only customer's default branch, country, a/c are available.

Thanks & Regards

Ganesh Varma. G

Edited by: Ganesh Varma on May 19, 2008 12:57 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ganesh Varma,

You can get customers Bank details from RCT1 Table. It gets data from Incoming payment. Bank Name as Account No. , Branch as Branch No. , A/c No. as A/C No.

Former Member
0 Kudos

Thanks for u'r reply.

I am speaking abt PLD tables.

source type: database

Table: ..........?(which table i have to select)

Field:.............?(which table i have to select)

I want to pick customers bank address, city & Pin code.

Ganesh Varma. G

Former Member
0 Kudos

Hi

Which template are you working with (Check, Outgong Payment, etc...)?

Paulo Calado

SAP Business One Forums Team

Former Member
0 Kudos

Hi Ganesh Varma,

Where did you enter Customer's bank address, city & pin code?

Former Member
0 Kudos

Base document is AR invoice

Former Member
0 Kudos

I am entering customer bank details at

Business partners> customers> payment terms tab> next to Bank country > click on the round icon.

at that place I am entering customer bank details.

The data is capturing into OCRB table.

how to pull out this data into PLD?

Thanks & Regards

Ganesh Varma. G

Former Member
0 Kudos

Hi

Unfortunatelly you can't bring the information direct from the A/R Invoice PLD.

What you can do (as an workaround) is:

1. Create a query (and save it) to get the information you want like that:

  • Query for BankName *

SELECT T0.BankName FROM DSC1 T0, OCRD T1 WHERE

T0.BankCode=T1.housebank

  • Query for Bank Street *

SELECT T0.Street FROM DSC1 T0, OCRD T1 WHERE

T0.BankCode=T1.housebank

2. Create an UDF for each one of the queries, for example

- BankName

- Street

3. Assign a Formatted Search for the UDF's you have defined at the 2nd step and using the respective query from the 1st step.

4. In the PLD you should add the fields UDF's fields in order to get printed the information from the UDF's, for example:

Field_1

Content Tab

Database Field

Table: A/R Invoice

Coumn: BankName

Field_2

Content Tab

Database Field

Table: A/R Invoice

Coumn: Street

Paulo Calado

SAP Business One Forums Team

Former Member
0 Kudos

Hi,

The bank details you are looking for are in the OCRB table, which is not available to choose for the Invoice.

Previously we could display these details by choosing the OCRB table with the ALT functionality in PLD and then using the Relate to option, but unfortunately it is not supported anymore.

What you can do is to create some UDF's with some Formatted Searches on the Business Partner master data to display there all the information you need, so then for the Invoice layout you can choose those fields simply from the BP table.

Hope it helps.

Regards,

Nat