Skip to main content
Solved

Load Id mandatory error when loading external supplier Payment

  • November 1, 2024
  • 2 replies
  • 110 views
P
Sidekick (Partner)
Forum|alt.badge.img+4

Hi team,

 

To load a supplier payment into the Mixed Payment window using an external file template, I keep encountering an error: “ORA-20124: Error.NULLVALUE: Field [LOAD_ID] is mandatory for Ext Payment Item and requires a value.” I reviewed the External File column definitions but couldn't identify any column for the LOAD_ID.

In the External Payments window, I also tried manually entering a Load ID, but there doesn’t seem to be a way to load the file for that specific Load ID. Could you provide input on what I should correct to successfully create the supplier payment?

 

 

 

Thank you

 

Best Regards,

Prabha

Best answer by Thomas Peterson

Hi, 

In a mixed payment, IFS has a number of different groups of data points / attributes.  To create a mixed payment, at a minimum you need data from the general tab, and the matching data. 

The noted file template (your csv) appears to have line (transactional) data only.   As a user you can’t simply enter new mixed payment transactions without the general data such as bank, MP id and other. 

As is, I don’t see how the noted file template can work.  

Either copy one of the system generated templates or use the function to create a template from the file type. 

Then as a user, enter a mixed payment and note the attributes you need to create and process a mixed payment.   Then create CSV based on the new template. Enter similar attribute and attribute values that were used in the user entered template. 

 

Best regards, 

Thomas

View original
    Did this topic help you find an answer to your question?

    2 replies

    T
    Superhero (Employee)
    Forum|alt.badge.img+19
    • Thomas Peterson
    • Superhero (Employee)
    • 1040 replies
    • Answer
    • November 8, 2024

    Hi, 

    In a mixed payment, IFS has a number of different groups of data points / attributes.  To create a mixed payment, at a minimum you need data from the general tab, and the matching data. 

    The noted file template (your csv) appears to have line (transactional) data only.   As a user you can’t simply enter new mixed payment transactions without the general data such as bank, MP id and other. 

    As is, I don’t see how the noted file template can work.  

    Either copy one of the system generated templates or use the function to create a template from the file type. 

    Then as a user, enter a mixed payment and note the attributes you need to create and process a mixed payment.   Then create CSV based on the new template. Enter similar attribute and attribute values that were used in the user entered template. 

     

    Best regards, 

    Thomas

    P
    H
    2 people like this
    • P
      prabha.ruberu
    • H
      Harindee Wickramarachchi
    P
    Sidekick (Partner)
    Forum|alt.badge.img+4
    • prabha.ruberu
    • Author
    • Sidekick (Partner)
    • 16 replies
    • November 14, 2024

    ​@Thomas Peterson -Thanks Thomas the issue was resolved once i add header details to the file and external file template control.

     

     

     

     

     

     

     

     

     

     

     

    Reply


    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings