EDI Import Overview
"EDI Import" enables you to access the invoice's EDI (electronic data interchange) files sent by the vendor and process the invoice using it.
FTx Cloud POS offers you the below three options to process the invoice:
- You can "Apply" the invoice from the "Invoices" module.
- It will update the product counts in the system.
- 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."
- You can download the PDF file and use it for further processing.
- To learn how to create and apply an invoice, please read Invoices.
- You can convert a purchase order to an invoice from the "Purchase Orders" module.
- To learn how to create a purchase order, please read Purchase Orders.
- You can process the invoice through "EDI Import."
Prerequisites: You must complete the EDI Setup process for the vendor and ensure the FTP Connection is working.
- Please read EDI Setup to complete the EDI Setup for a vendor.
- To learn how to set the FTP Connection for a vendor, please read FTP Connections.
- 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:
- Search the invoice's EDI file sent by the vendor
- Manu
ally upload the invoice's EDI file - Process the invoice
Reaching "EDI Import"
- Step 1: Log into Control Center
- Step 2: Choose Point of Sale
- Step 3: Choose Inventory
- Step 4: Choose Receiving
- Step 5: Choose EDI Import
Figure 0.0
Understanding the "EDI Import" Layout
Please refer to Figure 0.1 and the descriptions of the buttons and fields below to understand the layout of "EDI Import."
Figure 0.1
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. Buttons:
- EDI Setup: This button navigates you to the "EDI Setup" module.
- Search Invoices: Once you select the location and vendor, this button lets you search for related invoices.
- Manual Upload/Import: This button helps you upload the EDI files manually.
4: EDI Files to Process: This section shows the fetched EDI files.
- File Details: This section shows details of the selected EDI file.
5. Refresh: This button is used to refresh the invoice details.
5: Process Invoice: This button lets you process the invoice.
- Invoice #: It is auto-fetched while processing.
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.
1. Processing the Invoice
To process the invoice, search the invoice's EDI file for the particular vendor and location and then process it.
1.1 Searching Invoices
Please follow the steps below to search for the invoice.
- 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 1.1.0.
Figure 1.1.0
- The system will fetch the EDI file and show it under EDI Files to Process, as Figure 1.1.1 shows.
Figure 1.1.1
- If the chosen vendor has sent multiple EDI files, the system will show all of them under EDI Files to Process.
- Click on the required file to select it. The File Details section will show its detailed information.
All the invoices that have missing information such as Vendor part, Product, UPC and Name will be highlighted in red text in the “File Detail” section, and a "Add" button is displayed beside each highlighted item reducing manual entry and improving accuracy.
When the user clicks Add for a missing vendor part:
- The system opens the existing Add Vendor Part page.
- The system pre-populates all available fields from the EDI file, including:
- Vendor Part Number (when available)
- UPC (when available)
Users can edit/update the pre-populated values before saving.
Note: The UPC field is pre-populated if the product already exists in the system.
If the product does not exist, the user can still create a new product using the existing Add button next to the Item dropdown.
1.1.1 Create New Product from the Add Vendor Part Window
If the product does not exist, you can still create a new product using the existing Add button next to the Item dropdown.
- Click Add to create a product
- The system opens the existing Create Product popup.
- The popup now pre-populates available product details from the EDI file, such as:
- UPC
- Name
- You can edit the pre-populated details and enter missing required information, including:
- Category
- Manufacturer / Brand
- Department
- Pricing details
This makes the EDI Import – Invoice workflow faster and more user-friendly by automatically filling in as much product and vendor part data as possible from the EDI file, minimizing manual effort and reducing data entry errors.
1.1.2. 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.
- Click the "Manual Upload/Import" button highlighted in Figure 0.1.
- The Upload EDI File screen will appear, as Figure 1.1.1.0 shows.
Figure 1.1.1.0
- Click the "Choose File" button to select and upload the EDI file.
- Once the EDI file is uploaded, the Upload EDI File screen will look like Figure 1.2.0.
1.2 Processing the Invoice
Please follow the steps below to process the invoice:
- Select the EDI/invoice you need to process.
- Click the "Process Invoice" button shown in Figure 1.1.1.
- The Process Invoice message will appear, as Figure 1.2.0 shows.
Figure 1.2.0
- 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 1.2.1
- The system will process the invoice and show the success message, as Figure 1.2.2 shows. The processed invoice will be available in the list of invoices in "Invoices."
Figure 1.2.2
- If you click the "Go to Invoice" button, the system will navigate you to the respective Edit Invoice screen in "Invoices."
For guidance on performing an EDI Import,
please view the linked video. 1.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:
- Enable the "Manually Override Invoice Date" button, highlighted in Figure 1.2.1.0, and click in the Date field. A drop-down calendar will appear. Choose the required date and process the invoice, as "1.2 Processing the Invoice" explains.
Figure 1.2.1.0
2. FTx Academy Training Course
To gain a more comprehensive understanding, sign up for the FTx Academy training program — enroll in the courses and explore the topic lesson by lesson and reinforce your learning with quick quizzes at the end of each module.
Related Articles
EDI Import (Employees)
Overview "EDI Import" allows you to access and process the vendor-provided EDI (electronic data interchange) files for invoices. FTx Cloud POS offers the following three options for processing invoices: 1. Apply the Invoice (Invoices Module) This ...
EDI Setup
EDI Setup Overview EDI Setup is an automated process that enables a retailer to communicate purchase orders (POs) to vendors electronically. Through this setup, vendors receive POs in a standardized EDI (electronic data interchange) file format, ...
Import Utility
Overview Import Utility is a powerful feature that enables you to import data into the system from an external file in a supported format (CSV). This utility allows you to add or insert bulk data across various system methods efficiently, saving time ...
Vendors
Vendors Overview Before using the "Purchase Orders" or "Invoices" module, vendors must first be set up in the Control Center. This setup ensures that purchase orders can only be created by selecting a specific, pre-configured vendor. As a result, ...
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, ...