vendor Reference Document

[sridhar_muthekepalli3]

Dear Friends

In vendor invoice,T.code FB60, in reference document field, the user should not enter the same reference document number twice.The system should give an error message ' reference document already exists'.

Can this achieved by writing a validation. If so, How to create a validation?

Thanks

MSReddy

[sridhar_muthekepalli3]

thanks for the answers

[Former Member]

Hi,

Several answers were given.

1) You can make reference field mandatory for certain document types. Transaction OBA7.

2) You can mark vendor master field "Check double invoice" LFB1-REPRF on company code level. If you try to post an invoice with same reference field for the same vendor within the same company code and the same document date, then an warning message will be triggered during the document entry. It doesn't depend on the document type. If you want to change the message to error, then you can do it with transaction OBA5 (message F5/117).

3) If none of the above covers your requirements, then you could create a FI validation on line item level. Transaction OB28.

Regards,

Svetlin

[Former Member]

Hi

As per my knowledge by default if the invoice date and the reference number are same with other document then the system will through an error.

Only based on the refernce number I have to check. I will check and I will let you know.

Regards

Rs

[durgasankar_innamuri]

Hi,

As per my knowledge reference field make mandatory is in the document type level.

at the time of creating vendor in the screen where you specify payment terms there is one more option chk double invoice choose this one. so when your user entering any invocie twice the system will generate a warning message. if your user accepts that one you can convert that one into error message.

Hope this is clear, if yes assign points

Regards,

Sankar