ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> PO receipt error
http://www.istechforum.com/YaBB.pl?num=1156279711

Message started by cathyh on 08/22/06 at 12:48:31

Title: PO receipt error
Post by cathyh on 08/22/06 at 12:48:31

We had a hiccup in a PO receipt that we need to fix. PO had 2 items received and a third receipt of the first item with a negative quantity. So there should be 3 line items in the PO receivers- first item for 3, second item for 3, and another one for the first item for -1. These show in Print receivers and in the RNI report. But AP-C said there were no receivers and when I said yes to show all receivers for this vendor, there they were.
Somehow during the receipt the PO was closed and I reopened it in View PO receivers. We still cannot access the PO lines in AP-C.
In maintain database I found the record in two places, both BKAPPO and BKAPHPO. The BKAPHPOand BKAPHPOL record has correct amounts in RNI$and number of lines. The BKAPPO and BKAPOL records are not correct- in BKAPPO there are no $ in RNI$, and in BKAPPOL there are only two lines and the fields for BUYOFF and SCRAP each have 3 in them.
I edited the record in MD-- I changed the RNI amount in BKAPPO to the right amount, and zeroed out the buyoff and scrap fields, and ran through the PO-C again, receiving 0 amounts and now I can see the two lines with 3 each in AP-C.

How do I get the third line to show up ?

The inventory records are good, showing a receipt of 3 and -1 for the first item, and 3 for the second item. The GL record for the receipt is also right.

There must have been some sort of record lock happening when this occurred. The person who entered it has done this procedure many times, and noticed nothing unusual.

Title: Re: PO receipt error
Post by lmk223a on 08/23/06 at 05:00:36

AP-C is a little finicky for negative dollar/negative quantity receipts.

In order to see them in AP-C, the invoice amount you enter must either be $0 or a negative dollor amount before they will appear.

Title: Re: PO receipt error
Post by cathyh on 08/23/06 at 07:02:50

We have done this many times before and it has always worked, but we are not doing a negative total. Instead, we are just reducing the total amount received for a line item, ie 3 reduced to only 2.

Title: Re: PO receipt error
Post by cathyh on 08/23/06 at 07:35:17

I mucked around some more in maintain database this morning and fixed it. I had to add a BKAP_POL_ARD for the line items in BKAPPOL, and delete a BKAP_POL_INVNUM "CPMOREY" in the BKAPHPLO and BKAPHPO records. I had already deleted a INVDTE and PSTDTE in BKAPHPOL yesterday. PMOREY is the user who entered the PO receipt, and she never went to CLose PO, but somehow the PO closed. Normally it does close for receiving purposes, but in this case it closed as in closed and put away!