The MMS interface is used to manage flows coming from and designed for the AXEL - MMS software.

This processing uses the parameters specified in the MMS setup function.

SEEREFERTTO The principles of the interface function are given in the MMS setup documentation.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Enter the reference identifying the MMS interface setup to use.

All the flows are selected by default. It is possible to de-select those that do not have to be processed.
It is also possible to:

- specify selection formulas that differ from those specified by default, in the setup,
- specify a period in order to limit the journal of exported stock counts,
- modify the selection, indicated in the setup, to extract the journal of stock counts with or without the MMS movements.

By default, a log is displayed at the end of the processing if it is launched in interactive mode. It indicates:
- the directories used,
- the setup used: pivots, selections, dimensions, etc.,
- the result of the processing for each imported file.

Block number 1

Identifier (field ID)
field INTIT

Block number 2

field FILLER
Destination type (field TYPEXP)

Select the type of sender: customer or server.
Log (field TRACE)

A log file is systematically created at the end of the processing. It indicates:

  • the folders,
  • the setup used: pivots, selections, etc.
  • For each imported file:
      • the number of lines read/processed/rejected
      • the name of the reject file,
      • the list of the rejected lines with the explanation.

If this check box is selected, the file is opened at the end of the processing launched in interactive mode. Otherwise, it is created but opened only if errors occur.
Work directory (field VOLFILWRK)
Storage directory (field VOLFILSTO)

Imports

Purchase requests (field PSHPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Purchase requests to import: MMSPSH.csv.
This pivot code is entered at the level of the interface setup.

field FLGPSHPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Movements (field MVTPIT)

This field, that cannot be modified, contains the pivot code describing the lines of the Stock issue movements file to import: MMSMVT.csv.
This pivot code is entered in the setup of the interface.
field FLGMVTPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Dimension type (field DIEIMP)

Exports

Analytical dimensions (field CCEPIT)

Ce champ, non modifiable, contient le code du pivot décrivant les lignes du fichier des Sections analytiques à exporter : MMSCCE.csv.
Ce code pivot est renseigné au niveau du paramétrage de l'interface.

field FLGCCEPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Dimension type (field DIE)

This field, that cannot be modified, contains thedimension typefor the cost center.
This information is entered at the level of the interface setup.
Storage site (field FCYPIT)

Ce champ, non modifiable, contient le code du pivot décrivant les lignes du fichier des Sites de stockage à exporter : MMSFCY.csv.
Ce code pivot est renseigné au niveau du paramétrage de l'interface.

field FLGFCYPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Product set (pivot) (field ITMPIT)

This field, which cannot be modified, contains the pivot code describing the lines of the Productsfile to export: MMSITM.csv.
This pivot code is entered in the setup of the interface.

field FLGITMPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Selection formula (field ITMFOR)

This field is used to specify a products selection reference, which will be suggested, by default, when launching the interface processing.

This field is used to specify a products selection reference.
This reference can be entered, by default, at the level of the interface setup function.

Product-site stock (field ITVPIT)

This field, which cannot be modified, contains the pivot code describing the lines of the Product stock - site file to export: MMSITV.csv.
This pivot code is entered in the setup of the interface.

field FLGITVPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Stock journal (field STJPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Stock journalto export: MMSSTJ.csv.
This pivot code is entered at the level of the interface setup.

field FLGSTJPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

End date (field STJENDDAT)

A date range can be entered to limit the stock journal exported.

This range is limited by:
- an end date
- a start date

End date: It is either possible to enter a fixed end date, or to indicate that the end date taken into account must correspond to the current date.
Start date: It is either possible to enter a fixed start date or to indicate the number of days to take into account before the end date.
Current date (field STJEDTFLG)

This checkbox can only be accessed if any end date has been entered. It is then automatically activated.
The end date taken into account to determine the period concerned by the stock journal export, will systematically be the same as the current date.

field FIL030701
With MMS movement (field STJMMSFLG)

When activated, this box indicates that during the stock journal export, the movements coming from the MMS (previously imported) have to be exported.

Start date (field STJSTRDAT)

A date range can be entered to limit the stock journal exported.

This range is limited by:
- an end date
- a start date

End date: It is either possible to enter a fixed end date, or to indicate that the end date taken into account must correspond to the current date.
Start date: It is either possible to enter a fixed start date or to indicate the number of days to take into account before the end date.
End - no. days (field STJNDSTR)

This field can only be accessed if any start date has been entered. It is used to enter the number of days taken into account before the end date to determine the period concerned by the stock journal export.

Suppliers (field BPSPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Suppliers to export: MMSBPS.csv.
This pivot code is entered at the level of the interface setup.

field FLGBPSPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Selection formula (field BPSFOR)

This field is used to specify a supplier selection formula.
This formula can be entered, by default, at the level of the interface setup function.

Supplier contact (field CNTBPSPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the ContactsSuppliersto export: MMSCNTBPS.csv.
This pivot code is entered at the level of the interface setup.

field FLGCNTBPSP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Supp. classification (field CLSBPSPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Classification Suppliersto export: MMSCLSBPS.csv.
This pivot code is entered at the level of the interface setup.

field FLGCLSBPSP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Supplier product (field ITMBPSPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the ProductsSuppliers to export: MMSITMBPS.csv.
This pivot code is entered in the setup of the interface.

field FLGITMBPSP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Projects (field PJTPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Projects to export: MMSPJT.csv.
This pivot code is entered at the level of the interface setup.

field FLGPJTPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Units of measure (field STUPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Projects to export: MMSPJT.csv.
This pivot code is entered at the level of the interface setup.

field FLGSTUPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

UOM conversion (field TCOPIT)

This field, that cannot be modified, contains the pivot code describing the file lines of the Units conversion to export: MMSTCO.csv.
This pivot code is entered at the level of the interface setup.

field FLGTCOPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Users (field USRPIT)

This non modifiable field contains the pivot code describing the lines of the Users file to export: MMSUSR.csv.
This pivot code is specified in the setup of the interface.

field FLGUSRPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Status of requests (field STAPSHPIT)

This field, that cannot be modified, contains the code of the pivot describing the lines of the Requests progress file to export: MMSSTAPSH.csv.  
This pivot code is entered in the setup of the interface.

field FLGSTAPSHP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Batch task

This function can be run in batch mode. The standard task MMSINT is provided for that purpose.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation