Hi everybody,
I have to create bank transfer letter for giving instruction to our bank to transfer money in our suppliers bank account. For this we need following information:
Bank Name
IFSC CODE
Account holder name (External bank owner name as in account name)
External bank account number
Type of Account
Branch
Now I am not getting all infromation in any table.
Please help me as soon as possible. Its really really urgent.
Thanks,
Table 4 Extrnl bank a/c holder name and a/c number
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
So you will be generating a bank transfer letter for every payment made to a supplier right ?
Since you have not mentioned any specific version, i assume you are in release 11, following table names might help you..
AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_Checks_All
AP_Invoice_Payments_All
Also refer to metalink note 148388.1 and download sample aplist which contains all payment related table names along with columns ....
NOTE: Make sure all of your suppliers are assigned to an supplier bank account , else it will be difficult to satisfy the requirement..
Since you have not mentioned any specific version, i assume you are in release 11, following table names might help you..
AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_Checks_All
AP_Invoice_Payments_All
Also refer to metalink note 148388.1 and download sample aplist which contains all payment related table names along with columns ....
NOTE: Make sure all of your suppliers are assigned to an supplier bank account , else it will be difficult to satisfy the requirement..
Who is online
Users browsing this forum: No registered users and 2 guests