Interface programs

General Ledger Interface (IC130)

Interfaces transactions processed in the Inventory Control, Purchase Order, Requisitions, and Warehouse applications to the general ledger.

Item Master Interface (IC525, IC526, IC527)

Run Item Master Interface programs (IC525, IC526, IC527) to extract Item Master data to create an export file.

The IC525 file is used to interface ESI (Enterprise Systems Incorporated).

The IC526 file is used to interface with McKesson.

The IC527 file is used to interface with DeRoyal.

Received, Not Invoiced Report (PO135)

Interfaces transactions to the general ledger for non-inventory purchase order receipts and adjustments. This program is an as-of or estimate program which records your liability for the period. This program creates auto reversal transactions.

Matched, Not Received (PO136)

Interfaces approved invoices for goods that have not been received. This can happen for two reasons: 1) the approval was entered in the AP20 invoice forms and released prior to a receipt. 2) a receiving adjustment causes the received quantity to be less than the approved quantity on an invoice.

Standard Cost Calculation (PO139)

Standard Cost Calculation (PO139) calculates and creates a reversing journal entry for the difference between purchase order and standard cost for purchase order lines with a matched not received (MNR) or received not invoiced (RNI) quantity that is greater than zero. Standard cost companies are the only type of company that can run PO139.

Open Receipt Archive (MA180)

Interfaces write off and archived receipt transactions to the general ledger. Write off receipts are still available in the match process. Archived receipts are no longer available in the match process.

Payment Closing (AP170)

Completes a cash payment cycle for a pay group. Once you close the cash payment cycle, you cannot reprint bad payment forms or recreate a payment tape or electronic payment file. Creates and interfaces transactions to the general ledger for cash, discount, reportable income withholding, currency gain and loss, and payment accrual transactions.

Invoice Distribution Closing (AP175)

Interfaces transactions for released invoice distributions to the general ledger. You must run AP175 at least once in an accounting period. You can run it any time after you release an invoice.

Match Discount Accrual (AP176)

Interfaces accrued payment that were created during the match process. You must run this program at least once per accounting period, but you can run it as often as you need. It is recommended that you run this program at the same time you run Invoice Distribution Posting (AP175). This program debits the AP Liability account using the accrual code on the invoice and credits the Discount Accrual account defined on the Invoice Matching company.

Invoice Reinstatement (AP190)

Reinstates invoices associated with payments voided in the Cash Management application. Depending on the reason for voiding the payment, you can reschedule, maintain, or cancel a reinstated invoice. Creates and interfaces transactions to General Ledger for cash, discount, reportable income withholding, currency gain and loss, and payment accrual transactions.

Unrealized Gain or Loss (AP191)

For companies that pay non-base currency invoices this program is used to calculate, create, and interface unrealized gain and loss transactions, for released invoices.

Company Expense Posting (EE175)

Interfaces released company-paid expense distributions to the General Ledger application. You must run EE175 at least once in an accounting period, but you can run this report anytime after you release an expense.