Invenory Errors
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Invenory Errors as PDF for free.
More details
- Words: 691
- Pages: 9
INVENTORY MODULE ABC ITEMCLASS PRODUCT Item sub type ITEMTYPE ITEMMASTER
COMPANYINFORMATION UNITS COMMODITY
UNIT CONVERSION LOCATION
Item Location
No Records A/C are not maintainted. O.K. O.K. O.K. (1) “CS” Unit is not maintained in unit master though Item Master are maintained for 6 rows
Ok Ok Ok Ok Ok
Ok
(2) Duplicate key "013495” found in item master sheet but description is different for both keys
Ok
(3) Following (1054,1087,1170,2007)Commodity Keys are not maintained in Commodity Sheet though Item master is maintained.
Ok
O.K. O.K. O.K. O.K.
Duplicate Key found ( W269) in Location Sheet but other information is different.
Ok
(1) A/C are not maintainted. (2) Zeros paded to few Itemkey, does not match with Item Master.
Ok
See attachement for details. AP MODULE FOB
O.K.
SHIP VIA
O.K.
Branch
O.K.
VENDOR CLASS
A/c are not Maintained.
TERMS
VENDOR MASTER
In BME Terms key can not accept more than three character but in excel sheet more than three character terms keys are maintained.
Ok
O.K
AR MODULE FOB SHIP VIA TERRITORY CUSTOMER CLASS TERMS CUSTOMER MASTER
SALES PERSON SHIP TO
O.K. O.K. O.K. O.K O.K. (1) Territory key "MO2" is not maintained but it is defined at "Customer master" for 40 rows.
Ok
(2) Customer Class “ CANADA” is not maintained though Customer Master is maintained.
Ok
O.K. (1) Customer key “11416” is not maintained in Customer master sheet though Ship to Key is maintained . Ok
"CS " unit is not maintained in ItemKey 012703 012708 012710 012711 012712 012727
W269 W269
013495 013495
ItemKey 715046-1054 794101-1087 791820-1170 794103-2007
"CS " unit is not maintained in "Unit master"though "Item Master" are maintained for 6 rows Description APPLESAUCE PINEAPPLE FINE CUT PINEAPPLE CRUSHED PINEAPPLE CUBED PUMPKIN BANANA-SLICED-CAN (10-0148)
TLC Outside Freezer Frostyaire Searcy
RUM -138 PROOF RED STAR CUL. ALCOHOL TAX DRAWBACK - RUM
(1054,1087,1170,2007)Commodity Keys are not maintained in Commodity Sheet though "Item master" is maintained. Description Coating Chocolate Flavored Cone Coating #5046 45 lb Plastic Pail Orange Bar Base 50 gal drum with double liner Chocolate Fondant #1820 525# Steel drum with double liner Sherbet Orange (1-60) #4103 5 Gallon Plastic Pail W/BAG
ITEM MASTER Weight 42 42 42 42 42 42
PhysicalCountDays TrackSerialLot DefaultLotSize DaysToCalculateExpiration_Dt ItemType ItemSubType ItemCostMethod OversoldCostMethod PriceGroup 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S
Duplicate key found at "LOCATION" but other information are different 11400 W. Burleigh Street 507 Remington Road
Milwaukee WI Searcy AR
53222 72143
USA USA
Traca Barger
Duplicate key found at "Item master" but description is different 0 0
Weight
0L 0L
99990.00 99990.00
365.00 RM 365.00 RM
A A
S S
PhysicalCountDays TrackSerialLot DefaultLotSize DaysToCalculateExpiration_Dt ItemType ItemSubType ItemCostMethod OversoldCostMethod PriceGroup 0L 99990.00 365.00 FG A S 45 0L 99990.00 365.00 FG A S 560 0L 99990.00 365.00 FG A S 544 0L 99990.00 365.00 FG A S 49.58
ABCKey
ManufacturerCode ProductKeyCommodityKey ECCNCodeItemLengthItemWidth ItemHeight StockUnit RM CS RM CS RM CS RM CS RM CS RM CS
PurchaseUnit CS CS CS CS CS CS
Total Logistics Control 501-268-5888 FrostyAire for Frozen Foods
RM RM
ABCKey
GA EA
ManufacturerCode ProductKeyCommodityKey ECCNCodeItemLengthItemWidth ItemHeight StockUnit 1054 COAT EA 1087 FB EA 1170 FB EA 2007 SB EA
GA EA
PurchaseUnit EA EA EA EA
SalesUnit CS CS CS CS CS CS
OrderMethod RecordUserRecordDatePurchaseQCSalesCommissionKey SalesQC O N N O N N O N N O N N O N N O N N
ProductionQC LotSizingMethod AdditionalCommission N L N L N L N L N L N L
GA EA
O O
N N
SalesUnit EA EA EA EA
OrderMethod RecordUserRecordDatePurchaseQCSalesCommissionKey SalesQC O N N O N N O N N O N N
N N
N N
L L
ProductionQC LotSizingMethod AdditionalCommission N L N L N L N L
SalesCommissionEffectiveDate SalesCommissionExpireDate PSrLotAutoGen PCustomPosition POptional PCustom
PDateFormat PSeqNo
MSrLotAutoGen MCustomPosition
SalesCommissionEffectiveDate SalesCommissionExpireDate PSrLotAutoGen PCustomPosition POptional PCustom
PDateFormat PSeqNo
MSrLotAutoGen MCustomPosition
MOptional MCustom MDateFormat ManufacturingSeqNo MultipleBINsRequired AutoLotIssueMethod F F F F F F
F F
MOptional MCustom MDateFormat ManufacturingSeqNo MultipleBINsRequired AutoLotIssueMethod F F F F
COMPANYINFORMATION UNITS COMMODITY
UNIT CONVERSION LOCATION
Item Location
No Records A/C are not maintainted. O.K. O.K. O.K. (1) “CS” Unit is not maintained in unit master though Item Master are maintained for 6 rows
Ok Ok Ok Ok Ok
Ok
(2) Duplicate key "013495” found in item master sheet but description is different for both keys
Ok
(3) Following (1054,1087,1170,2007)Commodity Keys are not maintained in Commodity Sheet though Item master is maintained.
Ok
O.K. O.K. O.K. O.K.
Duplicate Key found ( W269) in Location Sheet but other information is different.
Ok
(1) A/C are not maintainted. (2) Zeros paded to few Itemkey, does not match with Item Master.
Ok
See attachement for details. AP MODULE FOB
O.K.
SHIP VIA
O.K.
Branch
O.K.
VENDOR CLASS
A/c are not Maintained.
TERMS
VENDOR MASTER
In BME Terms key can not accept more than three character but in excel sheet more than three character terms keys are maintained.
Ok
O.K
AR MODULE FOB SHIP VIA TERRITORY CUSTOMER CLASS TERMS CUSTOMER MASTER
SALES PERSON SHIP TO
O.K. O.K. O.K. O.K O.K. (1) Territory key "MO2" is not maintained but it is defined at "Customer master" for 40 rows.
Ok
(2) Customer Class “ CANADA” is not maintained though Customer Master is maintained.
Ok
O.K. (1) Customer key “11416” is not maintained in Customer master sheet though Ship to Key is maintained . Ok
"CS " unit is not maintained in ItemKey 012703 012708 012710 012711 012712 012727
W269 W269
013495 013495
ItemKey 715046-1054 794101-1087 791820-1170 794103-2007
"CS " unit is not maintained in "Unit master"though "Item Master" are maintained for 6 rows Description APPLESAUCE PINEAPPLE FINE CUT PINEAPPLE CRUSHED PINEAPPLE CUBED PUMPKIN BANANA-SLICED-CAN (10-0148)
TLC Outside Freezer Frostyaire Searcy
RUM -138 PROOF RED STAR CUL. ALCOHOL TAX DRAWBACK - RUM
(1054,1087,1170,2007)Commodity Keys are not maintained in Commodity Sheet though "Item master" is maintained. Description Coating Chocolate Flavored Cone Coating #5046 45 lb Plastic Pail Orange Bar Base 50 gal drum with double liner Chocolate Fondant #1820 525# Steel drum with double liner Sherbet Orange (1-60) #4103 5 Gallon Plastic Pail W/BAG
ITEM MASTER Weight 42 42 42 42 42 42
PhysicalCountDays TrackSerialLot DefaultLotSize DaysToCalculateExpiration_Dt ItemType ItemSubType ItemCostMethod OversoldCostMethod PriceGroup 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S 0L 99990.00 365.00 RM A S
Duplicate key found at "LOCATION" but other information are different 11400 W. Burleigh Street 507 Remington Road
Milwaukee WI Searcy AR
53222 72143
USA USA
Traca Barger
Duplicate key found at "Item master" but description is different 0 0
Weight
0L 0L
99990.00 99990.00
365.00 RM 365.00 RM
A A
S S
PhysicalCountDays TrackSerialLot DefaultLotSize DaysToCalculateExpiration_Dt ItemType ItemSubType ItemCostMethod OversoldCostMethod PriceGroup 0L 99990.00 365.00 FG A S 45 0L 99990.00 365.00 FG A S 560 0L 99990.00 365.00 FG A S 544 0L 99990.00 365.00 FG A S 49.58
ABCKey
ManufacturerCode ProductKeyCommodityKey ECCNCodeItemLengthItemWidth ItemHeight StockUnit RM CS RM CS RM CS RM CS RM CS RM CS
PurchaseUnit CS CS CS CS CS CS
Total Logistics Control 501-268-5888 FrostyAire for Frozen Foods
RM RM
ABCKey
GA EA
ManufacturerCode ProductKeyCommodityKey ECCNCodeItemLengthItemWidth ItemHeight StockUnit 1054 COAT EA 1087 FB EA 1170 FB EA 2007 SB EA
GA EA
PurchaseUnit EA EA EA EA
SalesUnit CS CS CS CS CS CS
OrderMethod RecordUserRecordDatePurchaseQCSalesCommissionKey SalesQC O N N O N N O N N O N N O N N O N N
ProductionQC LotSizingMethod AdditionalCommission N L N L N L N L N L N L
GA EA
O O
N N
SalesUnit EA EA EA EA
OrderMethod RecordUserRecordDatePurchaseQCSalesCommissionKey SalesQC O N N O N N O N N O N N
N N
N N
L L
ProductionQC LotSizingMethod AdditionalCommission N L N L N L N L
SalesCommissionEffectiveDate SalesCommissionExpireDate PSrLotAutoGen PCustomPosition POptional PCustom
PDateFormat PSeqNo
MSrLotAutoGen MCustomPosition
SalesCommissionEffectiveDate SalesCommissionExpireDate PSrLotAutoGen PCustomPosition POptional PCustom
PDateFormat PSeqNo
MSrLotAutoGen MCustomPosition
MOptional MCustom MDateFormat ManufacturingSeqNo MultipleBINsRequired AutoLotIssueMethod F F F F F F
F F
MOptional MCustom MDateFormat ManufacturingSeqNo MultipleBINsRequired AutoLotIssueMethod F F F F
Related Documents
Invenory Errors
June 2020 16
Errors
November 2019 66
Errors
November 2019 51
Ora Errors
November 2019 47
Footsteps Errors
November 2019 35