Welcome to JRI's Help page for Avante

This page contains notes specific to Avante processes, files, and anything else that might be userful that is specific to Avante. Some of these things are from Epicor, some are written in-house, while others may just be notes and pointers.

  • Processes
      Process Description
      SYSS9002.1 E-mailer (MODE 5 specifically)
      SYS3005
      SYS9040      		 Control Tables
      SYS3002 Dict maint/display
      Enter file name,
      Press F6 for a list of fields,
      Scroll to a field in question, then hit F8 for details.
      SOP9182 Determine why a part is/is not in DaytonAccess or StoreFront
      SYSS9091 NOTIFY setup by user
      MIS9000 Find next seq for a 3-letter prefix
      SYS3058 Add process to bucket
      SEC.USER.SETUP User security/setup
      PCM8200 Circular reference
      SYS9009 Zip code table
      INV2007 INV Trail
      PCM2001 Disp Cost Tbl
      GLM2001 GL Display
      INB9394 Part miss-match cat & class
      UTL3001 Create file
  • Major File Names
      File Description
      SOHDR Sales Order Header file
      ID = ORDER#
      SOXRF Sales Order Header/Detail Xref
      ID = ORDER#
            F1=lines for SODET & SOXRF
      ID = ORDER# * Line#
            F1=delivery #s for SODEL
      SODET Sales Order Detail
      ID = Order# * Line#
            F20 = Shipment#
      SHIPTRN Sales Order Shipments
      ID = Order# * Shipment#
      SODEL Sales Order Line Delivery
      ID = Order# * Line# * Delivery#
            F28 = Ship-to seq#
      SOSHIPTO Sales Order Ship-To
      ID = Order# * Ship-to Seq#
  • Seq File

      When SYS9002.1 sets up a sequencial file, it builds it at:
          /usr/igi/avante94/flodata/dldata
      with a name of:
          TEMP.port#

  • Zip/Postal Codes

      Originally, Epicor's core software was written to tap into a third party package from Vertex that validates the City, State, Zip, Country (and optionally county). Unfortunately, Epicor uses this package in a way that is not exactly the way it was intended to be used. Vertex is a tax tracking package. Any address (CSZ) that is enterred in Avante is bounced against the Vertex data. Vertex will return a successful hit, multiple hits, or no hits. Usually, this is not a big deal in Avante - for multiple or no hits, the user gets an appropriate error message and can adjust accordingly.

      However, occationally there will be an address enterred that is not in a taxable jurisdiction. Since Vertex only tracks taxable info, this valid address will fail Vertex's test. This is rare, but it does occationally happen.

      This logic has a fatal flaw when dealing with Storefront. When the user enters an on-line sales order and submits it to Avante, the user has surrendered control to the web server. If Avante/Vertex determines that the CSZ has multiple or no hits, Avante pops up the on-the-fly screen for the user to fix the address. However, a Storefront user will never see this screen - all they see is teheir web browser. Eventually, Avante will return a fatal error because there is not a valid address. This causes a nasty, meaningless message to appear in the user's browser.

      To deal with this, several changes were made.

      • The Avante program that does this test, TAXS0030.1 has been alterred. If Vertex returns no hits, the logic will do a 2nd test. If the customer is non-taxable, a new test will be made against the new file, ZIPXRF. If this test passes, the address is valid (a non-taxable juristication), and Avante will continue.
      • In Storefront, when the user enters the order, it will do a pre-test against the ZIPXRF file. If it fails, it will notify the user right away, and they will need to re-enter the data. If it passes the test in Storefront, it will be safe to file to Avante because it runs the same code and will pass the test there.

      The ZIPXRF file is a new file that must be manually re-populated each month. This file contains every valid USA Zip Code and Canadian Postal Code. This information is downloaded from Zip-Codes.com who in turn get their information from the US and Canadian Postal Services. These 2 downloads must be done each month and then loaded into the ZIPXRF file from Avante from TCL via SYSS9054.1.

      The downloads may be performed as oftne as desired for a year (it requires an annual fee). To download the data, log in using the following:
      Login: Schrorj (this is Rodney's original login)
      Password: idontcare
      Be sure to download the .csv version. Put this in the DLDATA file/dir, then run SYSS9054.1.

  • Fix Stuck User Screen

      Sometimes, a user gets stuck in a user screen. Larry has a beta program to fix this.
      RUN DSC.IIUTIL FIX.USERDATA.INDEX