Skip to main content

EDI 860 - Purchase Order Change Request - Knowledgebase / SalesPad / EDI - Cavallo Technical Support

EDI 860 - Purchase Order Change Request

Authors list

Overview

The EDI 860 Purchase Order Change Request document is used when a customer needs to request changes to an existing order that they previously submitted as an 850 Purchase Order. This can include changes to the order and its sales lines, as well as sales line additions and cancellations, and changes to sales line cross dock information. These changes are imported as pending change requests, which can then be reviewed and accepted or rejected as applicable.

Prerequisites

Before continuing with EDI 860 setup, make sure EDI is properly configured in SalesPad by reviewing the following documentation:

Data Cross Reference

Select the EDI tab in the ribbon and open the Data Cross Reference screen.

CWTuLgG5F0sr7KPQdvyujFyds3TuGz1fHfdarbpM6rdxnXuq3ssDgNTy9RI8Jwo-yIbD_wTAQmp6tZx80orOPzktGNbUZwOiqyII.png?access_token=sncl9i-mrqiacvnwi-0601613d919153c330a4eefcc87db0d6a10bc9e3

It is likely that the Trading Partner used on incoming 860 documents already exists in the Data Cross Reference setup, because the sales document that needs to be updated was originally created by an inbound 850 for that same Trading Partner. If this is the case, select the trading partner’s row and make sure the 860 is also selected in the EDI column.

If this is a new Trading Partner, click the New button to add a new trading partner and set the following columns: Trading Partner ID, Partnership, Customer Num, and Warehouse. Make sure that 860 is selected in the EDI column, and that Is Enabled is checked.

From there, the rest of the Data Cross References need to be added. For more information on setting up Data Cross References, refer to the following documentation: Data Cross Reference.

Business Object Mapping

Select the EDI tab in the ribbon and open the Business Object Mapping screen.

KKuUGQg37y1oCl-y5ch_1FUc_wjJY5jdc6JV2nEiZsHg9Pnb26ZHTP2E4VONLQ74fSpEdjBK4FfNTS9OvC_maYyFybKQA8G01llE.png?access_token=sncl9d-npqzeoxvzp-934417392d0d70697402dd5b222e683382d88b2b

Click the New button to add a new row and set the following columns:

Column

Value

Mapping Name

Name of the 860 transaction mapping

Provider

SPS Commerce

EDI

860

Schema Name

OrderChanges

Direction

In

Document Type

Sales Document

Document Subtype

Sales document type and ID in SalesPad

Trading Partners

Trading partners to which the mapping applies (trading partners are configured in the Data Cross Reference screen)

Is Enabled

Make sure this is checked.


The Elements section of this screen should become enabled and display default mappings which outline the most common way to set up a basic 860. This should be reviewed and updated as needed to match the expected structure with the Trading Partner. For more information on setting up the Business Object Mapping, refer to the following documentation: Business Object Mapping.

Security Editor

Open the Security Editor by going to Modules -> System -> Security Editor and make sure the following plugins are enabled as needed:

  • EDI Order Changes Sales Document

  • EDI Order Changes Sales Line Items

  • EDI Order Changes Cross Dock Sales Line

Update sub-securities as needed for each. Save all changes, log out, and log back in for changes to take effect.

IFAZofPkdAaUeecQvx1ziiS1kMlX9dtUOaSdDAA1gw-cnsLI6Adutt0p4TCZRpXlgUVqzo7CcSOHRHGJbDrYOAs0WbuP2AGZODR4.png?access_token=sncl9f-qvabtwlftz-6f788442b5ed63d06f767e8733e0b34b1339ba65

Can Accept Changes - Allows a user to accept changes to sales documents. Default: False

Can Reject Changes - Allows a user to reject changes to sales documents. Default: False

Can Reject Deletes - Allows a user to reject delete requests to sales documents. Default: False

YhhTmltJWYpJ1EJvoCu4w3o5QqWUZDg80nboMA7a_kUkSo2GGcbHIcXG_LUpeF4nYgpbSNz2fnLxZ8qH8812NeIww20Tz8hUThi8.png?access_token=sncl9e-gfsyupmvdl-cd7f031e8c0d7f0a33fa13e7b896ad0547d91ce5

Can Accept Changes - Allows a user to accept changes to sales line items. Default: False

Can Reject Changes - Allows a user to reject changes to sales line items. Default: False

Can Accept Deletes - Allows a user to accept delete requests to sales line items. Default: False

Can Reject Deletes - Allows a user to reject delete requests to sales documents. Default: False

Can Accept Adds - Allows a user to accept additional sales line items. Default: False

Can Reject Adds - Allows a user to reject additional sales line items. Default: False

Reprice Lines - Determines if updated lines should always be repriced, never be repriced, or allow the user to decide when accepting changes. Default: User Can Decide

ocNMb8QAG7xMRg4RE1qsEzIJV-O1aq4EAHF68APePsczcHSu2GjMSPk2AQV2RMJ77_ic6eO8-W0PEC2q2CYHl5PliNT_yQV49q1M.png?access_token=sncl9j-kuotqpkmrl-16cb214c76d10591eb420e0772f3282b46e26828

Can Accept Changes - Allows a user to accept changes to the cross dock sales lines. Default: False

Can Reject Changes - Allow a user to reject changes to the cross dock sales lines. Default: False

Can Accept Deletes - Allows a user to accept delete requests to cross dock sales lines. Default: False

Can Reject Deletes - Allows a user to reject delete requests to cross dock sales lines. Default: False

Can Accept Adds - Allows a user to accept additional cross dock sales lines. Default: False

Can Reject Adds - Allows a user to reject additional cross dock sales lines. Default: False

Importing An 860 Document

Once the above configuration is in place, the EDI 860 can be imported using the EDI Processing screen. In order to properly import an EDI 860 document, the following must be in place:

  • An 860 XML document must exist in the designated FTP server folder.

  • A sales document must exist in SalesPad that matches the Sales Doc Num that is defined in the 860 document. This sales document must also fit the other specifications for this trading partner, such as having the specified customer and warehouse.

Click the Receive button on the EDI Processing screen to download and process the 860 XML document.

New records will appear in the grids on the screen to indicate the status of the import. If there are any issues, then relevant error information will be included in these records. If all processing was successful, then the records will show a Processed status, and a link to the updated document will be provided in the Document Number column.

Reviewing 860 Change Requests

Sales Document Entry tabs are used to review the pending changes that were requested via the EDI 860 document. The user can then choose to accept or reject each change.

The EDI Order Changes Sales Document tab is used to accept or reject changes to the header information for the sales order. This can include changes to fields like requested ship dates, as well as billing and shipping address fields. Requested changes can be accepted or rejected en masse by checking their checkboxes before clicking the corresponding button.

8QsEN9htnqswUVSAfZghnl8xRJhNUxWgxkoi32zgrLyVer7boArJ3Hx7Misg-XPKJo5V2gr5k4nDnJtJbjeJc5NdjcPCxsgRTljs.png?access_token=sncl9j-ixeebfzurg-c19b4aefddc04310454e5b7739cb824a5f662488

Similarly, the EDI Order Changes Sales Line Items tab is used to accept or reject requested changes to the sales line items for the sales order. Changes for each line are grouped within the grid for easy visibility. If the Reprice Lines checkbox is checked when accepting line changes, each changed line will then be automatically repriced based on the changes.

ApBF_HLlb7Ljo87QqHJWRLyAP9EWDl5MJl5frc153K3XxoXHPc0yivu4vEqdTGGCp1xy8GURg4D475qGLro7E0vN8baKCVJQi9nM.png?access_token=sncl9k-nbqyxwrndj-c731e8a4015f4e9c0e68a3664960d6d536360c5d

The EDI Order Changes Cross Dock Sales Line tab lets the user accept or reject requested changes to the sales lines’ cross dock information. Changes are grouped by sales line item for easy visibility.

QIU-vrfDQatKR4iP6XZwYMKceaC6dLT-XeeuJDQ4zyH84aQzGCKa6-OiOx9voZZoM9fSiNF9-rok1JAK9813G6o8i3cO7O6OuiAY.png?access_token=sncl9i-vhzohifqxh-28aa579bc2865b79f2b49ad964e6029ccaf0d863


Helpful Unhelpful