EDI Programs And Requirements

879 Price Information

Vendor and Division Guideline

The goal of the EDI Cost Change System is to process cost changes that the vendors submit to a Kroger Division. This document describes the logic of the Divisional programs.

Method of transportation is not used to match cost changes. Although vendors might provide it to us EDI, it is not being sent by EDI to WMS. The programs were written to use the WMS method of transportation if EDI did not provide it. Since EDI never sends method of transportation the programs always display the WMS method of transportation.

When Bracket #1, Bracket #2, Bracket #3, and Bracket #4 are zero on the VORD screen, the WMS item is considered to be UN-BRACKETED. When EDI sends only on cost for an item, the EDI item is considered UN-BRACKETED. The programs will match un-bracketed items with regard to the bracket amount on the EDI bracket.

If WMS is un-bracketed and EDI is not, the bracket amount from EDI needs to match the WMS bracket amount on the VORD screen.

If WMS has four brackets, EDI will need to match all four or no cost changes will be processed for that item. The same is true for two or three brackets.

Unit of measure is sent by EDI. The program will match the BRACKET WT CODE from the VORD screen with the EDI weight code. If EDI does not provide a weight code the program will use the WMS weight code. If EDI provides a weight code that does not match WMS, the cost change will not process.

If EDI has a cost change that is the same as the cost already in the system, the program will not match change. If WMS has four brackets and three matched, but one does not, because the cost was already the same, the item will be rejected.

  1. The DEALS EDIT OPTION in position 31 in the PU52 parameter card controls by facility warehouse the outcome if the effective date occurs during a deal or contract, "1" will reject a cost change effective during a deal. "2" will change the effective date to the date after the deal ends. "3" will accept the cost change as is. "4" will accept the cost change if it is a decrease.
  2. The BRACKET MATCH FLAG in position 32 in the PU52 parameter card controls by facility warehouse how UN-BRACKETED EDI COST changes are match to WMS. "Y" says that the EDI bracket does not have to equal the WMS bracket to match. "N" says that they must be equal, except if the WMS bracket is zero.
  3. The MAXIMUM PERCENTAGE OF CHANGE ALLOWED is in 33-34 in the PU52 parameter card. It controls by facility warehouse if a change is to be rejected, because the change is too much.
  4. WMS can have costs for up to 4 brackets. BRACKET #1 must have a cost before BRACKET #2 and #2 must have a cost before #3 or #4. The BRACKET #1 cost is usually the highest cost.
  5. When BRACKET #1, BRACKET #2, BRACKET #3, and BRACKET #4 amounts are zero on the VORD screen, the WMS item is consider to be UN-BRACKETED. All UN-BRACKETED items must have the cost under BRACKET #1. Costs in BRACKET #2, #3, and #4 are ignored for WMS UN-BRACKETED items.
  6. When EDI sends only one cost for an item, and the PU52 BRACKET MATCH FLAG is equal to "Y", the program will match EDI items without regard to the bracket amount on the EDI bracket, WMS bracket, or the unit of measure. In order to match, WMS BRACKET #2, #3, and #4 must be zero.
  7. When EDI sends only one cost for an item, and the PU52 BRACKET MATCH FLAG is equal to "N", the program will match EDI items where the WMS bracket is zero or equal to the EDI bracket.
  8. When EDI sends more than one cost for an item and WMS is UN-BRACKETED, the bracket amount from EDI needs to be zero in order to match WMS.
  9. IF WMS has four brackets, EDI will need to match all four or no cost changes will be processed for that item. The same is true for two or three brackets.
  10. if EDI has a cost change that is the same as the cost already in WMS, the program will not match change. If WMS has four brackets and three matched, but one does not, because the cost was already the same, the item will be rejected.
  11. EDI can have up to ten brackets. If two or more are have a bracket amount of zero, the item will be rejected. If any two brackets have duplicate bracket amounts, they will be rejected only if they match a WMS bracket.
  12. Unit of measure is sent by EDI. The program will match the BRACKET WT CODE from the VORD screen with the EDI weight code. IF EDI does not provide a weight code the program will use the WMS weight code. If the EDI bracket amount is zero, the weight code is ignored. If EDI is UN-BRACKETED, the weight code is ignored. If EDI provides a weight code that does not match WMS, the cost change will not process.
  13. The effective date of the cost is calculated from today's date, the EDI order date, the EDI ship name, the LEAD TIME from VORD, the parameter cards input to PU52, and knowledge of the day of the week for all of the above.

    Has the possibility of changing the effective date sent by a vendor:

  14. The parameter cards for PU52 control the day of the week of the effective date. If you want a date that fell on Sunday to be automatically changed to Monday you would put a "+001" in the Sunday column. If Sunday needs to fall back to the previous Friday, put a "-002" in the Sunday column. These cards override all of the other date logic.
  15. If the effective date is prior to today's date then use today's date.
  16. If the order date is provided, use it for the effective date.
  17. If the ship date and order date are provided, use the order date for the effective date. If the ship date is provided, the lead days from VORD are subtracted from the ship date not counting Saturdays and Sundays. The effective date is adjusted by the parameter card and cannot be prior to today or today is used.
  18. Method of transportation is not used to match cost changes.
  19. Matched future cost changes can be altered by the CICS transaction "FCOS".

    The data from the EDI Vendors is processed and sent to the KMA Mainframe around 8:00 P.M. (E.S.T.) Monday through Friday. The KMA program that processes this data is run around 10:30 P.M. (local time) Monday through Thursday and Saturday. Times will vary by KMA.

    Valid EDI Cost changes sent by a vendor on Tuesday before 5 P.M. will appear on:

    { PU50 on Tuesday night (invalid changes will also appear on this report)

    { FCOS on Wednesday morning

    { Deals will show the cost change on Thursday morning.

    If a cost change did not process correctly division needs to:

    1. Look the item up on FCOS. Correct FCOS items in FCOS.
    2. Look for the item in the PU55 report (PU50) in INFOPAC. Correct errors appearing in the PU55 report. Contact the vendor to correct their data and re-transmit it. If PU55 allowed a bad cost change to process, it will need to be corrected in FCOS.
    3. Look at the UCS0700.707 report. Contact the vendors with errors in this report and have the vendors correct their data and re-transmit it.