Alert for duplication

[vivek_varun2]

one requirement is there from my client, for travelling expenses,the bill which they get from vendor is the sum of bills( suppose 100) .now they want a provision that if the same bill ( any one or two out of 100) comes again the system should give warning or error that this bill has been paid.

Is there any provision for this in DMS

thanks in advance

[vivek_varun2]

one thing more i want to say that they make payment by fb60 (vendor invoice) that means no PO is there and they are not entering all bills one by one manually,they are just entering the sum of the all bill

[Former Member]

Hi,

If you are using "object links" in DIR and uploading the bills as document in the system than using "1-n ratio" customizing in DC10 will be the solution. Since there is no default "object link" for "vendor invoice" than you should first create custom "object link" with required key fields. Than assign it to a document type. After clicking the check box under Define document types --> Define object Links -->1:n ratio you are able to prevent linking more than one document to a specific "vendor invoice" ...

Hope it helps...

[vivek_varun2]

Dear Omur,

They get summary of the travel bill (in excel sheet) from their vendor(travel agent) which includes multiple bills typically 200 to 300 bills, now when they make entry of these bills in SAP, it is not feasible to make 200 entries in SAP, so they make only one entry of the total sum of all the bills which is addition of 200 bills.

their concern is since they are not entering all the bill no in SAP and entering only summary (sum of bills), if any bill is presented second time for the payment they will not be able to track whether this bill has already come or not...

what they want is any space where they can maintain all the bill no in SAP, which is searchable, so in future if they have any doubt about a particular bill, they can search and find out if this bill has already presented.

presently they are attaching a excel sheet scan copy with this SAP document, but this is not serving the purpose as the text in the attached file is not searchable.

the answer which you have given is not addressing my issue, hope now the issue is clear ...

Regards

Vivek