Payables & Cash Management

Get Involved. Join the Conversation.


    Mxolisi Magaula
    Hash total calculation incorrect
    Topic posted September 13, 2019 by Mxolisi MagaulaGreen Ribbon: 100+ Points, tagged Financials, Payables 
    17 Views, 2 Comments
    Hash total calculation incorrect
    Why is the script not calculating the correct hash total

    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)))

    For an Example we have a Payer that have an Account Number with 11 digits 88881939266 but when we run the debit order process this script will return 15 instead of 11.

    Please help:

    Why is the script not calculating correct hash total.

    Thanks in advance,

    Best Regards,

    Mxolisi Magagula




    • Becky Alvarez

      Did you mean for this to be in Payables or Receivables?  I think you would get more responses if this were in Receivables since it is dealing with funds capture and this forum is mostly for payments.  I can move it if you like.

    • Kondaiah Mandadi

      Please provide the exact template name that is being used by customer.