EDI Import

EDI Import

EDI Import Overview

"EDI Import" enables you to access the invoice's EDI files sent by the vendor and process the invoice using it.
FTx Cloud POS offers you the below three options to process the invoice: 
  1. You can "Apply" the invoice from the "Invoices" module.
    1. It will update the product counts in the system. 
    2. If there is any change in the product cost, the system will prompt a message to update the cost. If you confirm, the system will update it in "Products."
    3. You can download the PDF file and use it for further processing. 
    4. To learn how to create and apply an invoice, please read Invoices. 
  2. You can convert a purchase order to an invoice from the "Purchase Orders" module.  
    1.  To learn how to create a purchase order, please read Purchase Orders. 
  3. You can process the invoice through "EDI Import."
Prerequisites: You must have completed the EDI Setup process for the vendor and ensure the FTP Connection is working.

    1. Please read EDI Setup to complete the EDI Setup for a vendor.
    2. To learn how to set the FTP Connection for a vendor, please read FTP Connections. 
  1. The vendor sends you the invoice's EDI file. You can fetch it in "EDI Import" and process the invoice.

"EDI Import" enables you to: 


  1. Search the invoice's EDI file sent by the vendor
  2. Manually upload the invoice's EDI file 
  3. Process the invoice 

1. Reaching "EDI Import"

  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Inventory
  4. Step 4: Choose Receiving
  5. Step 5: Choose EDI Import

2. Understanding "EDI Import" Layout

  1. Please refer to Figure A and the descriptions of the buttons and fields below to understand the layout of "EDI Import." 

           Figure A
Fields:
1: Select Location: This drop-down helps you to select the location for which you need to search or process the invoice. 
2: Select Vendor: This drop-down helps you select the vendor you need to search for to process the invoice.  
3.1: EDI Setup: This button navigates you to the "EDI Setup" module. 
3.2: Search Invoices: Once you select the location and vendor, this button lets you search for related invoices.   
3.3: Manual Upload/Import: This button helps you upload the EDI files manually.   
4: EDI Files to Process: This section shows the fetched EDI files. 
4.1: File Details: This section shows details of the selected EDI file. 
5: Process Invoice: This button lets you process the invoice. 
6: Manually Override Invoice Date: This button lets you change the invoice date. The system will consider the current date to process the invoice. You can manually change it using this toggle button. 

3. Processing the Invoice

To process the invoice, search the invoice's EDI file for the particular vendor and location, and then process it. 

3.1 Searching Invoices

Please follow the steps below to search for the invoice. 
  1. Select the location using the Select Location drop-down, select the vendor using the Select Vendor drop-down, and click the Search Invoices button highlighted in Figure B. 

Figure B
  1. The system will fetch the EDI file and show it under EDI Files to Process, as Figure C shows. 

Figure C
  1. If the chosen vendor has sent multiple EDI files, the system will show all of them under EDI Files to Process.
  2. Click on the required file to select it. The File Details section will show its detailed information.

3.1.1 Manually Upload the Invoice EDI

If the vendor has sent the Invoice EDI file via email or any other medium, you can manually upload it to the system. Please follow the steps below to upload the EDI file manually. 
  1. Click the Manual Upload/Import button highlighted in Figure A.
  2. The Upload EDI File screen will appear, as Figure D shows.

Figure D
  1. Click the "Choose File" button to select and upload the EDI file.
  2. Once the EDI File is uploaded, the Upload EDI File screen will look like Figure E.

3.2 Processing the Invoice  

Please follow the steps below to process the invoice. 
  1. Select the EDI/invoice you need to process.
  2. Click the "Process Invoice" button shown in Figure C.
  3. The Process Invoice message will appear, as Figure E shows. 

Figure E
  1. The system may show the Process Invoice From PO screen depending on how the order was created. Please select the applicable PO (Purchase Order) from the drop-down and click "Continue."

Figure F
  1. The system will process the invoice and show the success message, as Figure G shows. The processed invoice will be available in the list of invoices in "Invoices.

Figure G
  1.  If you click the "Go to Invoice" button, the system will navigate you to the respective Edit Invoice screen in "Invoices."

3.2.1. Manually Overriding the Invoice Date

The system will consider the current date to process the invoice. Please follow the steps below to change it. 
  1. Enable the "Manually Override Invoice Date" button, highlighted in Figure H, and click in the Date field. A drop-down calendar will appear. Choose the required date and process the invoice, as "3.2 Processing the Invoice" explains.   

Figure H

    • Related Articles

    • EDI Setup

      EDI Setup Overview EDI Setup is an automated process for letting the vendor know what the retailer (store) wants to order. Vendors will get the purchase order (PO) from the retailer as per the EDI Setup (EDI File). Once the vendor processed the ...
    • Lottery Games

      1. Lottery Games Overview A lottery game involves lottery tickets and drawing numbers at random for a prize. A lottery ticket is treated as a regular product and assigned a UPC. See Figure 1.1. Figure 1.1 Figure 1.2 below shows the product details ...
    • Invoices

      Invoices Overview Receiving invoices is an efficient method for updating store inventory levels. It establishes a traceable inventory movement trail against vendors, including quantities and costs. Additionally, invoices aid in projecting inventory, ...
    • Vendors

      Vendors Overview Vendors need to be set up in the system (Control Center) before you will be able to make purchase orders and utilize invoices. You can create purchase orders by choosing the specific vendor you wish to order from. When utilizing ...
    • FTP Connections

      FTP Connections Overview Configure the FTP Connections to send/receive files for purchase orders/getting invoices, respectively. FTP Connections is a server-side setting to send/receive files by implementing the automated process. You need to ...