Internal only not customer facing
The PO Interface program allows you to load PO's from a batch file. This allows for interface of PO's from non-atrieveERP systems. The interface only supports Summary PO's to a maximum of 19 GL account charges without POM and 99 with POM. The program does not support calculation of GST in the load process. It expects that the interface data file contains any GST amounts as part of the PO estimate and distributions. GST can be processed in invoice entry against these PO's.
Enter P/O Interface Filename
-
Enter the VMS file name containing your PO transactions. The filename can be any valid VMS filename and directory name or logical to a maximum of 20 characters. The file name is not checked for validity until processing begins. The file must be a variable length with a record length of 80.
Enter Accounting Period
-
Enter the accounting period where these transactions are to be recorded. The program does not verify the period against the atrieveFinance calendar. You are responsible to make sure the period is open for processing and is the correct period.
Enter Batch Type to Interface
-
Enter the 3 character atrieveFinance batch type code to use for this interface. The code is not verified until processing begins. If invalid, the process is aborted.
Interface File Description
-
Transaction code 'A' for add PO must be the first transaction in the file and must be in position one (1) of the transaction line.
Field number and field data separated with a comma must be on the following lines in the file
(e.g.: field number, field data - 03,924384 - 010100441511,279.35).
The first group of entries must contain the PO header information. This is terminated by a transaction code '99'. The second group is the GL account numbers and amounts. These are also terminated by a transaction code '99'. The sequence alternates between header and distributions until all transactions are complete.
The following are the PO header fields supported.
03 or 3 for the PO number. Maximum 10 alpha numeric characters no duplicates.
01 or 1 for the vendor number. It must be valid in the vendor file. Maximum 10 alphanumeric characters.
04 or 4 for the requisition number. Max of 10 characters alphanumeric.
08 or 8 for PO estimate. It can contain a decimal point and numeric digits. No other characters are allowed.
The GL account numbers followed by the amount are the only items in the distribution portion of the file. The amount must contain the same characters as the estimate above.
The transaction file is terminated with a code of 'EX'.