Entering Additional 845 Document Information

Use additional documentation information to define additional parameters required to process an 845 pricing contract for an EDI trading partner.

To enter additional 845 document information:

  1. Display pricing contracts in the 845 Contract Upload Queue.

  2. Select a line from a vendor whose 845 document information you want to update.

  3. From the Edit menu, select EDI Additional Document Information to display the EDI Additional Document Information window for the vendor.

  4. Enter the following information:

Note: Use the Product Matching hot key to define how you want the EDI 845 to determine matching priorities on the product data. This is new in Release 9.0.5.

Field

Description

Grp/User to Review Received Document

Enter the ID of the person or message group to notify when an EDI transaction is received.

Grp/User to be Notified of Document

Enter the ID of the person or message group to notify when an EDI transaction is received.

Alternate Interchange ID

Identify a test ID (or alternate production ID) for your trading partner. It follows the same format as the group number. Use this field instead of setting up a separate profile for the purpose of testing with your partner.       

Note: When entering EDI Trading Partner Maintenance and entering a Trading Partner ID number, the IDs listed include this Alternate Interchange ID. We recommend that you always choose the main profile and get to the Alternate Interchange ID through the main profile, not by selecting the alternate interchange at this point.

Cost/Price Matrix

Select from the following options for how you want to handle matrix creations based on the incoming document from your trading partner:

  • C - Cost Only Matrix - This option creates a cost-only matrix with matrix type 'O.'  

  • P - Price Only Matrix - This option creates a price-only matrix which restricts cost values from EDI.

  • B - Cost and Price Matrix - This option creates a matrix with both options. This is the default.

Default Selling Formula

Enter the pricing formula, if the vendor always uses the same formula for determining your selling price for 845 pricing contracts.

The system populates the Formula column in the Sell Price view on the 845 Contract Detail with this formula.

You can override the formula for individual customers in the Formula field on the Contract Upload Settings screen in Customer Maintenance or for individual 845s in the Formula column of the Sell Price view of the 845 Contract Detail.

Update COMM-COST on Sell Matrix

Indicate whether the system should upload and update the COMM-cost in addition to the COGS cost.

If set to Yes, the system applies the formula and basis for the rebate cost of goods sold (COGS) to the rebate COMM cost, and from the direct COGS to the direct COMM cost.

Invert Multiplier

Specify whether the vendor sends straight multipliers or an inverse multiplier in their inbound 845 documents. The multiplier is a number that the vendor sends in the 845 that is used in the pricing matrix formula to calculate the rebated cost that is applied to a product when it is sold. The vendor can send the multiplier in one of two formats:

  • Actual multiplier - For example, the formula is sent as 0.55 and the value used in the pricing matrix formula is the exact same value. In this case, set this field to No to indicate in the formula that you want to use 55% of the amount.

  • Inverse multiplier - For example, the formula is sent as 0.55, but it needs to be inverted to 0.45. In this case, set this field to Yes to indicate in the formula that you want to use 55% off the amount.

Auto Create 845 Renewal SPA

Enter Y to let the system create renewals automatically for special pricing agreements (SPA). The system conducts the same checks as if you were processing it manually through the 845 Contract Upload Queue.

Default Global SPA COGS Basis

Enter the cost-of-good-sold (COGS) basis you want the system to use when automatically processing SPA agreements.

Default Global SPA Direct COGS Basis

Enter the direct cost-of-good-sold (COGS) basis you want the system to use when automatically processing SPA agreements.

Sell Groups

Use the Sell Groups hot key to display the Sell Group Translation screen, where you list the vendor's product groups and map them to Eclipse sell groups.

  • In the Vendor Group column, enter the vendor's product groups.

  • In the Sell Group column, for each vendor group, select or enter the corresponding Eclipse sell group.

  • Use the Group Matrix hot key, as needed, to display the Buy/Sell Group Maintenance screen, where you can create new Eclipse sell groups.

Enable Product Matching Priorities

New in Release 9.0.5

Indicate if you want to match your products when receiving EDI 845 documents by other parameters than by UPC or EAN codes.

You can decide which options on which to match and in what order giving you more control over your product matching priorities. Set this option to Yes to activate the Product Matching hot key. For more information about this option, see Defining Product Matching Priorities for EDI.

By leaving this set to No, the system works as designed prior to Release 9.0.5 using the UPC and EAN codes on 845 documents.

Ignore Purpose Code for Auto Creation

In conjunction with the Auto Create 845 Renewal SPA option above, you can set this option to Yes to only bypass the EDI 845 Contract Review Queue and automatically update the sell matrix records. This requires the second field value in the Beginning Segment for Price Authorization Acknowledgement/Status (BPA) be set to 04.

The default is No.

If this option is set to Yes, the system addresses the following:

  • If Sell Matrix records already exist for the specified contract and product, then the system automatically sets the existing records to expire the day before the new contract records are set to take effect, and creates new Sell Matrix records for the updated contract information.

  • If Sell Matrix records do not already exist for the specified contract and product, then the system  automatically creates new Sell Matrix records for the contract information.

  • If the system is unable to match a part number (UPC or vendor catalog) in the 845 data, then the 845 contract information for only the product(s) that the system was unable to match goes to the EDI 845 Contract Review Queue.

  1. Save your changes and exit the window.

To enter sell groups for the vendor:

  1. From the EDI Additional Document Information window, select Sell Groups from the Edit menu to display the EDI Sell Group Translation window, where you list the vendor's product groups and map them to Eclipse sell groups.

  2. In the Vendor Group column, enter the vendor's product groups.

  3. In the Sell Group column, enter the corresponding Eclipse sell group.

  4. If you need to create new sell groups, select Edit > Group Maintenance to display the Buy/Sell Group Maintenance window.

  5. Save your changes and exit the window.

See Also:

Receiving EDI 845 Price Authorization Acknowledgments Overview

Entering Additional EDI Document Information