Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Incoming_links
SpaceUSE

Overview

Stock adjustments registered during warehouse operations, such as physical inventory counts or instant stock adjustments without inventory counts, require recognition in financial accounting.

Periodically, the company analyzes registered stock adjustments, finds out each cases, the reasons for the deviations, determines the stock owner company, evaluates the goods, determines the guilty party, makes decisions about the financial consequences for the company. All such decisions must be documented according to enterprise policy.

Depending on the decisions made, stock adjustments are recognized in financial accounting as profit and loss items in the current period.

At the next step, the cost of goods is evaluated. Cost evaluation is especially important in cases of stock reclassification or stock quality changes. For simplification purposes, data on the cost of goods can be filled in with data from disposed goods.

As a result of the process, stock adjustments are correctly recognized in financial accounting.

Video guide

Widget Connector
urlhttp://youtube.com/watch?v=N74vyvuzp1I

Recognize stock adjustments flowchart

Definition

The inventory adjustment documents are created to record the identified stock discrepancies. These stock discrepancies can be results of the inventory count and discrepancies found during the fulfillment of regular warehouse operations.

Inventory count sheet data are used for the automatic filling of new inventory adjustment documents.

If discrepancies are found in the inventory during warehouse operations, inventory adjustment documents are created and filled in manually.

In the case of creating inventory adjustment documents for the group of companies (centralized warehouse management), the actual (and positive) inventory of the company is monitored.

In the case of inventory reclassification and inventory quality change, the data on the accepting goods are filled in with the data of the disposing goods.

The result of creating inventory adjustment documents is an update of available inventory data that reflects the physical available inventory.

...

BPMN Modeler Enterprise
attachmentIdBpmn39689019
diagramBackgroundColor#ffffff
enableCustomViewerHeightfalse
diagramName

...

Recognize stock adjustments
showBpmnLinkstrue
showAnyLinkstrue
showConfluencePageLinkstrue
showAttachmentsInTabfalse
showDmnLinkstrue
showEmbeddedCommentstrue
saveZoomPositionfalse
showJiraIssueLinkstrue
showBpmnJsPaneltrue
shownAttachmentVersion

...

9
showDmnInTabfalse
viewerHeight250
commentedSavingfalse
vbcpEntIdvxcp-ent-id-4afa8503-4289-4103-becc-fecead546158
showConfluenceAttachmentLinkstrue
showExternalContentLinkstrue
showMdfInstanceLinkstrue
showMaximalHeightfalse
loadImageInViewermodel
showBpmnInTabfalse
showDocumentationtrue
showJiraIssuesInTabfalse

Paths

PathWarehouse and delivery → Surplus, shortage, stock quality change → Inventory adjustments
In-app link EN code
Text_to_copy
e1cib/command/DataProcessor.WarehouseGoodsIssueReceipt.Command.WarehouseActs
In-app link RU code
Text_to_copy
e1cib/command/Обработка.ЖурналСкладскихАктов.Команда.ОткрытьФормуСпискаСкладскихАктов

How to

...

check stock

...

adjustments pending recognition

1. Go to

...

Click the Reports → Stock discrepancies report.

Warehouse and delivery, then click Inventory adjustments under Surplus, shortage, stock quality change.

2. In the Inventory adjustments workplace, select the Warehouse, then click the To register → Reports hyperlink.

3. In the Unregistered surpluses and shortages of goodsreport

...

, check the list of stock

...

adjustments pending recognition in financial accounting.

How to

...

recognize stock adjustments using a wizard

...

1. In the Inventory adjustments

...

workplace, click Create → By using wizard

...

.

2. In

...

the Inventory adjustment

...

wizard workplace,

...

on the Setuppage

...

Select the Warehouse.

...

, specify the Physical inventory register

...

period, the Inventory adjustment date, click Next.

Click the Set filter to customize the selection.

Click the Next button.

3. On the Reclass stock or change quality page

...

, select a line in the Stock shortage table

...

, select a corresponding line in

...

the Stock surplus

...

table, click Process selected items

...

, Specify the quantity

...

.

Info
titleNote

Click

...

Reclass all stock and

...

Process stock quality...

...

to automatically reclass all matched lines.

...

4. Check data in the Stock reclasses and quality changes table

...

below. Click Next.

Info
titleNote

...

You can reclass stock only for goods with a common unit of measure

...

as during the

...

offset the

...

quantity of

...

outbound and

...

inbound goods is the same.

You cannot make a stock

...

reclass transaction for items that have different VAT rates.

The stock quality change transaction is made only for the goods that have different quality attributes.

