Complete POs

[iwells]

Hi,

We have some PO line items in Accpac (v5.6A) that have the line item set to Completed = YES and while the items have been receipted, they've not been invoiced or returned. I'm assuming after it was receipted and then they clicked on Completed = NO and set it to yes. Is there a way to adjust this line item back to Completed = NO? Also, ff the user has mistakenly set the line item on the PO to Completed = YES by adjusting the quantity outstanding and not adjusting the quantity cancelled, is there any way to open this line item back up for adjustment?

I guess in both cases I was wondering if there's system functionality I can use rather than a sql script, that way I can push it back on users to correct without my assistance.

Ian

 

[ettienne]

Not from the UI. They could add a line to the PO, provided that the PO has not been completed/invoiced. Yeah I know that's not the best option, but the only one for the user to do something.

 

[iwells]

Yea I played with it and couldn't find anything and just wanted to check to see if someone else had a better take.

What's happened is we have lots of POs and receipts that have been somehow set to completed in the front end, but there's no associated invoice with them and when I check the line items associated with the PO or receipt the line item flag is set to 0 to say it hasn't been completed.

SQL update it is.

 

[ettienne]

Just a comment - the PO receipt sets the line to completed, not the PO invoice.

 

[Jay Converse]

Be very, very, very (did I say very) careful with SQL updates in the PO module. It's very complicated, and you can break it easily, i.e., be unable to run Dayend anymore without ripping out the old records.

 

[iwells]

my plan was to update the receipt line items to completed = 1 and then properly invoice the line items ... that should be ok shouldn't it? keep in mind these are very, very old records to so i'm open to other suggestions.

 

[Jay Converse]

You have a 50/50 chance of screwing things up. Try it in a test company first.

 

[DjangMan]

Also - process-wise the users are probably entering the invoices into AP directly instead of going into PO Invoicing (or entering the invoice during receipting). The vendor is paid so they don't complain but your receipts don't get invoiced and your AP clearing account will be a mess.