The utility loads data from a .csv file into an OH set. Add at least one row of required data, save data in a .CSV format, then load into BusinessPlus via this utility.
Please enter the name for your new AP Set: Enter the file name to be created. Upon successful completion of the job, the set will be found within the AP Create/Update OH Set (APOHBTUB) page. Then the data can be proofed and distributed as a typical OH payable routine.
Name of the Flat File: Click on the ellipsis, browse and select the file to be uploaded.
Upload File Specifics
|
PEID |
Database code of PEID default = P |
PEID address code |
Invoice # |
Invoice Date |
AP Division code |
GL ledger code - default = User GL Code |
Orgkey |
Object Code |
JL code - default = User JL Code |
JL Orgkey |
JL Object Code |
FQA Account Number - can be used to obtain Key / Object |
Work order # |
Secondary Reference |
Quantity being paid (5 dec) default = 1 |
unit price being paid (5 dec) |
Discount % (4 dec) |
Discount amount (2 dec) |
Discount taken (3 dec) |
Discount date |
Tax code 1 |
Tax amount 1 (2 dec) |
Tax code 2 |
Tax amount 2 (2 dec) |
Charge (freight) code |
Charge (freight) amount (2 dec) |
Duty code |
Duty amount (2 dec) |
Description of payment |
Misc code |
Relate code 1 (1099) |
Relate code 2 (1099 or AR) |
Date payment due |
Received Date |
GL description format - DX, IB, IN, NB, NI, NM |
Initial payment type default = DS |
Product ID |
Unit of measure |
PO partial pay flag P or F |
PO # |
PR & item # |
Check stock ID |
Check # |
Date check was printed |
Separate check flag |
Refund type |
Account # with vendor |
Bid # |
Contract # |
Alternate PE ID (1099) default = Primary PE ID |
Alternate PEDB Code (1099) - default = P |
Alternate Address Code (1099) - default = Primary Addr Code |
Asset ID |
Security code |
PO type |
Type of payment |
Claim # |
Type of check |
Warehouse ID |
Catalog Number |
PO Item Quantity (3 dec) |
PO Receiving Quantity (3 dec) |
Identifies type of file |
Identifies type of batch |
|
|
-
Required fields are highlighted in RED.
-
Dates are in the format of mm/dd/ccyy.
-
Save file in format CSV (comma-delimited) for input.