PO problem. Pleae HELP!!!

(0) Share

Report

Posted on by Niju David

880

Is there a way to cancel open PO's that have not been recevied against? Would need to do this in Mass. I know we can go through the edit PO status window but it would take forever to do the thousand(s) of PO's we need to cancel.

Thank you in advance for you help

Regards

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Chrisz 210 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure if there is a way of doing this without some kind of customisation. As you seem to know you can Functions > Deliver remainder > Cancel quantity on each individual PO lines but as we have also found this can take some time.

I think you will need to build new form listing PO's or PO lines which would handle several records one at a time and effectively do this process automatically. Wouldn't be the worlds most difficult mod so if anyone quotes you for it don't get ripped off.

Was this reply helpful? Yes No
veeyeskay Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Niju

There is no out of the box method (except Edit Purchase Orders) to achieve the same.

You can contact Microsoft Support and they might assist you with this requirement.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Niju, a down and dirty solution is as follows:

(as with all 'solutions' like this - 1. Back up your date. 2. Try it in a test company first 3. Run Checklinks and reconcile against the purchasing series afterwads. 4. Test, Test, and test again).

Update the underlying tables in GP to set the PO's to be Cancelled. The tables you are concerned with are POP10100 (PO Headers) and POP10100 (PO Lines).

you will want to:

UPDATE pop10100 SET POSTATUS = '6'

UPDATE pop10100 SET STATGRP = '2'

UPDATE pop10110 SET POLNESTA = '6'

HOWEVER - you will probably not want to run this aginst every PO - so you will need some kind of filter to limit the PO transactions that this runs against. If you knew that it was all PO's prior to a certain date, then you could add a where clause to the queries along the lines of:

WHERE docdate < '2009-12-31 00:00:00.000'

Or in your case maybe look at filtering where the status is 1 (New), 2 (Released) or 3 (Change Order)

But be very careful!! Lines could have received values, but the order could be a change order if a new line was added etc.

As I said - test very carefully.

Once the PO's are cancelled, you could look at transferring them to history in the nornal way. This will give you some level of comfort from a data validity point of view. Once they get transferred to history, they are out of the way as such.

Best regards,

Ian.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

I've used Word's Mail Merge macro to successfully accomplish this in the past. Have a look at David Musgrave's excellent article on Mail Merge here - blogs.msdn.com/.../how-to-use-word-mail-merge-and-macros-to-import-data.aspx.

Hope this helps,

Was this reply helpful? Yes No