Symptom
You have the following errors in the Data Flow Verification(DFV) Error for a Manual Payment:
"Transaction amounts differ
Accounting Notification ABC(ABC is the Payment ID), Operational Document Type Manual Payment, Company.
Accounting Notification Item ABC-N (N is the item ID of the payment).
Financial Audit Trail Documentation 0 for Payment Order ABC of Company.
Payment Allocation Item N."
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Application and User Management work center.
- Go to the Business Data Consistency view.
- Go to the Data Flow Verification Results subview.
- Select DFV Result DEF (DEF is the DFV Result ID).
For manual payment ABC, the following errors are displayed:
"Transaction amounts differ
Accounting Notification ABC(ABC is the Payment ID), Operational Document Type Manual Payment, Company.
Accounting Notification Item ABC-2 (2 is the item ID of the payment).
Financial Audit Trail Documentation 0 for Payment Order ABC of Company.
Payment Allocation Item 2."
Cause
The line Item N is split into two lines in the Business Transaction for Accounting of the Journal entry.
The split of one item creates two lines in business transaction. During data flow verification process it tries to compare the actual amount with business transaction amount. But, due to split of the items the system raises the error - " Transaction amounts differ ". In real time scenario there is no error.
You can check this as follows:
- Go to the General Ledger work center.
- Go to the Journal Entries view.
- Search for ABC.
- Select the related Journal Entry XYZ (XYZ is the journal entry ID) and click open the same.
- the Manual Payment is ABC.
- Click open the same and then View All. --> it is an outgoing bank transfer for the amount AAAA.AA Currency.
- Go back to the JE XYZ.
- Click You can also and select View Business Transaction for Accounting.
- Click View All.
For the Item ABC-2, the lines are split into two. The sum of the amounts in the two split items is same as the amount in the item1.
As the line in the business transaction got split in to two line the system could not recognize the actual amount of Payment allocation.
Resolution
You can ignore the DFV Result and close the same.
Keywords
KBA , SRD-FIN-MOP , Payment Management , Problem