-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.45-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */; -- -- Create schema iso -- CREATE DATABASE IF NOT EXISTS iso; USE iso; -- -- Definition of table `iso_log` -- DROP TABLE IF EXISTS `iso_log`; CREATE TABLE `iso_log` ( `ID` int(11) default NULL, `Month No#` double default NULL, `Date` double default NULL, `Reported by` varchar(255) default NULL, `Is Customer Aware or Internal` varchar(255) default NULL, `Cust ID#` varchar(255) default NULL, `Customer Name` varchar(255) default NULL, `item #` varchar(255) default NULL, `PO/Release No` varchar(255) default NULL, `Who Caused & Cause` varchar(255) default NULL, `Reprint?` varchar(255) default NULL, `Supplier Name` varchar(255) default NULL, `Description of Problem (Text will wrap)` varchar(255) default NULL, `How was the problem resolved?` varchar(255) default NULL, `Closure Date` double default NULL, `Resolution (Drop Down)` varchar(255) default NULL, `CAR No` double default NULL, `SCAR No` varchar(255) default NULL, `CAR Closure Date` varchar(255) default NULL, `SCAR Closure Date` varchar(255) default NULL, `CAR Loss Amt` varchar(255) default NULL ) TYPE=InnoDB; -- -- Dumping data for table `iso_log` -- /*!40000 ALTER TABLE `iso_log` DISABLE KEYS */; INSERT INTO `iso_log` (`ID`,`Month No#`,`Date`,`Reported by`,`Is Customer Aware or Internal`,`Cust ID#`,`Customer Name`,`item #`,`PO/Release No`,`Who Caused & Cause`,`Reprint?`,`Supplier Name`,`Description of Problem (Text will wrap)`,`How was the problem resolved?`,`Closure Date`,`Resolution (Drop Down)`,`CAR No`,`SCAR No`,`CAR Closure Date`,`SCAR Closure Date`,`CAR Loss Amt`) VALUES (1,1,39448,'Linda','Customer','1539','Lubricating Specialties','AMX-OSHA','293070','Supplier - Shipped wrong','no','DDD LABEL TECH','Vendor did not follow shipping instructions and client complained about freight bill','Vendor ok\'s short pay of their inv. By $613.41, client already short paid inv. By same amount.',39450,NULL,NULL,NULL,NULL,NULL,NULL), (2,1,39450,'Talya','Internal','002848','Source Refig','Business cards','218627','CSR - Input Error','no','HOUSE OF CARDS','Business cards sent electronically on 12/5 by Talya and mistakenly sent again on 12/12 by Tammi Mc Cullough','Issue credit to customer for second invoice',39085,'CAR (14.3)',1042,NULL,NULL,NULL,NULL), (3,1,39454,'Steve','Customer','002774','Lucescu Realty','OB','213188, 213197','Unclassified error or complaint','no','Mouse Graphics','Customer wants to be billed actual as they were shorted on both invoices','Credit for amount not received',39456,'CAR (14.3)',1860,NULL,NULL,NULL,NULL), (4,1,39456,'Rebecca ','internal','002489','First American','DDT','295054','Acctg - Billing Error','no',NULL,'Bill NOTES not followed','asked them to fix',39458,NULL,NULL,NULL,NULL,NULL,NULL), (5,1,39456,'Rebecca ','internal','002489','First American','multiple','219831, 219916, 219971, 220032,220199','CSR - Input Error','no','VIP','Wrong Cost and/or Sell and/or set up charge','fixed and I am going to set pricing plans in Quantum so that correct contract price pulls onto POs automaticaly',39091,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (6,1,39456,'Christine C','Customer','002195','Kubota','R2401-81224','216536','CSR - Input Error','no','VIP','Client had several duplicate line items on this PO. One of the wrong part#s was removed when making adjustments','please remove item #RC408-81244 for (20) at $12.89 each, and add item R2401-81224 for (20) at $14.65/each and rebill client',39456,'CAR (14.3)',1509,NULL,NULL,NULL,NULL), (7,1,39456,'Rebecca ','Customer','002489','First American','1100030P','219918, 219916','CSR - Input Error','no','VIP','Order was on 219918 from Qnet but was then moved to 19916 to make a split ship BUT the shipping info was not moved to ship the order 1day air','Client called to check on order… I told her we can re-produce troday and ship 1day or she can wait for ground shipment…she said it is OK to wait for ground',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (8,1,39456,'Wendy','Internal','1157B','BrandM','Various','Various','Whse - Late Delivery','no','F&S','Did not ship our orders; did not notify us that wouldn\'t shipped','Shipped the next day 1/08/08',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (9,1,39456,'Shauna','customer','002043','Unified Grocers','ug1049','217350','SR - Incorrect Info Provided','Yes - Supplier/Carrier Expense','Block','vertical perf - sample provided and vendor did not follow it and rep approved incorrect perf','job reprint',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (10,1,39456,'Rebecca ','Customer','002489','First American','1100030P','219916','Supplier - Late Delivery','no','VIP','Order was sent to VIP 12/28 and did not ship until 1/9 --normal time is within 48hours BUT PO did not note this….','I will make sure procedure is changed so when Brent is out everyone will know…and I told VIP to make sure our orders ship asap….they said this one was lost…. ',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (11,1,39457,'Talya','Customer','002853','Pathology','1227','217328','Supplier - Shipped wrong','Yes - Supplier/Carrier Expense','Genforms','Vendor placed barcode in a diffent position than what was approved from proof. ','Vendor reran job',39457,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (12,1,39457,'Talya','Internal','002848','Source Refrig','CWJ','219133','CSR - Input Error','no','Blue Sphere & Colorado Timberline','Incorrect qty. ordered. Qnet order is for 2 jackets but purchase order only had a qty. of 1','Having both vendors shipped additional j jacket',39457,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (13,1,39458,'Rebecca ','Customer','002489','First American','1100172P109200','208423','Quantum error','no','Quantum','Rel 208423 shows in Q serial #\'s 539601-539700 but it should be 539801-539900 …rel 207948 was 539601-539700…Q pulled same# twice…only one receipt','manually fixed and asked mark to get Q to look into qlitch',39457,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (14,1,39461,'Talya','Customer','002766','Freeman-Atlanta','100447','214532','Supplier - Late Delivery','no','VIP','Freeman requested for exhibitor kits to ship to their client 1/3/08 and did not ship until 1/10. Freeman sent e-mail concern of disappointment and embarrassment.','There is nothing we could do about the late shipment in terms of delivery but I sent an email acknowledgment and apology. Will let Kurt Jr. deal with VIP and also talk further with Freeman when he is back from vacation.',39461,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (15,1,39462,'Christine C','Customer','002353','Sysco Harmony','DTNP-LR','290430','Acctg - Billing Error','no','Label Resourses','This is an ammendment to car # 1503 (log# 1028) Vendor used glue closure on rolls, client asked vendor to use rubber band closure. Excess glue causes printer damage','Please credit an additional $218.00 (client has alread short paid invocie by this amount)',39462,'CAR (14.3)',1510,NULL,NULL,NULL,NULL), (16,1,39465,'Linda','Customer','002674','Fastframe','FFIC-40','206774','Cust - ordered Wrong or Late','no','IPS','Customer ordered wrong','Returned for credit of $30.00 plus $7.50 pick pack. Total credit $37.50. Please credit credit card on file',39469,NULL,NULL,NULL,NULL,NULL,NULL), (17,1,39465,'Linda','Customer','1730','Leslie','Various','273931','Carrier - Error','Yes - Client Expense','IPS','Fedex lost carton, client short paid invoice. Leslie\'s has filed claim and will pay back IPS. See CAR for further details','Client will pay back IPS when they are paid back by Fed ex',39469,NULL,NULL,NULL,NULL,NULL,NULL), (18,1,39465,'Linda','Customer','1730','Leslie','11421','130290','Acctg - Billing Error','no','IPS','customer paid inv in full but took debit memo for something else that Alan Deguzman did not identify. Chris Paul is researching','Accounting corrected',39470,NULL,NULL,NULL,NULL,NULL,NULL), (19,1,39468,'Talya','Customer','002199','Freeman-LV','11-174044','214944','CSR - Input Error','no','VIP','Cost of kits billed incorrectly','Rebill kits at correct cost',39468,'CAR (14.3)',1862,NULL,NULL,NULL,NULL), (20,1,39470,'Christine C','Customer','002451','Taylor Made Golf','849688','212844','Supplier - Short, Partial, wrong Qty','no','West Key Graphics','we invoice client for 16M they only received 15M','client short paid invoice, issue internal credit for $20.00',39470,'CAR (14.3)',1511,NULL,NULL,NULL,NULL), (21,1,39470,'Christine C','Customer','2193','Specialty Labs','christmas','218332','SR - Incorrect Info Provided','no','Advantagae Mailing','Sales mis-quoted job to client','please change sell to $0.773 and charge freight, issue credit and re-bill customer',39470,'CAR (14.3)',338,NULL,NULL,NULL,NULL), (22,1,39470,'Ron','Internal','1479SC','Saddleback','8720.110SC','219069','SR - No Approval','no','IPS','Erika entered order knowing approval would come. Instead custoemer changed art. :(','Charge back PO 219069',39473,NULL,NULL,NULL,NULL,NULL,NULL), (23,1,39470,'Rob G','Customer','1622','National Healthcare','One and two card kits','Several','Cust - Incrrct/Mssng info Provided','no','Metavante','National Healthcare is no longer accepting our invoices. We need to credit open invoices to them and rebill 1478C','Credit and rebill',39470,'CAR (14.3)',48,NULL,NULL,NULL,NULL), (24,1,39471,'jennifer p','Customer','002733','Oakwood','PM1296C','219827','Supplier - Short, Partial, wrong Qty','no','Taylor Graphics','ordered 100 pk/50, but vendor sent 57 pk/100, and was sent out to customer that way. Taylors packing list also shows shipping a total of 5400, but F&S says this is wrong and they received the 5700','adjust quantities',39471,NULL,NULL,NULL,NULL,NULL,NULL), (25,1,39471,'Christine C','Customer','002195','Kubota','7K500-79911','212278','SR - Incorrect Info Provided','no','VIP','This was a sales error, rep ordered wrong item','Please credit $171.00, client short paid invoice, issure internal credit memo',39471,'CAR (14.3)',1512,NULL,NULL,NULL,NULL), (26,1,39471,'Christine C','Customer','002200','Freeman','16449','214634','SR- Instructions not followed','no','VIP','Image & client had a misunderstanding on what part of the kits should be b/w vs. color.','we agreed to split the difference. Please issue credit of $193.00 and rebill. Sell should be $23.23 per kit, not $27.09 ',39471,'CAR (14.3)',350,NULL,NULL,NULL,NULL), (27,1,39472,'joanne','Customer','002767','rcrmc','282','220861','CSR - Input Error','no','free','I ordered 20 packs/should have been 5','Dan will pick up remaining 15 packs',39472,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (28,1,39472,'Dan L','Customer','1440','Mission','266695','N/A','CSR - Instructions not followed','no','N / A','Client P.O. was not processed for this item.','Client cancelled order, and will re-order.',39472,NULL,NULL,NULL,NULL,NULL,NULL), (29,1,39473,'jennifer p','Internal','002489','First American','110073p030700','215304','Supplier - No IPS Packing Slip/Labels','no','Orion','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39399,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (30,1,39473,'jennifer p','Internal','1478','LBMMC','1005515','216580','Supplier - No IPS Packing Slip/Labels','no','Enterprise','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39401,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (31,1,39473,'jennifer p','Internal','1157','Mazda','TT-RE-MST','213825','Supplier - No IPS Packing Slip/Labels','no','Schweizer','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39405,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (32,1,39473,'jennifer p','Internal','002534','RMC','200-301','216204','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39405,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (33,1,39473,'jennifer p','Internal','1479','SBMMC','8560-52','216540','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39405,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (34,1,39473,'jennifer p','Internal','002533','Redlands','002230','217151','Supplier - No IPS Packing Slip/Labels','no','PDF','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39406,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (35,1,39473,'jennifer p','Internal','1428','St.Mary','1428','217321','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39406,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (36,1,39473,'jennifer p','Internal','1440','Mission','1440','217208','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39406,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (37,1,39473,'jennifer p','Internal','002947','FireMaster','F1055','217379','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39407,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (38,1,39473,'jennifer p','Internal','1440','Mission','213673','217248','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39407,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (39,1,39473,'jennifer p','Internal','1428','St.Mary','6080.021','217134','Supplier - No IPS Packing Slip/Labels','no','Trade Printers','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39412,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (40,1,39473,'jennifer p','Internal','002487','First American','1000040x090600','216870','Supplier - No IPS Packing Slip/Labels','no','Inland Envelope','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39412,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (41,1,39473,'jennifer p','Internal','002489','First American','1100196x110700','215682-A','Supplier - No IPS Packing Slip/Labels','no','Su Mano','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39414,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (42,1,39473,'jennifer p','Internal','1609','St. Joe','PHARM 1037','217871','Supplier - No IPS Packing Slip/Labels','no','BARCODE','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39414,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (43,1,39473,'jennifer p','Internal','1428','St.Mary','7040.009','217078','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39415,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (44,1,39473,'jennifer p','Internal','1479','SBMMC','23302','217690','Supplier - No IPS Packing Slip/Labels','no','Professional media Resources','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39415,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (45,1,39473,'jennifer p','Internal','002971','IAN H. GRAHAM','IHG004','218193','Supplier - No IPS Packing Slip/Labels','no','Unisource','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39415,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (46,1,39473,'jennifer p','Internal','1001','OCMMC','MD-107','218029','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39416,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (47,1,39473,'jennifer p','Internal','1479SC','SBMMC- SANCLEMENTE','8720.01SC','216814','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39419,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (48,1,39473,'jennifer p','Internal','1428','St.Mary','7020.006','216750','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39421,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (49,1,39473,'jennifer p','Internal','1481','AMMC','2030077','217688','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39421,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (50,1,39473,'jennifer p','Internal','1478','LBMMC','1044013','217687','Supplier - No IPS Packing Slip/Labels','no','Data Label inc.','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39421,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (51,1,39473,'jennifer p','Internal','1478','lbmmc','1004956','217700','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39421,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (52,1,39473,'jennifer p','Internal','002534','RMC','100-190','217606','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39426,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (53,1,39473,'jennifer p','Internal','1428','St.Mary','7170.003','215077','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39426,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (54,1,39473,'jennifer p','Internal','002489','First American','0010082X030700','218179','Supplier - No IPS Packing Slip/Labels','no','Dart Manufacturing','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39428,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (55,1,39473,'jennifer p','Internal','1478','LBMMC','1005646','218281','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39429,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (56,1,39473,'jennifer p','Internal','1428','St.Mary','7230.022','218255','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39429,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (57,1,39473,'jennifer p','Internal','1350','CHOC','16009','218526','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39429,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (58,1,39473,'jennifer p','Internal','002534','RMC','210-534','218253','Supplier - No IPS Packing Slip/Labels','no','COAST INDEX','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39433,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (59,1,39473,'jennifer p','Internal','002733','Oakwood','PM1405','218813','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39433,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (60,1,39473,'jennifer p','Internal','002534','RMC','5TABSET','217612','Supplier - No IPS Packing Slip/Labels','no','COAST INDEX','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39433,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (61,1,39473,'jennifer p','Internal','002733','Oakwood','PM1286','217986','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39433,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (62,1,39473,'jennifer p','Internal','1350','CHOC','166454','218398','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39436,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (63,1,39473,'jennifer p','Internal','002489','First American','1160023X110700','218949','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39442,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (64,1,39473,'jennifer p','Internal','1409B','ST. JUDE','254690','219252','Supplier - No IPS Packing Slip/Labels','no','Lancer Label','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39442,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (65,1,39473,'jennifer p','Internal','1730 ','Leslies','Various','218907','Supplier - No IPS Packing Slip/Labels','no','Dickies','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39449,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (66,1,39473,'jennifer p','Internal','1478','LBMMC','1005323','217701','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39449,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (67,1,39473,'jennifer p','Internal','1350','CHOC','99043FB/ 99044FB','219081-A','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39451,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (68,1,39473,'jennifer p','Internal','002534','RMC','505-796','219284','Supplier - No IPS Packing Slip/Labels','no','Arrowhead Press','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39451,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (69,1,39473,'jennifer p','Internal','1157B','BrandM','91-U315-000','219153','Supplier - No IPS Packing Slip/Labels','no','Sweda','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39455,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (70,1,39473,'jennifer p','Internal','1440','Mission','210891/ 210892','219171','Supplier - No IPS Packing Slip/Labels','no','block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39455,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (71,1,39473,'jennifer p','Internal','1409B','St. Jude','152301','219170','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (72,1,39473,'jennifer p','Internal','002971','IAN H. GRAHAM','IHG023','219847','Supplier - No IPS Packing Slip/Labels','no','Print N Copy','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (73,1,39473,'jennifer p','Internal','1609','St. Joe','HH 8031','218471','Supplier - No IPS Packing Slip/Labels','no','PDF','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (74,1,39473,'jennifer p','Internal','1609','St. Joe','HH 4060','218768','Supplier - No IPS Packing Slip/Labels','no','PDF','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39456,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (75,1,39473,'jennifer p','Internal','1409B','St Jude','15452','219803','Supplier - No IPS Packing Slip/Labels','no','Lancer Label','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39457,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (76,1,39473,'jennifer p','Internal','1481','AMMC','2018214','219287','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39457,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (77,1,39473,'jennifer p','Internal','1730','Leslies','11090','220233','Supplier - No IPS Packing Slip/Labels','no','Wright Business Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39463,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (78,1,39473,'jennifer p','Internal','002534','RMC','210-322','219701','Supplier - No IPS Packing Slip/Labels','no','HC Miller Co.','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39463,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (79,1,39473,'jennifer p','Internal','002043','Unified Grocers','905-R','220283','Supplier - No IPS Packing Slip/Labels','no','FTI Group','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39465,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (80,1,39476,'Jim I','Customer','1288','BAX ','OP100','219050','Carrier - Error','no','Ennis','Carrier damaged freight so 2 cartons(3600 forms) are unusable',NULL,39485,'CAR (14.3)',1866,NULL,NULL,NULL,NULL), (81,1,39476,'jennifer p','Customer','002489','First American','Various','210462','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (82,1,39476,'jennifer p','Customer','002489','First American','Various','210464','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (83,1,39476,'jennifer p','Customer','002489','First American','Various','210465','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (84,1,39476,'jennifer p','Customer','002489','First American','Various','210466','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (85,1,39476,'jennifer p','Customer','002489','First American','Various','210467','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (86,1,39476,'jennifer p','Customer','002489','First American','Various','210468','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (87,1,39476,'jennifer p','Customer','002489','First American','Various','210469','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (88,1,39476,'jennifer p','Customer','002489','First American','Various','210471','Whse - Late Delivery','no','F&S','Sent releases to F&S at 10:30 on Thursday 1/24/08, and F&S confirmed receipt of orders, but did not ship them.','Questioned F&S about this on 1/29/08, and the shipped out that day',39476,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (89,1,39477,'Rebecca ','Customer','002733','Oakwood','CHPA Invitation','221669','Supplier - Non Conforming Product','Yes - IPS Expense','Carlson Craft','Carlson produced 2 kinds of env, one with foil lining and one with logo on front. Order ws for 1 envelope with logo and lining. ','Carlson gave reduction on cost from 798 to 723.25 --IPS reprinting at Taylor for a cost of 125 and no charge to client. Po 221669-A',NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (90,1,39477,'joanne','Customer','002530','phs','phs-244431','220790','Carrier - Error','Yes - Supplier/Carrier Expense','copy run','ups lost shipment','copy run opened an investigation; in the meantime, he is re-printing',39478,'CAR (14.3)',1636,NULL,NULL,NULL,NULL), (91,1,39477,'Dan L','Customer','1440','Mission','247214','218932','CSR - Input Error','no','IPS','Incorrect client P.O.','Credit item from invoice, and re-bill with correct P.O.',39477,'CAR (14.3)',1637,NULL,NULL,NULL,NULL), (92,1,39477,'Dan L','Customer','1440','Mission','KP13','219373','Cust - Incrrct/Mssng info Provided','Yes - Client Expense','Classic Embroidery','Purchasing did not request title to be embroidered on jacket as desired by end user.','Image will re-print job at client expense.',39477,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (93,1,39477,'jennifer p','Customer','002533','Redlands','001766','208857','Whse - Shipped Short or Wrong','no','F&S','Sent release to F&S for 15 pk/100 on 1/9. They only shpped the customer 3 pk/100, and customer received invoice for full amount','F&S to ship the balance of 12 to customer at their expense',39478,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (94,2,39479,'Kelley','Customer','1428','St Mary','6010.006','217851','CSR - Input Error','no','Taylor Graphics','Order was entered twice','Client returned duplicate order',39479,'CAR (14.3)',1638,NULL,NULL,NULL,NULL), (95,2,39479,'Dan L','Customer','002533','Redlands','002533','217665','SR - Incorrect Info Provided','Yes - IPS Expense','IPS','Incorrect copy printed.','Client will pay original invoice, IPS to replace order at no charge.',39479,'CAR (14.3)',1639,NULL,NULL,NULL,NULL), (96,2,39479,'Rebecca ','Customer','002733','Oakwood','BC','220781','Acctg - Release/Inventory Error','no','BCT','Acctng did not tell CSR that PO was processed','order will be placed now, late. new process in place to prevent this ---- CSR is to keep email Conf fromQnet that shows order entered and pending approval, he then has to make sure he gets the apprval notice AND the PO # from jennifer …this will preven',39479,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (97,2,39482,'Kelley','Customer','002767','RCRMC','24-0042','216220','SR - Incorrect Info Provided','no','DSFI','Sales error','Client short paid invoice, credit applied for $296.35',39482,'CAR (14.3)',1640,NULL,NULL,NULL,NULL), (98,2,39482,'jennifer p','Customer','1350','CHOC','16009','210820','Whse - Shipped Short or Wrong','no','F&S','sent F&S release for 100 packs, but they only shipped 93. Customer contacted us about short shipment','F&S performed a physical on product, and found that they did not ship the 7 packs in question. They are shipping at their cost today.',39482,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (99,2,39482,'jennifer p','Internal','1730','Leslies','Various','220307','Supplier - No IPS Packing Slip/Labels','no','Dickies','product arrived mixed in cartons without IPS packing list. Over 50 items, so F&S will have to rebox like items together','F&S will box product correctly.',39482,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (100,2,39482,'Christine C','Customer','002195','Kubota','3C581-99713','220295 & 220263','CSR - Input Error','no','VIP','client sent two PO\'s at same time, after PO\'s were created and submitted, clinet added an additional line item, I added to wrong PO','please remove item # 3C581-99713 from PO# 220263 and add it to PO# 220295 and rebill for both PO;s. ',39482,'CAR (14.3)',1513,NULL,NULL,NULL,NULL), (101,2,39482,'jennifer p','Internal','1478A','MHS','1088999','221460','Supplier - Non Conforming Product','no','Taylor Graphics','we specifically requested on PO that this needs to be packaged as pk/50, but vendor packaged as pk/100',NULL,39482,NULL,NULL,NULL,NULL,NULL,NULL), (102,2,39483,'Talya','Internal','1433-A','Westcliff','900 SB','219604','CSR - Input Error','no','K&G Graphics','Unit of measure cost and sell entered incorrectly causing the vendor to be short paid and client not charged correctly.','K&G Graphics should be 31.82/M and not 31.82/ctn and Westcliff should be 89.89/ctn',39483,'CAR (14.3)',1871,NULL,NULL,NULL,NULL), (103,2,39486,'Bret A','Internal','001951','Vision','AA','221193','Supplier - Late Delivery','no','CTR WEB','After several follow-ups, vendor assured shipment date of 2/7. Job did not ship until 2/8 causing delay in product arrival ','Vendor to ship 5 boxes via 3-day at no expence to 1 location, deliver via own truck 3 cartons to another local location.',39486,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (104,2,39486,'Dan L','Customer','002534','RMC','210-321','211218','Acctg - Release/Inventory Error','no','F&S','Client ordered 1 case, 12 cases were released.','Frank & Sons will pick up overshipment and return to warehouse.',39486,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (105,2,39486,'Dan L','Customer','002530','PHS','Y0015P','222258','CSR - Instructions not followed','no','Lancer Label','Client ordered 2 rolls, only 1 roll was ordered by IPS.','IPS to ship balance of order to client.',39486,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (106,2,39490,'Shauna','Customer','002043','Unified Grocers','UG73','211443','Whse - instruct not followed','no','F&S','HOT Shipment -cust. needed delivered on certain date & F&S never delivered- 2days late.','F&S is delivering on 2/12/08',39490,NULL,NULL,NULL,NULL,NULL,NULL), (107,2,39491,'Christine C','Customer','002195','Kubota','FC','218716','CSR - Input Error','no','FSA','Billed for incorrect hours','Credit origional hours and bill for correct hours from 164.32 to 257.69',39491,'CAR (14.3)',1514,NULL,NULL,NULL,NULL), (108,2,39493,'Dan L','Customer','002534','RMC','35015-1HP','214512','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Label Resourses','47 cases did not included perf on label.','Bad product that was received by customer has been replaced with existing inventory. Supplier to replace 47 cases at no charge.',NULL,'CAR & SCAR',NULL,NULL,NULL,NULL,NULL), (109,2,39493,'Dan L','customer','002530','PHS','P080123','216458','Unclassified error or complaint','no','Block','Client sent IPS a UPS shipment for bad product, and debited the cost on this order / invoice.','IPS to issue internal credit of $14.34 to cover balance owed.',39493,'CAR (14.3)',1642,NULL,NULL,NULL,NULL), (110,2,39493,'Rebecca ','customer','002489','First American','1100172P109200','211003 211944 211943','Whse - instruct not followed','no','F&S','Wrong serial numbers were shipped.','client will have to call all agents that were shipped policies and find out what each has. - month end reports will have to be adjusted',NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (111,2,39493,'Michelle','Customer','1239','Blue White Ind.','90016-005','222667','Cust - Incrrct/Mssng info Provided',NULL,'Alna','Wrong logo','correct logo provided and envelopes rerun',39498,NULL,NULL,NULL,NULL,NULL,NULL), (112,2,39493,'jennifer p','Customer','1478','LBMMC','1109040','211627','Whse - Late Delivery','no','F&S','sent order to warehouse, should have delivered on 2/9, but did not deliver until the following week','F&S delivered to customer',39493,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (113,2,39496,'Talya','Customer','002200','Freeman-Denver','199033','215821','Unclassified error or complaint','no','VIP','Error in sell cost to client. Cost obtained form excel price list that did not display correct total.','Issue credit and rebill customer',39496,'CAR (14.3)',1876,NULL,NULL,NULL,NULL), (114,2,39496,'Rebecca ','Customer','002489','First American','0020102x070700','211284','Unclassified error or complaint','no','Dual','alteration charge should not be charged to client - change of client procedures…cannot charge this ','Credit and rebill',39496,'CAR (14.3)',1879,NULL,NULL,NULL,NULL), (115,2,39497,'joanne','Customer','1428','st. mary','7401.011','222980','CSR - Input Error','Yes - IPS Expense','claremont print','Specs were incomplete','Re-print',39497,'CAR (14.3)',1643,NULL,NULL,NULL,NULL), (116,2,39498,'Tammy','Customer','002640','Think Together','T-Shirts','223299','CSR - Instructions not followed','Yes - IPS Expense','Sanmar/Absurd Shirts','Clients email stated that they wanted off white/recycled t-shirts like prev order - White t\'s were ordered - when I returned I followed up and caught the mistake - Reordered the off white t\'s that they wanted and had the White t\'s returned- ','Absurd retruned the White T\'s on RA#21832846 at a 7% restocking fee - Frt to return and 7% need to go into cost of job - will be a low margin- DS Account- Client got the shirts when they wanted them after all. - ',39499,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (117,2,39499,'Dan L','Customer','002534','RMC','RMC-RX1','223174','Supplier - ***to be determined','no','Presstime','Cello\'d packs included mixture of (2) physicians Rx Pads.','Client opened all packs received to separate correctly.',39499,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (118,2,39499,'Shauna','Customer','002943','Unified Grocers','BC-ART','220538','SR - Incorrect Info Provided','no','Manfre Graphics','Incorrect Artwork Charge','Customer to short pay Invoice',39499,'CAR (14.3)',23,NULL,NULL,NULL,NULL), (119,2,39500,NULL,'Customer','002853','Pathology Inc.','336C','218985',NULL,'no','Ennis','wrong sell price','issue credit/reinvoice',NULL,NULL,1880,NULL,NULL,NULL,NULL), (120,2,39500,'Christine C','Customer','002573','William\'s Furnace','P322085','220643','Supplier - Shipped wrong','no','Birmingham Press','Client says they did not receive total that they ordered. We billed them for 13,200 each and they only received 13,000','Client short paid invoice, issue internal credit for $63.20',39500,'CAR (14.3)',1515,NULL,NULL,NULL,NULL), (121,2,39500,'Rob G','Customer','1157','Mazda','WRS','215988','Acctg - Billing Error','no','Classic Embroidery','Due to pre-billing, invoice just needs to be charged back','Charge back invoice 290344 to sales',39503,'CAR (14.3)',49,NULL,NULL,NULL,NULL), (122,2,39503,'Bob','Customer','002733','Oakwood','PM1069','219824','Supplier - Non Conforming Product','no','Taylor','Client Supplied Art ; Taylor proofed Art & made an unauthorized change. However, sales & client did not catch the mistake and approved the proof.','Taylor issued a partial credit. Oakwood & Image are splitting the sell price of the job.',39503,'CAR (14.3)',1881,NULL,NULL,NULL,NULL), (123,2,39503,'steve','Customer','1157','Mazda','J Hook','217095','Supplier - Short, Partial, wrong Qty','no','Plexi-fab','shipped too many overs','Free overs to the client and 10% off',39504,NULL,1882,NULL,NULL,NULL,NULL), (124,2,39503,'steve','Customer','002807','HY planning','2008 SN','219835','Supplier - Late Delivery','no','BIC','Apparently BIC claims that there was money owed to them and our account was on HOLD. I was not notified of the hold and by the time I was, the product was past due with shipping, thus requiring expedited freight. Client will only pay a partial of the fr','Client is paying only partial of freight',39506,NULL,1884,NULL,NULL,NULL,NULL), (125,2,39503,'Steve','Customer','002807','HY planning','AF','219785','CSR - Instructions not followed','no','Scent USA','Vendor not set up for terms and CSR didn\'t follow up with accounting. Accounting took 3 weeks to set vendor up causing a productiontime issue and the product having to be expedited.','Customer is paying only partial freight',39503,NULL,1885,NULL,NULL,NULL,NULL), (126,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211589','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (127,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211591','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (128,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211593','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (129,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211595','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (130,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211596','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (131,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211597','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (132,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211598','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (133,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211599','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (134,2,39505,'jennifer p','Customer','002733','Oakwood','Various','211600','Supplier - Late Delivery','no','F&S','F&S confirmed that they received these orders on 2/08, but then never shipped them, until we asked them about it on 2/22/08','all shipped out the next business day',39503,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (135,2,39506,'tammi','Customer','1157c','Mazda','91-u322-000','209628','Supplier - Late Delivery','no','Sweda','order for replacement stock was submitted to vendor on 1/15/08 (221007) and delivery to F&S happened on 2/27/08. customer wants good faith refund of shipping charges','issuing credit to end users credit card for shipping charges of $7.95',39507,'CAR (14.3)',1894,NULL,NULL,NULL,NULL), (136,2,39507,'Tammy','Customer','1481 & 1409M','anaheim & st. jude','Releases','212777 & ?','Supplier - Shipped wrong','no','F&S','Pick and Pack accounts are being bulk shipped -- clinet turning in orders per dept and f&son is packing multiple dept orders into one box making it impossible for the receiver to distribute items to ordering depts.','Joe Fries Called Frank and Son and reminded them that each release needs to be in it\'s own package - even if it is only 1 pack for a dept.',39507,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (137,3,39511,'Dan L','Customer','002534','RMC','Various','217695','Supplier - Non Conforming Product','no','IFC','Barcode label on chart folders was printed incorrectly by supplier.','Supplier picked up and repaired all folders at client location. Remaining inventory is being repaired at supplier warehouse.',NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (138,3,39511,'Dan L','Internal','002534','RMC','210-321','212697','Acctg - Release/Inventory Error','no','F&S','Product that was returned to F&S was not received into Quantum, so release was backordered to client.','Error corrected by Accounting. Release was filled the following week.',39518,NULL,NULL,NULL,NULL,NULL,NULL), (139,3,39512,'Rebecca ','Customer','002489','First American','F280','217119','Cust - Incrrct/Mssng info Provided','no','Sanmar ','Client wanted to return sample after PO was billed for sample','got sample back. Mike to keep. - credit client. Keep cost on invoice',39512,'CAR (14.3)',1875,NULL,NULL,NULL,NULL), (140,3,39512,'Bob','Internal','002733','Oakwood','CHPA Shirts','222772','CSR - Instructions not followed','no','Sanmar/Classic','CSR did not follow correct instructions for sell prices.','Issued a corrected Invoice prior to customer receiving',39146,'CAR (14.3)',1896,NULL,NULL,NULL,NULL), (141,3,39512,'Tammy','Customer','1416/1477','ocde/health & human services','dea 4','222624 & -A','CSR - Input Error','no','copy run','I entered in this order under the wrong client id - entered in under 1416 and it should have been 1477','Orange county called and sent the box to us -- I did a new order and sent it back to Health & Human services - Need to credit invoice 300650 in full and rebill it all under po 222624-A - do not charge client for any frt due to delay.',39514,'CAR (14.3)',1040,NULL,NULL,NULL,NULL), (142,3,39516,'Rebecca ','Internal','002487','First American','Freight','224319','Unclassified error or complaint','no',NULL,'need all freight on summary PO of freight changes now','Accounting will move charges',39515,'CAR (14.3)',82,NULL,NULL,NULL,NULL), (143,3,39513,'Rebecca ','Customer','002489','First American','towel','213290','Whse - Late Delivery','no','Frank and Son','they did not ship on 3rd- client called on 6th looking for product for an event.','f/s to ship today 1day air at their expense,.',39513,NULL,NULL,NULL,NULL,NULL,NULL), (144,3,39514,'Rebecca ','Internal','002487','First American','Freight','296404-a and 297042-a','Unclassified error or complaint','no',NULL,'client needs all frieght on one summary bill each month','we will move these to latest PO 224319 for freight in Feb',39514,'CAR (14.3)',2001,NULL,NULL,NULL,NULL), (145,3,39517,'jennifer p','Customer','002733','Oakwood','Various','213706','Whse - Late Delivery','no','F&S','F&S received our release before cutoff time on Friday 3/7, and confirmed receipt, but did not ship','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (146,3,39517,'jennifer p','Customer','1157B','Brand M','Various','213537','Whse - Late Delivery','no','F&S','F&S received our releases on 3/5, and confirmed receipt, but the never shipped them, no explanation as to why','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (147,3,39517,'jennifer p','Customer','1157B','Brand M','Various','213541','Whse - Late Delivery','no','F&S','F&S received our releases on 3/5, and confirmed receipt, but the never shipped them, no explanation as to why','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (148,3,39517,'jennifer p','Customer','1157B','Brand M','Various','213542','Whse - Late Delivery','no','F&S','F&S received our releases on 3/5, and confirmed receipt, but the never shipped them, no explanation as to why','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (149,3,39517,'jennifer p','Customer','1157B','Brand M','Various','213543','Whse - Late Delivery','no','F&S','F&S received our releases on 3/5, and confirmed receipt, but the never shipped them, no explanation as to why','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (150,3,39517,'jennifer p','Customer','1157B','Brand M','Various','213544','Whse - Late Delivery','no','F&S','F&S received our releases on 3/5, and confirmed receipt, but the never shipped them, no explanation as to why','will ship out today, 3/10/08',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (151,3,39517,'Brent G','Customer','002489','First American','Various','R#213023,213022,213021,213020,213024','Whse - Shipped Short or Wrong','no','F&S','F&S sent out the incorrect item.They should have sent item#0030003X060700(Legal Size) but sent item#0030001X060700(Letter Size). The picker was not paying attention to location listed on paperwork.','Corrected item was sent to the customer. ',NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (152,3,39517,'jennifer p','Customer','1478','LBMMC','2037463/2037464','213678/213679','Whse - Shipped Short or Wrong','no','F&S','Sent them release 213678 for 20 of 2037463, and release 213679 for 15 rolls of 2037464, but they shipped 35 of 2037464 and 0 of 2037463','F&S will deliver correct product on 3/11/08, and pick up the wrong product and retrun to stock at no charge to Image.',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (153,3,39517,'tammi','Customer','1157b','Mazda','91-m300-l 91-m302-l 91-m307-l','r#s 213539 213537',NULL,'no',NULL,'Two orders via the MStore had multiple issues. The first release had an item on back order and since entire order doesn\'t ship until complete the order is delayed in going out. Client was not notified of backorder. Second release, client ordered an ite','Client is not happy, I will send some Mazda goodies and this is not going to resolve her frustration.',39517,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (154,3,39518,'Ron','Customer','1478','LBMMC','BC-DEVEIKIS','215086','Unclassified error or complaint','Yes - IPS Expense','BCT','Business cards had an error & it is unclear whether customer, csr, or BCT made error','For good will Ron is eating',39518,'CAR (14.3)',NULL,NULL,NULL,NULL,NULL), (155,3,39518,'Tammy','Customer','1398','st. joes hospital','bc-1115','220281/221341','Cust - ordered Wrong or Late','Yes - IPS Expense','BCT','client sent in manual business card order form - it was an order that could have been done on the internet. BCT misread the handwritting and client wanted it reprited even though it is their fault','sales will eat the cost of the re-run $33.50 to keep client happy -- sales will hand deliver credit to client- Stuart',39520,'CAR (14.3)',1032,NULL,NULL,NULL,NULL), (156,3,39518,'jennifer p','Internal','1478','LBMMC','3022352','223255','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39518,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (157,3,39518,'jennifer p','Internal','1478A','Memorial Care','2017451','222925','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39518,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (158,3,39518,'jennifer p','Internal','1428','St Mary','6080.012','221416','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39518,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (159,3,39519,'Linda','Customer','1730','Leslie\'s','11054','298621','Cust - ordered Wrong or Late','no','Image','Customer ordered 60 packs but claim they ordered 50','Client short paid invoice',39519,NULL,NULL,NULL,NULL,NULL,NULL), (160,3,39519,'Mike','Customer','002487','FATIC','RTM Processing','various','Acctg - Billing Error','no','Various','RTM transatction invoicing for October and November of 2007 was incorrect because FATIC provided flawed data and IPS did not catch the flaw. ','Data is corrected - IPS will issue a Credit and will issue Debits against vendors',39519,'CAR (14.3)',2007,NULL,NULL,NULL,NULL), (161,3,39519,'tammi','Customer','03011','Boys & Girls Club of SD','CNI&M','219609','Supplier - Non Conforming Product','no','Taylor','Rush order printed incorrectly, errors made by both vendor and sales rep','sales rep was to knock $1k off client\'s invoice. vendor reduced sell by $150',NULL,'CAR (14.3)',1898,NULL,NULL,NULL,NULL), (162,3,39519,'Linda','Customer','001935','Medtronic','705454-CDZ1','294010','Supplier - Short, Partial, wrong Qty','no','SuMano','Vendor short shipped','Internal Credit to be isseud',39519,NULL,NULL,NULL,NULL,NULL,NULL), (163,2,39504,'tammi','Internal','1157t','Mazda','ENT-033','223791','CSR - Input Error','no','Gold Bond','CSR entered qty of 2 and order was written for qty of 2000','revised order to vendor',39504,NULL,NULL,NULL,NULL,NULL,NULL), (164,3,39521,'tammi','Customer','1157b','Mazda','91-u226-0000','211303','Carrier - Error','no','F&S','mug arrived broken (1 out of 5)','sending replacement mug ',39521,'CAR (14.3)',2008,NULL,NULL,NULL,NULL), (165,3,39510,'tammi','Customer','1157t','Mazda','nametags-zz','223553','CSR - Input Error','no','Halls & Co','CSR used incorrect address so delivery was not done and the problem wasn\'t identified til the delivery was a week overdue.','Had to arrange a courier to p/u from UPS and deliver to client.',39510,NULL,NULL,NULL,NULL,NULL,NULL), (166,3,39512,'Dan L','Internal','002530','PHS','P080123','216458','Acctg - Billing Error','No','Block','CAR submitted on 2/15 for internal credit of outstanding balance. CAR has not been completed by Accounting.','Re-faxed CAR to Sarah on 3/5',39512,NULL,NULL,NULL,NULL,NULL,NULL), (167,3,39521,'Dan L','Internal','002530','PHS','P080123','216458','Acctg - Billing Error','no','block','CAR submitted on 2/15 for internal credit of outstanding balance. CAR has not been completed by Accounting.','Followed up with Sarah on 3/14',39521,NULL,NULL,NULL,NULL,NULL,NULL), (168,3,39519,'Dan L','Internal','1440','Mission','0155','214028','Acctg - Release/Inventory Error','no','Frank and Son','Release for product was emailed to inventory department but was not included as part of client\'s weekly delivery. ','Product was released and delivered to client the following day.',39520,NULL,NULL,NULL,NULL,NULL,NULL), (169,3,39519,'Dan L','Internal','1440','Mission','213443','214029','Acctg - Release/Inventory Error','no','Frank and Son','Release for product was faxed to inventory department but was not included as part of client\'s weekly delivery. ','Product was released and delivered to client the following day.',39520,NULL,NULL,NULL,NULL,NULL,NULL), (170,3,39521,'Dan L','Internal','1440','Mission','214117',NULL,'Acctg - Billing Error','no','Pro Forms','CAR submitted on 9/17/07 & 11/8/07 but is still unprocessed. 94 pks of bad stock that was destroyed still shows up in Quantum inventory.','Followed up with Acctg. On 3/14/07',39521,NULL,NULL,NULL,NULL,NULL,NULL), (171,3,39521,'Kelley','Internal','1428','St Mary','8700.070','217766','SR - Incorrect Info Provided','Yes - IPS Expense','Taylor','Order was placed with incorrect specs.','Vendor reprinted job',39521,'CAR (14.3)',1645,NULL,NULL,NULL,NULL), (172,3,39525,'Mark','Internal','1157B','Brand M','91-u360-L','222536','CSR - Input Error','no','Wov In Line - straps','CSR setup items incorrectly. Should have been stock items, forgot to assign warehouses making it impossible to receive into F&S and created potential invoice to client that was caught by SR','Invoice is credited in system, receiving info identified and manually received into warehouse. All other documents closed.',39525,NULL,NULL,NULL,NULL,NULL,NULL), (173,3,39525,'jennifer p','Internal','1609','St. Joseph','HOS 9034','224249','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39525,NULL,NULL,NULL,NULL,NULL,NULL), (174,3,39525,'jennifer p','Internal','002534','RMC','100-007','224060','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39525,NULL,NULL,NULL,NULL,NULL,NULL), (175,3,39526,'Brent G','Customer','1479','SMMC','8650.10','R#213457','Whse - Shipped Short or Wrong','no','IPS','Customer said that a duplicate order of item#8650.10 was shipped to them. I will return the 4 packs to the warehouse.','CSR is sending back to the warehouse 4 packs to return to stock.',39525,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (176,3,39531,'joanne','Customer','002767','RCRMC','171','224579','CSR - Instructions not followed','Yes - IPS Expense','Superprint','Did not provide new art to vendor and they printed old version.','Re print with new art.',39531,'CAR (14.3)',1647,NULL,NULL,NULL,NULL), (177,3,39532,'Lisa','Customer','1409B','St Jude','BC-363','224193','CSR - Input Error','No','BCT','CSR entered sell price incorrectly',' ',39532,NULL,NULL,NULL,NULL,NULL,NULL), (178,3,39532,'Lisa','Customer','1664','St Jude Heritage','158824','215345','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Block','Exact Repeat order was submitted; forms are 1/1 but vendor printed forms without backer','Vendor re-printed entire order - PO # 215345-A',NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (179,3,39532,'Rebecca ','Customer','002733','Oakwood','PM1288','39028','Whse - Shipped Short or Wrong','no','Frank and Son','F/S shipped PM1296C instead of PM1288','Client will keep wrong item….JP to ship correct item',39532,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (180,3,39533,'jennifer p','Internal','1157B','Brand M','Various','222441','CSR - Input Error','no','Classic Embroidery','CSR didn\'t provide vendor with labels or packing list, so product arrived all mixed together at warehouse','F&S will sort out the product,and box correctly',39533,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (181,3,39533,'jennifer p','Customer','002489','First American','Various','samples','Whse - instruct not followed','no','F&S','requested F&S to pull some samples and ship to customer, but they did not complete request','F&S shipped out on second reqeust',39533,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (182,3,39533,'jennifer p','Customer','002805','United General','Various','samples','Whse - instruct not followed','no','F&S','requested F&S to pull some samples and ship to customer, but they did not complete request','F&S shipped out on second reqeust',39533,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (183,3,39533,'Christine C','Customer','1433','Westcliff','WCL-KCH','219327','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Evans','Evans printed key chain up-side-down','re-ran job, credited us original invoice and billed us on new invoice to include extra $21.85 for magnets to be charged back to sales rep.',39533,'CAR (14.3)',1516,NULL,NULL,NULL,NULL), (184,3,39534,'jennifer p','Internal','1409B','St Jude','13506','225061','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (185,3,39534,'jennifer p','Internal','1478','LBMMC','1005648-B','224689','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (186,3,39534,'jennifer p','Internal','002534','RMC','210-378','224612','Supplier - No IPS Packing Slip/Labels','no','H.C MILLER','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (187,3,39534,'jennifer p','Internal','1481','AMMC','2029767','223955','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (188,3,39534,'jennifer p','Internal','1481','AMMC','2018089','225013','Supplier - No IPS Packing Slip/Labels','no','Peterson\'s','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (189,3,39534,'jennifer p','Internal','1730','Leslies','6007-L','216153','Supplier - No IPS Packing Slip/Labels','no','D&D concepts','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (190,3,39534,'jennifer p','Internal','1729','Leslies poolbrite','11899','223687','Supplier - No IPS Packing Slip/Labels','no','Stouse ','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (191,3,39534,'jennifer p','Internal','1730','Leslies','Various','219620','Supplier - No IPS Packing Slip/Labels','no','Dickies','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (192,3,39534,'jennifer p','Internal','1730A','Leslies','Various','223502','Supplier - No IPS Packing Slip/Labels','no','D&D concepts','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (193,3,39534,'jennifer p','Internal','1440','Mission','254751','221253','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (194,3,39534,'jennifer p','Internal','1478','Long Beach','1005070','223859','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (195,3,39534,'jennifer p','Internal','002533','Redlands','016043','223531','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (196,3,39534,'jennifer p','Internal','1481','AMMC','2021017','224002','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39534,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (197,3,39535,'tammi','Customer','1157b','Mazda','91-u226-0000','213106','Carrier - Error','no','F&S','mugs arrived broken (4 out of 20)','sending replacement mugs for 3 and crediting 4th',39535,'CAR (14.3)',1829,NULL,NULL,NULL,NULL), (198,3,39535,'Jaime','Customer','1935','Medtronic','6025236-CNQ1','196787','Supplier - Billing Error','no','Freedom Graphics','vendor shipped/billed incorrectly. Credit has been given','customer will short pay invoice 285767',NULL,NULL,NULL,NULL,NULL,NULL,NULL), (199,3,39535,'jennifer p','Internal','002043','Unified Grocers','UG73','224501','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39535,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (200,3,39535,'jennifer p','Internal','002848','Source Refrig','Various','225053','Supplier - No IPS Packing Slip/Labels','no','Blue Sphere & VF Imagewear','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39535,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (201,3,39538,'Bob','Customer','002733','Oakwood','BC-1 ','219581','Supplier - Non Conforming Product','no','Taylor','Business Cards had mis-alignment on the Embossing.','Destroy bad stock and credit',39538,'CAR (14.3)',2036,NULL,NULL,NULL,NULL), (202,4,39539,'Rebecca ','Customer','002733','Oakwood','#10WDoENV-M','221920','Supplier - Short, Partial, wrong Qty','Yes - Supplier/Carrier Expense','BCT','BCT lost 3500 env','printing more on po 226121 - need to short pay BCT to collect 786.66 for lost stock',39559,'CAR (14.3)',2037,NULL,NULL,NULL,NULL), (203,4,39540,'Kelley','Customer','1428','St Mary','7075.036','224186','SR- Instructions not followed','Yes - IPS Expense','Antonio','Client requested revisions to order that was overlooked, order was printed incorrectly.','Repirnt at no cost to client',39540,'CAR (14.3)',1646,NULL,NULL,NULL,NULL), (204,4,39540,'Tammy','Customer','1398','st. joes hospital','letterhead-foundation','212142/208519','Supplier - Non Conforming Product','Yes - IPS Expense','k&g','HUGE issues - letterhead job was run 2 times - both times had issues - sent job back several times and they could never fix it right- cut un-evenly, tick marks, bad ink coverage, packaged poorly - sales rep had several conversations with K&G and no one ev','Ended up running this at Block and owe the client a $649.50 Credit - really need K&G to credit us 371.93 but that is not going over very well - SCAR to k&g',NULL,'CAR & SCAR',1035,NULL,NULL,NULL,NULL), (205,4,39540,'Tammy','Customer','1482','st. joes health','bus.cards','218458','CSR - Input Error','no','bct','entered in dq98136 marian smith under account 1482 and it should have been under 1615y -- need to credit inv 293865 for the one name and reinvoice it so that only the 2 names are on it - kingston & watson - getting a po# for the one name - smith to be str','credit inv 293865 for the 46.10 +tax - reinvoice with just the 2 names --straight bill account 1615y for the one name -- client po to follow on CAR',39546,'CAR (14.3)',1033,NULL,NULL,NULL,NULL), (206,4,39540,'Tammy','Customer','1615y','st. joes heritage','artwork- YP 0733','216430','SR - Incorrect Info Provided','no','IPS','sales entered in the wrong hosp account number - 1398 - should have been 1615y - customer service did not catch it….','credit inv 301635 for 266.68 and straight bill under account 1615y - client po 150-1041331',39546,'CAR (14.3)',1034,NULL,NULL,NULL,NULL), (207,4,39541,'Christine C','Customer','002808','Riverside Co. Sherrif\'s Dept','RB','220755','Supplier - Short, Partial, wrong Qty','no','Wright Business Graphics','Client ordered 2,560 units, vendor shipped 2,500 short by (60)','Client short paid invoice by $46.38, issue internal crdt',39546,'CAR (14.3)',1517,NULL,NULL,NULL,NULL); INSERT INTO `iso_log` (`ID`,`Month No#`,`Date`,`Reported by`,`Is Customer Aware or Internal`,`Cust ID#`,`Customer Name`,`item #`,`PO/Release No`,`Who Caused & Cause`,`Reprint?`,`Supplier Name`,`Description of Problem (Text will wrap)`,`How was the problem resolved?`,`Closure Date`,`Resolution (Drop Down)`,`CAR No`,`SCAR No`,`CAR Closure Date`,`SCAR Closure Date`,`CAR Loss Amt`) VALUES (208,4,39541,'jennifer p','Customer','1730','Leslies','6007-2XL','215226','Acctg - Release/Inventory Error','no',NULL,'customer ordered 4 of 6007-2XL, Jorge keyed in order for 4 of 6007-4XL','Customer will receive the correct item, and return the wrong stock to F&S',39546,NULL,NULL,NULL,NULL,NULL,NULL), (209,4,39541,'jennifer p','Internal','002534','RMC','400-019','225336','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39541,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (210,4,39541,'jennifer p','Internal','1478','LBMMC','3021662','225150','Supplier - No IPS Packing Slip/Labels','no','Label Resources','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39541,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (211,4,39541,'jennifer p','Internal','1428','St. Mary','7230.010','224636','Supplier - No IPS Packing Slip/Labels','no','Pacific Data Forms','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39541,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (212,4,39542,'Rebecca ','Customer','002733','Oakwood','BC-1 GSA','226225','Supplier - Non Conforming Product','Yes - IPS Expense','Taylor','BC were printed wrong at Taylor (masters) so the order from BCT was bad ….','Taylor reprinted masters at no charge but IPS is reprinting cards at BCT at IPS expense --do not chrge client for replacement PO 226225',39542,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (213,4,39542,'Linda','Customer','1730','Leslies','multiple','205855','Whse - instruct not followed','no','IPS','short shipped','client short paid invoice',39542,NULL,NULL,NULL,NULL,NULL,NULL), (214,4,39542,'Linda','Customer','003059','Magicplay','FMC-SS','224375','Unclassified error or complaint','no','Taylor','client will not pay for overs','invoice short paid',39542,NULL,NULL,NULL,NULL,NULL,NULL), (215,4,39542,'Linda','Customer','003059','Magicplay','Sell Sheets','224377','Unclassified error or complaint','no','Taylor','Client will not pay for overs','invoice short paid',39542,NULL,NULL,NULL,NULL,NULL,NULL), (216,4,39542,'Christine C','Customer','002195','Kubota','97897-37120','222100','CSR - Input Error','no','VIP','VIP did not have this book on back up, they were unable to produce it, Kubota cancelled this item and I did not take it off of PO before invoiced','Please issue credit for $60.00 and rebill client.',39542,'CAR (14.3)',1518,NULL,NULL,NULL,NULL), (217,4,39545,'jennifer p','Internal','002848','Source Refrig','Various','225059','Supplier - No IPS Packing Slip/Labels','no','PACIFIC SCREENWORKS','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (218,4,39545,'jennifer p','Internal','1157T','MAZDA','ENT-033','223791','Supplier - No IPS Packing Slip/Labels','no','Gold Bond','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (219,4,39545,'Christine C','Customer','1516','Big Lots','PM800015-440','4CP RIBBON','Supplier - Shipped wrong','no','Scansource','Ribbons are defective due to shipment','Credit 3 ribbons',39545,'CAR (14.3)',1519,NULL,NULL,NULL,NULL), (220,4,39545,'jennifer p','Internal','1409B','St Jude','208378','224279','Supplier - No IPS Packing Slip/Labels','no','PressTime','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (221,4,39545,'jennifer p','Internal','1409b','St Jude','158792','225677','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (222,4,39545,'jennifer p','Internal','1478','LBMMC','1005076','225254','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (223,4,39545,'jennifer p','Internal','1478','LBMMC','1005013','225720','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (224,4,39545,'jennifer p','Internal','1478','LBMMC','1005090','225446','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (225,4,39545,'jennifer p','Internal','002733','Oakwood','AM114','225176','Supplier - No IPS Packing Slip/Labels','no','Taylor Graphics','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (226,4,39545,'jennifer p','Internal','1481','AMMC','3022777','225675','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (227,4,39545,'jennifer p','Internal','1730 ','Leslies','6007-2xl/ 6007-3xl','216153','Supplier - No IPS Packing Slip/Labels','no','D&D concepts','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (228,4,39545,'jennifer p','Internal','1409B','St Jude','113935','224917','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (229,4,39545,'jennifer p','Internal','1730','Leslies','11173','225169','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (230,4,39546,'tammi','Internal','002752','Ardent Learning','mtd-pg tabs','225056','Supplier - Non Conforming Product','no','Coast Index','In some sets of tabs one tab was blank and printing was on the left side edge',NULL,NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (231,4,39545,'tammi','Internal','002752','Ardent Learning','mtd-pg spines','225056','Supplier - Short, Partial, wrong Qty','Yes - Supplier/Carrier Expense','Taylor','one set of spines was shipped short and Metro is unable to finish binders',NULL,NULL,'SCAR (6.1)',NULL,NULL,NULL,NULL,NULL), (232,4,39545,'Dan L','Customer','002530','PHS ','P080015','224313','Supplier - Non Conforming Product','no','PDF','vendor shipped a short carton.','client will short pay invoice $219.36. IPS to issue internal credit. Supplier will issue credit.',39545,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (233,4,39545,'Dan L','Customer','002767','RCRMC','MHTF-424','222006','CSR - Input Error','no','Pro Document','Order was entered as 100 pks rather than 80 packs as ordered by client.','client returned extra product, and will shortpay invoice by $102.80. IPS to issue internal credit.',39545,NULL,NULL,NULL,NULL,NULL,NULL), (234,4,39546,'jennifer p','Internal','1478','LBMMC','1005515','225994','Supplier - No IPS Packing Slip/Labels','no','Enterprise','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39546,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (235,4,39546,'jennifer p','Internal','002534','RMC','100-026','225310','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39546,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (236,4,39546,'jennifer p','Internal','1730','Leslies','11054','225173','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39546,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (237,4,39546,'jennifer p','Internal','002848','Source Refrig','HATS','225447','Supplier - No IPS Packing Slip/Labels','no','Otto Internat\'l','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39546,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (238,4,39546,'jennifer p','Customer','1478','LBMMC','1005515','215441','Whse - Shipped Short or Wrong','no','F&S','F&S was sent order for 5 of item 1005515, on 4/1, but they did not include it when shipping','F&S to ship with Long Beach deliveries on 4/9/08',39546,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (239,4,39547,'jennifer p','Internal','1730','leslies','Various','224920','Supplier - No IPS Packing Slip/Labels','no','Dickies','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39547,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (240,4,39547,'jennifer p','Customer','1730','leslies','6007-M','215649','Whse - Shipped Short or Wrong','no','F&S','F&S was sent order for 4 of item 6007-M on 4/3, but they only 1.','They are shipping out the balance of 3 on 4/9/08 at their expense',39547,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (241,4,39547,'Christine C','Customer','002195','Kubota','70000-05000','221659045','CSR - Input Error','no','F&S','We missed keyed a Kubota Release. Release should have been for (42) we keyed only (2)','Customer shipped balance from their location; Kubota is requesting a credit for frt in the amount of $217.45',39547,'CAR (14.3)',344,NULL,NULL,NULL,NULL), (242,3,39519,'Michelle','Customer','002898','Playboy','CSR More Bang Sheet','224817','Supplier - Shipped wrong','no','House of Ideas','Provided customer Fedex acct# on PO to ship order but supplier shipped UPS','Supplier billed IPS for shipping ',39519,NULL,NULL,NULL,NULL,NULL,NULL), (243,3,39531,'Michelle','Customer','002898','Playboy','2008 PBTV Intl Mailer','224639','Supplier - Non Conforming Product','no','Taylor Graphics','Supplier did not include verbiage \"Playboy TV\" as part of the logo','Order fulfillment by MMI and did not catch print error until after mailing but supplier re-printed labels to ship to customer',39531,NULL,NULL,NULL,NULL,NULL,NULL), (244,3,39531,'Michelle','Internal','1157T','Mazda','VS-MSS & VS-LLS','224298','Supplier - Late Delivery','no','Alstyle Apparel','Supplier did not ship as scheduled then could not meet next day deadline to have courier pick up order','IPS scheduled courier to pick up but the order was delayed an extra day. End Vendor, Sanctity did a RUSH job to complete order for customer',39531,NULL,NULL,NULL,NULL,NULL,NULL), (245,4,39549,'Christine C','Customer','002860','Centex Homes','bus.cards','224800','SR - Incorrect Info Provided','Yes - Supplier/Carrier Expense','Taylor Graphics','Wrong art file sent','job needs to be re-run. No charge for reprint, customer will pay original invoice.',39549,'CAR (14.3)',348,NULL,NULL,NULL,NULL), (246,4,39552,'Linda','Customer','002673','Fastframe','FB1001','202381','Acctg - Billing Error','no','IPS','Billed to the wrong acct# ','Credit to be issed',39552,NULL,NULL,NULL,NULL,NULL,NULL), (247,4,39552,'Linda','Customer','1730','Leslies','VD-01','303099','Acctg - Billing Error','no','IPS','Customer billed in error','Credit to be issed',39552,NULL,NULL,NULL,NULL,NULL,NULL), (248,4,39552,'Linda','Customer','2376','Energy Club','EZ-Seal','303409','Acctg - Billing Error','no','IPS','Client bill incorrect amount','Customer to short pay invoice',39552,NULL,NULL,NULL,NULL,NULL,NULL), (249,4,39552,'Linda','Customer','1730','Leslies','10495','291982','Supplier - Shipped wrong','no','Radstar','Client never received','credit to be issued',39552,NULL,NULL,NULL,NULL,NULL,NULL), (250,4,39552,'jennifer p','Internal','1609','ST JOE','HH 8025','224562','Supplier - No IPS Packing Slip/Labels','no','S&W Manufacture','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39552,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (251,4,39552,'jennifer p','Internal','1350','CHOC','166108','225610','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39552,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (252,4,39552,'jennifer p','Internal','1730','LESLIES','11139','226114','Supplier - No IPS Packing Slip/Labels','no','TAYLOR','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39552,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (253,4,39552,'jennifer p','Internal','1428','ST MARY','7070.013','225966','Supplier - No IPS Packing Slip/Labels','no','CAL SNAP','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39552,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (254,4,39553,'jennifer p','Customer','002848','Source Refrig','SR-7200A','215976','Whse - Shipped Short or Wrong','no','k&g','requested them to ship 1 carton, but they shipped two instead','customer will adjust their PO and keep the extra stock, made a revision on the release',39553,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (255,4,39553,'jennifer p','Customer','002848','Source Refrig','SR-7200A','216204','Whse - Shipped Short or Wrong','no','k&g','requested them to ship 1 carton, but they shipped two instead','customer will adjust their PO and keep the extra stock, made a revision on the release',39553,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (256,4,39552,'Tammi','Customer','002972','McCormick Int\'l','8-11900','226098','CSR - Input Error','no','On Demand','CSR entered qty of 2000 and order was written for qty of 2',NULL,NULL,'CAR (14.3)',2010,NULL,NULL,NULL,NULL), (257,4,39555,'jennifer p','Internal','1730','Leslies','11569','226132','Supplier - No IPS Packing Slip/Labels','no','Kieran Label','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39555,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (258,4,39555,'jennifer p','Internal','1479SC','SBMMC-San Clemente','8720.75SC','226388','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39555,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (259,4,39555,'jennifer p','Customer','002733','Oakwood','PM1408','216686','Whse - instruct not followed','no','F&S','We instructed F&S to ship this out on 4/15 UPS Overnight service to arrive 4/16. They shipped it ground, instead','Shipped replacement out Overnight at their expense, and issued stop shipment and return to stock on the ground shipment',39555,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (260,4,39555,'jennifer p','Internal','1481','AMMC','3025577','226214','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39555,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (261,4,39555,'Bret A','Customer','002733','Oakwood','2008 CALANDERS','212770','Cust - Incrrct/Mssng info Provided','Yes - Client Expense','Dual','One month out of calander project was proofed incorrectly by client (extra day in month I believe)','Vendor unwrapped individual packages, inserted new copy for corrected month, recelloed and shipped out. Reworked under p.o. 214615',39555,NULL,NULL,NULL,NULL,NULL,NULL), (262,4,39556,'jennifer p','Customer','1409B','ST Jude','208378','224279','Supplier - Short, Partial, wrong Qty','no','PressTime','we ordered 60 pd/50, but the vendor produced 60 pd/100.','We will keep the product, and adjust the pricing, and unit of issue',39556,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (263,4,39556,'jennifer p','Internal','1409B','ST Jude','208378','224279','Supplier - No IPS Packing Slip/Labels','no','PressTime','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39556,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (264,4,39556,'jennifer p','Internal','1157B','Brand M','Various','222274','Supplier - No IPS Packing Slip/Labels','no','AD SPECIALTIES','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39556,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (265,4,39556,'jennifer p','Internal','1428','ST MARY','8560.018/ 6080.016','226131','Supplier - No IPS Packing Slip/Labels','no','CAL SNAP','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39556,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (266,4,39556,'Debbie','Internal','1398','St. Joseph','6000-0112','224352','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Pro Forms','Top ply was collated incorrectly and out of registration, logo was dropped from the pdf.','Rerun received but labeled incorrectly',39556,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (267,4,39559,'Cheryl','Customer','002043','Unified Grocers','S508/l508','226241','SR - Incorrect Info Provided','Yes - IPS Expense','Sanmar/authentic','Wrong shirts ordered and embroidered','Entered a new P.O. to order the correct shirts to be embroidered',39568,'CAR (14.3)',25,NULL,NULL,NULL,NULL), (268,4,39559,'Charles F','Internal','1730','Leslie\'s','6007-M, 6007-XL','216153','Supplier - No IPS Packing Slip/Labels','no','D&D concepts','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39559,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (269,4,39559,'Charles F','Internal','1730','Leslie\'s','1868KH-4230, FP110KH-1234','226996','Supplier - No IPS Packing Slip/Labels','no','Dickies','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39559,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (270,4,39559,'Charles F','Internal','1479','SMMC','23302','227767','Supplier - No IPS Packing Slip/Labels','no','Professional Media Resources','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39559,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (271,4,39559,'Debbie','Internal','1398','St. Joseph','8700-0150','222781','Supplier - Late Delivery','no','International Filing Company','Customer confirmed the ship date then didn\'t deliver as promised','Stock received late.',39559,'Log ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (272,4,39560,'Dan D','Customer','002770','Prometheus','PRO043','213921','Cust - ordered Wrong or Late','no',NULL,'Customer ordered wrong color flags that were in stock.','Client returned inventory to VOS for credit.',NULL,'CAR (14.3)',1254,NULL,NULL,NULL,NULL), (273,4,39560,'jennifer p','Internal','002534','RMC','100-395','226264','Supplier - No IPS Packing Slip/Labels','no','PRO','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39560,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (274,4,39560,'jennifer p','Internal','1481','AMMC','2018205','225676','Supplier - No IPS Packing Slip/Labels','no','Su Mano','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39560,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (275,4,39561,'Dan D','Customer','002770','Prometheus','Freight Charge','211233','Acctg - Billing Error','no',NULL,'Customer disputing freight charge of $48.26.','Credit and Re-bill freight for amount of $5.57',NULL,'CAR (14.3)',NULL,NULL,NULL,NULL,NULL), (276,4,39561,'jennifer p','Internal','1479SC','San Clemente','8720.141SC','226475','Supplier - No IPS Packing Slip/Labels','no','Taylor','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39561,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (277,4,39561,'jennifer p','Internal','1440','Mission','213673','227863','Supplier - No IPS Packing Slip/Labels','No','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39561,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (278,4,39561,'jennifer p','Internal','1478','LBMMC','1005091/ 1005654','227457','Supplier - No IPS Packing Slip/Labels','No','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39561,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (279,4,39562,'Rob G','Customer','1157','Mazda','9999-95-4624-08','222327','SR - Incorrect Info Provided','no','CCI','Customer was charged incorrectly','Need to credit and rebill',39562,'CAR (14.3)',2039,NULL,NULL,NULL,NULL), (280,4,39563,'Tammi','Customer','1409m','St. Jude','235','221233','Cust - Incrrct/Mssng info Provided','Yes - IPS Expense','IPS','art submitted by client had inconsistent colors and when file was moved from art dept to print shop, data was dropped','reprinted with corrected art, with additional art changes by the client',39563,'CAR (14.3)',2052,NULL,NULL,NULL,NULL), (281,4,39566,'jennifer p','Internal','002534','RMC','505-796','227551','Supplier - No IPS Packing Slip/Labels','no','Arrowhead Press','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39566,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (282,4,39566,'jennifer p','Internal','1478','LBMMC','3025093','225798','Supplier - No IPS Packing Slip/Labels','no','Genforms','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39566,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (283,4,39566,'jennifer p','Internal','002533','Redlands','001634','223531','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39566,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (284,4,39566,'jennifer p','Internal','002534','RMC','150-216','227546','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39566,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (285,4,39567,'Jim I','Customer','002213','Flextronics','NB150C','221987','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Journal Books','Plant inserted pens supplied by IPS that were not a good fit in the pen lopop. The pens could not be removed easily, and customer was unhappy','Plant credited us the cost of inserting pens, then made new pens that we could re-insert',39567,'CAR (14.3)',2071,NULL,NULL,NULL,NULL), (286,3,39514,'Michelle','Internal','1157T','Mazda','VS-MSS & VS-LLS','224298','Supplier - Late Delivery','no','Alstyle Apparel','Supplier did not ship as scheduled then could not meet next day deadline to have courier pick up order','IPS scheduled courier to pick up but the order was delayed an extra day. End Vendor, Sanctity did a RUSH job to complete order for customer',39514,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (287,4,39567,'Michelle','Customer','1157B','Mazda','91-M301-L, 91-M304-L, 91-U330-000, 91-U183-000','R#215309','Acctg - Release/Inventory Error','no','F&S','Customer did not receive balance of order after initial backordered item was credited, many voicemails & email follow-ups w/customer while waiting for status of release since no tracking listed in release for items reflecting \"shipped\"','Issuing crdit to customer for the complete order and shipping him the available items including a free mug',39567,'CAR (14.3)',2060,NULL,NULL,NULL,NULL), (288,4,39567,'Michelle','Customer','1157B','Mazda','91-U330-000','R#215602','Carrier - Error','no','F&S','Defective Item','Issuing credit for returned item',NULL,'CAR (14.3)',2057,NULL,NULL,NULL,NULL), (289,4,39567,'Michelle','Customer','1157B','Mazda','91-M304-M','R#216280','Acctg - Release/Inventory Error','no','F&S','Customer ordered 2 but order was mistakenly keyed in as 20','Issuing credit for the 18 items returned',NULL,'CAR (14.3)',2056,NULL,NULL,NULL,NULL), (290,4,39560,'Michelle','Internal','1157B','Mazda','91-M351(M, L, XL, 2)','PO#222512','Supplier - ***to be determined','Yes - Supplier/Carrier Expense','Ash City','Item received with a slight hint of pink which should have been white shirts','Re-ordered the shirts that again received in slight pink color so order returned for the 2nd time and re-ordered the shirts from new vendor, Bodek & Rhodes, PO# ',NULL,NULL,NULL,NULL,NULL,NULL,NULL), (291,4,39567,'Michelle','Customer','1157B','Mazda','10-005L, 10-005X, 10-008L, 10-008X, 10-011X','R#208117','Cust - ordered Wrong or Late','no','F&S','Customer made mistakes on initial order','Customer returned 11 of the 13 items ordered, only 8 items were authorized for return',NULL,'CAR (14.3)',2062,NULL,NULL,NULL,NULL), (292,4,39567,'Michelle','Customer','1157B','Mazda','91-M256-0WM','R#202321','Cust - ordered Wrong or Late','no','F&S','Customer did not like','Issuing credit for item returned',NULL,'CAR (14.3)',2063,NULL,NULL,NULL,NULL), (293,4,39567,'Joe H','Customer','002826','OCUW','NAME BADGE','229121','Supplier - Shipped wrong','no','VIP','job was packaged out of order','removed fulfillment from this job. Will be inlcued on the next',39568,NULL,NULL,NULL,NULL,NULL,NULL), (294,4,39568,'Lori','Customer','1409b','St Jude','Polo Shirts','226274','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Classic Embroidery','Wrong logo was embroided on shirts. St Joe logo instead of St Jude','IPS reordred shirts and Classic will embroider with correct logo. Classic will pick up the cost of the extra shirts',39568,'CAR (14.3)',2072,NULL,NULL,NULL,NULL), (295,5,39569,'Michelle','Customer','003030','Long Beach State Sport Management Program','PPS','223827','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Leed\'s','Customer was not happy w/finished product ','Re-print at vendor\'s expense, close out original PO# 223827 & reproduced on PO# 229535',39569,'CAR (14.3)',2064,NULL,NULL,NULL,NULL), (296,5,39574,'jennifer p','Internal','1409B','St Jude','240463','227880','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39574,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (297,5,39574,'jennifer p','Internal','002733','Oakwood','PM1408','217716','Supplier - No IPS Packing Slip/Labels','no','Su Mano','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39574,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (298,5,39574,'jennifer p','Internal','002043','Unified Grocers','UG1607','227870','Supplier - No IPS Packing Slip/Labels','no','CAL SNAP','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39574,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (299,5,39575,'jennifer p','Internal','1730','Leslies','11210','228474','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39575,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (300,5,39576,'jennifer p','Customer','1157B','Brand M','Various','216879','Whse - Shipped Short or Wrong','no','F&S','F&S was supposed to ship 25 hats to this customer, and all of their paperwork noted that they had, but customer claimed they only received 8 hats','F&S researched, and found that they were wrong and did NOT ship all of the product to custmer. They shipped out balance today via UPS overnight, at their expense.',39576,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (301,5,39576,'Linda','Customer','002376','Energy Club','BEY','227738','Supplier - Short, Partial, wrong Qty','no','Digital Label','Shipped 3000 each, billed for 3300each','Invoice to be short paid by $28.56 plus $2.36 tax = $30.92',NULL,NULL,NULL,NULL,NULL,NULL,NULL), (302,5,39576,'Linda','Customer','1730','Leslie','Binder-FF','219506','Supplier - Non Conforming Product','no','Docupak','Defective binder rings came open during shipping an 30% of the contents fell out of the shipping container','20% discount - Client to pay $5642.00 plus $465.46 (tax) and $106.011 (frt) for a total of $6213.57. Contacting Vendor for a credit',NULL,NULL,NULL,NULL,NULL,NULL,NULL), (303,5,39577,'Lori','Customer','002496','LBS Financial','Lip Balm','220595','Supplier - Non Conforming Product','no','Points of Light','Vendor\'s imprint did not match the approved proof.','Vendor will issue a CM for 350. We will give customer a credit for 350.00',39577,'CAR (14.3)',NULL,NULL,NULL,NULL,NULL), (304,5,39577,'Michelle','Customer','002918','Adready, Inc.','White Paper & Case Studies','226392','CSR - Input Error','no','Taylor Graphics','Order entered as LT/500 instead of LT/1500 for 3 versions - accounting billed customer for what was shipped from Taylor\'s invoice which was an overbill of 2/3 the price','IPS issuing credit to customer for the amount overbilled',39577,'CAR (14.3)',2053,NULL,NULL,NULL,NULL), (305,5,39579,'ron','Customer','1207','oii','Z340077','225968','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Taylor Graphics','Boxes had \"white\" offset marks on the printing','Taylor will pick up these boxes and go through tem and re-print as needed',39580,'CAR (14.3)',1013,NULL,NULL,NULL,NULL), (306,5,39581,'Talya','Customer','002353','Sysco Harmony','DTP','226408','Acctg - Billing Error','no','Label Resources','Vendor Freight charge of $670 + 20% =837.50 charged to client. Client complained about freight charge too high.','client to short pay invoice by $ 167.50',39581,'CAR (14.3)',1520,NULL,NULL,NULL,NULL), (307,5,39581,'joanne','Customer','002534','RMC','525-835','229281','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','claremont print','Vendor printed only one side of a 2-sided form','Repint',39581,'CAR (14.3)',1650,NULL,NULL,NULL,NULL), (308,5,39581,'jennifer p','Customer','002489','1st american','talon policies','219024','Supplier - Late Delivery','no','quantum','Order came in over the internet 4/29/08 and did not go through to us- client emailed us on the 12th looking for the order.','Jennifer emailed quantum and they say they can not re-create the problem and that they can not fix it since it is only happening to us. Ups 3 day on img\'s account',39581,NULL,NULL,NULL,NULL,NULL,NULL), (309,5,39580,'jennifer p','Customer','002489','1st american','newsletter distribution',NULL,'CSR - Instructions not followed','no','IPS','spread sheet sent to distribute newsletters -- last page of list did not get done -- lots of late orders','Jennifer is real sorry and this will not happen again.',39581,NULL,NULL,NULL,NULL,NULL,NULL), (310,5,39581,'jennifer p','Internal','1409B','St Jude','182800','228960','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (311,5,39581,'jennifer p','Internal','1478','LBMMC','1069586','228728','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (312,5,39581,'jennifer p','Internal','1479','SBMMC','8700.27','228801','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (313,5,39581,'jennifer p','Internal','1478','LBMMC','1005027','229135','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (314,5,39581,'jennifer p','Internal','1440','Mission','214117','227849','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (315,5,39581,'jennifer p','Internal','1479','SBMMC','24161','228690','Supplier - No IPS Packing Slip/Labels','no','PJ Printers','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39581,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (316,5,39581,'Mike','Customer','003076','Cachet','flashlights/booklights','227475','Supplier - Non Conforming Product','no','Calibre Int\'l','Jill is sending us one of the flashlights --- she said they don’t look good\nThe flashlights got delivered to Santa Ana -- Jill sent them on to TX --- \nThe book lights got to TX - Jill is hoping that they look good --- \nThe people at high Caliber are n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (317,5,39582,'jennifer p','Internal','1428','St. Mary','6080.012','229128','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39582,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (318,5,39583,'jennifer p','Customer','002489','First American','1160014X030800','204602-a','Cust - ordered Wrong or Late','no',NULL,'customer ordered 50 pk/25, but they meant to order a total of 50 folders (which would be 2 pk/25).','customer returned 48 packs to F&S - return # is Quantum is 1965',39583,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (319,5,39583,'jennifer p','Internal','1409b','St Jude','118066','229588','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39583,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (320,5,39583,'jennifer p','Internal','1428','ST MARY','8560.031','229385','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39583,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (321,5,39583,'jennifer p','Customer','002489','First American','0030007X120400','qnet# 41663','Quantum error','no','quantum','customer placed an order on 4/25, but did not generate to our end, from Quantum','Had Quantum retore on their end and re-send us the order, and sent to customer on 5/15. Quantum can provide no explanation to us, as to why this error is occuring',39583,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (322,5,39584,'jennifer p','Customer','1730','Leslies','Various','217551','Cust - ordered Wrong or Late','no',NULL,'Leslies ordered this product too soon for a new store, and product arrived before store opened.','Stock returned to F&S 5/15, turned around and send it back out overnight on Leslies Fedex account, to arrive 5/16. ',39584,'CAR (14.3)',1166,NULL,NULL,NULL,NULL), (323,5,39584,'jennifer p','Customer','002770','Prometheus','Various','219327','Quantum error','no','quantum','another order that did not transmit over to us, from Quantum','Quantum restored the order, and we shipped out on 5/16',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (324,5,39584,'jennifer p','Internal','002733','Oakwood','PM1408','217716','Supplier - No IPS Packing Slip/Labels','no','Su Mano','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (325,5,39584,'jennifer p','Internal','1481','AMMC','1005648','228808','Supplier - No IPS Packing Slip/Labels','no','Megaform','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (326,5,39584,'jennifer p','Internal','1481','AMMC','2021570','229526','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (327,5,39584,'jennifer p','Internal','1440','Mission','213443','229809','Supplier - No IPS Packing Slip/Labels','no','Block','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (328,5,39584,'jennifer p','Internal','1481','AMMC','2018213','229109','Supplier - No IPS Packing Slip/Labels','no','Pro Document','Stock arrived at F&S without an IPS packing slip.','Stock received okay.',39584,'LOG ONLY - no action ',NULL,NULL,NULL,NULL,NULL), (329,5,39587,'Cheryl','Internal','2954','Antex','A108','218766','Supplier - Non Conforming Product','Yes - Supplier/Carrier Expense','Block','Missing Numbers and incorrect paper work','Vendor reprinted the job',39587,'CAR (14.3)',26,NULL,NULL,NULL,NULL), (330,5,39598,'Jim G','Customer','2834','Jonathan Louis','BC','217410','CSR - Input Error','no','House of Cards','wrong unit price entered','credit',NULL,NULL,2076,NULL,NULL,NULL,NULL), (331,5,39598,'Jim G','Customer','2853','Pathology Inc.','331A','231266','CSR - Input Error','no','National','wrong unit of measure entered','rebill & create new PO#',NULL,NULL,2077,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `iso_log` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;