Accounts Payable: Custom Reports Available
| File Name | Description | Select | Input | Output |
| Apcus01 | Unpaid invoicesall invoices,all paid bycheck #, manually select |
Checking acct code, include manual checks,beginning due date, ending due date,warrant number |
Vendor, invoice #,purchase amt, disc,paid amt, check #,check date |
|
| Apcus02 | Same as 01, except added option of running manual check register |
Vendor, invoice date,account, amount, check # and date |
||
| Apcus03 | Same as 02, except can specifysingle or all funds. |
Vendor, invoice date,account, amount,check # and date |
||
| Apcus04 | Assign claim numbers to each invoice orprint abstract, assumes a voucher number is assigned |
Abstract: voucher range, paid unpaid or both, order by account claim or vendor |
Vendor, vendor address,claim number,account,amount and check number | |
| Apcus05 | Invidual or all vendors |
Beginning check date and ending check date | Vendor code, vendor name,invoice date, amount, amount paid, check number and date | |
| Apcus06 | Invoice Edit List | Invoices not posted to GL or all unpaid invoices, all or individual checking accounts | Start due date, end due date, vendor or company name order | Vendor, due date, checking account, account number, invoice amount and description |
| Apcus07 | Check register report | Single or all checking account codes, individual or all vendors | Starting and ending date | Vendor number,vendor name, invoice date, invoice number, check amount, check number and date and memo/description |
| Apcus08 | Check warrant report | Checking account code,include manual checks | Beginning check number, ending check number and warrant report number | Check number, vendor/company,invoice description, check date, amount paid and account number |
| Apcus09 | Check warrant report | Check date | Check number, date, vendor, invoice number, paid amount, signature area | |
| Apcus10 | Check warrant report-groups by general ledger account number | Unpaid invoices, all invoices, all paid invoices by check number, manually select invoices or manual check register | Checking account code,include manual checks, beginning check number, ending check number,beginning due date, ending due date and warrant report number. | Vendor, invoice number, purchase amount, discount amount, paid amount and reference account |
Apcus11
Apcus11a |
Special Ed cost accounting, uses voucher number field to report special ed expenses
7 Character filter and date and paid range Student ID placed in voucher field |
Disability code range, check date range, include participant details, account detail, invoice detail
|
Account, description, vendor name, check date and amount paid
|
|
| Apcus12 | Single line vendor report | All , individual or selected vendors | Order by vendor number or company name | Vendor number, vendor address, city, state and zip |
| Apcus13 | Invoice edit list | Invoices not posted t o general ledger or all unpaid invoices | Individual or all checking accounts, start due date, end due date | Vendor code, vendor name, description, account number and invoice amount |
| Apcus14 | Vendor file report | All, individual or selected vendors | Vendor number or company name order | Vendor name, company name, contact, address, city, state, zip and phone number |
| Apcus15 | Check register by general ledger department or range of departments | Due date or check number, checking account code | Include manual checks, beginning check number, ending check number, fund range or department range | Check number, check date, vendor, po number, invoice number and account number |
| Apcus17 | Check register | Due date or check number | Checking account code, include manual checks, beginning check number, ending check number | Check number, check date, vendor, po number, invoice number, account number, po amount and check amount |
| Apcus18 | Check register-requires NJ school account number | Checking account code | Include manual checks, beginning check number, ending check number | Check number, check date, vendor, invoice number, account number,amount paid and po number |
| Apcus19 | Check register paid from each checking account and general ledger number to debit | Individual or all vendors, beginning check date, ending check date | Vendor, company name, invoice date,invoice description, account number, amount paid, check number and check date | |
| Apcus21 | Employee course reimbursement | Assumes voucher field filled with 'CR' | Invoice date range | Vendor number, payee name, memo and amount |
| Apcus2/2 | Custom folder labels | Labels as entered, label for one vendor, selected vendor label, label for all vendors or label for label code | Vendor ID, company name and fiscal year | |
| Apcus23 | Vendor activity report |
Individual or all vendors, beginning invoice date, ending invoice date | PO #, vendor number, vendor name, invoice description, budget account, invoice #, check #, amount and outstanding | |
| Apcus24 | Invoice report by fund and department | Due date or check number, checking account code, date or check number range, sort and subtotal by vendor,fund and department range | Due date, vendor code, company name, po number, invoice number, account number, po amount and invoice amount | |
| Apcus25 | Numeric payments list | Beginning check date, ending check date, order by account or vendor | Vendor, company name, invoice, account, description, amount, check number and date paid | |
| Apcus26 | Account number report | Beginning check date, ending check date, account number | Vendor code, company name, invoice number, account, description, amount, check number and date paid | |
| Apcus27 | Warrant/invoice report | Warrant report number, due date or check number, checking account code, date or check range, edit authorization section | Vendor number, po#, invoice #, invoice description, account number, account description, po amount, invoice amount, check #
|
|
| Apcus28 | Monthly claims report by fund | Paid or unpaid invoices,check date range(if paid) | Vendor, description, amount. Subtotals by each fund and totals all funds | |
| Apcus29 | Purchase journal by account number | Posted ro current balance,status(open, partial, closed, all), include po's(current, last or next year), starting order date, ending order date | Account #, account description, company name, po# po date, status and posted amount | |
| Apcus30 | MA sites-due date edit tool | Individual or all vendors, edit screen pops up, edit due date, company and invoice number | ||
| Apcus31 | Check warrant by fund | Unpaid invoices, all invoices, all paid invoices by check number,manually select invoices or manual check register | Checking account code,include manual checks,beginning due date, ending due date, check warrant number | Vendor, invoice date, account, amount, check number and check date |
| Apcus32 | Purchase order journal | Sort by vendor name or po #, starting order date, ending order date | Po #, po date, vendor number, vendor name, po amount |
|
| Apcus33 | File folder labels | Labels as entered, labels for one vendor, selected vendor labels, labels for all vendors or labels for label code | Vendor code,company name, fiscal year | |
| Apcus34 | Check warrant report | All invoices, all invoices by check number, manually selected invoices,manual checks | Checking account code, include manual checks, beginning due date, ending due date, warrant number | Vendor number,invoice date, account number, amount, check number and check date |
| Apcus35 | General ledger distribution report | Unpaid invoices,paid invoices or AP as of date | Individual, range or all batches,account number or batch number order | Account number, vendor number,vendor name, description, po number, invoice number, invoice date, amount and batch number |
| Apcus36 | Purchase order distribution report-by fund | Unreceived,received/no invoice or both | Account number,vendor name, description, po number, item description extended amount |
|
| Apcus37 | Paid to vendors by account for check dates | Account number, starting check date, ending check date | Account number, vendor number, vendor name, po number,check number, check date and amount | |
| Apcus38 | Invoice edit list | Invoices not poste to general ledger or all unpaid invoices | Individual or all checking accounts, start due date, end due date, order by vendor number or company | Vendor code, vendor name, invoice number, po number, invoice amount, invoice date, disencumber amount, due date, checking account, discount amount |
| Apcus39 | Check warrant account status report | Unpaid invoices by date range, all invoices in date rante, paid invoices by check number | Checking account code, include manual /direct pays, earliest due date,latest due date | Account number, vendor number,company name, description, current budget, year to date reamining |
| Apcus40 | Check warrant | Unpaid invoices, all paid invoices by check number,manually select invoices, manual / direct pay register | Checking account code, include manual/ direct pays, beginning due date, ending due date,warrant report number,include invoice memos, order by vendor number or company code | Vendor, invoice number, purchase amount, discount amount,paid amount, check number and check date |
| Apcus41 | Check summary report | Beginning check date, ending check date | Vendor number, company name, paid amount, 1099 amount | |
| Apcus42 | Warrant report | Unpaid invoices, all paid invoices by check number,manually select invoices, manual / direct pay register | Checking account code, include manual/direct pays, beginning due date,ending due date,warrant report, include invoice memos, order by vendor number or company name, edit authorization section | Vendor, invoice number, purchase amount, discount amount,paid amount,check number, check date, warrant authorization for signatures |
| Apcus43 | General ledger reference report | Starting check date, ending check date, account number selection(you may enter multiple accounts) | Account number, vendor number, check number, check date, invoice number, invoice date and amount | |
| Apcus44 | Review statement from vendor | Vendor code and invoice number | Display of invoice information fot that vendor to verify statement from vendor |
