Somehow we have an arrived line on a PO Receipt that will not let me delete it on the Receipt Entry form. When I try to delete it, it looks like it is being deleted but going back into the receipt it shows up again. It is giving errors about Invalid UOM. It somehow got saved in error. How do I delete this? The rest of the PO has already been received.
If you highlight the line you should be able to delete it, you might want to go to the lines > list view before clicking on the X to make sure you have the one you want.
Something I’ve observed with POs is that if you repeat pack slip numbers then it can combine receivers so I would suggest that you use unique combinations for every receiver.
I have been highlighting the line and clicking the X. It looks like it is deleting it, but when I clear the form and put the PO and packing slip in it shows back up.
This was a clerical error. we know not to make the pack slips repeat. We aren’t sure how we were able to put a different PO on the pack slip, but I also can’t find it in any table (that I know of) where this arrival information is stored.
Does anyone know where the arrived information is stored vs the actual receipt data (it’s not in RcvDtl)?
The data for Arrived lines is also in RcvDtl. The difference between an Arrived and a Received line is the ‘Received’ boolean value.
Your screenshot is showing a new receipt line that hasn’t been saved. Line number zero, no PO Line or Release number, no Part Number, no Description, Qty zero. That won’t exist in the RcvDtl table because it isn’t a saved line.
When I try to write a BAQ against the RcvDtl table, I don’t see it. The PO for the Pack Slip is different than the PO on the arrived line. I have tried filtering by both POs and the Pack Slip (each individually) but I never see it in the BAQ. Every time I open the Receipt Entry form using the pack slip I see that record so it has to be stored somewhere.
Any time I try to make a change to the record it tells me it is a bad unit of measure, since all of the part data is blank. I can’t get past that error.
That’s because most of that record is empty. There is no part, there is no description, there is no quantity. How it’s actually commited to the DB would be beyond me. Does this come in through some import that jams data into the database? The BO wouldn’t allow the state this record is saved in unless you have a real big bug.
Enter a UOM, part, description, and qty and you can probably delete it after that.
