Use this screen to print a discrepancy report and create quantity adjustments. Use it when you need to modify your quantity of inventory parts to correlate with an actual physical count you have taken.
Enter, or use Lookup to select, the count ID that the discrepancy report and adjustment creation processes will use.
Enter, or use Lookup to select, the warehouse where the count took place.
The system date is displayed as the default transaction date, but you can enter another date.
Enter, or use Lookup to select, the employee who is performing this transaction. A valid employee ID is required.
This checkbox will be selected, indicating that the status is active, until the physical count has been completed.
This checkbox will be selected if the count sheet/tags have been printed. If this checkbox is blank, the count sheet/tags have not been printed.
The date on which the physical count took place will be displayed.
This field displays either "Discrepancy Not Printed" or "Discrepancy Printed" to indicate the status of the Print Discrepancy Report and Create Adjustments Status. After the adjustments have been created, the adjustment status displays "Discrepancy Not Printed."
Select the radio button to indicate that this report be printed by Control Number or Project.
Select this checkbox to print all counts, even inventory transactions, with no discrepancies. If you do not select this checkbox, only counts with no discrepancies will be printed.
Select this checkbox to print dollar discrepancy subtotals by inventory project. If you do not select this checkbox, dollar value subtotals will not be printed.
Select this checkbox to print counts that have been reconciled by the user. If you do not select this checkbox, counts reconciled by the user will not be printed.
Select this checkbox to print counts that have not been reconciled. If you do not select this checkbox, counts that have not been reconciled will not be printed.
If you entered "Y" in the Auto-Assign field in the Transaction IDs subtask of the Warehouses screen and selected "Quantity Adjustments," leave this field blank and the system will automatically assign the next quantity adjustment ID. If Auto-Assign is "Y" and you manually assigned a quantity adjustment ID in this field, the system will not update the Last Inv Trans ID field in the Transaction IDs subtask of the Warehouses screen. If you entered "N" in the Auto-Assign field, you can manually enter a quantity adjustment ID containing up to 10 alphanumeric characters.
Enter, or use Lookup to select, the charge account for quantity adjustments for inventory allocated to non-common stock projects. This account must be an expense account, a project account, a valid detail account, and an active account.
Enter, or use Lookup to select, the charge organization for quantity adjustments for inventory allocated to non-common stock projects. The organization must be active and a valid account/organization combination.
Enter, or use Lookup to select, the charge account for quantity adjustments for inventory allocated to common stock projects. This account must be an expense account, a project account, and a valid detail account, as well as an active account.
Enter, or use Lookup to select, the charge organization for quantity adjustments for inventory allocated to common stock projects. This organization must be active and a valid account/organization combination.
Enter, or use Lookup to select, a reason code for this adjustment. The reason code must already be established in the Adjustment Reasons table.
Select this checkbox if you do not want to post expense inventory abbreviation transactions to the General Ledger.
Enter free-form text to be associated with this adjustment.
Select this pushbutton to view the accounting period to which the transaction will be posted according to the transaction date.
The information that is entered in this screen and saved as a parameter is stored in the FUNC_PARM_CATLG table. This screen also relies on the settings in the INVT_SETTINGS and MRP_SETTINGS_CORP tables. Information for printing discrepancy reports and creating adjustments is also stored in and/or pulled from the following tables: ACCT, EMPL, INVT, INVT_ABBRV_CD, INVT_PROJ, INVT_TRN, INVT_TRN_LN, INVT_TRN_LN_SR_LT, INVT_WHS_LOC_SR_LT, INVT_WHSE_LOC, ITEM, ITEM_CST, ITEM_PROJ_CST, IWL, PART, PHYS_CNT_DTL_SR_LT, PHYS_COUNT, PHYS_COUNT_DETL, POST_SEMAPHORE, PROJ, PROJ_EDIT, PROJ_ORG_ACCT, RSN_CD, SEQ_GENERATOR, SUB_PD, VIN_PHYS_COUNT, WHSE_LAST_TRANS.