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

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 "Y" to the first question, the system prompts the following question in a popup window:
    Export Canceled/Closed Line Items (Default "N")

See sample screen below:


The purpose of "7. Export Turn Around During Sales Order Import?" was to support Turn Around EDI 855. That is, as the sales order is imported, Elliott can send 855 (order acknowledgement) back to the trading partner to acknowledge the receiving of the order.

However, sometimes the trading partner may send a PO for invalid line items (such as items that are flagged as obsolete) and the sales order import program automatically closes the invalid line items. As a result, the turn around EDI 855 does not have the closed-out line items, which causes a problem.

To address this issue, we have now made flag 7 into a double flag to also prompt if the user wishes to "Export Canceled/Closed Line Items." If yes, then during the turn around sales order export for 855, we will export canceled/closed line items so the 855 will now send the line item that  is "Rejected" by us. The line items that will be sent with this flag set to "Y" include records in the CPORDLIN table where the column LINE_ITM_CANCEL_CLS has the following values:
  • C - Line Item Is Closed
  • X - Line Item Is Canceled 
  • Y - Line Item is Closed/Canceled
Change in Elliott SPS Services (ESS)
Elliott SPS Services (ESS) has also been changed and released on 3/14/2021 to handle the exported canceled/closed line items in ASCII files. In the translated 855 XML file, the \\OrderAck\Header\OrderHeader\AcknoweldgementType could have three possible values:
  • AD (Acknowledge with Detail) - If all line items on the PO are normal
  • RD (Reject with Detail)  - if all line items on the PO are canceled/closed
  • AC (Acknowledge with Change) - if some line items (but not all) on the PO are canceled/closed
In the \\OrdAck\LineItem\LineItemAcknowledgement\ItemStatusCode of 855, there could have two possible values based on if the line item is canceled or closed:
  • IA (Item Accepted)
  • IR (Item Rejected)
Modified Programs: ARCUSEDI, ARCUSEXT.FD, CPORDIMP, CPORDEXP

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 ...

    • ARPRGSCN Accounts Receivable Purge Closed Open Items

      Purge Closed Open Items Application Overview Periodically, you will want to remove from the A/R Open Item File all transactions that have been fully paid off. Otherwise, the file could become very large over a period of time. This application will ...

    • Change - Allow User to Delete Canceled or Closed Trx in Warehouse Receiving

      Release Date: 02/05/2021 Version: 8.5 & Up In PO Warehouse Receiving, if the user chooses to delete a receiving transaction that's marked as canceled or closed, the user will receive the following message: Order Canceled - Receiving Not Allowed See ...

    • 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 ...

    • Feature - Export 865 for Canceled/Closed Orders Separately

      Release Date: 10/12/17 This feature allows the user to specify whether canceled and closed orders should be exported separately from regular changes when exporting order audit data. To support this, a new flag has been added to the EDI Profile ...