API RF VALLINVL

Cette API permet de mettre à jour une ligne d’inventaire.

API imbriquées : aucune.

Contraintes et limites de fonctionnement (hors périmètre)

Paramétrage (PPE)

Valeurs restituées par l’API

Processus, contrôles et règles de gestion

Cas d’erreurs

Détail de l'API

Read the inventory line data (LINVL table) with the input parameters (typtie, sigtie, idoi, numcompe, numligoi, numseqlig).

Read the inventory order data (LOI table) with the input parameters (typtie, sigtie, idoi).

Validate the inventory line.

(Modify the inventory line’s ‘counting user code’ with the ‘IO’s validating user’ (uticomp = LOI.utival) , ‘counting time’ with the current time, ‘counting date’ with the current date, ‘inventory quantity’ (linvl.qteinvent) with the received parameter ‘qteunt’ and ‘physical receiving flag’ (LINVL.flgsaisie) with ‘1’).

If the modification of the inventory line does not succeed, the API returns the error code 0 and the error message ‘RFINV01005’.

If the operator is authorized to do modifications (input parameter ‘ habil_opr ’ != 0).

Read the slot address data with the corresponding third-party ID and slot address code from the inventory line (sigdep = LINVL.sigtie, codemp = LINVL.adremp).

If the received CU quantity is different from the real occupation quantity for the slot address (qteunt != EMP.occreel).

Read the inventory mode data (LMODINV table) with the corresponding inventory line’s third-party type and ID (LINVL.typtie, LINVL.sigtie) and IO’s inventory mode (LOI.modinv).

Create an adjustment movement with the following values:

(Third-party type equal to the inventory line’s third-party type (typtie = LINVL.typtie),

Third-party ID equal to the inventory line’s third-party ID (sigtie = LINVL.sigtie),

If the received CU quantity is bigger than the real occupation quantity for the slot address (qteunt > EMP.occreel).

Movement direction equal to ‘input’ direction (sensmvt = ‘E’),

Movement code equal to the inventory mode’s positive movement code (lcodmvt, w_lmodinv.codmvtpos),

Number of containers equal to the difference between the received CU quantity and the real occupation quantity for the slot address (l_nbrcnt = qteunt - EMP.occreel),

If the real occupation quantity for the slot address is bigger than the received CU quantity (EMP.occreel > qteunt).

Movement direction equal to ‘output’ direction (sensmvt = ‘S’),

Movement code equal to the inventory mode’s negative movement code (lcodmvt, w_lmodinv.codmvtneg),

Number of containers equal to the difference between the real occupation quantity for the slot address and the received CU quantity (l_nbrcnt = EMP.occreel - qteunt),

CU quantity equal to the number of containers (qteunt = nbrcnt),

Movement type equal to ‘adjustment’ (typmvt = ‘A’),

Batch ID equal to the inventory line’s inventory ID (idbch = LINVL.idinv),

Order ID equal to the inventory line’s inventory order ID (idord = LINVL.idoi),

Order line equal to the inventory line’s inventory line number (ligord = LINVL.numligoi)

Read the stock object (LOBJSTK table) with third-party type equal to the inventory line’s third-party type (typtie = LINVL.typtie), third-party ID equal to the inventory line’s third-party ID (sigtie = LINVL.sigtie) and stock object ID equal to the inventory line’s stock object ID (idobj = LINVL.idobj).

Call the function gnc_gener_mvt_ajust_xa, as so to generate the corresponding adjustment movement.

Call the function gnc_ gnc_valid_mvtstk, as so to validate the movement.

If the execution of the function is not successful, the API returns an error code 0 and an error message ‘RFINV01006’.

For each inventory line data (LINVL table) read with the input parameters (typtie, sigtie, idoi, numcompe) and with numligoi >= 1, numseqlig >= 0.

If the inventory line’s ‘counting user code’ is equal to ‘_’ (LINVL.uticomp = ‘_’).

The Inventory order is considered as not terminated.

If the inventory order is terminated.

Modify the status of the inventory order to ‘validated’ (LOI.statut = ‘9’).

Modify the validation time (LOI.heuval) and the validation date (LOI.datval) with the current time and date.

If the modification is not successful, the API returns the error code 0 and the error message ‘RFINV01007’.

Read the inventory header data (LINVE table) with the inventory order’s third-party type, third-party ID and inventory ID (LOI.typtie, LOI.sigtie and LOI.idinv).

If the inventory header is found.

Increase its number of inventory orders with one (LINVE.nboi).

Modify its status to ‘closed’ (LINVE.statut = ‘8’).

Otherwise.

The API returns an error code 0 and an error message ‘RFINV01004’.

Return the code 1.