|
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.
The
MAXIMUM PERCENTAGE OF CHANGE WARNING is in 35-36 in the PU52 parameter card. It
controls by facility warehouse if a warning message should
appear on PU55 if the cost change is too much.
5.
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.
6.
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.
7.
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.
8.
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.
9.
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.
10. 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.
11. 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.
12. 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.
13. 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.
14. 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:
15. 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.
16. If
the effective date is
prior to today's date then use today's date.
17. If
the order date is provided, use it for the effective
date.
18. 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.
19.
Method of transportation is
not used to match cost changes.
20.
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.
|
