NCFS Pre-Built Reports

NC Print cycle count listing report generates a list of items that will be physically counted in the given warehouse as part of scheduled cycle counting.

DAC Food-Warehouses Issues & Returns Report shows either items issued (NC Direct Issue and NC Deduct Inventory Adjustment) or returned (NC Direct Return and NC Add Inventory Adjustment) data for the date range and warehouse(s) parameters selected.

DAC Produce-Warehouse Issues & Returns Report shows either items issued (NC Direct Issue and NC Deduct Inventory Adjustment) or returned (NC Direct Receipt and NC Add Inventory Adjustment) data for the date range parameters selected.

Pre-pick Item Availability Report displays items by Inventory Org, Preferred Stock Location and Transfer Order line details to assist with preparing to pick orders to ship out.

NC Expense Transactions and Exceptions Report assists Inventory Agencies Accounting Divisions with reconciling accounting segment data keyed during Inventory Transactions.

Warehouse and Ship to Location Report displays Inventory Organization and Ship to Locations and addresses for each facility.

NC INV Inventory Item Details Report displays inventory item details such as item attributes, category codes, accounting segment mapping, etc...

Warehouse Picking Document Report displays Transfer Orders/SSP Orders by item and Preferred Stock Location. This assists the warehouse with picking the same item for multiple orders from one location in the warehouse.

NC SSP Open Orders Report lists Internal Requisitions by Customers that are not yet fully shipped and Backorder details. Requester (User) will be able to view the SSP Open Orders Report for the Inventory Organization(s) and Backorder details based on the delivery to location selected.

A BIP report will be created as part of this specification to deliver information concerning all sub-inventory items related to inventory. This report aims to assist agencies in identifying sub-inventory items and transaction defaults. It will include most of the columns found in the Manage Sub inventory and Locators, as well as the Manage Item Transaction Defaults Area.

The RPT-OTC-004 Transactions Details Report will be run by the AR Manager to aid in reconciliation. It will list all applicable transactions based on the selected parameters at the transaction line level, showing all applicable related transaction details, including the total transaction amount, individual line amounts, Transaction Date, Due Date, Transaction Status, Billable Flag, Receivables Distribution Account, and Revenue Distribution Account. For Posted transactions, the Receivables and Revenue Distribution Accounts will get derived from the Accrual Ledger after the Create Accounting program has completed.

The RPT-OTC-007 Daily AR Receipt Activity by Budget Code will be run by the AR Manager or Receipt Management user to aid in reconciliation. It will list all applicable receipts based on the selected parameters, showing all applicable related receipt details, including the total receipt amount, applied Transaction number (if applicable), and Customer Account.

The RPT-OTC-011 AR Aging Report by Invoices will be run by AR Managers and Collections Managers to aid in the collections process. It will list all applicable outstanding Invoices based on the selected parameters, showing all applicable related transaction details, including the total transaction amount, total outstanding amount, specific aging bucket based on 7-bucket aging, Invoice write-off status, and the Receivables Distribution Account. The report can be run two different ways, one where it is Grouped by Customer, and another where it is grouped by Receivables Distribution Account.

The RPT-OTC-012 DPI Allotment Report will be run by the AR Manager to aid in month-end activities. It will list all applicable invoices and credit memos completed using both state allotment and local funds based on the selected parameters, showing all applicable related transaction details down to the line level, including the total transaction amount, individual line amount, applied Transaction number (if applicable for Credit Memos), Customer Account, Distribution Details, Allotment Account, and Subtotals by Invoice, Customer, and Allotment Account.

This report captures Open Purchase Orders with remaining obligations at the PO distribution level.

PO Receipt Details Report will be developed to report PO receipts daily & monthly which are entered in the system.

The Supplier Dashboard provides information regarding Supplier, Sites & Contacts in the system to facilitate an ability to track and report on the list of master supplier data so that Business User can manage the process. This dashboard shows suppliers on hold, suppliers set up EPay, and suppliers with 3rd Party/Factor relationships.

This report captures PO lines counts by COA as a basis for agencies to complete cost allocations.

This report is specific to DAC and tracks PO purchases for Bread and Diary.

This report is specific to DAC and tracks receipts again purchase orders for Bread and Diary.

The Available Funds Report would provide details of expense for specific budget fund—Agency Management Unit—Agency Program—Project combination. The budget also would be captured for same combination in Budgetary Control menu. This report can be run at any date and the expenses would be captured till date along with budget amounts. The summary levels will be based on the control budget used by the agency for funds checking.

This report is designed to provide a Life-To-Date view of projects tracked using the Project Segment of the Chart of Accounts.

This report displays the debits, credits, beginning, and ending balances for liability accounts based on parameters selected as specified in section 2.3.

This report lists the debits, credits, beginning, and ending account balances for accrual balances based on parameters selected in section 2.3.

Detailed balances by bank ID Report lists the GL transactional balances, period debits, period credits, Journal batch name, Journal name, Journal category, Journal Source and other details for selected Agency, Budget code, and Accounting Period by bank account number.