Change PO Status from Release to Close

(0) Share

Report

Posted on by William T

185

Hi everyone,

I am trying to change the PO Status from Release to Closed. When I try to do this, a pop up saying "you can't change the status of this line item. it has unposted receipts assigned to them" I've checked to see if there were any batches that still needs to be posted but cannot find anything. From the looks of things, a receivables transaction entry was made but there is nothing in it by going through smartlist.

I've tried reconciling the purchase document, but it did not change anything.

does anyone have any idea on how to fix this?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

RE: Change PO Status from Release to Close

I ran the SELECT statement and inserted the receipt number in the receiving transactions window and they didn't come up

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

RE: Change PO Status from Release to Close

Purchasing>Transactions>Receivings Transaction Entry

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Change PO Status from Release to Close

Hey where is the PO receiving window.?

Was this reply helpful? Yes No
Marvin Burnett 165 on at

Like (0)

Report

RE: Change PO Status from Release to Close

Go into SQL Management Studio and run Select * from POP10310. You will likely find a record in this table that will reference the PO Number you are having a problem with. Go into GP into the PO Receiving window and put in the Receipt number that you found in the POP10310 table and a record should come up that is missing the header information. This would be the damaged record that I was referencing. Delete the record and you should be able to change the status on the PO number.

Hope this helps,

Marvin

Was this reply helpful? Yes No
Jsolt 35 on at

Like (0)

Report

RE: Change PO Status from Release to Close

How do we do this: Taking Leslie's advice I ran a select statement against POP10310 and found there was a receiving in the table for this purchase order. I took note of the reciept number RCTXXXX, went into PO receiving, punched in the number and the damaged reciept came up. Rather than trying to fix it , I found it best just to delete the receipt. I was then able to change the status.

Was this reply helpful? Yes No
Jsolt 35 on at

Like (0)

Report

RE: Change PO Status from Release to Close

How do you do what is described above? Do I still need to run a check links?

Was this reply helpful? Yes No
Marvin Burnett 165 on at

Like (0)

Report

RE: Change PO Status from Release to Close

The POP10310 is the Purchase receipt line work ( all the line items on an unposted receiving) and the POP30310 would be the Receipt line history table (basically one the PO is moved to history this is the table where the line items will reside).

Hope this helps,

Marvin

Was this reply helpful? Yes No
Jsolt 35 on at

Like (0)

Report

RE: Change PO Status from Release to Close

What is this POP10310 or POP30310 tables you are talking about?

Was this reply helpful? Yes No
Marvin Burnett 165 on at

Like (0)

Report

Re: Change PO Status from Release to Close

Hey William,

I believe I just had a very similar issue. Taking Leslie's advice I ran a select statement against POP10310 and found there was a receiving in the table for this purchase order. I took note of the reciept number RCTXXXX, went into PO receiving, punched in the number and the damaged reciept came up. Rather than trying to fix it , I found it best just to delete the receipt. I was then able to change the status. You may want to check the balancing of your accrued purchase account as mine was out of balance because of this transaction.

Marvin

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Change PO Status from Release to Close

Do you have any records in the POP10310 or POP30310 tables that are related to this item?

Leslie

Was this reply helpful? Yes No