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

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


    • Related Articles

    • Canceled PO Line Items Still Exporting on EDI

      Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

    • Feature - Export Turn Around 855 for Canceled/Closed Line Items

      Release Date: 03/09/2021 Version: 8.5 & Up In Customer EDI Profile, Screen 6, the following flag has been changed: 7. Export Turn Around During Sales Order Import? It is now changed to: 7. Export Turn Around In SO Import/Exp Cancel Lin If you answer ...

    • Feature - Ability to Create a CSV Export in PO Edit List When "Show Headers Only" = "Y"

      Release date: 5/3/18 Added the ability to create a CSV Export in PO Edit List when "Show Headers Only" = "Y." Enter "Y" for "Create CSV File ?", then enter CSV Path and File Name. The following fields will be in the CSV file: Order# Tp – P.O. Type ...

    • Reorder Advice Custom CSV Export Shows Zero Items

      Q - I am running our saved CSV report from I/M Reordering Advice Report, Custom CSV Export. Below is the screen shot for the parameters: I was hoping that choosing N on “Print Items with All Zeroes?” would exclude the items that have no activity. But ...

    • Manifest Orders Status Report to Export CSV Shows Blank Result

      Release Date: 01/06/2021 Version: 8.0 & Up Q - I tried to run COP -> Processing -> Print Pikc/Pack Tickets -> Shipping -> Manifest Order Status Report. I tried to export the CSV file. The report comes up OK. But the CSV shows blank. See sample screen ...