Exibir origem

Import

The import routine allows inflow imports, from a file created by another system.

Correct inflows are saved in the QEK file and the incorrect ones are retained in the inconsistent inflows file (QEP).

The Event Log lists correctly imported inflows in the system, divided in two groups, according to skip-lot evaluation: inflows to inspect and in skip-lot. Incorrect inflows are also listed, as are their respective inconsistencies.

After running the Import routine, you can print the Product forms, of inflows to inspect.

Another way to register inflows in the system is through the Inventory/Costs Environment and the Purchasing Environment, when registering the Purchasing Invoice. However, to obtain such integration between modules, you need to:

•	In the Product Registry, in the Inventory/Costs Environment and the Purchasing Environment, in the C.Q. Type field specify Q (Quality), and in the Track field either L (Lot) or S (Sublot);

•	Activate the MV_RASTRO parameter with an Y (Yes) content, through the Configurator Environment, enabling traceability control.

The .txt file format to import obeys the following form:

Field	Type	Size	Description
Supplier	C	06	Supplier Code
Supplier Store	C	02	Supplier's Store
Product	C	15	Supplier Code
Inflow Date	C	08	Inflow Date (AAAAMMDD)
Inflow Time	C	05	Inflow Hour (HH:MM)
Lot	C	16	Lot Number
Inflow Document	C	15	Inflow Document
Lot Size	C	08	Lot Size
Lot Sample Size	C	08	Lot Sample Size
Order Number	C	10	Order Number

Procedures

To Import Inflows:

1.	In the Inflow Import window, complete the parameters according to field help instructions, especially the following parameters:

•	Perform Import?

Select the import method, whether through the Normal file or TXT text file format.

•	TXT File Path?

If you completed the previously mentioned Perform Import parameter with the TXT option, enter the file path where this file is found.

Example:

\SERVER\IMPORT\\RECEIPTS\

•	TXT File Name?

If you completed the previously mentioned Perform Import parameter with the TXT option, enter the name of TXT file to be imported, found according to TXT File Path parameter data.

•	Display Import Log?

Select Yes for the system to display onscreen the import result data, which files were imported, etc., upon completion of import procedure. Otherwise, select No.

•	Print Event Log?

Select Yes for the import procedure events to be printed, when importing is finished. Otherwise, select No.

2.	Check data and confirm them.

The system performs the importing of material receipt files.