...

5.

...

On the Assign company stock for adjustment page, click the Operation type, select the relevant operations.

Info
titleNote

The following scenarios are available:

  • Select the Stock quality change in the Operation type to process the data related to changes in quality and generate the Stock quality change

...

  • document.

...

  • Select the

...

  • Stock reclass in the Operation type to process the data related to item reclassification and generate the Stock reclass documents. 

...

  • Select the Stock shortage in the Operation type to process the data related to inventory shortages and generate the Stock shortage recognition documents. 

...

  • Select the Stock surplus in the Operation type to process the data related to inventory surplus and generate the Stock surplus recognition documents. 

Review the information in the Stock discrepancies pending company stock assignment table.

6. Select lines, click Company remaining goods report

...

.

...

 In the Company stock balancereport

...

, check the list of companies in columns

...

that have the selected item in available stock.

Return to the Assign company stock for adjustment page

Select the line and click the Assign company stock manually button.

...

7. Select lines, click Assign company stock automatically, select a Company, click Ok. Click Next.

Info
titleNote

Click the Assign company stock automatically button to assign company stock automatically to all lines.

You may define the priority for the list of companies.

...

If the item is identified in several companies'

...

stock, the system will select the first specified in the order of priority

...

.

The system will automatically fill in the Stock discrepancies assigned to company stock table with inventory assigned to company stock.

Click the Next button.

The system will automatically create and fill in all necessary inventory adjustment documents.

It is also possible to select the line, click Assign company stock manually, and select a Company.

8. On

...

the Review generated inventory adjustment documents page

...

, check the list of created and posted

...

inventory adjustment documents.

...

 Open the stock adjustment recognition document.

How to define prices for reclassification and quality change

1. In the stock adjustment recognition document, click Main tab, check if valuation option requires different valuation for goods. Maintain default expense item or income item relevant to the stock adjustments recognition, then select relevant Dimension.

2. Click Advanced settings tab, select Currency, fill in the Cause for stock adjustment.

3. Click the Goods tab, fill in Price column. Post the document. 

Open the document and fill in the required fields, if the document hadn't been posted.

Select documents, click the Print button and choose the necessary print-out forms.

Info
titleNote

All necessary print-out forms shall be customized during the implementation project.

How to change goods quality

Go to the Inventory adjustments list.

Click the Create command and choose the Stock quality change (by custom price) or Stock quality change (by cost) business transaction.

Info
titleNote

The Stock quality change (by custom price) business transaction allows you to define the custom price for the incoming stock, which is different from the price of the outgoing stock of initial quality.

The Stock quality change (by cost) business transaction accepts incoming stock of a new quality at the same price as the outgoing stock of initial quality.

In the Stock quality change (by custom price) document, go to the Main tab.

Fill in Company, Business unit, Warehouse, Price type, Expense item and Expense dimension fields.

Go to the Stock tab.

Add a new line and fill in all required fields- original Item, original Item variant, another quality Item, another quality Item variant, Quantity, etc.

Specify the Price field manually or click the Fill in prices → by cost/price type command - depending on the business transaction.

How to reclass inventory

Go to the Inventory adjustments list.

Click the Create command and choose the Stock reclass business transaction.

In the Stock reclass document, go to the Main tab.

Fill in Company, Business unit, Warehouse, Price type

Leave the Receive goods at writing off cost checkbox unselected, specify Expense itemExpense dimension, Income item, Income dimension fields - to record cost differences of the reclassified goods.

OR Select the Receive goods at writing off cost checkbox to avoid any differences in cost of the reclassified goods.

Go to the Stock tab.

Add a new line and fill in all required fields- original Item, original Item variant, another Item, another Item variant, Quantity, etc.

Specify the Price field manually or click the Fill in prices → by cost/price type command.

How to recognize inventory shortage

Go to the Inventory adjustments list.

Click the Create command and choose the Stock shortage recognition business transaction.

In the Stock shortage recognition document, go to the Main tab.

Fill in Company, Warehouse, Price type, Expense item and Expense dimension fields.

Go to the Stock tab.

Add a new line and fill in all required fields- Item, Item variant, Quantity, etc.

The Price will be defined within the cost calculation procedure.

How to recognize inventory surplus

Go to the Inventory adjustments list.

Click the Create command and choose the Stock surplus recognition business transaction.

In the Stock surplus recognition document, go to the Main tab.

Fill in Company, Business unit, Warehouse, Price type, Income item and Income dimension fields.

Go to the Stock tab.

Add a new line and fill in all required fields- Item, Item variant, Quantity, etc.

...