Multiple Shipment Automatch with a Invoice

[MURTHYKO]

Dear Pals,

In OTM is it possible to auto match multiple shipments with one invoice? If yes, pls explain me how can we achive this?

Cheers,
Lakshman

[krishna.kk]

Re: Multiple Shipment Automatch with a Invoice

Do you mean to created a Single invoice for all the shipment ?

[krishna.kk]

Re: Multiple Shipment Automatch with a Invoice

Do you mean to create a Single invoice for all the shipment ?

[MURTHYKO]

Re: Multiple Shipment Automatch with a Invoice

Dear Pals,

In OTM is it possible to auto match multiple shipments with one invoice? If yes, pls explain me how can we achive this?

Cheers,
Lakshman

Actuall I have around 4 planned shipments in OTM and receiving an EDI invoice from carrier, which directly uploaded through integration. Now I am matching all the 4 shipments basing on Ref Num, which is showing in the "View Matched Shipments", but Auto Match is not working. System showing an error that multiple matches found. So how can I "Auto Match" more than one shipment with existing invoice?

Cheers,
Lakshman

[krishna.kk]

Re: Multiple Shipment Automatch with a Invoice

lakshman,

Using the Match Invoices action, you can manually match more than one shipment to an invoice. However, the AutoMatch Invoices action will automatically match only one shipment to an invoice.

Rgds
kishore

[MURTHYKO]

Re: Multiple Shipment Automatch with a Invoice

Hi,

I know that through automatch we can match one invoice with only one shipment in case multiple shipments it fail.But we have this reuirement to automatically match invoices to multiple related shipments.Please suggest come solution if any budy has worked in similar requirement.

Regrads
Arpit

[sally.thornton]

Re: Multiple Shipment Automatch with a Invoice

Hi,

RE: "[...] the AutoMatch Invoices action will automatically match only one shipment to an invoice."

Is this also the case when there are multiple reference numbers with the same qualifier on the invoice that match it to multiple invoices? For example, I have set the match rule to match the SI reference numbers on the invoices and shipments. I have entered an invoice where I have 2 SI reference numbers whihc match to an SI number on 2 shipments. The status I now get is MATCH_MULTIPLE_SHIPMENT_MATCH but there are no Buy Shipments in 'View Matched Shipment' and when I look at the 2 Buy Shipments in question they do not have a related invoice. Is there anyway to do this without the 'manual' match action as we may have hundreds of shipments quoted in one master invoice.

Thanks
Sally

[leo.heckmann]

Re: Multiple Shipment Automatch with a Invoice

What you really should be doing is getting one invoice per shipment from the carrier, then consolidate the CHILD invoices in OTM as a parent invoice and do the approval on the parent to send out payment to SP. the parent invoice and resulting voucher should contain all neccessary data to pay the SP (child invoice references, shipment references, order lines etc...).
Matching is meant to be on per shipment level and OTM does not cope very well with a master invoice per many shipments.

Is this invoice coming in via EDI?

[sally.thornton]

Re: Multiple Shipment Automatch with a Invoice

Hi,

We anticipate that the majority of invoices will be received in hard-copy and therefore manually keyed into OTM. Having worked with the i2 TMS, and having seen a multi-match process work before, I find this solution to be rather inpractical as we are looking at entering hundreds of invoices to each shipment per day. Is there any chance that this current rule may be changed? It looks like some work may have been done to allow multiple matching with the new status of [FONT='Times New Roman','serif']MATCH_MULTIPLE_SHIPMENT_MATCH [/FONT]now being available.

Thanks

Sally

[leo.heckmann]

Re: Multiple Shipment Automatch with a Invoice

Hi, I still fail to understand your shipment and invoice structure. Is it the case that you have a very large shipment handled by the carrier for perhaps many orders/customers and the SP sends you one invoice per customer? A shipment can have many invoices, but its the other way around that is more difficult. If a shipment has many invoices, the status you mention will handle it so you can sent up EDI for those invoices. Leo

[sally.thornton]

Re: Multiple Shipment Automatch with a Invoice

Hi,

We receive a monthly invoice from each of our 32 carriers. Each invoice has 250-300 lines on it and each line relates to a shipment. So the relationship is 1 invoice line = 1 shipment. We also have some of the larger carriers who invoice for 9,000-10,000 lines per month. So 1 invoice will equate to anywhere between 250 and 10,000 shipments.

Thanks

Sally

[leo.heckmann]

Re: Multiple Shipment Automatch with a Invoice

Sally, given this new info, I suggest you think about doing the following:
- SEnd in the invoice as a consolidated invoice into OTM where the stucture is parent invoice header then each line as a child invoice.
- Each child invoice will have a refnum which is common to the shipment (so each shipment created in OTM can have a refnum with value shipment ID and each child invoice on EDI parent will also have that refnum).
- EDI invoice arrives in OTM and uses an integration saved query to find each shipment from the invoices and does the match to all shipments from each child invoice.
-What you end up with is a parent invoice representing the paper invoice where all the child of the parent are correctly matched to its shipment.
- You can then approve the parent invoice in OTM , send the voucher and allocation base (if needed).
- You will probably want to use some sort of consolidated invoice report to view the large invoices before going for the approval.

Leo