on 01-21-2015 11:59 AM
Hi,
Happy New year to everyone.
I have to work on invoice tolerance check where i need to check the vendor invoice against a PO value.
This check as per standard SAP can be done either on certain % or certain value for example <= 5% or <= 10GBP
But i would like to have both the checks done.
Example
If i have an invoice whose difference is >5% and the amount difference is less than 10GBP it should not be blocked.
if i have an invoice whose difference is >5% and >10GBP it should be blocked.
how can this be done?
Is there any user exit i can use?
Thanks
Hi,
This can done in the t.code.OMRX.
Regards,
Mukthar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mukthar,
Thanks for quick reply.
could you please explain me how this works?
i had a look into this transaction code and see negative differences, positive differences and invoice reduction.
dont know how it works though.
Also are these tolerance limits for MIRO postings and 3 ways check with good receipt?
Thanks
Hi,
Check the below explanation for the above t.code.
In this step, you define tolerance groups for each company code. You can assign these tolerance groups to each vendor in the vendor master record.
You can define the following tolerances:
Total-based acceptance
Total-based invoice reduction
The system uses the following logic:
Negative differences:
negative small difference limit
absolute
percentage lower limits
Positive differences:
positive small difference limit
Check limit
not
absolute
percentage upper limits
Check limit
total-based invoice reduction
absolute
percentage upper limits
Activities
Specify
Further notes
If the system can create a small difference, it posts this difference to the account specified in account determination for transaction DIF.
See: Configure Automatic Postings
If no tolerance group is assigned to a vendor or if no tolerances have been specified for the assigned tolerance group, the system creates a difference line if the difference is smaller than the tolerance defined for tolerance key BD.
See: Set Tolerance Limits
Example
There is an invoice in the system to be posted; the vendor-specific tolerances are defined for the invoicing party as follows:
Total-based acceptance of negative differences
- Check absolute lower limit: 200.00-
- Check percentage lower limit: 4.00 %
- Check negative small difference: 10.00-
Total-based acceptance of positive differences
- Check positive small difference: 5.00
- Check absolute upper limit: 30.00
- Check percentage upper limit: 2.00 %
Total-based invoice reduction
- Do not check absolute and percentage upper limits
The invoice value expected by the system is 4000.
Gross | Small inv. amount | difference | Balance | Explanation |
---|---|---|---|---|
3992 | yes | 0 | 2 a) | |
3925 | yes | 0 | 2 b) | |
3820 | no | 180- | 2 b) percentage lower limit violated | |
4004 | yes | 0 | 3 a) | |
4025 | yes | 0 | 3 b) | |
4035 | no | 35 | 3 b) absolute upper limit violated | |
Regards,
Mukthar
Hi Muktar,
Thank you for the explanation, i spoke to the business about this solution but they are not comfortable since it needs changing the vendor master.
They want to use OMR6 and still want to set the block based on both the value AND percentage and not either OR.
is there any other way to do this?
Thanks
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.