Resynchro + stock control
This function is used to resynchronize the different information in the stock files at the level of the folder and at the level of a site.
This process can be carried out in direct or batch mode.
The process types proposed are the following:
Recalculation of the lot stocks
Resynchronization of the stock lines
Recalculation of the product-site totals
Resynchronization of the analysis requests
Resynchronization of the physical stock counts
Control of the FIFO stack
Control of the serial numbers
Prerequisite
Refer to documentation Implementation
Screen management
A selection window is used to choose the resynchronization processes to be launched, as well as to specify any additional selection criteria (warehouse site, product category ranges, product ranges).
Entry screen
Presentation
The resynchronization processing selection is used to identify the processings that can be carried out at the folder level and those that can be carried out at the site level.
Folder level processing
Lot stocks recalculation
This function is used to update the stock by lot from the stock lines for all sites in the folder.
The processing consists in comparing the lot file (STOLOT) and the stock file (STOCK), in case of a variance, the STOLOT file is updated.
Site level processesing
A warehouse site can be specified. By default, this field is initialized with the site associated with the user's profile. In order to take into account all sites, it is necessary to tick the "All sites" flag. As well as the storage site, it is possible to refine the selection by specifying product category ranges and/or product ranges. It should be noted that the restriction on the product range is only effective when at least one of the resynchronization processings at the site level is ticked. This criterion is not applied if there is a unique lot stock recalculation.
The different resynchronizations possible are as follows:
Stock lines: Calculation of the allocated quantities, in active STK (stock unit)
Product-Site amounts: This function compares the Product-Site amounts file (ITMMVT) with other files:
Comparison of the quantity with status A, Q, R in the ITMMVT file with respect to the STOCK file.
Comparison of the reserved quantity in the ITMMVT file with respect to the STOCK file.
Comparison of the quantities in transfer (in transit and transferred), the globally allocated quantities, the shortage quantities, the required quantities in the ITMMVT file with respect to the allocations file (STOALL).
Comparison of the quantity on order in the ITMMVT file with respect to the ORDERS file.
In the first instance, the system deletes the old amounts (storing the old values). After comparing the files described above, the ITMMVT file is updated when a variance has been established. The effect of this is to update all the stocks (reserved stock, allocated stock, stock in transfer...) in ITMMVT.
Quality controls: This resynchronization is used to update the STOQLYH (quality control header) and STOQLYHD (quality control detail) files from the stock line. Different cases are possible.
Loop on STOQLYD:
The system deletes a record in STOQLYD when in parallel there is no corresponding record in the STOQLYH and STOCK files.
The system creates a new record STOQLYH when in parallel there is a record in STOCK.
If a record exists in STOQLYD without corresponding record in the STOCK file but with a record in the STOJOU file, then the system sets the VALFLG (validation flag) field in STOQLYH to the value 2.
If there is a corresponding record existing in STOQLYH and STOCK, the system verifies that the VALFLG field is set to 1 and readjusts the quantities between the STOCK and STOQLYD records.
Loop on STOCK:
If no record exists in the STOQLYH and STOQLYD files, the QLYCTLDEM (analysis request) field in STOCK is re-zeroed.
A record in STOQLYD is created when an analysis request is referenced in STOCK and STOQLYH.
Reciprocally, a record in STOQLYH is created when an analysis request is referenced in STOCK and STOQLYD. In parallel, the quantities in STOCK and STOQLYD are checked.
The system readjusts the quantities between the STOCK and STOQLYH records when these already exist.
Loop on STOQLYH:
When no record exists in STOQLYD then the STOQLYH record is purged.
Stock counts: The process verifies that the product-sites, stock lines and locations blocked for stock counts are correctly identified. If this is not the case, the Hold flag and the list of stock count records concerned are re-zeroed.
Additionally, the processing checks:
The CUNLISSTA status in the CUNLISTE file
The CUNSSSSTA status in the CUNSESSION file
If incoherencies are detected, they are corrected and noted in the log file. For instance:
For the CUNLISSTA status in the CUNLISTE file, this type of message is returned:
"Stock count status: list SSE-ASN0301111 INV-ASN0309000 modified! : 5 -> 4"
For the CUNSSSSTA status in the CUNSESSION, this type of message is returned:
"Stock count status: session SSE-ASN0301111 modified! : 1 -> 2"
The following additional controls can also be carried out :
FIFO and stock price control: This function is used to control the coherence between the quantity expressed in the stock and the quantity indicated in the FIFO stack.
Comparison of the STOCOST file with respect to the STOCK file.
When an anomaly is discovered, the error must be manually corrected.
Serial number control: To be ticked to carryout a reconciliation between the stock lines and the linked serial numbers.
Comparison of the STOSER file with respect to the STOCK file.
When an anomaly is discovered (for example when a serial number is neither issued nor in stock), the error is automatically corrected (in the case previously mentioned, the deletion of the record in STOSER is automatic).
Processing log file:
The processing generates a log file that can be printed.
This log file lists the errors found and any corrections carried out.
Close
Fields
The following fields are present on this tab :
Selections
|
Enter or select a storage site at which the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
|
Tick to run the following processings for every site stock. |
|
Start category range. |
|
Enter this field to select a range of categories. Specify the category corresponding to the selection end range. |
|
Enter the selection start product number. The product ranges limit the adjustment to these products only. |
|
Enter the selection end product number. |
Resynchronizations
|
Tick to resynchronize the totals in the stock lines and launch the null stock lines purge. |
|
Tick to resynchronize the quality controls starting from the stock lines. |
|
Checking this field is used to resynchronize the remaining quantity fields prior to a potential disassembly (the process is carried out for all the sites). |
|
This function is designed to recalculate the site stock from the stock lines of this site. |
|
Check this box to resynchronize the stocks and trigger the null stock lines purge. |
|
This function is used to recalculate the stock by lot from the stock lines for all sites in the folder. |
Control
|
This function is designed to control for each site product that the stock has the same quantity as the FIFO price stack. |
|
|
Tick to carryout a reconciliation between the stock lines and the linked serial numbers. |
Miscellaneous
|
Close
Batch task
This function can be run in batch mode. The standard task FUNSTOR is provided for that purpose.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Site name: xxx non-existent record
This message appears when the specified site is not a declared site.
Lot stock de-synchronized… Correction carried out
This message appears when the process has found an anomaly in the lot stock file. The update of STOLOT with respect to STOCK is automatic.
Warehouse site de-synchronized… Correction carried out
This message appears when the process has discovered an anomaly in the site stock file. The ITMMVT file is automatically updated according to the information recorded in the files concerned (STOCK, STOALL…).
Orphan quality control line... Automatic deletion
This message means the record in STOQLYD has no corresponding record in STOQLYH and STOCK.
Non-controlled quality control line... This control is to be completed
The quality control appears as validated, however a line has not yet been controlled. The process modifies the posting value of the VALFLG field by setting it to 1 and rewriting the record in STOQLYH.
Orphan quality control header... Automatic deletion
This message indicates that the record in STOQLYH has no corresponding record in STOQLYD. The record in STOQLYH is thus automatically purged.
Stock and FIFO price tables de-synchronized… FIFO price and stock control carried out
This message appears when the "FIFO price et STOCK control" processing has found an anomaly. The correction is made manually.
Serial number not issued and not in stock... Automatic deletion
When a serial number is neither issued nor in stock, the deletion of the record in STOSER is automatic.