2015 Feb 11 2:30 PM
Hi Expert,
Could you please help me on this issue urgently.I am stucked in my work.
My requirement is – If there are some open debit charges and invoices in an account .When payment posted on account it should first clear the invoice line items .
The intent of these changes is to make sure that main 0006 is cleared after mains 0100 and 0150. The only inconsistency I see here is the due date.
I have made SPRO configuration change for this.
Configuration change has been in following path.
SPRO Node: Financial Accounting Contract Accounts Receivables and Payable Basic Functions Open Item Management Clearing Control Clearing Variants Define Clearing Variants
The following changes need to be taken into effect:
Sequence: 50, 70, 95, & 97
Sequence: 50, 70, 95, & 97
Sequence: 50 & 95
Sequence: 40, 50, 80, & 90
It is working fine when payment posted on account the only problem is with Account Maintance T-Code FP06 (when Create proposal is checked .
It is also working as expected when due dates of invoice are in past but this is not working when due dates are in the future dated . as per requirement is it should
If there is any residual then also clear future dated receivables invoice
Scenario #1
Payment posted on account which is more than overdue receivables amount to verify how SAP will clear residual amount
System proposed to clear all overdue receivables, part of periodic bill, and EE charges
Scenario # 2 :- Checked the same account maintance when due dates of invoices are in the past.
Posted Check payment on the account to verify if check payment behavious differently
Here, Due dates are in past and this is working as expected .
Many Thanks,
Gyanendra
2015 Feb 11 8:21 PM
Hi Gyanendra,
Your requirement is payments/credits should clear the invoice charges first before clearing the miscellaneous charges regardless of the due dates right ?
In your clearing variant say there should be three steps
First step grouping string should be based on transaction 003 and in grouping rule give all sorts of credits and payments on account
Second step grouping string should be based on transaction 003 and in grouping rule give invoicing transactions and group should be 2
Third step Grouping string should be based on transaction 003 and in grouping rule give miscellaneous trnasactions and group should be 3
thanks,
Vikram
2015 Feb 12 12:24 PM
Hi Vikram,
Thanks for your update.
Could you please provide the path in SPRO where I can apply this . I have attached two screenshot for your reference. I have done changes in following path.
SPRO Node: Financial Accounting Contract Accounts Receivables and Payable Basic Functions Open Item Management Clearing Control Clearing Variants Define Clearing Variants
Many Thanks,
Gyanendra
2015 Feb 12 2:27 PM
Hi Gyanendra,
Create a Clearing Variant first in Spro Config-
SPRO-->Financial Accounting-->Contract Accounts A/R & A&P--->basic functions--->Open Item Mgmt-->Clearing Control-->Define Clearing Variants
In the first step
Grouping String Should be 004-Main Tr and group rule should be 3 and then assign the main transaction value as 0060.
In the Second Step
Grouping String should be 004-Main Tr and Group rule should be 3 and in there assign the main transaction value as 0100
Sorting String should be 010-Due Date and there will be no rank and no tick on sort field.
In the Third Step
Grouping String should be blank and Sorting string will be 010-Due Date.
Assign this variant in the following Config--
SPRO-->Financial Accounting-->Contract Accounts A/R &A/P-->Basic Functions-->Open Item mgmt.-->Clearing Control-->Define Specification for Clearing Types-->Define Defaults for Account Maintenance
Assign the clearing variant to Clearing type 03 and 04.
Thanks
AB
2015 Feb 12 4:11 PM