You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Hash total calculation incorrect

edited Sep 13, 2019 6:34AM in Payables, Payments & Cash Management 2 comments

Summary

Why is the script not calculating the correct hash total

Content

Hi Experts,

I'm new to financials module,we are currently implementing a project and I'm responsible for reporting.

There is an RTF template that was being used on EBS and now we are using it on ERP Cloud

The RTF template is being used on the report 'Funds Capture Authorization And Settlement Formats' to produce an etext file for debit orders.

All the data is populating correct except a field called 'Hash Total' and this is because the following script is not returning the correct length.

LENGTH(SUM(NVL(PayeeAccount/FundsCaptureOrder/ PayerBankAccount/BankAccountNumber,0)))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!