|
IntroductionThis 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:
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. |