Page History: Nite Inventory Reports
Compare Page Revisions
Page Revision: Wed, 16 Sep 2020 14:21
General Description
The Nite Inventory process is a nightly dump of inventory and general ledger information that can be used to research historical inventory values, inventory usage, and GL Balances on a given day in history. This allows users or consultants to generate a snapshot of the data as it was that night. This archived historical data can be useful in case of audits or researching reconciliation for inventory accounts.
The Nite Inventory process is a system service that must be set up by ABIS personnel in order to start tracking nightly inventory and GL reconciliation data. Contact your ABIS consultant if you want the Nite Inventory process set up and running.
Setup Required
There are tow rules that must be set up in order to generate the data used in the Nite Inventory process. Both rules should be set up with the same GL accounts in order for the Nite Inventory process to work as expected.
- The Inventory vs. GL Dump Accounts (INVDUMP) rule controls which GL accounts are included in the comparison reporting data for transaction vs. general ledger reconciliation. This rule also contains the settings for who gets the reports emailed nightly.
- In addition to the two rules above, the AUTOBATCH Setup Option must be enabled and daily/nightly batching and posting must be configured in the Autobatch Options (AUTOBATCH) rule.
- The ADJITEMDETUPSRV system service must be set up and running. This is an ABIS-ONLY setup and must be coordinated with an ABIS consultant.
Reports
The Nite Inventory process generates data in system database tables, Excel files, and PDF reports that are saved (and optionally emailed) on a nightly basis. There are three reporting screens available for users and/or consultants to recreate the reporting data for historical dates.
Nite Inventory vs GL Summary (PRINTNITEINV) This report compares the inventory movement in quantity and cost for each day using data from the Nite Process datatables. Differences from the nite inventory (NITEINV)table from day to day are compared to the nite usage (NITEUSAGE) values for the same period. Any differences are shown and totaled in the difference column.
The report also contains a section comparing the days on hand inventory value compared to the general ledger value for the same day.
Start Date / End Date: Enter a date range to pull historical data stored in the system database tables during the Nite Inventory process.
Exclude Inv Diffs: Checking this box will suppress the inventory differences section from printing.
Exclude Cost Divs: Checking this box will filter out certain item-level details based on quantity and cost.
+/- Value Filter: Enter a whole dollar amount to filter the results based to only include details where the cost difference exceeds the entered value. For example, entering '1' will limit the report to showing items where the overall cost difference is equal to or greater than $1.
Nite Inv Report (DUMPNITEINV) This report will show data from the NITEINV table of the on hand quantities and values at the end of the day entered in the Date Field. The NITEINV data is populated during the Nite Inventory process. For this reason, the data is purely historical and is not affected by any backdated transactions.
Start Date: A date entry is required to produce the report.
Nite Usage Report (DUMPNITEUSAGE) This report will show usage quantity and cost data from the NITEUSAGE table for the date range provided. The NITEUSAGE data is a custom data set based on the ITEMACT transaction data that drives the general ledger posting. The NITEUSAGE data is populated during the Nite Inventory process. For this reason, the data is purely historical and is not affected by any backdated transactions.
Start Date / End Date: A start and end date range is required to run the report.
Datatables in the Nite Inventory Process
NITEINV: This table contains the nightly dump of inventory on hand values for every item with on hand value. The adddate is used for the Nite Inventory Report.
NITEUSAGE: This table contains a custom nightly dump version of the ITEMACT data that is used to generate accounting details. This data is useful for comparing to general ledger data. The adddate is used for the Nite Usage Report.
NITEDIFF: This table records any net change in quantity and/or value for each item from night to night.
NITEBAL:
