Convert Set from Non-Comp - APOHUTCB
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.