How to match 2 receipts to 1 AP invoice line?

This forum doesn’t allow attachments, can you offer a link instead, or send direct.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 16, 2015 11:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: How to match 2 receipts to 1 AP invoice line?


I tried posting this a little bit ago, but I didn't see it in the conversation. Trying this again. This is from the person that is looking to be able to do this. Hopefully this helps give more insight into the situation.

My issue is, we have started bringing in AP Invoices EDI and because most times the invoices are received before there are any merchandise received we are adding the invoice lines as “Unreceived Lines” and this process is working well for us, however, when I go to match the invoice to the receipt through the Invoice/Receipt Match, when there are multiple receipt lines for one invoice line, it only allows one receipt line to be matched to the invoice line. Please review the following screenshot:

[Image removed by sender.]

The system will only allow for me to choose one of the Unmatched Receipt Lines to match to the invoice. Since I am only able to match one line, there is an entry made for a variance and the second receipt is reported as received not invoiced.

Is there a way to match all of the found receipt lines to one invoice line? If there is not, how do we need to handle the other receipt lines that are not able to be matched?



[Non-text portions of this message have been removed]

How to match 2 receipts to 1 AP invoice line. The current design does not allow this to happen. How do we do a work around for this? We are on Epicor 9.05.606.


As far as I know, there is no way to match two receipts, to one invoice.  This has been a major pain for us.  The only "work around" I know of is to un-receive the 2 receipts and combine them.  Of course if it's gone through inspection you're screwed....   We've started to do different PO Line releases for each shipment, or use Advanced Billings instead of un-received lines.

If anyone else has any insight, we would love to hear about it.
Can you elaborate your scenario, we match multiple receipts to one invoice all the time, but perhaps without detail I can’t be sure it’s the same issue you’re faced with.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 10, 2015 8:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: How to match 2 receipts to 1 AP invoice line?



As far as I know, there is no way to match two receipts, to one invoice. This has been a major pain for us. The only "work around" I know of is to un-receive the 2 receipts and combine them. Of course if it's gone through inspection you're screwed.... We've started to do different PO Line releases for each shipment, or use Advanced Billings instead of un-received lines.

If anyone else has any insight, we would love to hear about it.



[Non-text portions of this message have been removed]

Here is a follow up from the person looking to pull this off, if it helps provide some insight.


My issue is, we have started bringing in AP Invoices EDI and because most times the invoices are received before there are any merchandise received we are adding the invoice lines as “Unreceived Lines” and this process is working well for us, however, when I go to match the invoice to the receipt through the Invoice/Receipt Match, when there are multiple receipt lines for one invoice line, it only allows one receipt line to be matched to the invoice line. Please review the following screenshot:

 

 

The system will only allow for me to choose one of the Unmatched Receipt Lines to match to the invoice. Since I am only able to match one line, there is an entry made for a variance and the second receipt is reported as received not invoiced.

 

Is there a way to match all of the found receipt lines to one invoice line? If there is not, how do we need to handle the other receipt lines that are not able to be matched?

I tried posting this a little bit ago, but I didn't see it in the conversation. Trying this again. This is from the person that is looking to be able to do this. Hopefully this helps give more insight into the situation.


My issue is, we have started bringing in AP Invoices EDI and because most times the invoices are received before there are any merchandise received we are adding the invoice lines as “Unreceived Lines” and this process is working well for us, however, when I go to match the invoice to the receipt through the Invoice/Receipt Match, when there are multiple receipt lines for one invoice line, it only allows one receipt line to be matched to the invoice line. Please review the following screenshot:

 

 

The system will only allow for me to choose one of the Unmatched Receipt Lines to match to the invoice. Since I am only able to match one line, there is an entry made for a variance and the second receipt is reported as received not invoiced.

 

Is there a way to match all of the found receipt lines to one invoice line? If there is not, how do we need to handle the other receipt lines that are not able to be matched?