Skip to content

PO Edit List Print & Export CSV Shows Canceled Line Items When Not Selected

Release Date: 03/16/2022
Version: 7.5 & Up

Q - The PO Edit List option under Purchase Order Processing does not adhere to the selection made when exporting to a CSV file.  We choose to export only these PO status types (U R P) where the possible values may be:
  • U = Unreleased
  • R = Released 
  • P = Printed
  • X = Cancelled
  • C = Closed
See sample screen below:


We noticed the Canceled PO is still exported in CSV. See sample screen below:


A - In your example, you have some line items that were canceled and got exported to CSV. I believe, if you look at the printed Edit List, you'll see the same situation. That is to say, the canceled PO line items still show up on the Edit List when you choose "U R P." Is that correct?

The CSV export follows PO Edit List's logic. If the PO and line items are printed, then they will be exported to CSV. So the question is why do the canceled entries show up if you only choose “U R P"? The reason for this is because the PO Status “U R P” selection is based on the PO Header status. That is to say, even if a PO has some canceled line items, if the PO header still has a status -- say “P” --  then that PO will still be printed. If the PO is printed, then the associated line items are also printed even if they are canceled.

The selection of PO status based on PO header is old logic from the Macola(R) days, and we are not sure if we can change it to the way you want without causing problems for other users. Especially there's no such thing as "U" (Unreleased) and "R" (Released) status at the line item level; in other words, the PO status is for the header only.  As for your situation, you just need to know that some canceled PO line items may still show up in the CSV. Since you can filter out those canceled line items in spreadsheet once the CSV is created, we think this is not a critical issue.


EMK

Feedback and Knowledge Base