DMEE setup: Total vendor payment
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,