Page History: Nite Inventory Reports
Compare Page Revisions
Page Revision: Wed, 16 Sep 2020 12:45
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 will compare the transactions against the postings in the data and show where there may be a difference.
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 the snapshot data of the on hand values at the end of the day entered in the Date Field.
Nite Usage Report (DUMPNITEUSAGE) This report will show all of the usage quantities and values for the date range provided.
Datatables in the Nite Inventory Process
NITEINV:NITEUSAGE:NITEDIFF:NITEBAL:
