For Stocks Inquiry

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 13

Procedure #2b Worksheet - Checking of Processed RS but without CM (Status 5, 11, 12 & 22)

Branch: D08 - Mexico


Generation Date:
7/25/2023

RS Date RS Whse Customer Order Receiving No.


10-16-2022 D08 2108149326 4430024842
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-23-2022 D08 2108152908 4430025654
12-28-2022 D08 2108152743 4430025682
06-03-2023 D08 2108160214 4430027285
06-03-2023 D08 2108160214 4430027285
06-03-2023 D08 2108160214 4430027285
07-03-2023 D08 2108161685 4430027602

Prepared by:

Approved by:
Credit Memo Item No.
284100003921
280000000100
738600001353
027700007497
027700007096
275500001092
275500000282
738600001370
027700007249
738300000033
052300002716
427300001228
284100001926
027700007562
Description Approved Qty.
PICASSO/SM 300X300MM LX21 SAPPHIRE GREY 0
SAIGRES/AMY 60X60CM GOLD STATUARIO (P) (21.B.660.4270) GLAZE 0
SAIGRES/AMY 60X60CM NATURAL LIMESTONE SILVER (M) (21.B.660.6 0
VERONA/FQ 60X60CM PY6648 FOXX 0
ARTE/OM 20X30CM OM233197 OLIVER 0
VERONA/XJS 60X60CM XJS62202 PASCAL CREMA GL POL POR 0
ARTE/YTC 60X60CM ZKW6611 YVORA BEIGE GL RFM CER 0
SAIGRES/AMY 60X60CM BASENTINA MOKA IVORY WHITE (M) (21.E.660 0
ARTE/OM 20X30CM OM232263 ORANI (G) 0
EMIGRES 25X75 CRAFT BLANCO R (PB) 0
POZZI/URINAL PST 5009 STAN 0
SEFA FOSW OT-01022 LAVATORY BRACKET CAST IRON 0
BIRKE/TH LJ-5039C URINAL FLUSH VALVE SS304 0
VERONA/FQ 60X60CM GLM6302 FAWN GRIS (M) 0
RS Status Credit Qty. CM Status Age (in days)
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
11 0 0
Remarks/Store Feedbacks
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED DAM FROM DELIVERY/C/O RECEIVING DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
CANCELLED FOR CLOSED/ C/O TRD.DEPARTMENT/DOUBLE CREATE
3 Worksheet - Checking RS Transactions but with No Actual Items
Branch: D08 - Mexico
Date: 06/12/2023 - 08/03/2023

RS Date RS Whse Customer Order Receiving No.


08-19-2022 D08 3004974035 4430024152
08-25-2022 D08 3005011537 4430024205
09-02-2022 D08 3005216346 4430024289
09-12-2022 D08 2108147641 4430024409
09-20-2022 D08 3005414216 4430024518
09-20-2022 D08 3005470171 4430024523
09-23-2022 D08 2108148034 4430024564
09-27-2022 D08 2108148113 4430024608
09-29-2022 D08 2108147957 4430024640
10-03-2022 D08 2108148546 4430024667
10-12-2022 D08 2108149353 4430024787
10-12-2022 D08 2108149353 4430024787
10-15-2022 D08 2108148537 4430024824
10-15-2022 D08 2108148838 4430024826
10-16-2022 D08 2108149329 4430024840
10-18-2022 D08 2108149351 4430024876
10-18-2022 D08 2108149351 4430024876
10-21-2022 D08 2108149907 4430024919
10-26-2022 D08 3005497706 4430024980
10-27-2022 D08 2108149348 4430024990
10-29-2022 D08 2108149568 4430025017
10-30-2022 D08 3005978538 4430025030
11-11-2022 D08 3006137020 4430025176
11-13-2022 D08 3006115693 4430025186
11-15-2022 D08 2108149408 4430025210
11-21-2022 D08 3006167638 4430025267
11-21-2022 D08 3006066816 4430025270
11-23-2022 D08 2108150803 4430025301
12-02-2022 D08 2108150607 4430025438
12-05-2022 D08 2108152292 4430025469
12-09-2022 D08 3006522184 4430025495
12-16-2022 D08 3006570385 4430025584
12-18-2022 D08 2108151960 4430025611
12-23-2022 D08 2108151175 4430025648
12-28-2022 D08 3006785713 4430025687
01-06-2023 D08 3006788368 4430025740
01-06-2023 D08 3006862647 4430025748
01-07-2023 D08 2108153555 4430025752
01-20-2023 D08 2108154025 4430025886
01-24-2023 D08 3007091505 4430025915
01-26-2023 D08 2108153975 4430025947
01-30-2023 D08 2108153065 4430025982
02-03-2023 D08 3007115981 4430026038
02-09-2023 D08 2108155139 4430026123
02-21-2023 D08 3007479234 4430026262
02-22-2023 D08 2108155236 4430026283
03-10-2023 D08 2108155364 4430026451
03-16-2023 D08 2108156331 4430026481
03-20-2023 D08 3007841727 4430026523
03-25-2023 D08 2108157007 4430026576
03-29-2023 D08 3007963395 4430026620
04-10-2023 D08 3008054953 4430026706
04-10-2023 D08 2108157651 4430026709
04-13-2023 D08 2108157386 4430026744
04-29-2023 D08 3008340605 4430026924
05-11-2023 D08 3008493110 4430027032
05-13-2023 D08 3008495739 4430027072
05-14-2023 D08 3008466705 4430027075
05-18-2023 D08 3008568507 4430027107
05-19-2023 D08 3008529810 4430027130
05-22-2023 D08 3008645778 4430027146
05-23-2023 D08 2108159657 4430027161
06-04-2023 D08 2108159261 4430027300
06-13-2023 D08 3008745027 4430027395
06-19-2023 D08 2108161047 4430027466
06-22-2023 D08 3009163140 4430027491
07-02-2023 D08 2108161675 4430027597
07-03-2023 D08 3009359826 4430027599
07-11-2023 D08 2108160861 4430027674
07-19-2023 D08 2108161642 4430027741
07-21-2023 D08 3009656565 4430027769
10-05-2022 D08 2108148815 4430024706
05-31-2023 D08 2108159606 4430027247
Credit Memo Item No. Description Approved Qty. RS Status
7100978538 284400017832 HEIM/WF FHX-A-646 M 1 33
7100982477 986600000346 SEFA/FOSW OT-01035 1 33
7100988355 986600000322 SEFA/FOSW OT-86013 1 33
959600000833 POZZI/GG PWM-20A01- 2 33
7101001193 959800002067 ALPHALUX/IGT WD515 1 13
7101001657 986600000305 SEFA/FOSW OT-71303 1 33
7101003923 027700007223 VERONA/JB 60X120CM 2 33
284100003929 SEFA/OT OT-01140 JA 1 33
738600001382 SAIGRES/AMY 60X120C 2 33
275500000641 VERONA/FM 60X120CM 2 33
7101018059 959600000833 POZZI/GG PWM-20A01- 2 33
7101018059 317400000378 POZZI /ACC LVA-018 ( 1 33
959600000775 POZZI/HBS HB-12955 1 33
986600000305 SEFA/FOSW OT-71303 1 33
7101020940 045200005145 PCK CODIE PLUS PRES 2 33
7101024456 317400000378 POZZI /ACC LVA-018 ( 1 33
7101024456 959600000833 POZZI/GG PWM-20A01- 2 33
7101024733 427300000591 POZZI P32060201 STAI 1 33
7101028553 959800002174 ALPHALUX/SJ 19109- 1 33
7101029124 317200000558 BASEL/SWR 30X60CM 5 33
317200000558 BASEL/SWR 30X60CM 5 33
7101030638 173900000936 ATLANTA PVC DURAC 5 33
7101039008 959800000582 P.TECH/HCP HP51701- 4 13
7101039914 986600000322 SEFA/FOSW OT-86013 1 33
427300000591 POZZI P32060201 STAI 1 33
7101045854 959800001358 P.TECH/INT JC445-730 1 13
7101046000 986600000333 SEFA/FOSW OT-81029 1 33
7101047632 027700003757 SOL/AD 60X60CM LF68 8 33
986600000300 SEFA/FOSW OT-71309 1 33
7101057103 317400000378 POZZI /ACC LVA-018 ( 1 33
7101059991 284100003225 SEFA/OT OT-77086-6 1 33
7101065309 317400000378 POZZI /ACC LVA-018 ( 1 13
986600000602 BASEL/QBO 30X60CM 6 5 33
135000000016 PERFORATED TAPE (JO 1 33
7101072884 037000000216 PLEDGE LEMON 330M 1 33
7101076980 427300000591 POZZI P32060201 STAI 1 33
7101077265 986600000345 SEFA/FOSW OT-01034 1 13
7101077636 284100003929 SEFA/OT OT-01140 JA 1 33
738600001382 SAIGRES/AMY 60X120C 2 33
7101089083 986600000650 SEFA OT-34501 COLD 1 33
7101092297 738600001340 SAIGRES/AMY 60X120CM 2 33
008600000298 BOYSEN 7154 4L SEMI 2 33
7101100157 317400000378 POZZI /ACC LVA-018 ( 1 33
7101104333 427300000591 POZZI P32060201 STAI 1 33
7101112316 986600000127 SEFA OT-34003 BAR S 1 33
7101113333 986600000483 BASEL/RM 30X60CM 6 5 33
284300000042 POZZI/WL 861340 EX 2 33
027700007688 SOL/QF 60X60CM JV3 4 33
7101132220 284400015732 HEIM/FT 180142 TURT 1 33
7101136109 173900000087 ATLANTA AQUALINE PI 1 33
7101138752 959600000838 POZZI/GG PWM-20A02- 5 33
7101145159 203400000193 VESBO TVFUP25 FEMAL 2 13
7101145290 002000003267 ABC F2 2KLS SANDEL 2 33
7101147530 275500000031 SOL/MS 60X60CM 66T0 4 33
7101158936 284100003252 SEFA/OT OT-62019 FE 1 33
7101166770 986600000339 SEFA/FOSW OT-01028 1 33
7101168592 104000000380 SUN & RAIN SR-020 1 1 33
7101168874 284400020579 HEIM/GZI JL3071-04 1 33
7101171289 986600000339 SEFA/FOSW OT-01028 1 33
7101172694 986600000300 SEFA/FOSW OT-71309 1 33
7101174175 986600000038 BASEL/CN 20X120CM 1 33
7101175280 002000003267 ABC F2 2KLS SANDEL 2 33
427300000591 POZZI P32060201 STAI 1 33
7101193769 104000000237 DAVIES MCS-0117 4L 1 13
7101198682 284400011169 HEIM/FF WS-6023538 1 33
7101201175 986600000588 SEFA/FOSW OT-01075 1 33
283600001194 ALPHALUX/YD YD-D-S4 1 33
7101211181 135000000016 PERFORATED TAPE (JO 1 33
284600000127 BASEL/SVZ 30X60CM S 5 33
427300000591 POZZI P32060201 STAI 1 33
7101228022 284100003297 SEFA/OT OT-65043 J 1 33
7101012778 738600001340 SAIGRES/AMY 60X120CM 2 33
027700008396 SOL/GJ 60X60CM DS6 4 33
ADO LOV Qty
Credit Qty. CM Status LOV Qty Difference Remarks/Audit Findings
1 2
1 2
1 2
2 2
1 2
1 2
2 2
1 2
2 2
2 2
2 2
1 2
1 2
1 2
2 2
1 2
2 2
1 2
1 2
5 2
5 2
5 2
4 2
1 2
1 2
1 2
1 2
8 2
1 2
1 2
1 2
1 2
5 2
1 2
1 2
1 2
1 2
1 2
2 2
1 2
2 2
2 2
1 2
1 2
1 2
5 2
2 2
4 2
1 2
1 2
5 2
2 2
2 2
4 2
1 2
1 2
1 2
1 2
1 2
1 2
1 2
2 2
1 2
1 2
1 2
1 2
1 2
1 2
5 2
1 2
1 2
2 2
4 2
D8-STORE REMARKS
CHANGE OF MIND /ETP
CHANGE OF MIND/ETP
CHANGE OF MIND /ETP
CHANGE OF MIND/CHANGE OTHER ITEMS.
CHANGE OF MIND /ETP
CHANGE OF MIND /ETP
Damaged from delivery
CHANGE OF MIND
CHANGE OF MIND
Damaged from delivery
FCE/DOUBLE C.O/UNSERVED.
FCE/DOUBLE C.O/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND /UNSERVED
System error double c.o/UNSERVED.
System error double c.o/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND
Return sample/REGULAR CUSTOMER
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CANCELLED C.O/INCOMPLATE ITEMS.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND /CHANGED DESIGNED
CHANGE OF MIND /CHANGE OTHER ITEMS.
DOUBLE C.O FOR CORRECTING ENTRY/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND /EXCESS ITEMS.
CHANGE OF MIND /CHANGE OTHER ITEMS.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CANCELLED C.O CHANGE PAYER/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND
Damaged from delivery
FCE/NO DISCOUNT.
CHANGE OF MIND
CANCELLED C.O CHANGE PAYER/UNSERVED.
CHANGE OF MIND
DAMAGED FOR REPLACEMENT
CHANGE OF MIND /CHANGE OTHER ITEMS.
DAMGED FOR CM
CHANGE OF MIND
CHANGE OF MIND /change item
CHANGE OF MIND
CHANGE OF MIND
CANCELLED INVOICE NO STOCKS/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CANCELLED C.O INSUFFICIENT PAYMENT.
CHANGE OF MIND
CHANGE OF MIND
FCE/DOUBLE C.O/UNSERVED.
CHANGE OF MIND
CHANGE OF MIND /change model /unserved.
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND
CHANGE OF MIND /cancelled c.o
DAMAGED FROM DELIVERY.
CHANGE OF MIND

You might also like