NC Asset Transfer by Agencies Report generates the list of assets by Asset book that were transferred (assigned/reassigned to employee, transferred to different location, change in depreciation expense account) within the asset book. The report can be scheduled daily or for specific date range.
NC Asset Transfers by Agencies Report generates the list of assets that were retired by Asset Book. The report can be scheduled daily or for specific date range.
Special Purpose Budget Report (DAPG26) generates a view of financial information for data as of a specific month for which the report is run. It will provide expense and revenue data grouped, sorted, and summed at various levels all based upon NCFS chart of account values.
Life to Date Federal Budget Code Report (BD701-F) will be developed to generate a view of financial information for data as of a specific month for which the report is run. It will give the total grant life-to-date information monthly.
GL Project Summary report generates a view of financial information for each project for which the report is run. It will give the chart of accounts details and the expense details monthly/quarterly/yearly.
Federal Grant 488/588 Transfer Account Reconciliation Report generates a view of financial information for specific account(s) for which the report is run. It will give the chart of account details monthly.
Grants Drawdown Report generates a view of expense transactions information for a specific date range that the report is run for. It will provide expense information that is sourced from the General Ledger.
LTD Budget to Actual Dashboard for LTD Budget Consumption is a budgetary dashboard that shows LTD budgets by budget code and fund levels. It also shows revenues, expenditures, obligations, unpaid invoices, inventory receipts as well as unused fund to track budget to actual performance on a periodic basis. The dashboard will also include a few charts/graphs to give users a visual snapshot of their LTD budget status.
Federal Check Clearance Pattern report identifies invoices paid through checks for federal programs (CFDA). The report will provide all necessary information related to these invoices, and the payment details. It will also calculate the number of interest days – a difference between the date the check was issued and the date the check cleared. Also, part of the report are several metrics such as Average Clearance Amount and Average Clearance Days.
LTD Budget Activity Details Report is a budgetary report that shows all detailed LTD transactions by budget code and fund levels. It shows revenues, expenditures, obligations, unpaid invoices + inventory receipts, as well as unused fund to track all transactions.
Shipment by Warehouse report lists fully and/or partially shipped/returned and/or accepted and/or rejected items/orders from/to the Inventory Organization on daily basis. Warehouse managers/staff will be able to review the report output for the Inventory Organization(s) they have access to.
Quantity Backorder Report shows the orders that do not have enough available quantity to fulfil the consumption requisitions or Transfer Orders. The warehouse manager/staff will review this report on daily basis. The report will include Item Number, Item Description, UOM, Requisition Number, Requisition Line, Quantity available to transact, Transfer Order Number, Transfer Order Line, Transfer Order Line Quantity, Quantities Backordered, Requested Delivery Date, Source Organization, Destination Organization, and Requester.
Cycle Count Variance Report will be developed to show the variances in counted quantities and values in comparison with the quantities and values in Oracle Cloud system.
Valued Transaction Register Report generates a list of all inventory transactions (Transfer Orders, Movement Request, Misc. Issue/Receipt et al) that are performed in the inventory organization and the valuation of such transactions along with the accounting posting of such transactions.
Daily Average Cost Changes Report generates the Item(s) Average Cost Changes on a daily basis in specific Warehouse(s)/Inventory. The report will show the data for all the item(s) where cost changes had occurred.
Open Orders Report will be developed to list Internal Requisitions by Customers/LEA and Transfer Orders by Inventory Organizations that are not yet fully shipped to them. Warehouse Manager(s) will be able to view the Open Orders Report for the Inventory Organization(s) that they have access to.
DPI Item Catalog Report generates the list of all publications/materials that are in Active Status. The report will list the items associated to DPI by either Grade, Category, Subject, Contract dates (Contract From Year and Contract To Year), Publication Type, Publisher, Catalog Price for DPI Inventory Organizations.
Warehouse Activity Register Report will be developed to generate the consolidated list of Items in the Inventory Organization, its availability and movement for a given date range.
Inventory Item Movement Report generates a list of items that are transferred from or to a specific Inventory and/or between Sub-inventories within an Inventory Organization for the given date range.
Negative On-hand Inventory Balance OTBI Report lists all the items having negative on-hand quantity in a warehouse. Report will list Inventory Organization, Item Category, Item Number, Item Description, UOM and the On-Hand Quantity.
Inventory Turns Report lists Cost Organization, Cost Book, Inventory Organization Code, Inventory Organization Name, Item Number, Item Description, Primary UOM, Beginning On-hand Qty, Beginning Value, Ending On-hand Qty, Ending Value , Cost of Goods Sold (COGS), Inventory Turns, Current On-hand Qty, Current On-hand value and Days Sale of Inventory based on the date range parameter provided. Warehouse managers/staff should be able to view the report output for the organization(s) which they have access to.
Pick List Report generates the list of items that are due to be picked and shipped for Inter-Org Transfers along with Consumer Orders/Self Service Procurement and Movement Request.