Interfacing EDI Invoices

Vendor invoices sent using Electronic Data Interchange (EDI) can be loaded into the Invoice Matching application. Invoice detail is created if the detail is provided by the EDI interface information. This procedure outlines the process for creating match, AP detail, and PO Service Only invoices from vendor invoices sent using EDI. See the Invoice Matching File Layouts for more information on using Invoice Interface (MA540).

With Match Add-On Cost, the add-on charge details are included in the interface.

To interface EDI invoices

  1. Access Invoice Interface (MA540).
  2. Select job parameters.
    1. On the Main tab, specify this information:
      Run Group

      Specify a run group if you are rerunning this program after you have fixed interface errors in Invoice (MA54.1).

      Leave this field blank if you specify a company. You can run or rerun this program using the Run Group field or the Company field, but not both.

      Company

      Select your Invoice Matching company. Leave this field blank if you enter a run group.

      Vendor

      Specify the vendor identification code to interface only the invoices for a specific vendor.

      Leave this field blank if you want to interface invoices for all vendors for the selected company.

      Batch

      Specify the batch number to only interface invoices for a specific batch number.

      Invoice Process

      Select Add to load the invoices into the application. Matching is a separate process if you select Add. Match invoices are created unreleased. Expense invoices can be released and scheduled for payment automatically if the EDI auto release. Some expense invoices might be created as unreleased due to exceptions on the invoice, such as out of balance conditions.

      Select Add and Match to load and match the invoices in one process. The application will load the invoice and then match the invoice using the rule group selected in the Match Table Rule field. If the match is successful, the invoice status is updated to released.

      Authority Code

      A user-defined code representing a person or department responsible for approving a registered invoice.

      On database input, the authority code is only used as a filter. On CSV input, the authority code is used as a default parameter.

      Match Table Rule

      Select the rule group to use if Add and Match is selected in the Invoice Process field.

      Processing Option

      Select the kind of input file, either a .csv or database file.

      Update

      Select No if you want to check for errors in the input file and produce a report.

      Select Yes if you want to load invoices into the application.

      Tax Exempt

      Select whether to set all invoices to tax exempt.

      If set to Y, system defaults Tax Indicator to E - Exempt for all Expense invoices or Tax Exempt flag is set to Y - Yes for all Match Invoices which brings all invoices to be tax exempted.

      It prevents the tax calls and calculation and overrides any set up on the interface files. This is applied to all the invoices in the batch.

      The default value is blank - No, which follows the standard functionality.

      Default CSV Process Level

      Specify or select a default process level for interfacing the invoice records. The process level will default to all invoices interfaced. Through the Process Level default accounts and codes are defaulted to the invoice.

      Default CSV Authority Code

      A user-defined code representing a person or department responsible for approving a registered invoice.

      The authority code will be assigned to accounts payable invoices if Invoice Approval is set to Yes in Company (AP00.4).

      On database input, the authority code is only used as a filter.

      List Comment Conversion Data

      Select whether to print conversion comments.

      Comment Sequence Break

      Select whether to page break for each comments.

    2. On the Options tab, specify this information:
      Delete CSV File

      Decide whether to delete the CSV file after the program has been run.

      Filename

      Specify the file name of the file to be imported. The file must be located in the following:

      $LAWDIR/ productline /edi/in (for UNIX)

      %LAWDIR%\ productline \edi\in (for Windows)

      LAWDIR/productline /edi/in (for IBM i)

      Validate Vendor Item

      Select Yes to validate a vendor item or Lawson item, and whether to use the item in the search for a missing PO line number.

      Print Imported Records

      Select whether to create a print file that lists all the invoices that have been interfaced.

      Include Invoices In Error

      You can select whether to interface invoices that have errors.

      We recommend that you only use this option when there are a small number of invoices with a simple error. For example, if you interface a small number of invoices without establishing a handling code in the Invoice Matching application, the invoices will have a simple error. If there are a large number, fix the file and you will not have to release them using Invoice (MA54.1).

      Enable GLN Processing

      Select Yes to convert GLNs to Lawson identifiers. Only allowed when processing CSV or EDI files.

      Enable GTIN Processing

      Select Yes to convert GTINs to Lawson identifiers. This is only allowed when processing CSV or EDI files. Defaults to N.

  3. Add the job.
  4. Submit the job. This program creates three output reports:
    • Fatal EDI Invoice Errors Report listing invoices that could not be loaded due to severe data problem.

    • Released Audit Report listing all of the released invoices that were loaded.

    • Unreleased Audit Report listing all of the unreleased invoices that were loaded.

Follow-up Tasks for Interfacing Invoices

To Use
Display invoices with errors Invoice Errors (MA54.8)
Maintain invoice information in the invoice conversion file Invoice (MA54.1)
Maintain distribution information in the invoice conversion file Distribution (MA54.2)
Maintain line detail information in the invoice conversion file Invoice Line Detail (MA54.3)
Interface corrected invoices Invoice Interface (MA540)