Skip to main content
Question

Sum function to total payment_amount in external payment file (BACS)

  • September 2, 2021
  • 3 replies
  • 170 views

Forum|alt.badge.img+2

On the external payment I created below which will replace the standard IFS BACS format for a UK customer, how do I add a function to sum the total of column “payment_amount” which is a number data type (detail tab). Without sum, the payment file output will list all supplier invoice while the file sent to bank should sum invoices to pay as one lumpsum per supplier.  I did a search to list of available main functions, could not find sum function. The closest function I can find is “Add”. Am I missing something?

 

 

 

 

 

 

This topic has been closed for comments

3 replies

Forum|alt.badge.img+19
  • Superhero (Employee)
  • 1026 replies
  • September 3, 2021

The alternative to what you have previously done is to use LUMP_SUM_PER_ORDER as the basis for your file.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • September 3, 2021

The file type created is copied from PAY_TRACE_ITEM view. Column LUMP_SUM_PER_ORDER does not exist.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • 4 replies
  • September 3, 2021

Pay_Trace_item_view has the supplier electronic payment address(Data 1 through 6) and bank account information I need to pay vendor wile LUMP_SUM_PER_ORDER view only has lump_sump total by supplier. Perhaps a customized view needs to be created?


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