The following guide will describe how to import purchase orders from a CSV or Excel file to M3.

The following input data:

Giving this CSV-file:

BAOR,MSGN,FACI,WHLO,SUNO,DWDT,PUNO,PNLI,ITNO,ORQA
FCM,0000000013,A01,101,Y00001,20171101,,,Y1005-Y04-028,111
FCM,,A01,101,Y00001,20171101,,,Y1005-Y04-030,222
FCM,,A01,101,Y00001,20171101,,,Y1005-Y05-028,333
FCM,,A01,101,Y00001,20171101,2000094,,Y1005-Y05-030,444

Create new function with the VXL configurator:

Input function metadata and click next

Select the CSV file and input information on the file:

Field separator: The char that separates the fields. Typically , or ; (Note: when using an Excel file this is not needed)

Decimal separator: For double/decimal value. , or . (Note: when using an Excel file this is not needed)

Task name: The name of this import task

Header start row: Which row is the header located. This is usually 1 for CSV files

Data start row: The row the data start. Usually the row after the header row.

Start and end column: Start and end column for the data. Used for later reference. Auto-suggested

Message column: Last message from the M3 API will be written here.

Input sort columns if the CSV file is not already sorted.

Add Step: Usually an import consists of multiple steps. For this example we are planning to use PPS370MI, the API for purchase order batch entry. To import a purchase order one has perform these steps: