Post Product Average Cost Changes


General Ledger Menu -> Inventory Postings -> Post Product Average Cost Changes

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

Rental Inventory
Sales Inventory
Inventory Transfer to External Branch
Update Product Costs & Prices
Costs & List Prices By Product Group
Update Re-Order Prices
Change Asset Tag Fields
Update Fixed Asset Tag

The Product Average Cost Changes Report lists Product #'s and Descriptions, Cost Change, and Quantity Change, by the G/L Inventory Account.

Security Roles and a password can be set on this program in Module Passwords. The module name is RSCA20C.
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 Inventory division of each cost 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.

The Inventory Account debited for the change in the inventory value, will be the G/L Inventory account assigned in the Product Class for each product.


POST EXPENSE ACCOUNT BY DIVISION
Check this box to post the Expense to the original division of each cost 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 ADJUSTMENT DATE
Accept the default date 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.

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.


COST ADJUSTMENT POSTING REPORT Confirmation
Review the report output.

If the report did 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 cost 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.

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 RSCA20C.
For more information on this security feature refer to System Security Overview.

Note: The CCQ or Cost Calculation Quantity is used when calculating the average cost of the product.
When inventory is received, the software notes the previous quantity on hand (Cost Calc. Qty) at the old cost. When the additional quantities are added, the software determines how many were received at the new cost, and calculates a new average cost.
Refer to Cost Calculation Quantity for details on how the costs are weighted to provide an accurate average for each sales product.

Posting Control
The Post Product Average Cost Adjustments program 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 Average Cost Adjustments flag will have access to the RESET button that unlocks the program.
Whenever the posting control flag for Average Cost Adjustments is reset, a record is written to the Delete Log for the Function RSCA20L.


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