Question

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

  • 3 September 2021
  • 3 replies
  • 143 views

Userlevel 2
Badge +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

Userlevel 7
Badge +18

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

Userlevel 2
Badge +2

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

Userlevel 2
Badge +2

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?