Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Inventory vs. GL Dump Accounts

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Wed, 16 Sep 2020 11:05



General Information

Default Menu Location Maintain >> System >> Rule Maintenance

Function The Inventory vs. GL Dump Accounts rule controls which general ledger accounts are included in the overnight inventory reporting and reconciliation features, commonly referred to as the Nite Inventory process. Each GL account set up in this rule will be processed nightly, and will have account balances and transaction details stored in the data tables used for the Nite Inventory and Nite Usage reports. The Nite Inventory process is designed to record historical data overnight each and every night to improve historical research and reconciliation activities when inventory, accounts receivable, or accounts payable GL balances get out of balance with the transaction data.

The GL Accounts for Inventory (INVGLACCTS) rule must also be set up with the same GL accounts as this rule in order for the Nite Inventory processes to work properly.

Image



Rule Setup – Text Fields

GL Account (text1): Enter the general ledger (GL) accounts that should be processed as part of the Nite Inventory reporting. For each GL account entered, the Warehouse (Whse) name and the Type must be specified. The Acct? (log1) checkbox must also be checked to flag the rule entry as a GL account.

For Inventory tracking, a single stock inventory account should be entered for each warehouse. The overnight reporting assumes a single stock inventory GL per warehouse. Non-stock, consignment, or other custom inventory GL accounts should not be added to this rule. It is designed for tracking stock inventory movement.

For AR and AP tracking, enter each appropriate account and specify the Type value of AR or AP to track and report GL balance comparison data nightly.

Whse Name (text2): The warehouse name should be entered for each GL account entered. For customers operating in a single warehouse environment, this can be left blank.

Email Address (text3): Enter email addresses that should receive the Nite Inventory reports as soon as they are processed. Each email address entered must have the Email? (log2) checkbox checked to flag the entry as an email setting rather than a GL account. Multiple email addresses can be entered as separate entries with the Email? box checked for each entry.

Type (AR, AP, INV) (text4): Each GL account entry must have the Type specified as either INV (Inventory), AR (Accounts Receivable), or AP (Accounts Payable).



Rule Setup – Number Fields

No Number Fields In Use



Rule Setup – Logic Fields

Acct? (log1): This designates a rule entry as a GL account entry. Check this box for each GL added to the rule.

Email? (log2): This designates a rule entry as an email address entry. Check this box for each email address added to the rule.

Batch after mid (log3): This should be checked for each account in environments where the nightly autobatch and posting happen after midnight. The default Nite Inventory logic processes before midnight and assumes the same day's transactions and GL postings have happened before midnight.

Inv before mid (log4): This field works with the 'Batch after mid' field and should only be checked if advised by ABIS personnel. Unchecked is the most common setting for this field.



Adjutant



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions