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=snx3op-ecdbazfinw-31ae528019980b4dff71c5811b19f2ad146dc7a0

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=snx3oi-jferzjhldk-9cc476e29d7a1efc15b8a82242fbd6ca6f992768

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=snx3or-kccccbriqy-b161d47a3d832f57590dcf1b1346e4384c324f93

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=snx3op-qokaspynoy-4cc2a22d3521357f47b630f7fe01d6658e4cc1fc

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=snx3oo-xrmqctxtgk-883bd85d2303c706b7944f3813f35c4014e9b49c

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=snx3oj-qfjggseyyv-c5b0b035fcf474d156fc505972455f491e5e204c

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=snx3or-auggnepmtf-3ab4e0b7fb5a54a1bb7e237c720988266d9dc175

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=snx3on-aazntboiwg-503eb3706a8b1d00a52225e1ccc4642ac0bf7cd7


Helpful Unhelpful