Invoice Verification---Urgent

[Former Member]

Hi,

How do we force system to block all invoices for payment where the total invoice amount is =>$5000

while posting invoice in MIRO.

Thanks

Sivaram

[Former Member · Accepted solution]

1. Do you want to block the payments of invoice >=5000 OR

2. Disallow an entry in MIRO for amount >=5000??

For 2 you need to create tolerance limits

Vj

Assign points if info helps

[Former Member · Accepted solution]

Vj,

We need to allow user to post all invoices but we need those invoice >5000 to be blocked for payments so that we can release them manually using MRBR.

thanks

Sivaram

[Former Member · Accepted solution]

I think you can create validation for this in "Financial Accounting -> Special Purpose Ledger -> Tools -> Maintain Validation/Substitution/Rules -> Maintain Validations"

Vj

[Former Member · Accepted solution]

Vj,

Thanks for quick reply,

You mean create a substitution at Document level of the Accounting document created by invoice. but then how do we release them since the block is only in Accounting. Is there any transaction in Accounting which is similar to MRBR

thanks

Sivaram

[Former Member · Accepted solution]

Siva:

OK, I figured out one thing.

No need for validations.

This is what you can do, its a simple process:

Go to FLB1N, Click on dynamic selections,

pick "Amount" from the left hand screen so it comes on the right hand screen,

on the right hand screen in the "Amount" field click on the yellow arrow for multiple selections,

click on the range tab, enter the range as 4,999.99 to say 100,000.00 (or any other maximum amount you want, max amount that can go up for an invoice), click on the execute button,

then again click on execute on the "Vendor Line Item Disply" screen, (u may need to select the vendors, or just leave it blank if u want),

the next screen will show all the amount >4,999.99, now click on menu > edit > select all

Then press CtrlShiftF9 for Mass Change, there you can but a payment block

Hope this helps.

Assign points if info is useful

Vj

[Former Member · Accepted solution]

Once the invoices are blocked, it wont get picked up in F110

Vj

Assign points if info helps

[Former Member · Accepted solution]

VJ, this is a manual process and involves user inter action.

I doubt this would pass a SoX auditor as a business process as if someone forgets to do it the invoices wont block and will be paid.

Further to this, if an invoice had the block removed and was not paid and the mass update took place that invoice would then be blocked.

I would suggest using a validation, however the spro route you defined was for the special purpose ledger which is not for LIV.

[Former Member · Accepted solution]

Yeah I had it in the back of my mind that manual process may not be acceptable, but gave it a shot anyhow.

As regards, wrong validation path path, my bad.

Good to have experts give their inputs

Vj

[Former Member · Accepted solution]

Siva:

The path for Validation is as follows:

FI > Global Settings > Tools > Validation/Substitution > Validation in Accounting Documents

Mark: I guess this is the correct path.

Vj

[Former Member · Accepted solution]

Vj,

Thanks for your inputs,

When you said to have validation/substitution, i assume that it would be at FI Document Level. but not MIRO Document level. i can write a validation/substitution for that but how do we release them when we need.( by a higher level Clerk). Do you suggest to goto document change and change the payment block..?? if that is the case then lower level clerk will also have authorization to change it which spoils complete purpose of blocking. Do you want me to write one more validation there also and enforce the lower level clerk not to change that feild..??? is there any simple way than that...

Thanks in advance ...

Sivaram

[Former Member · Accepted solution]

I haven't figured out a simpler way yet....

Vj

[Former Member · Accepted solution]

Please note a MIRO invoice in SAP should have a different doc type than that of an Finance invoice.

Therefore a validation can be written.

I would recommend using the payment block field and that consideration is made how the block is removed, through LIV, manually or via the payment run.

[Former Member · Accepted solution]

Mark,

Thanks for the reply,

Yes, we MIRO has a different Doc Type and i can write a Validation to enforce Payment Block when the invoice is >5000. About Releasing i guess we can do it by MRBR Manually. but how can we do i via Payment Run..?? do you mean remove the payment block when it shows as exception in F110..??

Thanks

Sivaram

[Former Member · Accepted solution]

In payment block config you can determine how and when the block can be removed.

One of the options is to remove the block from the payment run.

So the payment run sees the invoice as blocked, and then you manually remove it from the payment run if you wish.

It is always best to do it from MRBR.

Sounds like you have a solution now.

[Former Member]

Hi

I dont think the above mentioned suggestions would fullfill your requirement

Go to SPRO->Materials Management>Logistics Invoice Verification>Invoice Block and try you can get what you want and also fullfill your requirements.

Good Luck

Hari

[Former Member]

Hari,

Thanks for the response, i guess we cannot fulfill our requirement using Invoice Block in LIV. Could you let me know how we can achieve the desired requirement..

Thanks

Sivaram

[Former Member]

Sivaram

Why dont you give it a try and see,we have it done.

Hari