Example: Selecting Documents for Credit Reimbursements
For the records that you specify in data selection, the system creates reimbursements if the amount is a credit (negative). For example, assume you have these records in the F03B11 table:
Customer |
Company |
Document Type |
Amount |
Currency Code |
|---|---|---|---|---|
4272 |
00001 |
RM |
–100.00 |
USD |
4272 |
00001 |
RI |
50.00 |
USD |
4272 |
00001 |
RI |
100.00 |
USD |
4272 |
00001 |
RM |
–200.00 |
USD |
4272 |
00010 |
RI |
80.00 |
USD |
4272 |
00010 |
RM |
–150.00 |
USD |
4272 |
00010 |
RI |
180.00 |
USD |
You can use data selection as follows:
If you run the data selection with customer number 4272 as the only selection criterion, the system generates one reimbursement for 150.00 USD, based on the customer number (4272), company (00001), and currency code (USD) group.
The system generates a reimbursement because the overall balance of the customer's account based on the grouping is negative. The system does not generate a reimbursement for company 00010 because the overall balance is positive.
If you run the data selection with customer number 4272 and a document type of RM as the selection criteria, the system generates two reimbursements for customer 4272:
One for 300.00 USD based on customer number (4272), company (00001), and currency (USD).
One for 150.00 USD based on customer number (4272), company (00010), and currency (USD).
The system does not consider the overall balance of the customer's account because you specified document type RM.