Cost Layer Adjustment

The WorkPlace Inventory Management solution contains a detailed Inventory Ledger with detailed cost layers that are updated based on item valuation methods setup within Item Maintenance.  With the appropriate assigned security, users are able to update the cost for previously processed inventory adjustments of quantity tracked items and record the reason for the adjustment for reporting purposes. Existing Cost Layer Adjustment sessions can be edited by selecting them from the Outstanding Transactions heading on the WorkPlace Dashboard.  Open Cost Layer Adjustment Session(s) are those that have already been created but have not yet been processed.  Valid Item and Location combinations can only be loaded into a single open Cost Layer Adjustment session at a time.  

Document Toolbar

New

Clear

Allows the user to delete the session if it has not been processed.

Save

Process

Processing a Cost Layer Adjustment transaction will update the Inventory Ledger entries with the adjusted costs and create the corresponding General Journal entries.  The Stock Current Cost will be updated in Item Maintenance for any items setup with the Average valuation method based on the recalculated average cost using the Cost Layer Adjustment.

Header Fields

Number

A system generated sequential tracking number assigned to all Cost Layer Adjustment sessions as defined on the Inventory tab in System Settings.

Created On

System generated date identifying when the Release Request was created.

Created By

Name of the user who is logged in and creating the Release Request, they are the 'owner' of the session.

Reason

Enter a comment that summarizes the reason for the cost layer adjustment and will be recorded within the system for audit purposes.

Document Date

Defaults to current date, may be changed if needed.  

Posting Date

Defaults to the Document Date and may be changed if needed.

Load Fields

The following fields are available for selection to create a new Cost Layer Adjustment and populate the session lines. Once the Load button has been clicked, these fields will not be displayed.

Company

This field is available when Intercompany is registered to type in or select the company that owns the inventory.

Item

Type in or select the quantity-tracked inventory item for the cost layer adjustment.

Location

Type in or select a valid inventory location for the selected item.

Load Button

Click the Load button to populate the session lines with all Inventory Journal entries for the Item and Location selected.

Line Fields

Line

System generated sequential number assigned to each line.

Organization

Displays the Organization for source document.

Source Document

Displays the WorkPlace document number for the original inventory adjustment and associated source document if applicable.

Source Type

Displays the adjustment type for the Source Document.

Date

Displays the date of the Source Document.

Item

Displays the quantity tracked item that is being adjusted.

Location

Displays the inventory location for the selected item adjustment.

Quantity

Displays the quantity from the source document line converted to the base Unit of Measure for the Item that will be cost adjusted.

U/M

Displays the base unit of measure (UOM Base) for the item as setup in Item Maintenance.

Cost

The calculated cost for source document line will be displayed upon load and can be edited by the user for the cost adjustment.