Home

Friedman EDI Users Manual 2.1

1. o SHIP TO PO ORDER NUMBER Ship to customer purchase order number EISPO o INVOICE NUMBER Invoice number EIINV o PRODUCT NUMBER Product number of the ordered product EIPS o CUSTOMER PRODUCT NUMBER Customer product number for the ordered product EICPN o INQUIRY ORIGIN Inquiry origin code EIORG Valid codes are 1 order inquirv bv customer 2 order created in Order Status Maintenance OE35 3 all other orders o ITEM NUMBER Line item number from the sales order EIITEM o LINE STATUS CODE Valid line status codes EILNC are DE order cancelled in Ship and Bill Maintenance 0E57 IE line item deleted in Rapid Order Entry Maintenance OE51 or Order Detail OE54 RD order required date changed in Order Header Maintenance OE53 or line promise date changed in Sales Order Promising OE62 o QUANTITV DELETED Quantitv deleted EIOQS o CUSTOMER REFERENCE NUMBER Customer reference number EIREF Page 59 Frontier User s Manual Electronic Data Interchange Version 2 1 O SALES ORDER NUMBER Sales order number and suffix EOORD EOSUFX SHIP TO NUMBER Ship to customer number EOSTKY BILL TO NUMBER Bill to customer number EOBTKY INVOICE NUMBER Invoice number EOINV SHIP TO CUSTOMER PO Ship to customer purchase order number EOSPO CUSTOM
2. 1 for inquiries received from customers 2 for records created in EDI Order Status Maintenance OE35 3 for all other records Customer Product Number EICPN This field accepts and or displays the customer product number for this product Line Status LNC This field displays one of the following line status codes DE sales order cancelled in Ship and Bill Maintenance OE57 IC line item deleted in Rapid Order Entry Maintenance OE51 or Order Detail OE54 RD order required date changed in Order Header Maintenance 0E53 or order promise date changed in Sales Order Promising 0E62 Quantity Deleted EIOQS This field displays the quantity of the deleted item Reference Number EIREF This field accepts and or displays a user defined referenc number HOW TO PERFORM BASIC FUNCTIONS Displaying a list of orders by ship to purchase order number 1 Type the ship to purchase order number at which to begin the display in the Ship to PO Nbr prompt field Page 57 Frontier User s Manual Electronic Data Interchange Version 2 1 2 Press ENTER Displaving a list of orders bv sales order number 1 Type the sales order number at which to begin the display in the Sales Order Nbr prompt field 2 Press ENTER Changing a record in the file 1 Display the record to change 2 Type the changes as needed 3 Press ENTER The program records the
3. F3 Exit F5 Refresh F6 Select format F9 Insert F10 Entry F11 Change Use this display to add and or maintain XFP records o add a record press F10 for Entry mode Type the record information and press ENTER o change an existing record press F11 for Change mode The system allows changes to the record To insert a field in a record press F9 When you have completed entering and or maintaining records press F3 to exit The system displays an exit screen which lists the number of records added and c N hanged Tvpe the letter X the default value and press ENTER to exit or tvpe and press ENTER to return to the DFU Page 50 Frontier User s Manual Electronic Data Interchange Version 2 1 ORDER COPY ORD450 Description Use Order Copy ORD450 to create a new sales order for each customer in a specific copy order group by copying a selected existing sales order This program adds records to the EDI Customer Order Link XOP and XEP files then calls the program Customer Order Update ORD400CU Customer Order Update ORD400CU produces the following reports 00 00 DI Link Error Report UPDATE ORD400 DI Customer Order Accepted With Non Fatal Errors UPDATE ORD410 DI Customer Order Not Accepted Report UPDATE ORD410 DI Customer Order Accepted Report UPDATE ORD410 tid Pi Ei For more information on these reports see the Customer Order Update ORD400CU section of th
4. Order currencv code from Currencv Code Maintenance CRO1 ESFST ESPSTF ESPST ESTXCD ESAFLG ESCNTL The following fiel ESVTC1 ESVTRI ESVINI ESVTS1 ESVTC2 ESVTR2 ESVTN2 ESVTS2 ESVTC3 ESVTR3 ESVTN3 ESVTS3 ESVTC4 ESVTR4 ESVTN4 ESVTS4 ESVATS Example Page 22 Federal sales tax exempt number Provincial Provincial Tax code sales tax flag sales tax exempt number Not updated available for update by translator software when a functional acknowl ledgment is received Unique control number from the parameter EDICNTRL used to associate functional acknowl VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT total amount ledgments with link file records lds summarize VAT tax amounts by VAT code For a sample advance ship notice see Appendix 1 Frontier User s Manual Electronic Data Interchange Version 2 1 INVOICE PRINT amp UPDATE INVOO1 Job Description Use this job stream to print EDI and non EDI invoices which are processed separatelv The svstem prints EDI invoices when the parameter EDI contains the letter V in the Customer Invoice field A record is added to the Invoice Link EIP file for each invoice
5. Data Provided The information that appears on an acknowledgment includes o REASON Reason code text from the RC note file in Note Type Maintenance NF68 o WAREHOUSE Code description and address of the warehouse that will ship the order The system refers to the Warehouses Shipping field in Customer Master Maintenance CM52 to determine the shipping warehouse for the customer o BILL TO Number name and address of the bill to customer from Order Header Maintenance 0E53 o SHIP TO Number name and address of the ship to customer from Order Header Maintenance 0E53 o DATES The system prints the following dates if applicable date the order was received RECEIVED date the order was entered ENTERED date the acknowledgment was printed ACK PRT date the order was shipped SHIPPED date the shipper was printed SHP DTE and date the invoice was printed INVOICE Page 13 Frontier User s Manual Electronic Data Interchange Version 2 1 o MESSAGES If the acknowledgement is a reprint the message RE PRINT appears in this field If the order has been cancelled the message CANCELLATION appears in this field o SHIP TO PO Ship to purchase order number from Order Header Maintenance OE53 o SOLD TO PO Sold to also called bill to purchase order number from Order Header Maintenance 0E53 o TERMS Cash payment terms abbreviation from Cu
6. SALES UNIT OF MEASURE Sales unit of measure for the ordered product EOSUM CUST PRODUCT DESC Customer product description for the ordered product EOBTDS LINE STATUS CODE Valid line status codes EOLNC are DE order cancelled in Ship and Bill Maintenance 0E57 IC line item deleted in Rapid Order Entry Maintenance OE51 or Order Detail OE54 RD order required date changed in Order Header Maintenance OE53 or line promise date changed in Sales Order Promising OE62 STATUS RESPONSE CODE Status response code EOSRC EDI ACKNOWLEDGEMENT EDI functional acknowledgment code EOAF appears when a functional acknowledgement is received CONTROL NUMBER Control number assigned EOCNT to the transaction PROMISED DATE Promised date for the line item EOPRMM EOPRMY EOPRCT ORDER DATE ENTERED Date the purchase order was entered EOPOD CUSTOMER REFERENCE NUMBER Customer reference number EOREF Example For a sample report see Appendix 1 Page 62 Frontier User s Manual Electronic Data Interchange APPENDIX 1 REPORT SAMPLES Following are EDI report samples Purchase Order l A Acknowledgement ORDOO1 Advance Ship Notice ORDO30 Invoice Print amp Update INVOO1 Sales amp Credit Memos Report ARJ006 Daily EDI Invoice Register INVO10E dibbbbbMMbI DI DI DI DI DI DI DI DI Link Error Report EDIT ORD400 f gn jaka a Customer Or
7. o QUANTITV Quantitv from the XEOQS order quantitv field in the link file o SUM Sales unit of measure from the XESUM field in the link file or Product Master Maintenance PM70 o PRICE Price from the XEARTL unit price field in the link file or Price List Maintenance PR81 o EXTENDED PRICE Extended value calculated as the quantity times the price o ERROR The report includes one or more of the following error messages Parentheses with blanks will be filled in with the invalid value Order type of Order price changed to price table price price is not locked Order price changed to price table price price is locked This error message appears when the link file price is blank Price not locked but salesperson X entered Price not locked but salesperson fX rate is entered Price not locked but per entered Price not locked but discount amount entered Price not locked but discount percent X entered Price not locked but price qty is entered Price not locked but commission is entered Price not locked but net is entered Ship to override switch is invalid Invoice to override switch is invalid PST code deleted not required for US or VAT tax PST deleted not required for US or VAT tax Currency code deleted not required for single currency Currency rate d
8. 1 order inquiry by customer 2 order created in EDI Order Status Maintenance OE35 3 all other orders o ITEM NUMBER Line item number from the sales order EIITEM o LINE STATUS CODE Valid line status codes EILNC are DE order cancelled in Ship and Bill Maintenance 0E57 IC line item deleted in Rapid Order Entry Maintenance OE51 or Order Detail OE54 RD order required date changed in Order Header Maintenance OE53 or line promise date changed in Sales Order Promising OE62 o QUANTITV DELETED Quantitv deleted EIOQS o CUSTOMER REFERENCE NUMBER Customer reference number EIREF Page 61 Frontier User s Manual Electronic Data Interchange Version 2 1 O SALES ORDER NUMBER Sales order number and suffix EOORD EOSUFX SHIP TO NUMBER Ship to customer number EOSTKY BILL TO NUMBER Bill to customer number EOBTKY INVOICE NUMBER Invoice number EOINV SHIP TO CUSTOMER PO Ship to customer purchase order number EOSPO CUSTOMER PRODUCT NUMBER Customer product number for the ordered product EOBTPN SALES UNIT PRICE Unit price for the line item in the sales unit of measure EOARTL PRODUCT NUMBER Product number of the ordered product EOPN PRODUCT DESC Description of the ordered product EODESC ORDER QUANTITY Quantity of product ordered in the sales unit of measure EOOQS
9. Errors in Order Header User Exit will appear on the EDI Customer Order Not Accepted Report ORD410 Executing The Program To print the EDI customer order reports and update the transaction files select EDI Customer Order Update ORD400CU from the EDI Menu OEMENUE and press ENTER When you press ENTER if the value in the system parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear Page 44 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI Link Error Report UPDATE ORD400 Description This program provides a list of customer orders which are unac ceptable due to critical errors that prevent additional processing The order header and detail records were deleted from the Customer Order Link Header XOP file and Customer Order Link Detail XEP file and were added to the EDI Return Header Link ROP file and the EDI Return Detail Link REP file Data Provided See EDI Customer Order Edit ORD400CE Example For a sample UPDATE report see Appendix 1 EDI Customer Order Accepted With Non Fatal Errors UPDATE ORD410 Description This program reports customer orders that are acceptable but contain non fatal errors The svstem automaticallv changes a non fatal error field value to an acceptable value Other non fatal error
10. EDI Customer Order Update ORD400CU Link File Maintenance EDILINKXEF Order Copy ORD450 IV EDI ORDER STATUS Introduction To EDI Order Status EDI Order Status Maintenance OE35 Order Status Edit ORD870E Order Status Update ORD870U Appendix I Report Samples Frontier User s Manual Electronic Data Interchange Version 2 1 INN OD 13 19 23 31 32 42 47 5il 53 55 59 61 63 Page 1 Frontier User s Manual Electronic Data Interchange Version 2 1 Page 2 Frontier User s Manual Electronic Data Interchange Version 2 1 BEFORE YOU BEGIN Before you use this module you must create the following master files used by Order Entry and Purchasing amp Receiving o Customer Information o Vendor Information o Parameter Information Customer Information Before producing EDI documents for a custom er division vou must identifv that customer in Customer Master Maintenance CM52 To create EDI invoices for the customer division tvpe the letter V in the EDI inv field To create EDI acknowledgments for the customer type the letter Y in the EDI Ack field to create advance ship notices for the custom er type the letter Y in the EDI Adv ship field EDI customer orders can be received from any customer regardless of the value in these fields Vendor Information You need to identify each EDI vendor division in Vendor Master Maintenance VM10 To identify the vendor
11. EKINVP Invoice print date EKINST Shipping instructions EKCARR Carrier description EKFR Freight terms EKCRGN Credit region EKCNTY County code EKCTRY Country code EKREF Credit reference number EKREQD Required date EKDIV Division number EKWH Shipping warehouse EKWHD Shipping warehouse description EKWHA2 Shipping warehouse address line 1 EKWHA3 Shipping warehouse address line 2 EKWHA4 Shipping warehouse address line 3 EKWHAS Shipping warehouse address line 4 EKWHB Billing warehouse EKTAXG ax group for sales tax system parameter TAXVS contains S EKSM Salesperson code EKTRMS erms EKPN Product number EKDESC Product description EKLOT Lot number EKORGQ Original order quantity EKPER Per code EKPERQ Per quantity EKIUM Inventory unit of measure EKPCC Price category EKNETF Net price flag EKTXCD Tax code Tax group for sales tax system parameter TAXVS contains S Tax exempt code in VAT tax system TAXVS contains V GST tax exempt code in Canadian tax system TAXVS contains C EKNCDD No charge code EKCOMR Total salesperson commission EKWGT Product weight EKFLCS Freight class code EKCAT Price list EKARTL Price EKNETS Dollar value of item including discounts EKBTPN Customer product number EKCDSC Customer product description EKTEX Comment text EKTOT Total weight EKTOTP Total quantity EKMERS Merchandise total EKVALU Order total Page 17 Frontier User s Manual
12. amp Credit Memo Report includes o INVOICE NUMBER Invoice number from Invoice Print amp Update INVOO1 o INVOICE DATE Invoice date from Invoice Print amp Update INVOO1 o TY Order type from Order Header Maintenance 0E53 Valid order types SI Ship Invoice IO Invoice Only CM Credit Memo SO Ship Only QT Quote RM RMA o INVOICE AMOUNT Invoice amount from Invoice Print amp Update INVOO1 o DISCOUNT The system prints the allowable cash discount which it calculates in Invoice Print amp Update INV001 according to the cash payment terms that apply to the customer Cash payment terms are from Order Header Maintenance 0E53 and are validated in the AR note file in Note Type Maintenance NF68 o NET AMOUNT Net amount which the system calculates as the invoice amount less the discount from Invoice Print amp Update INVOO1 o ORDER NUMBER Svstem assigned order number from Order Header Maintenance OE53 o WH Shipping warehouse from Order Header Maintenance 0E53 o CUSTOMER Number and name of the ship to customer from Order Header Mainte nance OE53 The system totals the invoice amounts discounts and net amounts of all the sales and credit memos created during the invoice run Example For a sample Sales amp Credit Memos Report for ship and invoice and invoice only orders s Appendix 1 Daily Invoice Register EDI INVO1OE Page 28 Frontier User s M
13. 10 00 10 18 03 00 00 00 Page EXTENDED PRICE 1000 00 192 00 100 00 100 00 Program ORD410 Date Time EDI CUSTOMER ORDER NOT ACCEPTED REPORT UPDATE The following order has been removed from the EDI Link files and added to the EDI Return Link files Non fatal Error Fatal Error ORDER NUMBER INVOICE TO x CONNERS INC 505 SIXTH AVENUE BUILDING 1105 ALGONQUIN IL BILL TO POt Ship to PO 54620E Invalid cash terms ITEM No PART No 1 00 DGKHF Insufficient stock 2 00 PIPE 1 3 00 PIPE 1 4 00 PIPE 1 Page 13 XXXXXX XX 60035 XXX COMMENT WH 01 available 01 01 01 SHIP TO X CONNERS INC 505 SIXTH AVENUE BUILDING 1105 ALGONQUIN IL 60035 SHIP TO PO DIV ORDER DATE REQ DATE 54620E 01 10 18 03 10 18 03 for cust 1 already exists PART DESCRIPTION QUANTITY SUM PRICE PIPE 1 10 PIPE 1 10 BX 100 00 PIPE 1 10 BX 10 00 PIPE 1 10 BX 100 00 10 18 03 00 00 00 Page EXTENDED PRICE 1000 00 100 00 1000 00 Program ORD410 ORDER NUMBER 6670 00 INVOICE TO 2 STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60602 BILL TO PO ITEM No PART No COMMENT 1 00 PIPE 1 2 00 PIPE 2 3 00 PIPE 3 4 00 PIPE 4 Page 14 WH 01 01 01 01 EDI CUSTOMER ORDER ACCEPTED REPORT SHIP TO 2 STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60602 SHIP TO PO DIV ORDER DATE 54640E 01 1
14. 3 ESSTCT Sold to customer address citv ESSTST Sold to customer state ESSTZP Sold to customer zip code N ESBTNM Bill to customer name ESBTA1 Bill to customer address line 1 ESBTA2 Bill to customer address line 2 ESBTA3 Bill to customer address line 3 ESBTCT Bill to customer address city ESBTST Bill to customer state ESBTZP Bill to customer zip code ESNOTD Notice date ESNOTT Notice time ESSPO Ship to customer purchase order number ESBPO Bill to customer purchase order number ESINIT Picked by ESREQD Required date ESSM Salesperson code ESTRMS Terms ESINST Shipping instructions ESFRTT Freight terms ESWH Shipping warehouse ESWHB Billing warehouse ESENTD Order date ESITEM Item number ESPN Product number ESDESC Product description ESLOT Lot number ESBALQ Original order quantity ESSHPQ Picked or shipped quantity ESBOQ Quantity backordered ESARTL Price ESNETS Dollar value of item including discounts ESTAXG Tax group ESBTPN Customer product number ESCDSC Customer product description ESTEXT Comment text ESDSS Discount amount ESDISD Discount date ESTAXD Tax description ESSDES Miscellaneous charge description ESMERS Merchandise total ESVALU Order total Page 21 Frontier User s Manual Electronic Data Interchange Version 2 1 ESCURC
15. EDIT ORD400 EDI Customer Order Accepted With Non Fatal Errors EDIT ORD410 EDI Customer Order Not Accepted Report EDIT ORD410 EDI Customer Order Accepted Report EDIT ORD410 00 00 EDI Customer Order Edit ORD400CE and EDI Customer Order Update ORD400CU accept records from the EDI Customer Order Header Link XOP file and the EDI Customer Order Detail Link XEP file The fields in these files will default and validate the same way as the corresponding fields in Order Header Mainte nance 0E53 and Order Detail 0E54 with the following exceptions EDI Link Customer Order Header XOP file fields XOSPO The ship to purchase order number is a required field and together with XOSTKY is the key to the link file If there is a duplicate ship to purchase order number customer ship to number in the XOP file both orders will be rejected and will be listed on the EDI Link Error Report ORD400 If there is a duplicate ship to purchase order number customer ship to number combination in the order entry transaction database OH file the order will be accepted and will be listed in the EDI Customer Order Accepted With Non Fatal Errors Report ORD410 XOSTKY Customer ship to number which is a required field XOITEM Item sequence number XOOTYP Order type which defaults to SI if blank Valid values are IO CM QT RM and SI SO is not a valid order type XOORDT Order date in ISO format Y
16. EOI and EOS files ORD870CU List and update the orders in the EOI and EOS files SYMENU Display the System Functions Menu Page 5 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI PHYSICAL FILES Certain physical files contain fields used in the EDI Module file CMP s EDIWK EIP EKP EOI EOS EPP ESP RAP REP ROP XEP XEPWK XFP XFPWK XOP XTP which contain EDI fields are Customer Master EDI Work EJ PJ PJ DJ EJ El EJ Ej bt i DI DI DI DI DI DI DI DI DI DI DI Invoice Link Acknowledgements Link Order Inquirv Link Order Status Link Purchase Order Link Advance Ship Notice Link PCM Option Error Return Return Detail Return Header Customer Order PCM Option Lin Link Link Detail Link EDI Customer Order Detail Work K EDI PCM Option Link Work DI Customer Order Header Link DI Changed Option and Values The temporarv phvsical files used in EDI are OHPE O2PE O4PE O5PE O6PE WFWKPE XFPE Page 6 D D D D D Hee ti I Order Header I Sales Order Override Name And Address I Sales Order Billing Header I Sales Order Detail Comments I Sales Order Detail Line Items EDI Working Segments EDI PCM Converted Options The physical Frontier User s Manual Electronic Data Interchange Version 2 1 EDI SCREENS 1 J he following screens are used to set up EDI in Frontier o Customer Master Mai
17. Electronic Data Interchange Version 2 1 EKCURC Order currency code The currency code is the code from the currency table Currency Code Maintenance CROl which was added to the acknowledgment All currencv amounts on the acknowledgment are in this currencv EKAFLG This field is not updated It is available for update bv translator software when a functional acknowledgment is received EKCNTL This field is updated by the system with a unique control number beginning with the number in the parameter EDICNTRL Use this field to associate functional acknowledgments with link file records Example For a sample acknowledgment s Appendix 1 Page 18 Frontier User s Manual Electronic Data Interchange Version 2 1 ADVANCE SHIP NOTICES ORDO30MR Description Use this program to asynchronously print EDI advance ship notices when the letter Y appears in the Advance Ship Notice field in the parameter EDI In order for this program to print EDI advance ship notices for a customer the letter Y must appear in two fields in Customer Master Maintenance CM52 Ad vance ship notice and EDI Advance ship notice The Advance ship notice field tells the system to asynchronously print an advance ship notice the EDI Advance ship notice field tells the program to add a record to the Advance Ship Notice Link ESP file for each advance ship notice printed for that custom er If a record for an order already exists i
18. Invalid price currencv for catalog Invalid value for no charge code must be Blank 1 2 3 Invalid value for prot flag must be Blank X P N Invalid value for priority must be Blank or R Invalid value for drop ship flag must be Blank or D Invalid value for per must be Blank E L X C M N Unit of measure not on part master for Invalid value for proof copy print flag must be Blank Y N Invalid value for shipper print flag must be Blank Y N Invalid value for bill lading print flag must be Blank Y N Invalid value for invoice print flag must be Blank Y N Invalid value for net must be Blank or Y Price must be entered for alpha account line Invalid ERS code The one character code in the XOERS field must be the suffix of an entry in the OE note file type with the prefix ERS For example if XOERS contained A then this error would be printed if the OE note file NF68 did not contain ERS A Mandatory selection was not included on option link record This message appears only for mandatory selections Invalid OPTION selection Number of options exceeds the maximum for this option list Option list not valid for the model Errors in Order Header User Exit Order quantity is less than minimum quantity of Ja Order quantity is not a multiple of Jes Inv
19. Maintenance CM52 o SHIP TO If the override field XOOVSW contains a character then th ntir override name and address must be entered in the link XOP file ship to fields XOSTKY ship to customer XOSTNM customer name XOSTA2 address XOSTA3 address XOSTA4 address XOSTCT city XOSTST state and XOSTZP zip code If the override field is blank the ship to number name and address are from Customer Master Maintenance CM52 o BILL TO PO Bill to purchase order number from the XOBPOf bill to purchase order number field in the link file o SHIP TO PO Ship to purchase order number from the XOSPOf ship to purchase order number field in the link file o DIV Division from the XODIV field in the link file or Customer Master Maintenance CM52 o ORDER DATE Order date from the XOORDT field in the link file or is the date the EDI Link Error Report was generated o REQ DATE Required date from the XORQDT field in the link file or is the date the EDI Link Error Report was generated o ITEM No Line item number from the XEITEM field in the link file or is assigned by the system o PART No COMMENT Part number from the XEPN field in the link file Comment text is from the XETEXT field in the link file o WH Warehouse from the XEWH ship from warehouse field in the link file or Customer Master Maintena
20. division as an EDI vendor type the letter Y in the EDI field This will generate EDI purchase orders for the vendor Parameter Information In addition to entering the Master Files information you need to enter values in the following parameters o EDI EDIDS The system uses the parameter EDI to determine whether or not to transmit EDI customer invoices EDI purchase orders EDI order acknowledgements and or EDI advance ship notices and whether or not to receive customer orders Accepted EDI customer orders automatically may be placed on hold requiring manual release in Order Hold Inquiry 0E50 Access the EDI parameter from either the EDI Menu OEMENUE or the Purchase Order Parameter Menu POMENUD o transmit EDI customer invoices when you run Invoices INVO001 type the letter Y default in the first Transmit field Type the letter Y default in the second Transmit field to transmit EDI purchase orders when you run Purchase Orders POD010 To transmit EDI order acknowledgements when you run Acknowledgements ORDOOI type the letter Y default in the third Transmit field o transmit EDI advance ship notices when you run Asynchronous Advance Ship Notices ORDO30MR type the letter Y default in the last Transmit field The system then defaults the value in the EDI Advance Ship notice field in Customer Master Maintenance CM52 to Y To receive EDI customer orders when you run
21. file This program also can be used as an alternate way to assign default values for a model s options You specify a configuration code consisting of the default options and assign the code to a customer product During order processing the Page 43 Frontier User s Manual Electronic Data Interchange Version 2 1 svstem supplies the model number for that customer customer product number and uses the configuration code to insert values into the option selection fields For EDI orders if a PCM customer product number is found in the EDI Customer Order Detail Link XEP file then the configuration code from the ATP file for that product will be used to assign the options for that product Orders with invalid PCM customer product number effective dates will be rejected For each configured order the job stream will include the contents of the EDI PCM Option Link XFP file in the reports The EDI Link Error Report ORD400 will list EDI configured orders which are unacceptable due to invalid product number or option record errors Invalid product number errors include orders with an option record for a product that is not a configured product a config ured product with no option records and configured products with no line num bers Line numbers in the EDI PCM Option Link XFP and EDI Customer Order Detail XEP files must match If the line numbers do not match or if no line numbers exist then the order will be rejecte
22. file ship to fields XOSTKY ship to customer XOSTNM customer name XOSTA2 address XOSTA3 address XOSTA4 address XOSTCT city XOSTST state and XOSTZP zip code If the override field is blank the ship to number name and address are from Customer Master Maintenance CM52 o BILL TO PO Bill to purchase order number from the XOBPO bill to purchase order number field in the link file o SHIP TO PO Ship to purchase order number from the XOSPO ship to purchase order number field in the link file o DIV Division from the XODIV field in the link file or Customer Master Maintenance CM52 o ORDER DATE Order date from the XOORDT field in the link file or is the date the EDI Link Error Report was generated o REQ DATE Required date from the XORODT field in the link file or is the date the EDI Link Error Report was generated o ITEM No Line item number from the XEITEM field in the link file or assigned Page 36 Frontier User s Manual Electronic Data Interchange Version 2 1 bv the svstem o PART No COMMENT Part number from the XEPN field in the link file Comment text is from the XETEXT field in the link file o WH Warehouse from the XEWH ship from warehouse field in the link file or Customer Master Maintenance CM52 o PART DESCRIPTION Description of the product from Product Master Maintenance PM70
23. from the XOBPO field in the link file o SHIP TO PO Ship to purchase order number from the XOSPO field in the link file o DIV Division from the XODIV field in the link file or Customer Master Maintenance CM52 o ORDER DATE Order date from the XOORDT field in the link file or the date the EDI Link Error Report was generated o REQ DATE Required date from the XORQDT field in the link file or the date the EDI Link Error Report was generated o ITEM No Line item number from the XEITEM field in the link file or assigned bv the svstem o PART No COMMENT Part number from the XEPN field in the link file Comment text is from the XETEXT field in the link file o WH Warehouse from the XEWH ship from warehouse field in the link file or Customer Master Maintenance CM52 o PART DESCRIPTION Description of the product from Product Master Maintenance PM70 o QUANTITV Quantitv from the XEOQS order quantitv field in the link file o SUM Sales unit of measure from the XESUM field in the link file or Product Master Maintenance PM70 o PRICE Price from the XEARTL unit price field in the link file or Price List Maintenance PR81 o EXTENDED PRICE Extended value is calculated as the quantitv times the price Example For a sample EDI Customer Order Accepted EDIT Report see Appendix 1 Page 41 Frontier User s Manual Electr
24. messages describe a notable condition in the order The svstem assigns a number to the order and displavs this number at the top of the page A separate page is printed for each order Order header and detail records were deleted from the EDI Link Customer Order Header XOP file and EDI Link Customer Order Detail XEP file and were added to the order transaction files OH 02 04 05 06 BF Data Provided See EDI Customer Order Edit ORD400CE Example For a sample UPDATE report see Appendix 1 EDI Customer Order Not Accepted UPDATE Report ORD410 Description This program reports customer orders that are unacceptable that is the orders contain at least one fatal error All fatal and non fatal errors appear on the report The system does not assign a number to the order Instead order number XXXXXX XX appears at the top of the page A separate page is printed for each order Order header and detail records were deleted from the EDI Link Customer Order Header XOP file and EDI Link Customer Order Detail XEP file and were added to the EDI Return Header Link ROP file and the EDI Return Detail Link REP file Data Provided See EDI Customer Order Edit ORD400CE Example For a sample UPDATE report see Appendix 1 Page 45 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI Customer Order Accepted UPDATE Report ORD410 Description This program reports c
25. records no longer are needed use th Purge EDI Link Files EDI900 program to purge the file Page 54 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI ORDER STATUS MAINTENANCE OE35 PROGRAM SUMMARY Use EDI Order Status Maintenance OE35 to displav create maintain and or delete records in the EDI Order Inquirv Link EOI file on line Vou can displav the file either in ascending ship to purchase order number sequence or in ascending sales order number sequence beginning with a selected order number You then can maintain any field except the Inquiry Origin field However any data you input will not be validated by the system Function Keys F3 EXit F6 Fold and unfold screen F9 Add F10 Menu Bar Program Functions To display the file in order by ship to purchase order Type the ship to purchase order number at which to begin the display in the Ship to PO Nbr prompt field Press ENTER To display the file in order by sales order Type the sales order number at which to begin the display in the Sales Order Nbr prompt field Press ENTER To change records in the file Display the record to change Type the changes as needed Press ENTER To add records to the file Press F9 to display blank lines Type the new records Press ENTER To delete records from the file Display the record to delete Type the letter D in the function field of the recor
26. ship and invoice 1 ship only 2 invoice only 3 neither ship nor invoice for quotes o COM RATE The total commission percentage from the pricing programs or Order Detail OE54 Page 15 Frontier User s Manual Electronic Data Interchange Version 2 1 o WEIGHT Weight of the product at the inventorv unit of measure from Product Master Maintenance PM70 o FCC Freight class code from Product Master Maintenance PM70 o PRICING Pricing information orde r from Order Detail 0E54 o YOUR PRODUCT Product Maintenance which indicates the price list used to price the Customer product number and description from either Customer OE85 or PCM Customer Product Maintenance WS85 If you use the customer product number to order an item the customer product number appears on this report when the Customer Product Maintenance OE85 or the Ack is the letter P or B Ack Print flag or Ack field value is D or B Product Maintenance description appears if the o TOTAL ADVANCE PAYMENTS this order At the bottom of the acknowledgment weight and extended value WS85 Ack Print flag field value in field in PCM Customer the customer product Total amount of any cash in advance payments made for the system calculates and prints the total If the order is on hold the system will print the reason for hold in the top right corner of the acknowledgment In addition to pri
27. system with a unique control number Use this field to associate functional acknowledgments with link file records see Appendix 1 EIITEM Item number EISHPQ Shipped quantity EIBCKQ Back order quantity EIPN Product number EIDESC Description EIARTL Price EIEXTS Extended value EINOTE OE note text EISDES Extra charge account description EIBTPN Customer product number EICDES Customer product description EITEXT Comment text EITAXD US or Canadian tax description line EITAXS US or Canadian tax description in header record EIIUM Inventory unit of measure from item quantities on the invoice EIAFLG This field is not updated software EICNTR 1 beginning with the number in parameter EDICNTRL Example For a sample invoice Sales amp Credit Memos ARJ006 Page 27 Frontier User s Manual Electronic Data Interchange Version 2 1 Description The Invoices job stream prints the Sales amp Credit Memos Report ARJO06 The report lists the invoice number date and amount that correspond to each order for which the svstem created a sales or credit memo The svstem creates and prints two reports in the same format that list differ ent order types The first report contains information about invoices for orders with order tvpe SI and IO The second report contains information about invoices for orders with order tvpe CM Data Provided The information that appears on the Sales
28. the job to delete the records To prevent record locks end all asynchronous tasks before you release this job Executing The Program To delete all records in the EIP EPP EKP EOS or ESP files select Purge EDI Link Files EDI900 from the EDI Menu OEMENUE and press ENTER The program displays the Purge EDI Files option screen which is used to indicate what records should be deleted For each of the link files type Y to purge all records from the file A to purge only acknowledged records from the file N to not purge any records from the file After you have made your selections press ENTER Press F3 to submit the delete or F12 to cancel the request When you press F3 if the value in the system parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear Page 31 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI CUSTOMER ORDER EDIT ORD400CE Description Use this program to print the EDI customer order reports but without updating the order transaction files or the EDI link files No update will occur even if the orders are without errors NOTE Incoming EDI orders must either have all manually entered item numbers or no manually entered item numbers The program prints the following reports EDI Link Error Report
29. 0 00 Program ORD400 Date 10 18 03 Page EDI LINK ERROR REPORT UPDATE Time 00 00 00 The following orders will be removed from the received link file and added to the return link file CUSTOMER NO SHIP TO PO LINE ITEM PART NO ERROR 100000 100 Order header exists but no detail 1 54610E Order detail exists but no header 1 54612E Duplicate header record for this group of orders 1 54612E Duplicate header record for this group of orders 1 54613E Order detail exists but no header 1 54640E Invalid order type 99 must be SI CM QT IO 1 54640E 999 00 Invalid group with code 9 must be Blank or G 1 54640E 999 00 Invalid customer part number 999999999999999 for customer 999999 1 5467E Order header exists but no detail 1 5468E Order header exists but no detail Page 11 Program ORD410 ORDER NUMBER 6660 INVOICE TO 2 STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL BILL TO PO Ship to PO 54614E ITEM No PART No 1 00 PIPE 1 2 00 PIPE 2 3 00 PIPE 3 4 00 PIPE 4 Page 12 00 60064 COMMENT WH 01 01 01 01 EDI CUSTOMER ORDER ACCEPTED WITH NON FATAL ERRORS UPDATE aie SEIP TOs g STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60604 SHIP TO PO DIV ORDER DATE REQ DATE 54614E 01 10 18 03 10 18 03 for cust 2 already exists PART DESCRIPTION QUANTITY SUM PRICE PIPE 1 10 BX 100 00 PIPE 2 10 BX 200 00 PIPE 3 10 EA 10 00 PIPE 4 10 EA
30. 0 18 03 PART DESCRIPTION QUANTITY PIPE 1 10 PIPE 2 10 PIPE 3 10 PIPE 4 10 REQ UPDATE Date Time 10 18 03 00 00 00 Page EXTENDED PRICE 1000 192 00 00 00 00 Program ORD870 Date 6 03 03 ORDER STATUS REPORT EDI Edit Time 00 00 00 ORDER STATUS INQUIRY FILE Customer number 7515 Sales order number 33704 00 Ship to po order number 7515001 Invoice number Product number Customer product number Inquiry origin 3 Item number 00000 Line status code DE Quantity Deleted Customer ref number ORDER STATUS LINK FILE Sales order number 033704 00 Ship to number 7515 Bill to number 7515 Invoice number Ship to customer PO 7515001 Customer product number Line item 1 00 Sales unit price 15 00 Product number Product desc Order quantity Sales unit of measure EA Cust product desc Line status code Status response code 1 EDI acknowledgement Control Number Promised date 50401 Order date entered Customer reference number ORDER STATUS INQUIRY FILE Customer number 7515 Sales order number 33869 00 Ship to po order number 8500100 Invoice number Product number Customer product number Inquiry origin 3 Item number 00000 Line status code DE Quantitv Deleted Customer ref number ORDER STATUS LINK FILE Sales order number 033869 00 Ship to number 7515 Bill to number 7515 Invoice number Ship to customer PO 8500100 Customer product number Line item 1 00 Sales unit price 10 00 Product number Product desc Ord
31. 00 999 00 PART NO The following orders will be removed from the received link file and added to the return link file ERROR Order header exists but no detail Order detail exists but no header Duplicate header record for this group of orders Duplicate header record for this group of orders Order detail exists but no header Invalid order type 99 must be SI CM QT IO Invalid group with code 9 must be Blank or G Invalid customer part number 999999999999999 for customer 999999 Order header exists but no detail Order header exists but no detail Program ORD410 INVOICE TO 2 STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60064 BILL TO POt Ship to PO 54614E ITEM No PART No COMMENT 1 00 PIPE 1 2 00 PIPE 2 3 00 PIPE 3 4 00 PIPE 4 Page 8 WH 01 01 01 01 Date Time EDI CUSTOMER ORDER ACCEPTED WITH NON FATAL ERRORS EDIT SHIP TO g STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60604 SHIP TO PO DIV ORDER DATE REQ DATE 54614E 01 10 18 03 10 18 03 for cust 2 already exists PART DESCRIPTION QUANTITY SUM PRICE PIPE 1 10 BX 100 00 PIPE 2 10 BX 200 00 PIPE 3 10 EA 10 00 PIPE 4 10 EA 10 00 10 18 03 00 00 00 Page EXTENDED PRICE 1000 192 100 100 00 00 00 00 Program kk ORD410 EDI CUSTOMER ORDER NOT ACCEPTED REPORT Date Time EDIT The following order will be removed f
32. 2 1 o PO VALUE Value of the purchase order from PO Entrv Maintenance PU13 In addition to printing a paper copv of the EDI purchase order the svstem updates the EDI Purchase Order Link EPP file for each EDI purchase order The EPP fields are updated as follows EPRCD Record code H for header record and D for line item record EPRCD Record code identifier always updated with 01 EPORD Purchase order number EPREV Revision number EPWH Warehouse EPREVD Revision date EPPRTD Purchase order print date EPPOD Purchase order date EPVMKY Bill to vendor number EPVNAM Bill to vendor name EPVAD1 Bill to vendor address line 1 EPVAD2 Bill to vendor address line 2 EPBCTY Bill to vendor city EPBST Bill to state EPBZIP Bill to zip code EPDSKY Ship to vendor number EPDNAM Ship to vendor name EPDAD1 Ship to vendor address line 1 EPDAD2 Ship to vendor address line 2 EPDCTY Ship to vendor city EPDST Ship to vendor state EPDZIP Ship to vendor zip code EPDATT Name of person to deliver to EPPT Person to confirm order with EPBUYR Name of buyer EPTEL Contact person telephone number EPVREF Confirmation number EPTRMS Payment terms EPSVIA Ship via description EPFOBD FOB EPCURC Purchase order currency code from the currency table Currency Code Maintenance CRO1 added to the purchase order during entry All currency amounts on th
33. 2 1 o TAX GRP Tax group from Customer Master Maintenance CM52 or Order Header Maintenance 0E53 o REF For credit memos the system prints the number of the order to which the credit corresponds For each line item of the order the acknowledgment lists the following information o DESCRIPTION Internal product description from Product Master Maintenance PM70 o PRODUCT NUMBER Internal product number of the ordered product from Order Detail OES54 o QUANTITY Quantity of each product ordered from Order Detail OE54 o PC Per code from Price List Maintenance PR81 Valid values blank or E per each per lot per ten units per hundred units per thousand units no price free per tenth per hundredth 30 Z lt O x b o PER QTY Per quantity which indicates the value of the per code o EXTENDED Extended price of the line item including any discounts o UNIT PRC Unit price of the ordered product o UM Sales unit of measure from Product Master Maintenance PM70 o NT The Net price flag Y from Order Detail 0E54 indicates that the price is a net price without discounts if applicable o TX The tax code Y indicates that the order is taxable and N indicates that the order is not taxable The tax code is from Order Detail OE54 o NC No charge code which indicates if the order is chargeable from Order Detail 0E54 Valid codes are Blank
34. Customer Order Update ORD400CU type the letter Y default in the Receive field If you want accepted EDI customer orders to be automatically placed on hold type the letter Y in the bottom field The default value is N o EDICNTRL EDICS The parameter EDICNTRL allows you to specify the range of numbers to be used Page 3 Frontier User s Manual Electronic Data Interchange Version 2 1 as EDI control numbers for purchase orders acknowledgments advance ship notices invoices and the order status report Control numbers are used when the value in the corresponding transmit field on the parameter EDI is the letter Y and the current number field above is not blank Access EDICNTRL from either the EDI Menu OEMENUE or the Purchase Order Parameter Menu POMENUD The Current Number field on the EDICNTRL parameter is incremented each time Frontier uses a control number In addition the control number field in the appropriate link file will be updated with the next number in the corresponding Current Number field o EDIOUT EDIOUTCD The parameter EDIOUT allows you to specify the output queue and its library to be used for EDI invoices the EDI invoice register EDI purchase orders EDI order acknowledgements and EDI advance ship notices Type the name of the output queue in the top field and the name of the library in the bottom field The system does not validate the values in this parameter Access EDIOUT fr
35. ER PRODUCT NUMBER Customer product number for the ordered product EOBTPN SALES UNIT PRICE Unit price for the line item in the sales unit of measure EOARTL PRODUCT NUMBER Product number of the ordered product EOPN PRODUCT DESC Description of the ordered product EODESC ORDER QUANTITY Quantity of product ordered in the sales unit of measure EOOQS SALES UNIT OF MEASURE Sales unit of measure for the ordered product EOSUM CUST PRODUCT DESC Customer product description for the ordered product EOBTDS LINE STATUS CODE Valid line status codes EOLNC are DE order cancelled in Ship and Bill Maintenance 0E57 IC line item deleted in Rapid Order Entry Maintenance OE51 or Order Detail OE54 RD order required date changed in Order Header Maintenance OE53 or line promise date changed in Sales Order Promising OE62 STATUS RESPONSE CODE Status response code EOSRC EDI ACKNOWLEDGEMENT EDI functional acknowledgment code EOAF appears when a functional acknowledgement is received CONTROL NUMBER Control number assigned EOCNT to the transaction PROMISED DATE Promised date for the line item EOPRMM EOPRMY EOPRCT ORDER DATE ENTERED Date the purchase order was entered EOPOD CUSTOMER REFERENCE NUMBER Customer reference number EOREF Example For a sample report see Appendix 1 Page 60 Frontier User s Manual Electronic Data Interchange
36. Friedman Corporation Electronic Data Interchange NOTE The content of this user manual was updated for Version 2 1 However since this manual was produced in O fficeVision on the AS 400 it reflects the old format and JavaView screens are not included The manual will be rewritten and converted to the new PC format for Version 2 2 Frontier Version 2 1 U ser Manual Copvright Information Information in this document is subject to change without notice Friedman Corporation shall not be liable for anv technical or editorial errors contained herein or for incidental or consequential damages resulting from the performance furnishing or use of this material O Copyright of Friedman Corporation 2003 All rights reserved This documentation contains proprietary information of Friedman Corporation It is provided for the use of Friedman Corporation staff and members of client organizations only Any use of this documentation by other persons is prohibited by law Friedman Corporation One Parkway North Deerfield IL 60015 Phone 847 948 7180 Fax 847 948 9425 www friedmancorp com Table Of Contents I INTRODUCTION Before You Begin EDI Menu OEMENUE EDI Physical Files EDI Screens III EDI BATCH PROGRAMS EDI Purchase Orders PODO10 EDI Customer Order Acknowledoments ORDOO1 Advance Ship Notices ORDO3OMR Invoice Print amp Update INVOO1 Purge EDI Link Files EDI900 EDI Customer Order Edit ORD400CE
37. MBER QUANTITY PC PER QTY UNIT PRC M QUEEN ANNE TABL QAW 6 1 408 72 GM 68 12 YOUR PRODUCT WALQA QUEEN ANNE TABLE WALNUT 6 ORDER TOTALS TAX TOTAL SHIP ORDER COMPLETE NO BACKORDER Page 2 REASON OVER LIMIT DATE RECEIVED 00 00 00 ENTERED 00 00 00 ACK PRT 00 00 00 SHIPPED 00 00 00 SHP DTE 00 00 00 INVOICE 00 00 00 ORD SUF OT ORD DTE REQ DTE S BR B BR 363 00 SI 00 00 00 00 00 00 01 01 NTN COM TXC RATE WEIGHT FCC PRICING Y 20 00 50 0000 TABLES TABL 50 300 0000 408 72 24 00 432 72 YOUR NATIONAL DISTRIBUTORS 0 P 0 BOX 78822 1300 MAIN LINE ROAD ORDER 20268 SHIP TO NATIONAL DISTRIBUTORS INC SOLD TO 100000 P O BOX 78822 10000 1300 MAIN LINE ROAD CHICAGO IL 60640 CHICAGO SHIP TO P O SOLD TO P O PICKED BY ORDER DATE 8 15 03 SHIPPING INSTRUCTIONS FREIGHT CHARGES COMMERCIAL TRUCK LIN PRE PAID 15 03 PRODUCT QTY NUMBER DESCRIPTION LOT ORDERED QAC QUEEN ANNE TABLE CHERRY 100 PRODUCT TEST CUST PROD FOR QAC 100000 QUEEN ANNE TABLE CHERRY 10 QAC YOUR PRODUCT TEST CUST PROD FOR QAC 100000 Page 3 IF PAID BY 09 14 03 DEDUCT TOTAL B 2 L WH SH WH 01 01 INC 60640 TAX SLSM 001 MARY SHIP NO LATER THAN CUSTOMER TERMS 10 DAYS NET 30 QTY PICKED 100 10 QTY BACK ORD 100 10 PRINT DATE 13 63 PRICE TIME 10 17 50 NETS 100 00 01 00 BILL TO SHIP TO 100000 100000 WESTERN MEDICAL SUPPLY WESTERN MEDICAL SUPPLY 93 E KI
38. Not Accepted Report ORD410 will list EDI configured orders with fatal errors Fatal errors for configured orders include an invalid option selection invalid option list the number of options exceeding the maximum for the option list and not including a mandatory selection EDI will process sales orders for models that use the HOLDORD and or MAKEBUY user exits For models that use HOLDORD EDI will place the order on schedule hold O6HOLD field with the reason code specified in HOLDORD For models that use MAKEBUY EDI will change the O6MOBY field value based on the rules speci fied in the formula User Exit Program A user exit program can be invoked to check the order header information when the order is sent for processing The name of this program is entered in the parameter OEUEDT the bottom field of option 30 on the Order Entry Parameter Menu 2 OEMENUD2 If the order does not pass the edit the fatal error message Errors in Order Header User Exit will appear on the EDI Customer Order Not Accepted Report ORD410 Executing The Program To print the EDI customer reports without updating the order transaction files select EDI Customer Order Edit ORD400CE from the EDI Menu OEMENUE and press ENTER When you press ENTER if the value in the system parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request I
39. T CARSON DRIVE 93 E KIT CARSON DRIVE PHOENIX CA 85039 PHOENIX CA 85039 INVOICE INVOICE BL SH CUST DATE NUMBER WH WH TYPE TAX CUST PO DROP SHIP PO 10 03 03 0000252 01 01 D 1 ORDER SLSM FRT SHIPPING INSTRUCTIONS CUSTOMER TERMS 6052 00 KEN PPD AIR FREIGHT 20 NET 30 D SHIPPED BACK ORDERED PART NUMBER DESCRIPTION PRICE NET CURRENCY 12 9724 1HP 1800RPM 208 VOLT ODP 5 00 5 00 YOUR PRODUCT HFS350 HARTMAN FORCEPS STRAIGHT 3 1 2 SUB TOTAL 5 00 IF PAID BY 10 23 03 DEDUCT 05 HANDLING CHARGES 5 00 10 00 Page 4 Date 10 03 03 Page Program ARJ006 SALES amp CREDIT MEMOS Time 00 00 00 NET ORDER INVOICE INVOICE INVOICE NUMBER DATE TY CR AMOUNT DISCOUNT AMOUNT NUMBER WH CUSTOMER 0002050 9 20 03 SI 10 00 05 9 95 6052 00 01 100000 WESTERN SUPPLY Page 5 Program INV010E Wh 01 DAILV EDI INVOICE REGISTER ORDER NAME SOLD TO INVOICE TP SHIP TO 6052 00 WESTERN MEDICAL SUPPLY 100000 0000252 SI 100000 TOTAL CUSTOMER BRANCH TOTAL GRAND TOTAL Page 6 MERCHANDISE Bre 00 MISC CHARGE FREIGHT TAX 00 00 Date Time TOTAL 10 00 10 00 10 00 10 00 00 00 03 Page l 00 00 00 COST 27 2200 MARG 444 40 Program CUSTOMER NO 100000 PRPPRPPB BR Page 7 ORD400 SHIP TO PO 100 54610E 54612E 54612E 54613E 54640E 54640E 54640E 5467E 5468E Date 10 18 03 Page EDI LINK ERROR REPORT EDIT Time 00 00 00 LINE ITEM 999
40. Version 2 1 ORDER STATUS UPDATE ORD870U Description Use Order Status Update ORD870U to create the 870 transac tions from the 869 transactions in the EDI Order Inquirv Link EOI file place the records in the EDI Order Status Link EOS file list the transactions on a report and purge records from the EDI Order Inquirv Link EOI file Use Order Status Update ORD870U to purge the EOI file Executing The Program To create and print a list of 870 transactions and purge the EOI file select Order Status Update ORD870U from the EDI Menu OEMENUE and press ENTER When vou press ENTER if the value in the svstem parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear Data Provided The report includes the following information for each order o CUSTOMER NUMBER Ship to customer number EISTKY o SALES ORDER NUMBER Sales order number and suffix EIORD EISUFX o SHIP TO PO ORDER NUMBER Ship to customer purchase order number EISPO o INVOICE NUMBER Invoice number EIINV o PRODUCT NUMBER Product number of the ordered product EIPS o CUSTOMER PRODUCT NUMBER Customer product number for the ordered product EICPN o INQUIRY ORIGIN Inquiry origin code EIORG Valid codes are
41. YMMDD Defaults to current date XORQDT Required date in ISO format YYMMDD Defaults to current date XOERS ERS Evaluated Receipt Settlement code used to suppress invoice printing Order header note number five will contain ERS followed by the value in XOERS Any value in order header note number five will be overwritten with the ERS code XOWH Warehouse must be in the division XODIV XODIV Division is a required field EDI Customer Order Detail Link XEP file fields XEPN If the original product has been deleted from the svstem the substitute product if one is designated in the product master will be used in the line item If no substitute was designated the order will be listed on the EDI Customer Order Not Accepted report XESPO Ship to purchase order number which is a required field XESTKY Customer ship to number There must be a corresponding header record in Page 32 Frontier User s Manual Electronic Data Interchange Version 2 1 the XOP file for the ship to purchase order number customer ship to number combination XEITEM Item sequence number XEOQS Order quantitv in the XESUM unit of measure XESUM Defaults to the unit of measure in the parameter HFAPRC Valid values are the inventory unit of measure and the sales unit of measure XEPROT Price lock flag which defaults from the header file price protect code XOPROT If
42. a price is included in the detail file XEARTL field and the price protect value is Y the link file price is accepted If the link file contains a price and the price protect value is blank the price is changed to a price table price if one is available and the changed price is reported as a non fatal error If the price protect value is blank and the salesperson number XESLMI XESLM2 XESLM3 rate XESLP1 XESLP2 XESLP3 per code XEPER discount amount XEDSS discount percentage XEDSC1 XEDSC2 XEDSC3 price at quantitv XEPRCQ commission XECOMR or net price flag XENETF contains a value the link file value is accepted and a message appears on the EDI Customer Order Accepted With Non Fatal Errors Report ORD410 If the price protect value is Y and one of the above fields contains a value the link file value is accepted and no message appears on the report XERQDT Date in the ISO format YYMMDD which defaults to the required date in the header record XORQDT XETEXT Comment text The detail record is considered a comment line if this field contains anything and product information is ignored XECPN The customer product number is 30 positions long However only the first 15 positions will appear on the EDI Link Error Report XEWH If in different division than XOWH bill to customer must be in both divisions If the shipping warehouse field in the EDI Customer Order Deta
43. alid automatic split code can t be Y if allocation code is _ Example For a sample EDI Customer Order Not Accepted EDIT Report see Appen dix 1 EDI Customer Order Accepted EDIT Report ORD410 Description This program reports customer orders that are acceptable that is contain no errors This report prints a separate page for each order Data Provided Information provided about an order includes o INVOICE TO If the override field XOOVBW contains a character then th ntik Page 40 Frontier User s Manual Electronic Data Interchange Version 2 1 override name and address must be entered in the link XOP file invoice to fields XOIVKY invoice to customer XOITNM customer name XOITA2 address XOITA3 address XOITAA address XOITCT citv XOITST state and XOITZP zip code If the override field is blank the invoice to number name and address are from Customer Master Maintenance CM52 o SHIP TO If the override field XOOVSW contains a character then th ntir override name and address must be entered in the link XOP file ship to fields XOSTKY ship to customer XOSTNM customer name XOSTA2 address XOSTA3 address XOSTAA address XOSTCT city XOSTST state and XOSTZP zip code If the override field is blank the ship to number name and address are from Customer Master Maintenance CM52 o BILL TO PO Bill to purchase order number
44. anual Electronic Data Interchange Version 2 1 Description The Invoices job stream prints the Dailv Invoice Register EDI INVOIOE This report lists the order number customer name and number invoice number date and amounts that correspond to each order for which the svstem created an EDI invoice The svstem calculates and prints totals bv customer warehouse and companv Printed EDI Dailv Invoice Register is sent to the output queue specified in the parameter EDIOUT EDI orders do not appear on the non EDI Daily Invoices Register INVO10 Data Provided The Daily Invoice Register EDI contains one line for each invoice the system creates Per invoice information includes o WH Shipping warehouse from Order Header Maintenance 0E53 o ORDER System assigned order number from Order Header Maintenance 0E53 o NAME Name of the sold to customer o SOLD TO Sold to customer from Order Header Maintenance 0E53 o SHIP TO Ship to customer from Order Header Maintenance OE53 o INVOICE Invoice number from Invoice Print amp Update INVOO1 o TP Order type abbreviation from Order Header Maintenance 0E53 Valid order types are SI Ship Invoice IO Invoice Only CM Credit Memo SO Ship Only QT Quote R RM RMA o MERCHANDISE Total cost of all items with product numbers from Invoice Print amp Update INVOO1 o MISC CHARGE The svstem calculates and prints the
45. changes but will not validate the new data Adding a record to the file 1 Press F9 to display blank lines Type the new records as needed 2 Press ENTER The value in the Inquiry Origin field of each new record will be the number 2 Deleting a record from the file 1 Display the record to delete 2 Type the letter D in the function field for that record 3 Press ENTER Page 58 Frontier User s Manual Electronic Data Interchange Version 2 1 ORDER STATUS EDIT ORD870E Description Use Order Status Edit ORD870E to create the 870 transactions from the 869 transactions in the EDI Order Inquirv Link EOI file and list the transactions on a report This program will not purge records from the EDI Order Inquirv Link EOI file Use Order Status Update ORD870U to purge the EOI file Executing The Program To print a list of 870 transactions select Order Status Edit ORD870E from the EDI Menu OEMENUE and press ENTER When vou press ENTER if the value in the svstem parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear Data Provided The report includes the following information for each order o CUSTOMER NUMBER Ship to customer number EISTKY o SALES ORDER NUMBER Sales order number and suffix EIORD EISUFX
46. customer zip EISTKV Ship to customer number EISNAM Ship to customer name EISADI Ship to customer address line 1 EISAD2 Ship to customer address line 2 EISAD3 Ship to customer address line 3 EISCTY Ship to customer city EISST Ship to customer state EISZIP Ship to customer zip EIINVD Invoice date in the format YYMMDD EIINVH System generated invoice number EIWHB Billing warehouse EIWHS Shipping warehouse EICTYP Customer type EITAXG Tax group for sales tax system TAXVS S For header records same as in order header For detail records blank EISPO Ship to customer purchase order number EIBPO Bill to customer purchase order number EITXCD Tax code For header records same as in order header For detail records same as in detail Tax group for sales tax system tax exempt code for VAT tax system or GST tax exempt code in Canadian tax system EIFST GST tax number in Canadian tax system EIPSTF PST exempt flag in Canadian tax system A Y means PST tax will not be added N means PST tax will be added EIPS PST tax number in Canadian tax system EIORD Sales order number EISUFX Sales order backorder suffix EISM Salesperson code EIFRTT Freight terms EIINST Shipping instructions EICTDS Cash terms description EICURC The currency of the invoice The currency code is the code from the currency table Currency Code Maintenance CRO1 which was added to the order during order entry 0E53 All curre
47. d information and press o change an existing record press F11 for Change mode The system allows changes to the record To insert a field in a record press F9 Following is a copy of the XEP display Page 48 Frontier User s Manual Electronic Data Interchange Version 2 1 EDILINKXEF Mode ENTRY Format RFSXE File XEF Ship to PO Ship to Item Order qty SUM Product number SUM Customer product nbr Actual price NC Price protect ta Required date Warehouse Disc1 Disc2 Disc3 Discount amount 000 Price at quantitv Tax code Charge code Drop ship flag Sls 1 Sls 2 Sls 3 Sls 1 SLST2 3 ST Su 3 3 Commission Price per Comment grp with Netf ji Change flag F3 Exit F5 Refresh F6 Select format F9 Insert F10 Entry F11 Change Use this display to add and or maintain XEP records o add a record press F10 for Entry mod ENTER changes to the record To insert a field Following is a copy of the XFP display th o change an existing record press F11 for Chang Typ record information and press mod The system allows in a record press F9 Page 49 Frontier User s Manual Electronic Data Interchange Version 2 1 EDILINKXEF Mode Format s s x x s RFSXF File NTRY gt El m Ship to PO Ship to Item Option Option selection Dim Qty 00000 Description Model set item
48. d to delete Press ENTER FOLDED SCREEN FIELD LEVEL HELP he prompt fields are Ship to PO Nbr SPO This field accepts and or displays the ship to customer purchase order number Sales Order Nbr ORD Page 55 Frontier User s Manual Electronic Data Interchange Version 2 1 This field accepts and or displavs the sales order number Sales order numbers are assigned when the order is created in Order Header Maintenance OE53 or Rapid Order Entrv Maintenance OE51 RMA order numbers are assigned in RMA Entrv Maintenance RM51 he following data fields appear on the folded part of the screen Customer Number STKY This field accepts and or displavs the number of the customer to whom orders will be shipped You may override the ship to customer number in Order Header Maintenance OE53 or Rapid Order Entrv Mainte nance OE51 when you create a sales order On a selection screen or in the prompt area if you type a question mark invalid customer number or the first portion of a customer number the system displays a list of existing customers in the Customer Master Window CMO1 If you type a question mark the display begins with the first customer in the file If you type an invalid name or a portion of the name the display begins with the next valid customer Move your cursor to a customer and press ENTER to select that customer Div EIDIV DV note tvp
49. d with a critical error If the EDI PCM Option Link XFP file does not contain a selection for a particu lar valid option list the svstem will use the default option selection if one exists Such orders will be listed on the EDI Customer Order Accepted With Non Fatal Errors Report Non fatal error will occur when the option price is not found and when the initial option list is not found NOTE Maintenance of the option description is not supported The EDI Customer Orders Not Accepted Report ORD410 will list EDI configured orders with fatal errors Fatal errors for configured orders include an invalid option selection invalid option list the number of options exceeding the maximum for the option list and not including a mandatorv selection EDI will process sales orders for models that use the HOLDORD and or MAKEBUY user exits For models that use HOLDORD EDI will place the order on schedule hold O6HOLD field with the reason code specified in HOLDORD For models that use MAKEBUY EDI will change the O6MOBY field value based on the rules speci fied in the formula User Exit Program A user exit program can be invoked to check the order header information when the order is sent for processing The name of this program is entered in the parameter OEUEDT the bottom field of option 30 on the Order Entry Parameter Menu 2 OEMENUD2 If the order does not pass the edit the fatal error message
50. der Accepted With Non Fatal Errors EDIT ORD410 Customer Order Not Accepted Report EDIT ORD410 Customer Order Accepted Report EDIT ORD410 Link Error Report UPDATE ORD400 Sr EE ag Customer Order Accepted With Non Fatal Errors UPDATE ORD410 Customer Order Not Accepted Report UPDATE ORD410 Customer Order Accepted Report UPDATE ORD410 Order Status ORD870 Page Version 2 1 MINUS Q N P PF F P P PR Q Q N P OG 63 1 01 4012 2 07 04 200 CAMDEN LUMBER SUPPLY FRIEDMAN CORPORATION 1475 NORTH LANDON SUITE 200 STEVENSON IL 60457 104 WILMOT ROAD DEERFIELD IL 60015 ATTN NOTIFY 847 555 4711 80 CONFIRMING ORDER 2 07 04 STEVE BECKER AIR FREIGHT NET 15 DAYS DESTINATION 1 00 10 EA QA21 QUEEN BEE PROD 2 15 04 10 0000 EA 01 00 114 000 LINE CLOSED REQUISITION NUMBER 004678 BEST WAY POSSIBLE PREFERRED VENDOR REDUCED INSPECTION APPLIES PO VALUE 100 00 Page 1 12 09 03 14 48 05 ACKNOWLEDGEMENT WAREHOUSE 01 WAREHOUSE 01 NORTH CHICAGO 4646 N KEELER CHICAGO IL 60055 BILL TO 111111 SHIP TO 111111 ROPER INDUSTRIES ROPER INDUSTRIES 111111 S W STREET 111111 S W STREET ATTN PURCHASING DEPT ATTN PURCHASING DEPT INDIANAPOLIS IN 55510 INDIANAPOLIS IN 55510 SHIP TO PO SOLD TO PO TERMS DIV P900278 P900278 2 10 NET 30 DAYS 02 ERT CR CTY CTRY TAX CARRIER SHIPPING INSTRUCTIONS TERM REG CDE CDE GRP REF UNITED PARCEL AIR FREIGHT COL 01 COK 1 EXTENDED U DESCRIPTION PRODUCT NU
51. e in Note Tvpe Maintenance NF68 This field displavs the sales order customer s division Sales Order Number ORD This field accepts and or displavs the sales order number Sales order numbers are assigned when the order is created in Order Header Maintenance OE53 or Rapid Order Entry Maintenance OE51 RMA order numbers are assigned in RMA Entrv Maintenance RM51 SUFX This field accepts and or displavs a two digit suffix number that indicates the backorder level Line Item Number ITEM This field accepts and or displavs the number of each line item Ship to Customer PO SPO This field accepts and or displays the ship to customer purchase order number Invoic INV This field accepts and or displays the invoice number Invoices INVO001 the program used to generate invoices assigns a number to each sales order invoice starting with the value in the DAINV parameter Page 56 Frontier User s Manual Electronic Data Interchange Version 2 1 function field FIDE This field accepts the letter D to delete the record UNFOLDED SCREEN FIELD LEVEL HELP The following additional fields appear on the unfolded part of the screen Product Number EIPS This field accepts and or displavs the number of the ordered product Inquirv Origin ORG This field displavs one of the following inquirv origin code
52. e purchase order are in this currency EPVALU Order value EPLINE Line item number EPOQP Order quantity in the purchase unit of measure EPPUM Purchase unit of measure EPPN Product number EPDESC Product description EPRDD Required date EPPPP Vendor price in effect for the quantity ordered EPACCT General ledger account number EPPDD Promised date EPFRQ Number of the requisition converted to a purchase order EPWRK Manufacturing order number EPOP Subcontracted operation work order number Page 11 Frontier User s Manual Electronic Data Interchange Version EPCNT EPCPN EPDWRL EPTEXT EPAFLG 2 51 Project number Vendor product number Drawing number revision letter Comment text EPCNTR Example Page 12 This field is not updated It is available for update by translator software when a functional acknowledgment is received This field is updated by the system with a unique control number beginning with the number in parameter EDICNTRL Use this field to associate functional acknowledgments with link file records For a sample purchase order s Appendix 1 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI CUSTOMER ORDER ACKNOWLEDGMENTS ORDOO1 Description Acknowledgments can be used either as client confirmations or to determine that an order was entered properly The system prints EDI Acknowl
53. e quantitv picked from Batch Allocation ORD006 When the order has been shipped this field displays the shipped quantity o QTY BACK ORD Quantity that was backordered from Batch Allocation ORD006 o PRICE Price of product ordered from pricing programs or Order Detail OE54 o NETS Net item value from the pricing programs or Order Detail OE54 o YOUR PRODUCT Customer product number and its description from either Customer Product Maintenance OE85 or PCM Customer Product Maintenance WS85 If you use the customer product number to order an item that number appears when the Shp Print flag field value in Customer Product Maintenance OE85 or the Shp field in PCM Customer Product Maintenance WS85 is P or B the customer product description appears if the Shp Print flag or Shp field value is D or B The system calculates and prints the total net value and displays the order entry notes from Order Header Maintenance 0E53 Page 20 Frontier User s Manual Electronic Data Interchange Version 2 1 In addition to printing a paper copv of the EDI advance ship notice the svstem updates the following fields in the EDI Advance Ship Notice Link ESP file for each advance ship notice ESDRC Record tvpe ESORD Sales order number ESSUFX Sales order number suffix ESSTCN Sold to customer name ESSTA1 Sold to customer address line 1 ESSTA2 Sold to customer address line ESSTA3 Sold to customer address line
54. ears if the Inv Print flag or Inv field value is D or B o SUB TOTAL The system calculates and prints the subtotal as the sum of the taxable and non taxable merchandise o TAXES Up to five separate taxes may appear on the invoice Each tax is defined in the TX note file in Note Type Maintenance NF68 and is calculated against the total of the taxable merchandise o TERMS Description of the terms from the customer master the total discount amount is calculated using those terms o TOTAL ADVANCE PAYMENTS Total amount of any cash in advance payments made for this order o INVOICE AMOUNT The system calculates and prints the total invoice amount gross discount In addition to printing the EDI invoice the system updates the EDI Invoice Link EIP file for each EDI invoice The EIP fields are updated as follows Page 25 Frontier User s Manual Electronic Data Interchange Version 2 1 EIRCD Record code H for header record and D for line item record EIRCD Record code identifier always updated with 01 EIBTKV Invoice to customer number EIBNAM Invoice to customer name EIBADI Invoice to customer address line 1 EIBAD2 Invoice to customer address line 2 EIBAD3 Invoice to customer address line 3 EIBCTV Invoice to customer citv EIBST Invoice to customer state EIBZIP Invoice to
55. edg ments when the parameter EDI contains the letter Y in the Customer Order Ac knowledgement field The program adds a record to the Acknowledgment Link EKP file for each acknowl edgment for customers that have the letter Y in the EDI Acknowledgment field in Customer Master Maintenance CM52 The record includes one header record and a detail record for each detail line on the acknowledgment Extra header records will be written for each customer note comment from Order Header Maintenance OE53 the customer master record or the Order Header Link XOP file The program then sends the printed acknowledgments to the output queue specified in the parameter EDIOUT If a record for an order already exists in the EKP link file the program deletes the existing record then adds a new record to the file The EKP file control number is updated with the next number in the parameter EDICNTRL if the parameter contains a control number The value in EDICNTRL is incremented each time a control number is used Executing The Program To print create EDI acknowledgments select EDI Custom er Order Acknowledgements ORDOOI from the EDI Menu OEMENUE and press ENTER When you press ENTER if the value in the system parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear
56. eleted not required for single currency Invalid value for invoice print flag must be Blank T N P Ship to PO for cust already exists The above item is a drop ship item Insufficient stock available This error message appears when there is insuffi cient stock of kit bill components Default option selection used for opt Price needs to be determined for the option selected Initial option list name not found for the model Price is less than price variance Page 37 Frontier User s Manual Electronic Data Interchange Version 2 1 Example For a sample EDI Customer Order Accepted With Non Fatal Errors EDIT Report see Appendix 1 EDI Customer Order Not Accepted EDIT Report ORD410 Description This program reports customer orders that are unacceptable that is contain at least one fatal error All fatal and non fatal errors on the order are reported This report prints a separate page for each order Data Provided Information provided about an order includes o INVOICE TO If the override field XOOVBW contains a character then th ntir override name and address must be entered in the link XOP file invoice to fields XOIVKY invoice to customer XOITNM customer name XOITA2 address XOITA3 address XOITA4 address XOITCT city XOITST state and XOITZP zip code If the override field is blank the invoice to number name and address are from Customer Master
57. er number from Order Header Maintenance OE53 o PICKED BY Initials of the user who entered the order o ORDER DATE Date of the order from Order Header Maintenance 0E53 Page 19 Frontier User s Manual Electronic Data Interchange Version 2 1 o BL WH Billing warehouse from Order Header Maintenance OE53 o SH WH Shipping warehouse from Order Header Maintenance 0E53 o TAX Tax group from Customer Master Maintenance CM52 or Order Header Maintenance 0E53 o SLSP Salesperson code from Order Header Maintenance OE53 o SHIPPING INSTRUCTIONS Ship via description from Customer Master Maintenance CM52 or Order Header Maintenance OE53 o FREIGHT CHARGES Freight charges code from Ship and Bill Maintenance 0E57 o SHIP NO LATER THAN Required date from Order Header Maintenance 0E53 o CUSTOMER TERMS Customer cash payment terms code from Customer Master Maintenance CM52 or Order Header Maintenance 0E53 The following information appears for each line item in the order o PRODUCT NUMBER Internal number of the ordered product from Order Detail OE54 o DESCRIPTION Internal product description from Product Master Maintenance PM70 o LOT Lot from which the order was picked from the on line allocation programs o QTY ORDERED Quantity of each product ordered from Order Detail OE54 o QTV PICKED or QTV SHIPPED For picked orders this field displavs th
58. er quantity Sales unit of measure EA Cust product desc Line status code Status response code 1 EDI acknowledgement Control Number Promised date 50701 Order date entered Customer reference number ORDER STATUS INQUIRY FILE Customer number 7494 Sales order number 33899 00 Ship to po order number Invoice number Product number Customer product number Inquiry origin 3 Item number 00000 Line status code DE Quantity Deleted Customer ref number ORDER STATUS LINK FILE Sales order number 033899 00 Ship to number 7494 Bill to number 7494 Invoice number Ship to customer POt Customer product number Line item 1 00 Sales unit price 15 00 Product number Product desc Order quantity Sales unit of measure EA Cust product desc Line status code Status response code 1 EDI acknowledgement Control Number Promised date Order date entered Customer reference number Page 15 Page DE DE DE p
59. exists but no header Duplicate header record for this group of orders Invalid order type must be SI CM QT 10 RM Invalid group with code must be Blank or G Invalid customer part number for customer Ship to P O number is missing Customer number is missing Data Area DANXO is locked Order type of SO ship only not valid for EDI customer orders Invalid item number reserved for kit bills group items Invalid part number not PCM part but PCM option records are present Invalid part number PCM part with no PCM option records Invalid part number PCM part does not contain a line number Invalid PCM option record does not have a line number Invalid PCM option record does not match order detail line number Customer number is invalid Customer number has been deleted Invalid customer part eff date for customer Option from XFP file will be ignored as PCM part file WS85 is used Departmental pricing department is missing Department is given but not a departmental pricing Departmental pricing department is invalid Shipping wh is not set up in customer division Customer not valid for shipping division __ Page 35 Frontier User s Manual Electronic Data Interchange Version 2 1 Manufacturing warehouse __ is invalid Distribution warehouse __ is invalid Invalid inventory segment for product and manufacturing wareho
60. f the value in BATSBM is the letter N no window will appear Page 34 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI Link Error Report EDIT ORD400 Description This program provides a list of customer orders which are unac ceptable due to critical errors that prevent additional processing Data Provided The EDI customer order information includes o CUSTOMER NO Ship to customer number from either the XOSTKY ship to customer number field for header errors in the EDI Link Customer Order Header XOP file or the XESTKY ship to customer number field for line item detail errors in the EDI Link Customer Order Detail XEP file o SHIP TO PO Ship to purchase order number from either the XOSPOf ship to purchase order number field for header errors in the EDI Link Customer Order Header XOP file or the XESPO ship to purchase order number field for line item detail errors in the EDI Link Customer Order Detail XEP file o LINE ITEM Line item number from the XEITEM item sequence number field in the EDI Link Customer Order Detail XEP file o PART NO Product number from the XEPN field in the EDI Link Customer Order Detail XEP file o ERROR The program prints the following critical error messages Parentheses with blanks will be filled in with the invalid value Order header exists but no detail Order detail
61. for sold to customers that have the letter Y in the EDI Invoice field in Customer Master Maintenance CM52 The system then sends the printed invoices and the EDI Daily Invoice Register to the output queue specified in the parameter EDIOUT The system updates the control number field EICNTL in the EIP file when the Customer Invoice field in the parameter EDI contains the letter Y The control number is updated with the next number in the parameter EDICNTRL if the parame ter contains a control number The value in EDICNTRL is incremented each time a control number is used The Invoices job stream initiates the following programs o Invoice Print amp Update INVOO1 o Sales amp Credit Memos ARJ006 o Daily Invoice Register EDI INVO10E NOTE Records also will be added to the Invoice Link EIP file when you run Select Invoice Reprint INVOO1 S Executing The Job To print invoices select Invoice Print amp Update INVOO1 from the EDI Menu OEMENUE and press ENTER The program displays the Submit Daily Invoices for Processing option screen Type the following and press ENTER o invoice cycle number to limit printing to only invoices for customers with that invoice cycle number in the Invoice cycle field in Customer Master Maintenance CM52 To print all invoices type asterisk in this field o warehouse code to limit the program to that warehouse or type asteri
62. ge Version 2 1 The invoice provides the following information for each shipped line item in the order Except for the extended amount this information does not appear on the summarv invoice o SHIPPED Shipped quantitv from Ship and Bill Maintenance 0E57 o BACK ORDERED Back order quantity from Backorder Maintenance OEBOMR NOTE When an item with the per code L is completelv backordered no extended price will appear on the invoice for that item If the L item is partially backordered the original invoice will include billing for the entire lot and the invoice for the backordered quantitv will be billed at no charge o PART NUMBER Ordered product from Order Detail OE54 o DESCRIPTION Internal product description from Product Master Maintenance PM70 or Order Detail 0E54 o PRICE Product price from the pricing programs o EXTS The program calculates the line item extended value as Order quantity x Unit price x 1 discountl x 1 discount 2 x 1 discount3 Discount o YOUR PRODUCT Customer product number and its description from either Customer Product Maintenance 0E85 or PCM Customer Product Maintenance WS85 If you use the customer product number to order an item the customer product number appears when the Inv Print flag field value in Customer Product Maintenance 0E85 or the Inv field in PCM Customer Product Mainte nance WS85 is P or B the customer product description app
63. il Link XEP file is blank the svstem will perform order routing Orders For Configured Products Orders containing configured products including model sets will be handled the same way as in Option Selection and Maintenance WS54 and Order Detail OE54 The job stream will update the Configuration CFP file and the order total dollars ODGRSS field and will add the OPTIONS BEGIN and OPTIONS END comment lines to the order Use parameter OPTEND to determine the number of lines Option Selection and Maintenance WS54 will add between the last line item on a configured sales order and the OPTIONS END line EDI Customer Order Update ORD400CU will print the adjusted model price model price plus dimensional prices plus matrix prices on the reports PCM Customer Product Maintenance WS85 is used to create and maintain the customer product number records in the PCM Customer Product Number ATP file This program also can be used as an alternate way to assign default values for a model s options You specify a configuration code consisting of the default options and assign the code to a customer product During order processing the svstem supplies the model number for that customer customer product number and Page 33 Frontier User s Manual Electronic Data Interchange Version 2 1 uses the configuration code to insert values into the option selection fields For EDI orders if a PCM customer produc
64. ired date in Order Header Maintenance 0E53 for this customer s order The system adds the inquiry origin code 3 and the line status code RD to the file for the changed date o You delete a detail line from this customer s order in Rapid Order Entry Maintenance OE51 or Order Detail OE54 The system adds Page 7 Frontier User s Manual Electronic Data Interchange Version 2 1 the inquirv origin code 3 and the line status code IC to the file for the deleted item o You cancel this customer s order in Ship and Bill Maintenance 0E57 The system adds the inquiry origin code 3 and the line status code DE to the file for the cancelled order o You add or change the order promise date in Sales Order Promising OE62 o Vendor Master Maintenance VM10 The field that appears in Vendor Master Maintenance VM10 for EDI is EDI VMEDI This field accepts and or displavs one of the following to iden tifv the vendor as an EDI vendor N default do not create an EDI purchase order for this vendor Y create an EDI purchase order for this vendor Page 8 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI PURCHASE ORDERS PODO10 Description Use this program to asvnchronouslv print EDI purchase orders when either o parameter EDI contains the letter Y in the Purchase Order field o for drop ship orders when the item is flagged with either the letter T or B in the CR field of U
65. irmation number from PO Entrv Maintenance PU13 o CONTACT PHONE Contact telephone number and extension from Vendor Master Maintenance VM10 o DATE ORDER WAS PLACED Date the order was placed from PO Entry Maintenance PU13 o CONTACT Name of the contact person from Vendor Master Maintenance VM10 o SHIP VIA Shipping method used by the vendor from Vendor Master Maintenance Page 9 Frontier User s Manual Electronic Data Interchange Version 2 1 VM10 The value in this field defaults from Vendor Master Maintenance VM10 but can be overridden in PO Entry Maintenance PU13 o TERMS Cash terms code from PO Entrv Maintenance PU13 o FOB Description of how the vendor handles freight defaults from Vendor Master Maintenance VM10 but can be overridden in PO Entry Maintenance PU13 o LINE ITEM NUMBER Line item number or comment line number from PO Entry Maintenance PU13 o QUANTITY Quantity ordered from PO Entry Maintenance PU13 o PURCHASE UNIT OF MEASURE Purchase unit of measure from Product Master Maintenance PM70 o PRODUCT NUMBER Product number from PO Entry Maintenance PU13 o PRODUCT DESCRIPTION or COMMENT Description of the product from Inventory Segment Maintenance PM73 The comment is from PO Entry Maintenance PU13 o DUE DATE Date the order is due from PO Entry Maintenance PU13 o PRICE Price of the product from Vendor Quote Maintenance QM11 If the
66. is manual Executing The Program To copy an existing order to the copy group select Order Copy ORD450 from the EDI Menu OEMENUE The program displays an option screen used to specify the order to copy copy group and order header fields to be copied If vou submit this program multiple times each request will retain its own options Tvpe the following and press ENTER O order to be copied the copy from order and suffix if needed The copy from order should have a ship to purchase order number If it does not the Ship to po field appears as well as an error message that requests the ship to purchase order number The system also copies the bill to purchase order number if one appears on the copy from order copy group source order header fields for each option type one of the following codes N default to update the field in the normal manner for example from the customer master or the parameters Y if the field value should be copied from the copy from order If the letter Y appears in the Price protected field then the order header price protected field value and the following line item field values will be copied from the copy from order no charge code price protected discount percentages 1 2 3 discount amount price at quantity salesperson 1 2 3 rate 1 2 3 total commission percentage per pricing code net price and unit price The order line ite
67. lid value for allocation flag must be Blank L O C Invalid value for back order code must be Blank Y N Invalid bill to warehouse Invalid carrier code ee Order date is invalid Required date is invalid Invalid cash terms Invalid division Invalid customer sales territory Invalid UPS zone Invalid freight terms Invalid salesperson number 2 Invalid credit memo reason Invalid sales promo Invalid customer not Invalid currency code Header to Base exchange not found Exchange rate not found Invalid value for acknowledgement _ must be Blank T N GL alpha code is not valid for customer orders VAT code required for non stock items Invalid VAT code Price is missing GL alpha code is invalid Jess Invalid customer product number Page 39 Frontier User s Manual Electronic Data Interchange Version 2 1 Invalid part number Jes Invalid inventory unit of measure Vis Invalid order quantity Invalid inventory segment Part Wh Invalid Canadian tax code Receiving segment not found or inactive Part wh Invalid value for handling chrge must be Blank Y N Invalid currency code Invalid salesperson Combined salesperson percentages is must equal 100 Invalid VAT tax code Substitute part number is invalid jie Invalid customer catalog
68. m line number quantity account alpha code product number unit of measure drop ship flag and comments always are copied from the copy from order NOTE Interbranch and configured orders cannot be generated using Order Copy ORD450 Also the copy from order may not include line numbers that include suffixes 1 01 1 02 and so on These line numbers are reserved for system us therefore the program will reject the order with a fatal error After you make your selections press ENTER Then press F3 to submit the job or press F12 to cancel the request When you press F3 if the value in the system Page 51 Frontier User s Manual Electronic Data Interchange Version 2 1 parameter BATSBM is the letter V then a confirmation window will appear Press F18 to submit the program or press FI2 to cancel the request If the value in BATSBM is the letter N no window will appear Page 52 Frontier User s Manual Electronic Data Interchange Version 2 1 INTRODUCTION TO EDI ORDER STATUS EDI Order Status allows vou to receive create change and delete inbound EDI Order Inquirv 869 transactions These transactions then are read bv a batch program which creates EDI Order Inquirv 870 transactions for all affected customers Frontier provides two EDI order status phvsical files EDI Order Inquirv Link EOI file for 869 transactions EDI Order Status Link EOS file for 870 t
69. meter values Press ENTER 4 more times to cuting The Program To enter and maintain the XEF file select Link File ntenance EDILINKEXD from the Electronic Data Interchange EDI Menu system first displays the XOP file records format RFSXO To display the format RFSXE or XFP format RFSXF records instead press F6 from the XOP play The system displays a selection screen Type 1 one in the Opt field the format to display and press ENTER 1 2 3 Type the following parameters Program EDILINKXEF Library FRNPGMO20 Data file XEF Library your data library 4 complete the change Exe Mai OEMENUE The XEP dis of Fol lowing is a copv of the XOP displav Page 47 Frontier User s Manual Electronic Data Interchange Version 2 1 EDILINKXEF Format Ship to PO Ship to Item Sold to Order type Sold to PO Order date Credit card Crdt crd type Crdt crd cent E Mail Ship to wh Cash terms Note 2 Note 4 Cr reason Ack flag F3 Exit F9 Insert RFS XO Mode File NTRY gt El m Div Price as Invoice to Required date CC exp date Sold to wh Note 1 Note 3 Note 5 Ref Promotion name F5 Refresh F6 Select format F10 Entry F11 Change Use this display to add and or maintain XOP records ENTER o add a record press F10 for Entry mode Type the recor
70. n the ESP link file the program deletes the existing record then adds a new record to the file The program updates the control number ESCNTL field in the ESP file with the next number in the parameter EDICNTRL if that parameter contains a control number The value in EDICNTRL is incremented each time a control number is used The program then sends the printed advance ship notices to the output queue specified in the parameter EDIOUT The program also prints two error listings Advance Shipper Errors and EDI Advance Shipper Errors The system prints these reports when the asynchronous task is brought down Executing The Job To print advance ship notices select Advance Ship Notice ORDO30MR from the O E Parallel Processing Menu OEMENUP and press ENTER The system initiates the asynchronous task Data Provided The information on an advance ship notice includes o ORDER Svstem assigned order number from Order Header Maintenance 0E53 o SHIP TO Number name and address of the ship to customer as defined in the customer master o SOLD TO Number name and address of the bill to customer as defined in the customer master o PRINT DATE Date the advance ship notice was printed o TIME Time the advance ship notice was printed o SHIP TO P O Ship to purchase order number from Order Header Maintenance OE53 o SOLD TO P O Sold to also called bill to purchase ord
71. nce CM52 o PART DESCRIPTION Description of the product from Product Master Maintenance PM70 Page 38 Frontier User s Manual Electronic Data Interchange Version 2 1 o QUANTITV Quantitv from the XEOQS order quantitv field in the link file o SUM Sales unit of measure from the XESUM field in the link file or Product Master Maintenance PM70 o PRICE Price from the XEARTL unit price field in the link file or Price List Maintenance PR81 o EXTENDED PRICE Extended value is calculated as the quantitv times the price o ERROR The report prints non fatal error messages preceded bv a single asterisk See EDI Customer Order Accepted With Non Fatal Errors EDIT fora list of the non fatal error messages The program also prints the following fatal error messages preceded by two asterisks Parentheses with blanks will be filled in with the invalid value The sold to customer number is invalid The invoice to customer number is invalid The ship to customer number is blank The ship to customer number is invalid Invalid value for Canadian PST tax code must be X or N Invalid credit region Invalid ship to state code Invalid tax group code Invalid invoice to state code Invalid shipping warehouse Invalid value for tax code must be Y or N Invalid value for price protected must be Blank or Y Inva
72. ncy amounts on the invoice are in this currency EIHND S Handling charge EISHPS Value of shipped item EIDISD Discount date in the format YYMMDD EITDIS Total discount value EITOTS Total order value EIAFLG This field is not updated but is available for update by translator software when a functional acknowledgment is received EICNTR This field is updated by the system with a unique control number Page 26 beginning with the number in parameter EDICNTRL Use this field to Frontier User s Manual Electronic Data Interchange Version 2 1 associate functional acknowledgments with link file records The following fields summarize VAT tax amounts by VAT code EIVTC1 EIVTRI EIVTNI EIVTS1 EIVTC2 EIVTR2 EIVTN2 EIVTS2 EIVTC3 EIVTR3 EIVTN3 EIVTS3 EIVTC4 EIVTR4 EIVIN4 EIVTS4 EIVATS The following fields are updated for detail records VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT code VAT tax rate VAT net value VAT amount VAT total amount EIRCD field contains D A detail record is created for each tax In VAT tax svstem this field is updated Product Master Maintenance PM70 All are in the inventory unit of measure It is available for update by translator when a functional acknowledgment is received This field is updated by the
73. nprinted Purchase Orders DS77 The program adds a record to the Purchase Order Link EPP file for each pur chase order for vendors that have the letter Y in the EDI field in Vendor Master Maintenance VM10 If a record for an order already exists in the EPP link file the program deletes the existing record then adds a new record to the file Printed purchase orders are sent to the output queue specified in the parameter EDIOUT Executing The Program To create EDI purchase orders select EDI Purchase Orders PODO1O from the EDI Menu OEMENUE and press ENTER The system initi ates the asynchronous task Print Purchase Orders PODO10 Data Provided The EDI purchase order includes the following data o REVISION NUMBER Revision number from PO Entry Maintenance PU13 o WAREHOUSE Warehouse from PO Entry Maintenance PU13 o PURCHASE ORDER NUMBER Purchase order number from PO Entry Maintenance PU13 o DATE The program prints the svstem dat o VENDOR NUMBER Vendor number from PO Entrv Maintenance PU13 o VENDOR ADDRESS Vendor address from Vendor Master Maintenance VM10 o SHIP TO ADDRESS Ship to address from PO Entrv Maintenance PU13 WH note type in Note Type Maintenance NF68 or Vendor Master Maintenance VM10 o ATIN Name of the vendor contact from PO Entry Maintenance PU13 o NOTIFY Name of the drop ship contact from PO Entry Maintenance PU13 o CONFIRMING ORDER Conf
74. ntenance CM52 he fields that appear in Customer Master Maintenance CM52 for EDI are EDI Invoic CMEDI This field accepts and or displays one of the following to indicate whether or not the system will create EDI invoices for this customer N default do not create EDI invoices for this customer Y create EDI invoices for this customer EDI customer orders can be received from any customer regardless of the value in this field EDI Acknowledgment EDIA This field accepts and or displays one of the following N default to not create EDI acknowledgements for this customer Y to create EDI acknowledgements for this customer EDI Advance ship notice EDIS This field accepts and or displays one of the following N default to not create EDI advance ship notices for this customer Y to create EDI advance ship notices for this customer NOTE The value in this field automatically changes to Y when you type the letter Y in the Advance Ship Notice Transmit field on the EDI parameter screen EDI Order status EDIU This field accepts and or displays one of the following N default to not update the EOI file for this customer Y to update the EOI file for this customer If the value in this field is the letter Y the system will update the EOI EDI Order Status Inquiry Link file for the customer when any of the following occurs o You change the order requ
75. nting a paper copy of the EDI acknowledgment the system updates the EDI Acknowledgment Link EKP file for each EDI acknowledgment The EKP fields are updated as follows EKDRC Record type EKORD Sales order number EKSUFX Sales order number suffix EKOTYP Sales order type cod EKREAS Credit reason description EKSTKY Ship to customer number EKBTKY Bill to customer number EKSNAM Sold to customer number EKSAD1 Sold to customer address line 1 EKSAD2 Sold to customer address line 2 EKSAD3 Sold to customer address line 3 EKSCTY Sold to customer address city EKSST Sold to customer state EKSZIP Sold to customer zip code EKBNAM Bill to customer number EKBAD1 Bill to customer address line 1 EKBAD2 Bill to customer address line 2 EKBAD3 Bill to customer address line 3 EKBCTY Bill to customer city EKBST Bill to customer state EKBZIP Bill to customer zip code EKNOTD Notice date EKNO Notice time EKSPO Ship to customer purchase order number Frontier User s Manual Electronic Data Interchange Version 2 1 EKBPO Bill to customer purchase order number EKINIT Picked bv EKDREC Order receipt date EKENTD Order entered dat EKACKD Acknowledgment print date EKSHPD Shipping date EKSHPP Shipper print date
76. om either the EDI Menu OEMENUE or the Purchase Order Parameter Menu POMENUD o EDISUM EDISUMD Access EDISUM from the EDI Menu OEMENUE Use this parameter to indicate whether or not ORD410 will print the EDI Summarv Report which totals the rejected accepted with no exceptions and accepted with non fatal errors orders sent via EDI Type the letter N to not print the report or Y to print the report NOTE For PowerBids EDI orders the report will include orders accepted with PowerBids codes 80 81 82 and 86 Page 4 Frontier User s Manual Electronic Data Interchange Version 2 1 EDI MENU OEMENUE The following chart brieflv describes th ach EDI Menu option Program Function EDI Select EDI documents EDICNTRL Update EDI control numbers EDIOUT Specify the EDI output queue EDISUM Indicate whether the EDI Summary will be printed CM52 Maintain customer masters NF 68 Maintain the note file OE35 Display and maintain the EOI file PODO10 Print EDI purchase orders ORD001 Print EDI acknowledoments INV001 Print EDI invoices EDI900 Purge selected EDI link files ORD400CE Edit incoming customer orders in the EDI customer files ORD400CU Add EDI customer orders to the system EDILINKXEF Update XEP XFP and XOP file records OE45 Maintain the order copy groups ORD450 Create a new sales order by copying an existing order for each customer in a copy group ORD870CE List the orders in the
77. on 2 1 XESPO Ship to purchase order number which is a required field XESTKV Customer ship to number There must be a corresponding header record in the XOP file for the ship to purchase order number customer ship to number combination XEITEM Item sequence number XEOQS Order quantitv in the XESUM unit of measure XESUM Defaults to the unit of measure in the parameter HFAPRC XEPROT Price lock flag which defaults from the header file price protect code XOPROT If a price is included in the detail file XEARTL field and the price protect value is Y the link file price is accepted If the link file contains a price and the price protect value is blank the price is changed to a price table price if one is available and the changed price is reported as a non fatal error If the price protect value is blank and the salesperson number XESLMI XESLM2 XESLM3 rate XESLP1 XESLP2 XESLP3 per code XEPER discount amount XEDSS discount percentage XEDSC1 XEDSC2 XEDSC3 price at quantity XEPRCQ commission XECOMR or net price flag XENETF contains a value the link file value is accepted and a message appears on the EDI Customer Order Accepted With Non Fatal Errors Report ORD410 If the price protect value is Y and one of the above fields contains a value the link file value is accepted and no message appears on the report XERQDT Date in the ISO fo
78. onic Data Interchange Version 2 1 EDI CUSTOMER ORDER UPDATE ORD400CU Description Use this program to update the order transaction files for EDI orders that do not have fatal errors This program will not update files for orders that have fatal errors If the parameter EDI contains the letter X in the hold field at the bottom of the screen then all customer orders will be updated with the hold code E Vou must manually release these orders in Order Hold Inquiry 0E50 before inventorv can be allocated This program prints the following reports EDI Link Error Report UPDATE ORD400 EDI Customer Order Accepted With Non Fatal Errors UPDATE ORD410 EDI Customer Order Not Accepted Report UPDATE ORD410 EDI Customer Order Accepted Report UPDATE ORD410 00 00 EDI Customer Order Edit ORD400CE and EDI Customer Order Update ORD400CU accept records from the EDI Customer Order Header Link XOP file and the EDI Customer Order Detail Link XEP file The fields in these files will default and validate the same way as the corresponding fields in Order Header Mainte nance 0E53 and Order Detail 0E54 with the following exceptions EDI Link Customer Order Header XOP file fields XOSPO The ship to purchase order number is a required field and together with XOSTKY is the key to the link file If there is a duplicate ship to purchase order number customer ship to number in the XOP file both orders
79. per code in Vendor Quote Maintenance QM11 is A price not known this field will contain the message TO ADVISE o INVENTORY UNIT OF MEASURE Inventory unit of measure from Product Master Maintenance PM70 o ACCOUNT NUMBER Account number from Inventory Segment Maintenance PM73 For subcontract purchase orders this field displays the WIP account number for the purchase order warehous o REVISION LEVEL Revision level if one exists for this purchase order o DRAWING NUMBER Drawing number if one exists for this purchase order o LINE CLOSED If the line item has been closed LINE CLOSED will appear after the account number o REQUISITION NUMBER If a requisition was converted into this purchase order this field contains that requisition number from PO Entry Maintenance PU13 o INSPECTION NOTES Inspection IP note for the inventory segment from Vendor Quote Maintenance QM11 If the inspection note referenced in QM11 has multiple lines in Note Type Maintenance NF68 all lines will appear o STANDARD INDUSTRY DESCRIPTION Standard industry description for the product warehouse from Vendor Quote Maintenance QM11 The program prints only those lines that are in effect and have been flagged to be printed Y in the PO flag field in QM11 The lines appear in sequence by the text type and sequence number Page 10 Frontier User s Manual Electronic Data Interchange Version
80. ransactions Inbound 869 Transactions The EDI Order Inquirv Link EOI file receives the 869 transaction records sent from the customer The svstem then allows vou to create maintain and or delete that customer s EOI file records automatically or manually Automatic Maintenance Use the EDI Ord sts flag field in Customer Master Maintenance CM52 to indi cate when the EOI EDI Order Inquiry Link file will be updated automatically for a customer If the value in this field is the letter Y updates occur under the following conditions o You change the order required date in Order Header Maintenance 0E53 for this customer s order The system adds the inquiry origin code 3 and the line status code RD to the file for the changed date o You delete a detail line from this customer s order in Rapid Order Entry Maintenance OE51 or Order Detail 0E54 The system adds the inquiry origin code 3 and the line status code IC to the file for the deleted item o You cancel this customer s order in Ship and Bill Maintenance 0E57 The system adds the inquiry origin code 3 and the line status code DE to the file for the cancelled order o You add or change the order promise date in Sales Order Promising 0E62 The system adds the inquiry origin code 3 and the line status code RD to the file for the item Manual Maintenance In addition you may use the on line program EDI Order Sta
81. rmat YYMMDD which defaults to the required date in the header record XORQDT XETEXT Comment text The detail record is considered a comment line if this field contains anything and product information is ignored XECPN Customer product number is 30 positions long However only the first 15 positions appear on the EDI Link Error Report XEWH If in different division from XOWH bill to customer must be in both divisions If the shipping warehouse field in the EDI Customer Order Detail Link XEP file is blank the svstem will perform order routing Orders For Configured Products Orders containing configured products including model sets will be handled the same wav as in Option Selection and Maintenance WS54 and Order Detail OE54 The job stream will update the Configuration CFP file and the order total dollars ODGRSS field and will add the OPTIONS BEGIN and OPTIONS END comment lines to the order Use parameter OPTEND to determine the number of lines Option Selection and Maintenance WS54 will add between the last line item on a configured sales order and the OPTIONS END line EDI Customer Order Update ORD400CU will print the adjusted model price model price plus dimensional prices plus matrix prices on the reports PCM Customer Product Maintenance WS85 is used to create and maintain the customer product number records in the PCM Customer Product Number ATP
82. rom EDI Link files and added to the EDI Return Link files Non fatal Error Fatal Error INVOICE TO 3 CONNERS INC 505 SIXTH AVENUE BUILDING 1105 ALGONQUIN IL BILL TO POt Ship to PO 54620E Invalid cash terms ITEM No PART No 1 00 DGKHF Insufficient stock 2 00 PIPE 1 3 00 PIPE 1 4 00 PIPE 1 Page 9 60035 XXX COMMENT WH 01 available 01 01 01 SHIP TO X CONNERS INC 505 SIXTH AVENUE BUILDING 1105 ALGONQUIN SHIP TO PO 54620E for custt 1 PART DESCRIPTION PIPE 1 PIPE AL PIPE 1 PIPE 1 IL 60035 DIV ORDER DATE REQ DATE 01 10 18 03 10 18 03 alreadv exists QUANTITY SUM PRICE 10 10 BX 100 00 10 BX 10 00 10 BX 100 00 10 18 03 00 00 00 Page EXTENDED PRICE 1000 00 100 00 1000 00 Program OORD410 INVOICE TO 2 STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60602 BILL TO POf ITEM No PART No COMMENT 1 00 PIPE 1 2 00 PIPE 2 3 00 PIPE 3 4 00 PIPE 4 Page 10 WH 01 01 01 01 EDI CUSTOMER ORDER ACCEPTED REPORT SHIP TO g STEVENSON PRODUCTS 123 FIRST STREET SUITE 204 CHICAGO IL 60602 SHIP TO POT DIV ORDER DATE REQ DATE 54640E 01 10 18 03 10 18 03 PART DESCRIPTION QUANTITY SUM PIPE 1 10 BX PIPE 2 10 BX PIPE 3 10 EA PIPE 4 10 EA EDIT PRICE 100 10 10 00 Date Time 10 18 03 00 00 00 Page EXTENDED PRICE 1000 192 100 100 00 00 0
83. sks to include all warehouses o output queue the default value is from the parameter OVRPRT which is maintained on the OVOES screen The system uses OVRPRT to determine the output queue to which invoices will be sent You may override the value in this field Press F3 to submit the request or press F12 to cancel the request When you press F3 if the value in the system parameter BATSBM is the letter Y then a confirmation window will appear Press F18 to submit the program or press F12 to cancel the request If the value in BATSBM is the letter N no window will appear Invoice Print amp Update INVOO1 Page 23 Frontier User s Electronic Data Version 2 1 Manual Interchange Description The Invoices job stream initiates Invoice Print amp Update INVOO1 which prints invoices for all orders that were shipped since the last invoice run The EDI Invoice Link EIP file will be updated for everv EDI invoice Printed invoices are sent to the output queue and librarv specified in the parameter EDIOUT Data Provided The information that appears on an invoice contains o INVOICE TO Number name and address of the invoice to customer from Customer Master Maintenance CM52 o SHIP TO Number name and address of the ship to customer from Customer Master Maintenance CM52 o INVOICE DATE w OM 5 H 8s Today s date NVOICE NUMBER When you exec
84. stomer Master Maintenance CM52 or Order Header Maintenance OE53 o DIV Division that will ship orders to the customer from Customer Master Maintenance CM52 or Order Header Maintenance OE53 o ORD System assigned order number from Order Header Maintenance 0E53 o SUF System assigned backorder suffix from one of the inventory allocation programs o OT Order type code from Order Header Maintenance 0E53 Valid codes are SI Ship Invoice IO Invoice Only CM Credit Memo SO Ship Only OT Quote RM RMA printed by RMA Forms Print RMAOO1 RMAOO1MR o ORD DTE Order date from Order Header Maintenance 0E53 o REQ DTE Required date from Order Header Maintenance 0E53 o S BR Shipping warehouse from Order Header Maintenance 0E53 o B BR Billing warehouse from Order Header Maintenance 0E53 o CARRIER Carrier that will ship the order from Customer Master Maintenance CM52 or Order Header Maintenance 0E53 o SHIPPING INSTRUCTIONS Description of the ship via code from Customer Master Maintenance CM52 o FRT TERM Freight terms code from Order Header Maintenance 0E53 o CR REG Credit region from Order Header Maintenance 0E53 o CTY CDE County code from Order Header Maintenance 0E53 o CTRV CDE Country code from Customer Master Maintenance CM52 or Order Header Maintenance OE53 Page 14 Frontier User s Manual Electronic Data Interchange Version
85. t number is found in the EDI Customer Order Detail Link XEP file then the configuration code from the ATP file for that product will be used to assign the options for that product Orders with invalid PCM customer product number effective dates will be rejected For each configured order the job stream will include the contents of the EDI PCM Option Link XFP file in the reports The EDI Link Error Report ORD400 will list EDI PCM orders which are unacceptable due to invalid product number or configuration option record errors Invalid product number errors include orders with an option record for a product that is not a configured product a config ured product with no option records and configured products with no line num bers Line numbers in the EDI PCM Option Link XFP and EDI Customer Order Detail XEP files must match If the line numbers do not match or if no line numbers exist then the order will be rejected with a critical error If the EDI PCM Option Link XFP file does not contain a selection for a particu lar valid option list the system will use the default option selection if one exists Such orders will be listed on the EDI Customer Order Accepted With Non Fatal Errors Report Non fatal errors will occur when the option price is not found and when the initial option list is not found NOTE Maintenance of the option description is not supported The EDI Customer Order
86. total of all items that do not have a product number excluding freight and tax from Invoice Print amp Update INVOO1 o FREIGHT The svstem totals and prints the freight charges from Invoice Print amp Update INVOO1 o TAX The svstem totals and prints the total amount of tax billed from Invoice Print amp Update INVOO1 o TOTAL Total amount billed from Invoice Print amp Update INVOO1 o COST Merchandise cost from the inventorv svstem o MARG The margin percentage is calculated as Page 29 Frontier User s Manual Electronic Data Interchange Version 2 1 Merchandise cost Cost Merchandise cost x 100 The system calculates and prints totals by customer by warehouse and by company Example For a sample register s Appendix 1 Page 30 Frontier User s Manual Electronic Data Interchange Version 2 1 PURGE EDI LINK FILES EDI900 Description Use this program to delete records from the following files EDI Invoice Link EIP EDI Acknowledgments EKP EDI Order Status Link EOS EDI Purchase Order Link EPP EDI Advance Ship Notice ESP 0 0 0 00 For each file listed you select whether to delete all the records in the file to delete only the acknowledged records or to not delete any records The program deletes the selected records and reorganizes the space in the files When you submit this job the system automatically will place the job on hold You must release
87. tus Maintenance 0E35 to add maintain or delete records from the EOI file You can display the file either in ascending ship to purchase order number sequence or in Page 53 Frontier User s Manual Electronic Data Interchange Version 2 1 ascending sales order number sequence beginning with a selected order number You then can maintain any field except the Inquirv Origin field However any data you input will not be validated by the system Outbound 870 Transactions The EDICNTRL parameter displays the control number range for outbound EDI records This parameter also holds the next control number to be used by the system The batch report EDI Order Status ORD870 can be run in edit ORD870E or update ORD870U mode The program reads the EOI file records creates the outbound 870 transactions places the 870 transactions in the EDI Order Status Link EOS file and in update mode only purges the records from the EOI file For each inbound detail with a line item 869 record the program cre ates a detail and a header 870 transaction record For each inbound header without a line item 869 the program creates a header 870 transaction EDI Order Status ORD870 generates a report which lists the EOS transactions The report also will include an error message for each order with errors each customer with no orders and each invalid customer number Once the EDI Order Status EOS file
88. use Invalid inventory segment for product and distribution warehouse Same manufacturing warehouse as for shipping Same distribution warehouse as shipping warehouse Cannot have distribution warehouse without manufacturing warehouse Same manufacturing warehouse as for distribution Invoice to customer number has been deleted Example For a sample EDI Link Error Report see Appendix 1 EDI Customer Order Accepted With Non Fatal Errors EDIT ORD410 Description This program reports customer orders that are acceptable but contain non fatal errors The system automatically changes a non fatal error field value to an acceptable value Other non fatal error messages describe a notable condition in the order This report prints a separate page for each order Data Provided The information provided about an order includes o INVOICE TO If the override field XOOVBW contains a character then th ntir override name and address must be entered in the link XOP file invoice to fields XOIVKY invoice to customer XOITNM customer name XOITA2 address XOITA3 address XOITA4 address XOITCT city XOITST state and XOITZP zip code If the override field is blank the invoice to number name and address are from Customer Master Maintenance CM52 o SHIP TO If the override field XOOVSW contains a character then th ntir override name and address must be entered in the link XOP
89. ustomer orders that are acceptable Thes orders contain no errors The svstem assigns a number to the order and displavs this number at the top of the page A separate page is printed for each order Order link header records were deleted from the EDI Customer Order Header XOP Link file and the order link detail records were deleted from the EDI Customer Order Detail Link XEP file These records were added to the transaction files OH 02 04 05 06 and BF Data Provided See EDI Customer Order Edit ORD400CE Example For a sample UPDATE report see Appendix 1 Page 46 Frontier User s Manual Electronic Data Interchange Version 2 1 LINK FILE MAINTENANCE EDILINKXEF Description Link File Maintenance EDILINKXEF provides direct access to a DFU used to enter and maintain the records in the EDI XEF logical file This fil e includes the following EDI phvsical files o XEP EDI Customer Order Detail Link File o XFP EDI PCM Options Link File o XOP EDI Customer Order Header Link File IMP ove ORTANT You will need to use the IBM command STRDFU to change the DFU to run r your data library To change the DFU On a command line type the command STRDFU and press ENTER to display the AS 400 Data File Utility DFU screen On the command line type option 3 Change a DFU program and press ENTER to display the list of parameters Press ENTER to record the para
90. ute this program the system assigns an invoice umber and prints the number on this report The system sequentially numbers l invoices starting with the value in the DAINV parameter For sales orders hat have a zero value and zero shipped quantity the invoice number will be o BL WH Billing warehouse from Order Header Maintenance 0E53 o SH WH Shipping warehouse from Order Header Maintenance OE53 o CUST TYPE Customer type code from Customer Master Maintenance CM52 o TAX In a sales tax environment the tax group is from Order Header Mainte nance OE53 flag In a VAT environment the value in this field is the tax exempt o CUST PO Customer purchase order number from the Sold to PO field in Order Header Maintenance OE53 o DROP SHIP PO Drop ship purchase order number if applicable from the Ship to PO field in Order Header Maintenance 0E53 o ORDER System assigned order number from Order Header Maintenance 0E53 o SLSP Salesperson code from Order Header Maintenance 0E53 o FRT Freight charges code from Ship and Bill Maintenance 0E57 o SHIPPING INSTRUCTIONS Description of the ship via code from Customer Master Maintenance CM52 or Order Header Maintenance OE53 o CUSTOMER TERMS Cash payment terms code from Customer Master Maintenance CM52 or Order Detail OE54 Page 24 Frontier User s Manual Electronic Data Interchan
91. will be rejected and will be listed on the EDI Link Error Report ORD400 If there is a duplicate ship to purchase order number customer ship to number combination in the order entry transaction database OH file the order will be accepted and will be listed in the EDI Customer Order Accepted With Non Fatal Errors Report ORD410 XOSTKY Customer ship to number which is a required field XOITEM Item sequence number XOOTYP Order type which defaults to SI if blank Valid values are IO CM QT RM and SI SO is not a valid order type XOORDT Order date in ISO format YYMMDD Defaults to current date XORQDT Required date in ISO format YYMMDD Defaults to current date XOERS ERS Evaluated Receipt Settlement code used to suppress invoice printing Order header note number five will contain ERS followed by the value in XOERS Any value in order header note number five will be overwritten with the ERS code XOWH Warehouse must be in the division XODIV XODIV Division is a required field EDI Link Customer Order Detail XEP file fields XEPN If the original product has been deleted from the svstem the substitute product if one is designated in the product master will be used in the line item If no substitute was designated the order will be listed on the EDI Customer Order Not Accepted report Page 42 Frontier User s Manual Electronic Data Interchange Versi

Friedman EDI Users Manual 2.1

Contents

Download Pdf Manuals

Related Search

Related Contents