Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Mxolisi Magaula
    Hash total calculation incorrect
    Topic posted September 13, 2019 by Mxolisi MagaulaGreen Ribbon: 100+ Points, tagged Financials, Payables 
    17 Views, 2 Comments
    Title:
    Hash total calculation incorrect
    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)))

    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

    Image:
    Document:

    Comment

     

    • 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.