Sales Order updation in Sage X3 using EDI 860 documents

By | November 4, 2023

EDI 860, also known as a Sales Order Change Request, is sent from a buyer to a seller when the buyer needs to make changes to their EDI 850 Purchase Order. This electronic data interchange transaction helps streamline trading partner communications, so changes can be tracked and made easily.

EDI 860 documents need to match the information found on the EDI 850 Purchase Order, and indicate the changes needed, and reasons for the changes. Data found on the EDI 860 document include:

  • Purchase Order number
  • Buyer and seller information
  • Product quantities and descriptions
  • Quantity and product type changes
  • Price changes
  • Addition or deletion of products
  • Rescheduling of the order/desired delivery date
  • Indication of reasons for change

Using EDI 860 makes it easy to change orders without needing to cancel an order and create a new EDI 850 transaction. It also creates a virtual paper trail, so vendors and buyers can easily reconcile order changes and discrepancies. Automated EDI also helps by eliminating the need for time-consuming retyping and reducing the potential for errors. 

Sending change requests with EDI 860 is also more secure than using an email or PDF document. EDI software providers often use technology like data encryption, HTTPs or FTPs protocols and portal user authentication to keep sensitive business details safe. 

Key Features:

Key features for the process of programmatically picking the EDI file from a defined location and creating a Sales Order transaction in Sage X3 are as follows:

  1. File Copy: The EDI file will be programmatically copied from the defined location, such as FTP, SFTP, or a network path, and saved in the Sage X3 local file format. This ensures that the file is accessible within the system for further processing.
  2. File Conversion: Based on the defined mapping, the EDI file will be programmatically read and converted into a Sage X3-compatible template. This conversion ensures that the file can be processed and understood by the system.
  3. Sales Order Creation: Once the Sage X3 template is ready, a Sales Order will be created using the details from the file, such as item, price, quantities ordered, shipping details, payment terms, discounts, and any other relevant information. The system will display a log to provide visibility into the process and any potential errors or notifications.
  1. File Deletion: After the successful processing of the EDI file, it will be deleted from the source location. This helps maintain a clean and organized file management system.

These key features enable the seamless integration of EDI files into Sage X3, facilitating the updation of sales orders. The process can be customized to fit specific business requirements and can be executed either manually or automatically for enhanced efficiency.

The 860In (Sales Order Updating in Sage X3) process automates the sales order updating from an EDI file. It involves file pickup from a defined location, conversion to Sage X3 format, and creating an archive for backup. The system then maps and converts the data, generates a sales order, and displays a log. The original file is deleted. This automated process enhances supply chain management in Sage X3.

About Us

Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.