otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Settlement
Reload this Page

Multiple Shipment Automatch with a Invoice


Settlement Utilizing Settlement in OTM / G-Log - including invoicing and billing.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old May 21st, 2008, 06:35
Member
 
Join Date: Feb 2008
Posts: 62
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
MURTHYKO is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old May 21st, 2008, 08:01
Senior Member
 
Join Date: May 2007
Posts: 102
Thanks: 22
Thanked 5 Times in 4 Posts
Groans: 2
Groaned at 0 Times in 0 Posts
Rep Power: 2
krishna.kk is on a distinguished road
Re: Multiple Shipment Automatch with a Invoice

Do you mean to created a Single invoice for all the shipment ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old May 21st, 2008, 08:02
Senior Member
 
Join Date: May 2007
Posts: 102
Thanks: 22
Thanked 5 Times in 4 Posts
Groans: 2
Groaned at 0 Times in 0 Posts
Rep Power: 2
krishna.kk is on a distinguished road
Re: Multiple Shipment Automatch with a Invoice

Do you mean to create a Single invoice for all the shipment ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old May 21st, 2008, 08:47
Member
 
Join Date: Feb 2008
Posts: 62
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
MURTHYKO is on a distinguished road
Re: Multiple Shipment Automatch with a Invoice

Quote:
Originally Posted by MURTHYKO View Post
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old May 21st, 2008, 10:00
Senior Member
 
Join Date: May 2007
Posts: 102
Thanks: 22
Thanked 5 Times in 4 Posts
Groans: 2
Groaned at 0 Times in 0 Posts
Rep Power: 2
krishna.kk is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old May 27th, 2008, 11:37
Member
 
Join Date: Feb 2008
Posts: 62
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
MURTHYKO is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old November 11th, 2008, 10:53
Junior Member
 
Join Date: Jul 2008
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
sally.thornton is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old November 19th, 2008, 09:57
Junior Member
 
Join Date: Nov 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
leo.heckmann is on a distinguished road
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?
__________________
MavenWire
www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old November 19th, 2008, 12:21
Junior Member
 
Join Date: Jul 2008
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
sally.thornton is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old November 19th, 2008, 12:30
Junior Member
 
Join Date: Nov 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
leo.heckmann is on a distinguished road
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
__________________
MavenWire
www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidated Bill/ Invoice uma Settlement 4 March 4th, 2008 11:38
Invoice Line krishna.kk Settlement 0 February 21st, 2008 12:44
Invoice XML Exception sholl Settlement 2 December 14th, 2007 16:26
Consolidate multiple orders into one shipment otmrookie Planning 4 December 14th, 2007 16:26
AUTOMATCH with SELL SHIPMENT Stefano Settlement 5 July 24th, 2007 21:21



All times are GMT. The time now is 04:51.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37