Import A/P Invoices

Introduction

This utility will create A/P invoices for each line in the defined import file and will update properly all A/P records associated with this invoice, including the G/L postings. NOTE: the file name _CANNOT_ have spaces in it (replace any spaces with underscores, e.g. 'My File.txt' should be 'My_File.txt' or 'MyFile.txt'.

At this time, the following columns must contain the defined data:

  1. Vendor No.
  2. Client No.
  3. Bank Acct No.
  4. Invoice date
  5. Invoice due date
  6. Invoice description
  7. Invoice amount (must be currency format, e.g. $64, $64.0, or $64.00)
  8. Invoice G/L account#s (MVA)
  9. Invoice G/L amounts (MVA)

If the invoice date column is left blank then the current date, or the last date of the current A/P financial period will be used (but you still need a column 4). If the amount isn't valid the line is skipped. If the G/L acct# isn't valid the line will be skipped. If the amount to allocate to the G/L acct# isn't valid the line will be skipped. MAKE SURE the data is valid first.

   Syntax:
      APINV.IMPORT NameOfFile {(options}

      * Options:
         B - ta[B] delimited file to import
         C - [C]omma-separated value (.csv) file to import (default)
         E - [E]FTFILE is the directory where import file is located
         F - [F]TPFILE is the directory where import file is located (default)
         M - Override EO[M] processing flag (that restricts invoice creation)
         Sn- [S]tart processing on row {n} (defaults to 1).  You can only start on
             lines 1 - 9 ('n' is limited to a single digit).

      Example: APINV.IMPORT ImportFile.csv

This will import data to create new A/P invoices for each line in the '.csv' file 'ImportFile.csv' located in the FTPFILE directory. If the name of the file is omitted then the file name 'CreateApInvoices.csv' is assumed.

Copyright © 1985-2024 - Advantos Systems, Inc. - All rights reserved.