Auto Match Invoice - having the same BM as Ref No

[raajamanikandan]

Have created a Match rule with BM as Shipment Refnum Qual ID, and have checked the Source Location Rule and Destination Location Rule.

Iam trying to send in multiple child invoices which have the same Bill of Ladiing No via integration, these child invoices have to match the respective shipments in a multileg scenario with distinctive Source and Destination, and have the same Bill of Lading No, but when ever I do this am getting an Invoice status of Match_Multiple_Shipment_Match. When I send in these invoices with distinct BM no and i have the shipments with distinct BM no it works perfectly.

Can anyone give us an idea why this is hapng, even if my Refnum qual is the same the source and destination is different so it should match the corresponding shipments, corrct me if am wrong.

[raj73]

Re: Auto Match Invoice - having the same BM as Ref No

This could be possible if you have multiple shipments (same source & destination locations) and with same BM shipment-reference-Number matching those on the child invoice in question. You could run a query from the Shipment Finder screen to double-check this.

[raajamanikandan]

Re: Auto Match Invoice - having the same BM as Ref No

Raj we do not have the same source and destination in any of the shipments, it is a multi leg shipment from Antwerp Factory to Antwerp Port by Truck, Antwerp Port to Kobe Port by Vessel and Kobe Port to Tokyo Factory by Truck, so we are trying to match the consolidated invoice from the service provider to these shipments, but we are getting results as Multiple Match, if the BM no is unique then it works just fine, the problem is only when we have the same BM no.

[leo.heckmann]

Re: Auto Match Invoice - having the same BM as Ref No

Guys,

The match rule indeed only goes of the refnum used for matching so if same for multiple , then you will get the MULTIPLE_MATCH status.

Can you generate a unique number using another refnum than BM and use that refnum to do the match?

Leo

[raajamanikandan]

Re: Auto Match Invoice - having the same BM as Ref No

Hi Leo,

Isnt the Source and Destination rule suppose to work as 'and' condition and constrain the match with these rules, this is one of our requirements since the Service Provider is sending 1 BM number for multiple shipments, any workarounds other than sending unique nos.

Thanks
Raja

[leo.heckmann]

Re: Auto Match Invoice - having the same BM as Ref No

Raj, you are right. Its been a while since I have done settlement and I got carried away. I think there is either a bug with the source dest lookup as it should work or there is a setup issue. PLease review your match rule setup once more against what is mentioned in Help, else log a bug with Oracle as the scenario you ahve described should work.