Skip to main content

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?

 

 

 

 

 

 

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

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

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?

Terms & ConditionsCookie settings