incorrect unit cost in PO - delete whole PO

[johnhugh]

Hello,

we're using Accpac 5.5.
I have a PO which has been partly receipted but no invoice has been entered yet. The PO is not completed yet.
For one line item which havs been receipted the unit cost is significantly wrong.
Because one of our reports lists all purchase order totals (not was has been receipted), I'm looking for a way to fix this specific PO or even better - delete it completely.

I can't find a way to delete a PO, even after all the receipted items have been returned?

The report looks up the value under POPORL.EXTRECEIVE.
Should I just change the amount in there?

 

[Jay Converse]

Complete the PO, then do an IC adjustment to fix the cost.

 

[ettienne]

You can correct the values in the PO receipt while it has not been invoiced, you can also set qty received to zero and it will back out the receipt. You cannot delete the PO or receipt once you have done the receipt, not with the PO screen anyway.

 

[johnhugh]

Thanks for your replies.

The PO has been receipted at the correct cost.
So the receipt is fine.

The issue is with the amounts in the PO entry screen which shows a wrong amount and which I was hoping to adjust.
I/C adjustement won't allow me to adjust the amounts in PO entry screen.

So I think you've said it. Unless I change it in the database the unit price in PO entry screen is fix if the item has been receipted before.

 

[Jay Converse]

The amounts on the PO don't matter if you've receipted it. It's the receipt cost that gets into the system as "last cost". Ignore that PO and move on.

 

[johnhugh]

Hi tuba,

I know Accpac doesn't care about the amount in the PO entry screen but it's the custom PO report I have which shows an inflated amount now cause it looks at the PO entry figures.

I know a PO report should look at what has actually been receipted rather than what has been ordered but that's not how they wanne have it here (it ignores PO returns as well).

So, looks like the only way to correct a unit price in PO entry is by modifying the database? Do I just change it in table POPORL or are there other tables as well?

 

[Jay Converse]

Why not fix the report?

 

[johnhugh]

By fixing you mean change it over to receipted POs instead of entered POs I presume?
I suggested that, but they want to specifically see PO entry information.

I've now excluded this one unit price in the report but would rather have it fixed in the database.

 

[Jay Converse]

Then editing POPORL is what you want to do.

 

[johnhugh]

thanks tuba....