True Commerce EDI File Import/Export

Overview

True Commerce offers a cost-effective EDI solution. They charge a fixed fee for each import and export template, regardless of the number of trading partners you have.

Importing EDI 850

Work with True Commerce on an exported CSV file. See the following for a sample.

EDI 850 Template with Sample Data 032023.csv

To import the CSV file, go to the GoldFinch Conversion app and execute the following:

1. In the Import True Commerce Orders tab, click Import CSV.

   

2. Click Choose File to select the .CSV file, and then click Upload File.

   
   

3. After importing the .CSV file, go to the Import EDI Sales Order list.

4. Click the Not Processed view, and then click Create Sales Order.

   

5. The Create Sales Orders routine verifies all the errors.

   1. Customer Name must exist in the Account table.

   2. Carrier Name must exist in the Shipping Agent table.

   3. Item No. (using the Status field) must exist in the Item table.

   4. Item Unit of Measure (using Bill To Name field) must exist in the Item Unit of Measure table.

   5. The routine does not check Alternate Shipping.

   6. The routine verifies duplicate PO Numbers in the current batch. It does not verify duplicate PO Numbers against the previous batches or existing sales orders.

      
      

6. The Create Sales Orders routine starts creating sales orders when all errors are rectified.

   When creating sales orders:

   1. The routine retrieves Sales Prices and Line Discount % from the configuration.

   2. The EDI Unit Prices and EDI Discount % are updated in two separate fields and the EDI Line Amount and Line Amount are compared.

      1. If the values are different, EDI Price Discrepancy field on the Sales Line is checked.

      2. Sales orders with No. of EDI Price Discrepancies greater than 0 must be reviewed before creating Whse. Shipments.

Exporting EDI 810

1. After creating and posting EDI invoices, click EDI Invoices 810 Not Created view, select the invoices to be exported, and then click Generate XML.

   1. You must work with True Commerce on the XML file format first.

   2. Then contact GoldFinch to add the Generate XML button and related code to your instance.

1. Click Step 1- General XML Document to generate an XML file for the selected sales invoices.

   The routine checks the following for these documents:

   1. Must be a posted document.

   2. Must not be a credit memo.

   3. The Shipment field must not be blank.

   4. Must be an EDI Invoice.

   5. EDI Invoice Generated must not be checked.

   The XML file will be downloaded to your local folder if there are no errors.

   

2. After downloading the XML file, click Step 2- Update EDI invoices Generated Fields to select the EDI Invoice Generated field, and provide the current date in the EDI Invoice Generate Date.

Article True-Commerce-EDI-File-Import-Export  ·  Last updated October 04, 2025 · GoldFinch ERP Help Center