Stock > Stock counts > Adjustments 

This function allows to carry out the comparison of the physical stocks(counted) and the data stored on the machine, and to generate the corresponding adjustments.

This function create/delete or modify the stock objects in semi-automatic manner, therefore, only confirmed user should use this function.

At a given moment, the discrepancy of stocks are calculated between the stock image after the closing of a counting and the stock keyed in in the counting.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

The view of the discrepancy is carried out from counting lines,  then after each selection of a line, the system indicates the stock objects of the database on the Stock Object bloc, then proposes the adjustments to be carried out on the Adjustment bloc 

Header

Presentation

Keying in of a stock count n° and a counting n°. The stock count should be pending and the counting closed. 

Warning, the processing can be done from any closed counting, it is necessary to be specific which one will serve for the regularizations.

The stock count type « by item » or « by address » is displayed for information.

Close

 

Fields

The following fields are present on this tab :

Counting

Sequence assigned by the system to the inventory.

Stock count number from which the adjustments are carried out.

  • Type (field TYP)

 

  • All (field ALLENREG)

 

Close

 

Tab Lines

Presentation

This tab presents for each counting line « in discrepancy », the comparison physical stock (keyed in), logical stock (Warehousing), the list of stock objects, and the adjustments proposed by the system. Depending on the adjustments carried out, the discrepancies are updated.

Counting lines

Auto Adj : automatic adjustment

If the automatic adjustment is simple to do the column is updated by Yes and the system proposes an adjustment, if the adjustment is more complex, because all the information were not yet filled in in the counting, the column has the value of No.
Then it is advisable to do the manual adjustment through the adjustment function, nevertheless, the information could be keyed in the Adjustment bloc to help the system carry out the adjustment.

Store/Address : location of the counting

Pic : tells if the location is the picking type

Depositor/Item :item depositorof the line of the counting keyed in.

+/- : quantitative discrepancy : physical stock (keyed in ) – logical stock (Warehousing) expressed in level 5 for the counting line.

<> : qualitative discrepancy : if ticked, tells that for the counting line, the qualitative information of the stock objects keyed in are different to that of the logical stock object.

(+/-) : quantitative discrepancy: physical stock (keyed in ) – logical stock (Warehousing) expressed in level 5 for the couple item/location of the counting.

(<>) : qualitative discrepancy : if ticked, tells that for the couple item/location, the information of the stock objects keyed in are different to that of the logical stock object..

(Lin no) : tells the number of counting lines  for the couple item/location.

(Obj no) : tells the number of Warehousing stock for the couple item/location

Stock objects

Indicates the stock objects present on the location,  and/or those to be created represented by an * on the column Stock objects. Depending on the selection of the stock objects, the system proposes an Adjustment (Increase, Decrease, Creation, Suppression, Qualitative) on the Adjustment tab.

The parameter I/O allows to verify if the existing stock objects have pending inputs or outputs.

To create a stock object, one must select a line where the object is represented by an *.

Adjustments

Indicates the information related to counting, to the stock object and by deducing the information of the adjustment type proposed.

Movement type : tells the type adjustment proposed by the system.

No containers/Container/CU Qty : quantitative characteristics of the item, keyed in during the counting (1° column), and the stock object (2° column).

Container n°/Stock nature /Reservation n° /Lot n° /Support n° /Origin code /Dates : qualitative characteristics qualitative of the item, keyed in during the counting (1° column), and the stock object (2° column)

Operating mode :

1- Selection of an inventory and a stock count n°

2- Selection of a counting line

3- Creation of adjustments :

After the creation of the movement, the system displays the management of anomalies screen, because coherence controls are carried out between the keyed in stock and the locations.  
For example, it is not possible to create stock objects of the different nature on a location with single nature storage type.

After the creation of movements, the system recalculates the new discrepancy table according to what was created.   

Close

 

Fields

The following fields are present on this tab :

Grid Lines

  • field CUT1

No help linked to this field.

  • Select (field SEL1)

No help linked to this field.

  • Auto adj. (field AUTAJM)

 

 

 

  • Pic (field PIC)

 

 

Product code defined in the GEODE product table.

  • Lot (field LOT)

 

  • -> (field FLECHE)

 

  • PKU (field CO_UC)

 

  • SO CU (field OS_UC)

 

  • +/- (field CUQDEV1)

No help linked to this field.

  • <> (field REFDEV1)

 

  • Counted total (field CO_TOT_UC)

 

  • SO total (field OS_TOT_UC)

 

  • (+/-) (field CUQDEV11)

No help linked to this field.

  • (<>) (field REFDEV11)

 

  • (No. count lines) (field CPTNBR)

 

  • (No. SO) (field SKONBR)

 

  • No. SO for lot (field SKONBRLOT)

 

Grid Stock objects

  • field CUT2

 

  • Select (field SEL2)

No help linked to this field.

  • +/- (field CUQDEV2)

 

  • <> (field REFDEV2)

 

 

  • Lot no. (field LOT2)

 

  • SO CU (field NBUCSKO2)

 

  • I/O (field PDG)

 

Grid Adjustment

  • Field title (field TEXTE)

 

  • Counting (field SKDVAL)

 

  • Stock object (field SKOVAL)

 

  • SO total (field SKOTOTVAL)

 

  • Adjustment (field AJMVAL)

Indicatesthe characteristics of the adjustments proposed by the system.

Close

 

Action icon

Check all
Uncheck all
Locations
Products
Single Object Inquiry
Stock objects

 

Close

 

Tab Adjustments

Presentation

This table is updated as and when the lines are selected and to be adjusted. The data are those of the memorized adjustments and is carried out at the time of validation.

Close

 

Fields

The following fields are present on this tab :

Grid

  • field CUT

 

  • Line (field CPTLIG)

 

 

 

 

 

 

  • Movement type (field ADJTYP)

 

  • No containers (field CTRQTY)

 

 

  • CU/STK no. (field CUQ)

 

  • Container no. (field CTRLIKNUM1)

 

 

  • Reservation no (field RSA)

 

  • Lot no. (field LOT)

 

  • Support no. (field SPT)

 

 

  • FIFO date (field FIFDAT)

 

  • Receipt date (field INPDAT)

 

  • Manufacturing (field MND)

 

  • Detention (field RTD)

 

  • SBD (field SLD)

 

  • UBD (field USD)

 

  • SbD (field SND)

 

Close

 

Menu Bar

This button unselects the records and the adjustments memorized by the system and marked the line as not « adjusted » in a way not to be proposed later.

Warning : if the button Cancel is used after the selection of all the lines, the system will no longer propose any line in discrepancy.

Allows the keying in of remarks related to the adjustments to be carried out. If the adjustments are not confirmed the remarks are destroyed.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Automatic adjustment movement code not defined

The movement code should be defined on the table of the current depositor.

Inventory without counting closed with discrepancy

The stock count n° keyed in does not have the counting that allows the carrying out of adjustments, either because there is no closed counting, or there is no discrepancy in the counting. 

There are other countings closed.

Warehousing warned the operator that there are other closed countings on which discrepancy of stock could be based on. 

Tables used

SEEREFERTTO Refer to documentation Implementation