Views Reply Votes
Rajan Prabakaran
Rajan
 8
Query to track entity wise supplier bank number.
116
2
00
Posted: Jul 17, 2019   
Votes
Shivakumar Patil
Shivakumar
 45
Replied 

I have tested and it displays all the bank data attached to the supplier

define buffer banknumber2 for banknumber.

for each creditor where creditorcode = "suppliercode" no-lock,
    each banknumber
    where banknumber.parentobject_id = creditor.creditor_id no-lock,
    first BankPayFormat no-lock
    where BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID,
    first BankNumber2 no-lock
    where BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID,
    first CompanySharedSet where CompanySharedSet.CompanySharedSet_ID =
BankNumber2.CompanySharedSet_ID no-lock,
     first Company where Company.Company_ID = CompanySharedSet.Company_ID
no-lock:
    display creditorcode banknumber.banknumber companycode .
end.

let me know if it works for you :-)

00
Replied: Jul 25, 2019
Votes
Rajan Prabakaran
Rajan
 8
Replied 

Hello Mr. Shivakumar,

   It's working, Thanks for your help.

  

10
Replied: Jul 28, 2019
Forums
All
Forum Help
Help Using Forums