on 09-25-2008 6:04 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Aloy,
I am afraid that you would need to use aggregation function in this case.
BR, Vaclav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.