ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Sporadic >> Phantom PO Receipts
http://www.istechforum.com/YaBB.pl?num=1194377648

Message started by cathyh on 11/06/07 at 12:34:08

Title: Phantom PO Receipts
Post by cathyh on 11/06/07 at 12:34:08

We have had a similar problem like this before but I did not document it very well.
Two receipts for same item on same PO, line 1 and 3, were received on 10/11 and 10/16 and were invoiced.
Now October RNI has additional receipts for the same part, lines 1 and 3, same quantity with receipt date 10/18/07.
In IN-A, the receipts shows in the received PO's screen but there is 0 quantity in the received column. In the transactions screen, only the two valid receipts are showing, but not the two on 10/18.
In the open PO listing, these lines that are showing up in the receiving report and the RNI report are not included.
I believe I fixed this before by deleting the phantom records from BKAPHPOL. Does this sound like a good solution? Is there another one?
And Finally, What could have caused this??

Title: Re: Phantom PO Receipts
Post by lmk223a on 11/07/07 at 07:38:45

Did someone inadvertently close the purchase order on 10/16? Then the purchase order was re-opened on 10/18?

Re-opening a closed po will put phantom receipts on RNI that do not show in view po receivers and inventory transactions.

Title: Re: Phantom PO Receipts
Post by cathyh on 11/07/07 at 08:31:06

Wow, I have never noticed that before, but as I said I have seen this before and could not connect it to anything so maybe that is what happened. Not that anyone is admitting anything....

Will deleting the two bogus records in MB fix the problem?

Title: Re: Phantom PO Receipts
Post by cathyh on 11/12/07 at 15:27:09

Could anyone confirm that deleting the two records in BKAPHPOL will fix the problem and not affect anything else?

Title: Re: Phantom PO Receipts
Post by Lynn_Pantic on 11/13/07 at 19:12:12

Deleting will fix and updating will prevent future occurrences. We have corrected the bug with reopening PO's.

Title: Re: Phantom PO Receipts
Post by cathyh on 11/14/07 at 08:54:44

I will delete the records. As for the update, I thought I had the latest update; I downloaded the 9/27/07 update and installed on 10/20/07 and all the fixes I see in the list are posted before that. ???