cancel
Showing results for 
Search instead for 
Did you mean: 

DMEE setup: Total vendor payment

Former Member
0 Kudos

Hi all,

I'm trying to setup DMEE for my vendor payments. The requirement is to have a single level tree layout with the total vendor payment amount for each line. I'm using the source structure FPAYH-RWBTR to map the payment amount but this field doesn't give me the total amount to be paid to vendor, instead it's giving me amount of vendor line items to be paid.

Example: I'm paying 2 invoices for a vendor:

invoice A = $1000

invoice B = $1500

Since the bank requirement is to have a file with a single level layout (no header, no transaction, no trailer), I need to capture the total on the invoices which is $ 2500. But instead, using the field FPAYH-RWBTR, I'm only getting the amount $1,000.

Is there a field that I can use that would give me the total instead of the line item amount? or is there another DMEE design to achieve my requirement?

Thanks and regards,

Aloy

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member194797
Active Contributor
0 Kudos

Hi,

FPAYH-RWBTR is the right field, but the grouping of several invoices into a single payment must be done by the payment program.
See Note 305414 - F110: Unintelligible grouping of documents.

Former Member
0 Kudos

Hello Aloy,

I am afraid that you would need to use aggregation function in this case.

BR, Vaclav