Post Inventory Adjustments


General Ledger Menu -> Inventory Postings -> Post Inventory Adjustments

This program prints an audit trail report and completes the posting to the General Ledger of any Inventory quantity adjustments for Rental or Sale products, entered via the following adjustment menu options:

Sales Inventory
Rental Inventory
Clone Rental or Sales Products
Update On Hand Qty By Product#
Product Quantity Adjustment
Change Product Numbers
Merge Sales Product Numbers
Inventory Count
Reset Product Quantities
Reverse Inventory Adjustments
Vendor Catalogues

The Inventory Adjustment Report lists product #'s and descriptions, location, division, quantity changes, cost changes, and the G/L Inventory Account.

Security Roles and a password can be set on this program from Module Password. The module name is RSIA10C.
For more information on this security feature refer to System Security Overview.

The prompts are:

POST INVENTORY ACCOUNT BY DIVISION
Check this box to post to the original source inventory Division of each quantity adjustment transaction.

Uncheck this box to assign an Inventory division now.

INVENTORY DIVISION
Enter the Division for the Inventory portion of the G/L posting transaction, or select it from the drop-down list.
This division will be used for the G/L Inventory posting, regardless of the actual inventory location division (RSIL).

The 'Inventory Account' debited for the change in the inventory value, will be the G/L Inventory account assigned in the Rental Product Class or Sales Product Class associated with each product.


POST EXPENSE ACCOUNT BY DIVISION
Check this box to post the Expense to the original division of each quantity adjustment transaction.

Uncheck this box to assign an Expense division now.

EXPENSE DIVISION
Enter the Division for the Expense portion of the G/L posting transaction, or select it from the drop-down list.

The G/L Expense Account used will be selected later.


G/L POSTING FORMAT
Select one of:
  • Select Summary to post to the G/L in summarized totals, so that there is only one Debit and one Credit for each Inventory account, per division.
  • Select Detail to post full Debit and Credit details to the G/L for each product.


EXPENSE ACCOUNT TO POST TO
Enter the G/L Expense account to be credited for the change in the inventory value, or select it from the G/L Account Search window.

POSTING DATE
Accept today's date, or enter the desired posting date.

PRODUCT TYPES
Select one of:
  • Select Rental to include only Rental Equipment in the report and the postings.
  • Select Sales to include only Sales Parts in the report and the postings.
  • Select Both to include both Sales and Rental products in the report and the postings.

FROM CLASS
Leave this field blank to include all Product Classes, or enter a starting Class for the report range, or select a Class from the Product Class Search window.
TO CLASS
Leave this field blank to include all Product Classes, or enter an ending Class for the report range, or select a Class from the window.

FROM ADJUSTMENT DATE
Leave this field blank to pick up all unposted adjustments by starting the period with a blank date, or enter the desired starting date.

TO ADJUSTMENT DATE
Accept today's date, or enter the desired ending date for the period.

ALL ADJUSTMENT TYPES
Check this box to post all adjustment types.

Uncheck this box to post a specific adjustment type.

ADJUSTMENT TYPE
Enter the Adjustment Type, or select it from the drop-down list.
Type codes can be setup in Inventory Adjustment Types.

Finished?
A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.

Click the ACCEPT button to begin printing the report, or CANCEL to abort.


ADJUSTMENT POSTING REPORT Confirmation
Review the report output.
If the report is not correct or did not print successfully, click NO to abort the update process.
The report can be regenerated and reprinted.

If the data is correct and the report printed successfully, click YES to accept it and to continue the post adjustments process.
The option to post to the G/L or to post manually will be provided next.

POSTING TO G/L Confirmation
This pop-up dialogue box is only triggered after the report is accepted.

Click NO to prevent posting directly to the G/L.
These adjustments to the G/L should then be done as a journal entry to ensure the Inventory sub-ledger matches the General Ledger. These transactions will not print again.
If these Inventory quantities are being entered as part of Startup, click NO to prevent duplicate posting, as the Inventory value will be included in the complete Beginning Balances journal entry.

Click the YES button to initiate the posting to the G/L per the reported records. A second summary will print with the posting data.

G/L POSTING SUMMARY REPORT Confirmation
This pop-up is only triggered if the second posting summary has been printed for the G/L postings.

If the report did not print successfully, or if errors are found, click NO to abort the posting to the G/L. The whole report can be regenerated and reprinted.

If the summary printed successfully and the data is correct, click YES to accept the report and to post these records to the General Ledger.

PASSWORD
This prompt appears if there is a Module password set on this posting function in Module Passwords for RSIA10C.
For more information on this security feature refer to System Security Overview.

Posting Control
The Post Inventory Adjustmentsprogram is designed to be run by one operator at a time.
Locking will occur if an operator did not exit the posting program correctly.
A Posting Control Information warning will appear on the screen and only operators with Security Role permission to reset the Inventory Adjustments flag will have access to the RESET button that unlocks the program.
Whenever the posting control flag for Inventory Adjustments is reset, a record is written to the Delete Log for the Function RSIA10L.


Topic Keyword: RSIA10
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)