Creating an 870 Order Status Report

Creating an 870 Order Status Report

Table of Contents
      1- Introduction
      2- Creating the Order Status Report
            a. Creating an Automatic 870
            b. Creating a Manual 870
      3- Generating the 870 Order Status Report

Introduction

The following wiki explains how to create an generate an order status report in EDI, which can then be sent to the trading partner.

Creating the Order Status Report

This menu option allows you create an order status report based on a previously received EDI purchase order. You have two options for creating an 870 – the Automatic way, and the manual one.  (automatic is of course preferred)

Creating an Automatic 870

In the main EDI menu, go to:

  • EDI Transaction sets
  • 870 Order Status (Report)
  • Create 870 Files from ASN
Select the appropriate BOL.

Enter the requested ship date. 

Click on "Ok". 


Creating a Manual 870

In the main EDI menu, go to:

  • EDI Transaction sets
  • 870 Order Status (Report)
  • Create New Order Stat (Report)

 

Select the appropriate PO's.

After selecting the EDI PO, the user is presented with the order status report screen.

Select ‘All Items’ to include all the items in the purchase order in the report or ‘Selected Items’ to include only selected items in the report.


Entering a date in either 'Header Level Date' and 'Detail Level Date' will determine which option/column is sent. Do NOT enter a date in both.

Header level date

  • If making a date change for the entire PO, use the 'Header Detail Date' column.
  • The user should also select “All Items” on top if the PO is to be cancelled.

Detail level date

  • If making item quantity changes, use the 'Detail Level Date' column. The user can then select each PO line and make qty changes (in Shp Qty).
  • The user should also select “Selected Items” on top.

The screen will appear for the next PO selected.

Enter the appropriate information and click on "Update/Exit".


Generating the 870 Order Status Report

This menu option allows you to generate an Edi Order Status Report based on a previously created Order Status Reports. The program will send only the items flagged to be sent when ‘Selected Items’ is selected in the report and all the items in the purchase order when ‘All Items’ is selected in the report. Use ‘Send Mail’ to send the generated 870.

In the main EDI menu, go to:

  • EDI Transaction sets
  • 970 Order Status (Report)
  • Generate EDI 870
Select the appropriate PO number.
  • Enter (Y)es to send all the lines on the PO in the 870.
  • Enter (N)o to send only some lines in the 870.

The Trading Partner requires the internal order number assigned to the PO.

Once entered, click on "Ok". 


    • Related Articles

    • P.O. - Create/Modify Shipment in Transit

      Introduction This module will allow the monitoring and receiving of incoming shipments. It is used in conjunction with existing purchase orders. Create Shipment in Transit Go to: P.O. Shipment in Transit Subsystem Processing Create/Modify Shipment ...

    • Sent/ Unsent EDI Invoices Report

      Introduction The following wiki explains how to generate a report to view EDI Invoices. Setup In EDI, go to: Invoicing Sent / Unsent EDI Invoices Report A report can be generated that displays only unsent invoices, only sent invoices, or both sent ...

    • Journal Entries - Creating a Reversing Entry

      Table of Contents Introduction Summary  Introduction The following wiki explains to a user how to make an automatic reversing journal entry. This option takes the entry that is being entered into that period and automatically creates the reverse of ...

    • Generating a Reverse Purchase Order (855) in EDI

      Introduction This wiki will show the user how to create a Reverse Purchase Order (transaction set # 855 -- a request generated by sellers in order to cancel a previous purchase order) in the EDI subsystem.   Instructions Step 1: Create the reverse PO ...

    • Creating a Non-Merchandise Credit Memo

      Table of Contents Introduction Setup Introduction It can occur where a customer will return items that aren't styles or inventory items, such as hangers or buttons. For these items, users cannot proceed with creating a credit memo as usual. The ...