Controlling Fields in MIGO Header

[Former Member]

Dear Friends

My problem is when purchase dept enters the procured material inside the factory, they do MIGO. In the MIGO Document header, in the field Delivery Note, they give customer invoice number as reference number. We do not want in any case that we create two MIGO documents with a single reference number ( customer invoice no).

After wards when the finance dept. create MIRO, they create MIRO in reference to this delivery note no. Thus there is a danger that a single customer will be billed twice.

But here we want to create a check point so that the same number is not accepted by this field , namely delivery note, in MIGO more than once. Pls tell me how to do it.

Thanks

Sangeeta

[Former Member]

HI,

You have to go ABAP only , No alternate setting in MIGO.

Regards,

Andra.

[Former Member]

Dear Friends

Can you tell me which user exit I am to use for this? Can you tell me how to do this in the system step by step? I have to first create a project from T Code CMOD....what after it?

Thanks

sangeeta

[former_member529134]

Hello,

The delivery note field is a text field and you will be using the function Read text to get the data from the field.

Then what you can do is to compare that with the entries is the same field with vendor number from MKPF and MSEG. But what i feel is that, the check you introduce will not be cent % dependable as it depends on the text the user is typing at the time of MIGO in the goods receipt header. One might give an extra space b/w the figures, system will take that as another bill number. So the dependency of the check is in doubt.

Regards

[Former Member]

Dear Friends

Can you please tell me the name of user exit regarding this?

Thanks

Chandra

[former_member529134]

Hello,

Just check the below ones with your abapper.

MB_CF001 Customer Function Exit in the Case of Updating a Mat. Doc.

MBCF0002 Customer function exit: Segment text in material doc. item

MBCF0005 Material document item for goods receipt/issue slip.

Also you have to check the vendor number also along with invoice as it is possible to get the same invoice number from different vendors. But when i was checking the requirement, i coudln't find the storing of the delivery note field. Do update how things went for you with the developemnt.

regards

[Former Member]

HI

There is a control at MIRO stage for double invoice, for this IN vendor master Payment Transactions Accounting you will find the Double Invoice Chk box below Tolerance filed activate it. During MIRO you have a Reference field in the basic data tab at header level, in this field we enter vendor Invoice number , there are three factor which is taken into consideration for double Invoice 1. if the vendor is same 2. if the reference no./details same 3. if the posting date is same.

Just chek out this option also.

Regards

[Former Member]

Hi Sangeeta ,

The following field exit may help you .

FIELD_EXIT_LFSNR

Contact your ABAPer for the necessary changes.

Regards

Ramesh Ch

[former_member581212]

hi,

Do use of Delivery compleated indicator for the reference in the MIGO...

If you want to restrict at MIRO, ie. not for double payment, then you can use the "duplicate invoice check" indicator in the MMR and get activated from SPRO based on:

Company code

Vendor

Reference

Document date

Amount

Currency...

When you do activate for co .code, reference and doc. date, all other 3 parameters get activated automatically....

do settings here:

SPRO >> MM >> LIV >> Incoming invoice >> check for duplicate invoice...

Regards

Priyanka.P

[Former Member]

Dear Friends

Thanks for response, duplicate invoice check indicator is all ready active in MIRO. But my users need that the same number in the MIGO header, delivery note, wont be accepted twice.

We dont have an ABAPer right now. Can you please let us know any alternative way to do it?

Thanks

Chandra