Missing Receipt Lines in AP Invoice Entry - New Receipt Line

Our accounting team is attempting to enter an invoice for two items that were received in 2019. The receipt lines are in the Received Not Invoiced report, however they do not show up in the list when you attempt to add Receipt Lines to the AP Invoice.

I don’t know the story behind the 5 year delay… and I think it’s beside the point but maybe has something to do with the issue?

What might cause this to happen?

Here are several points that I have checked:

  • PO lines were received complete on a single pack slip.
  • Received is checked, Invoiced is unchecked for both receipt lines.
  • Shows up correctly in Received Not Invoiced report.
  • Fiscal period in which the items were received is open.
  • Company Configuration > Finance > AP > ‘Save Receipts for Invoicing’ is checked, and as far as I know, has been since implementation in 2017.

When the ‘Save Receipts for Invoicing’ setting is enabled, are there records written to a database table somewhere that I should be checking for?

I’m not sure, but I do not think that they are saved separately. I believe Epicor uses the receipt tables to identify what is available to AP.

Wondering if you ran a query against the receipt tables to see if maybe something is off? Maybe it shows not invoiced but it actually is in the table?

Also, check if there are other invoices created for that packing slip/line. Perhaps an invoice was created for less than the full receipt line before? I would still expect the receipt to be available for invoicing unless your company configuration is set to not allow multiple invoices per receipt.

2 Likes

I should have included in my original post that I queried the APInvDtl table for any lines related to this PO and/or PackSlip number, and there are none.

Also, the Pack Slip header record shows SaveForInvoicing = TRUE, Invoiced = FALSE.

I would also have a look at Inspection Processing board if the receipt/PO line required any inspection. Can you confirm if inspection was required or has been completed already? Not sure if this will help but worth checking…

1 Like

Thank you for that suggestion, but Inspection Required is not enabled for these lines.

Hi Andrew, shot in the dark here. Have you looked at the Earliest Apply Date? This may prevent the receipts from pulling in.
image

That is a great idea, thanks, but in this case it’s set to July 2016 so not the issue this time.

1 Like

It was a minor data issue on the POHeader and RcvHead records. The POType value was blank, not ‘STD’ (Standard) as it should have been.

A “data fix” resolved the issue.

Reference KB0045337

6 Likes