REQUEST_ID WARRANTY_PO_NUMBER ORDER_NUMBER TRX_NUMBER INV_AMOUNT CN_NUMBER
239494884 137512936127 227092449 6100059 352.82 13066
239494884 121375309961236 227092439
239494884 337513737 227092407 6100013 352.82 12997
239494884 1213751372151235
239494884 6375301723
239494884 137530984127 227092455 6100063 352.82 13065
239494884 121375318601235 227092440
239494884 6375137373 227092428 6100046 352.82 13051
239494884 137512740 227092417 6100018 352.82
239494884 237513737 227092397 6100003 352.82 12988
239494884 121375304325891235 227092443
239494884 337522335 227092405 6100011 352.82 13061
239494884 1213751372261236 227092432
239494884 1213751372151236
239494884 121375309961235 227092434
239494884 121375318601236 227092444
239494884 1213751372261235 227092433
239494884 137530313127 227092454 6100062 352.82 13064
239494884 121375304325891236 227092435
239494884 137522335127 227092453 6100061 352.82 13062
239494884 137530319127 227092446 6100058 352.82
239494884 137513737127 227092452 6100060 352.82 13063
239494884 121375317121236 227092445
239494884 121375317121235 227092436
239494884 437513737 227092415 6100016 352.82 13015
CN_AMOUNT DN_NUMBER DN_AMOUNT STATUS
-352.82 13072 352.82 S
SO
-352.82 13008 352.82 ECNA
EO
EO
-352.82 13071 352.82 S
SO
-352.82 13055 352.82 ECNA
ECN
-352.82 12989 352.82 ECNA
SO
-352.82 13068 352.82 S
SO
EO
SO
SO
SO
-352.82 13070 352.82 S
SO
-352.82 13069 352.82 S
ECN
-352.82 13067 352.82 ECNA
SO
SO
-352.82 13022 352.82 ECNA
ERROR_MESSAGE
ARP_PROCESS_APPLICATION.CM_APPLICATIONORA-20001: A cash application is being made against a transaction with zero li
,Validation failed for the field - Order Type
,Please enter required information - Inventory Item
ARP_PROCESS_APPLICATION.CM_APPLICATIONORA-20001: A cash application is being made against a transaction with zero li
,Invalid bill-to customer ID. ,Invalid bill-to address ID.
ARP_PROCESS_APPLICATION.CM_APPLICATIONORA-20001: A cash application is being made against a transaction with zero li
,Validation failed for the field - Order Type
ARP_PROCESS_APPLICATION.CM_APPLICATIONORA-20001: A cash application is being made against a transaction with zero li
ARP_PROCESS_APPLICATION.CM_APPLICATIONORA-20001: A cash application is being made against a transaction with zero li
OU_NAME WARRANTY_PO_NUMBER CUSTOMERBILL_TO_ SHIP_TO_ CUSTOMER_C
CMI After Sa121375258401236 SHINGALA 328, soham 328,
a soham 8511000586
a
CMI After Sa1213752583901236 SHINGALA 328, soham 328,
a soham 8511000586
a
CMI After Sa121375309961236 KANHAIYA L2/23 CLUST 2/23 CLUST 9415714588
CMI After Sa1213753102901236 AVINASH KUmirzapur ra mirzapur ra 9450476760
CMI After Sa121375317121236 SHANTANU VPO NANDGR
VPO NANDGR
9732190632
CMI After Sa121375318601236 SANTANU Mbirnagari ra birnagari ra 8145345839
CMI After Sa121375304291236 PURABI DAS14 first flo 14 first flo 8473893962
CMI After Sa121375127251236 PURABI DAS14 first flo 14 first flo 8473893962
CMI After Sa121375312781236 TARUN BANPRO-17,1STPRO-17,1ST8473893962
CMI After Sa121375254861236 TARUN BANPRO-17,1STPRO-17,1ST8473893962
CMI After Sa121375304321236 TARUN BANPRO-17,1STPRO-17,1ST8473893962
CMI After Sa1213751372151236 NILADRISH 201 239 MB 201 239 MB 8420017581
CMI After Sa1213751372261236 NILADRISH 201 239 MB 201 239 MB 8420017581
CMI After Sa1213751274071236 HOTEL WELH G B Road H G B Road 9436460029
CMI After Sa1213751274081236 HOTEL WELH G B Road H G B Road 9436460029
CMI After Sa1213751274081236 HOTEL WELH G B Road H G B Road 9436460029
CMI After Sa1213753043251236 TARUN BANPRO-17,1STPRO-17,1ST8473893962
CMI After Sa121375304325891236 TARUN BANPRO-17,1STPRO-17,1ST8473893962
CMI After Sa 137513737127 RAJASRI C 100 12 BHA 100 12 BHA 8420621130
CMI After Sa 137522335127 PARUL pb 223 bptppb 223 bptp 8800154373
CMI After Sa 137530319127 MOTI BAGAN7890891530
ARCAHANA MOTI BAGAN
CMI After Sa 137530172127 SUDANDRA 17/9 1st st 17/9 1st st 9940112339
CMI After Sa 137512936127 AFSAR SHA 725/4, IND 725/4, IND 9760139259
CMI After Sa 137530313127 PRABHAKERSati Lane HoSati Lane Ho 8235714647
CMI After Sa 137530984127 Swan don mil9820276844
RAJESH PANSwan don mil
Web Adi uploaded Data
ITEM_CODE QUANTITY PRICE SALES_OFFASP_CUSTODATE_OF_PUODU_ITEMSERIAL_N
CHH24B5HWFS@CMI 1 299 208 M9052222 6/29/2022 224050071 5007129172
CHH24B5HWFS@CMI 1 299 208 M9051814 6/29/2022 224050071 5007129172
CHH24B5HWFS@CMI 1 299 104 M9051995 6/10/2022 224050077 5007767162
CHH24B5HWFS@CMI 1 299 104 M0004799 6/11/2022 224050077 5007764012
CHH24B5HWFS@CMI 1 299 301 M0004629 6/25/2022 224050079 5007951122
CHH24B5HWFS@CMI 1 299 301 M9052191 6/30/2022 224050075 5007562262
CHH24B5HWFS@CMI 1 299 304 M0009690 6/28/2022 224050073 5007387482
CHH24B5HWFS@CMI 1 299 304 M9052217 6/28/2022 224050073 5007387482
CHH24B5HWFS@CMI 1 299 101 M0007745 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 101 M9052221 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 101 M9051898 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 301 M9051934 6/25/2022 224050077 5007776142
CHH24B5HWFS@CMI 1 299 301 M9051934 6/25/2022 224050077 5007773082
CHH24B5HWFS@CMI 1 299 304 M9052217 6/27/2022 224050077 5007767162
CHH24B5HWFS@CMI 1 299 304 M9052217 6/27/2022 224050077 5007767162
CHH24B5HWFS@CMI 1 299 304 M9052217 6/27/2022 224050077 5007767162
CHH24B5HWFS@CMI 1 299 101 M9051934 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 405 M9051934 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 301 M9052073 6/26/2022 224050077 5007779132
CHH24B5HWFS@CMI 1 299 106 801429 6/28/2022 224050077 5007773502
CHH24B5HWFS@CMI 1 299 301 M9051848 5/23/2022 224050077 5007764162
CHH24B5HWFS@CMI 1 299 401 M9052091 6/30/2022 224050079 5007951092
CHH24B5HWFS@CMI 1 299 109 M9052015 6/26/2022 224050077 5007755512
CHH24B5HWFS@CMI 1 299 303 M9051975 6/27/2022 224050077 5007782172
CHH24B5HWFS@CMI 1 299 200 M0004811 6/27/2022 224050079 5007951122
WARRANTY_S
WARRANTY_ORDER_TYPRICE_LI EFFECTIVE_DAR_CREDIAR_DEBIT_NOTE_TYPE
6/29/2023 6/28/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:message
6/29/2023 6/28/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:message
6/10/2023 6/9/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WJ
6/11/2023 6/10/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/25/2023 6/24/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WJ
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WJ
6/28/2023 6/27/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/28/2023 6/27/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/25/2023 6/24/2027 S030 CMI Price Li 13-Dec-2021 CMI_SRV_WCMI_SRV_WJ
6/25/2023 6/24/2027 S030 CMI Price Li 13-Dec-2023 CMI_SRV_WCMI_SRV_WJ
6/27/2023 6/26/2047 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/27/2020 6/26/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/27/2027 6/26/2020 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:messag
6/30/2023 6/29/2027 S030 CMI Price Li 24-Jan-2023 CMI_SRV_WCMI_SRV_WJ
28-Jun-2023 27-Jun-2033 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
28-Jun-2023 27-Jun-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
23-May-2023 22-May-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
30-Jun-2023 29-Jun-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WL <bne:message
26-Jun-2023 25-Jun-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
27-Jun-2023 26-Jun-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
27-Jun-2023 26-Jun-2027 S030 CMI Price Li 28-Jan-2023 CMI_SRV_WCMI_SRV_WJ
Data Mapped from Output File
Messages ORDER_NUMBER TRX_NUMBCN_NUMBEDN_NUMBE
Sales Office.
Sales Office.
227092439 6100053 13080 13087
is inactive
227092445 6100057 13075 13083
227092444 6100056 13078 13084
Sales Office.
Sales Office.
om Item code
is inactive
om Item code
0 0 0 0
227092432 6100048 0 0
Sales Office.
Sales Office.
Sales Office.
om Item code
227092435 6100051 13076 13086
227092452 6100060 13063 13067
227092446 6100058 13073 13088
Sales Office.
Scenarios Scenarios Type
Amc Customer site inactive & ASP site is also inactive Negative case
Amc site is inactive & asp code is clear Negative case
Amc lucknow code is blocked but asp is clear Negative case
Amc lucknow code is blocked but asp code is inactive Negative case
Amc Kolkata code is double primary but asp code is active Negative case
Amc Kolkata code is double primary but asp code is blocked Negative case
Amc Guwahati code is inactive but asp code is ok Negative case
Amc Guwahati code is inactive but asp code is doubel primary Negative case
Amc delhi code is ok but asp code is blocked Negative case
Amc delhi code is ok but asp code is inactive Negative case
Amc delhi code is ok but asp code double primary Negative case
Effective date back date Negative case
Effective date is future date Negative case
end date future date Negative case
Start date is before System date Negative case
End date is before System date Negative case
Amc delhi but Asp for kolkata Negative case
Sales off kochi asp for kolkat Negative case
ok case Ok case
ok case Ok case
ok case Ok case
ok case Ok case
ok case Ok case
ok case Ok case
ok case Ok case
Final Remarks
Error Message not clear & Result not as per pre defined
Error Message not clear & Result not asp per pre defined & need to undersatnd error Err
Amc code is blocked in system but system is creating all transactions
In system Amc Lucknow is blocked & asp is inactive but system is not showing Amc cust
Amc code is double primary but system is allowing to create all transaction
Asp code is blocked but system is creating all transaction
Amc code is inactive But Error Message not clear
Amc code is inactive But Error Message not clear
Error Message not clear & Result not asp per pre defined
Error Message not clear & Result not asp per pre defined
Error Message not clear & Result not asp per pre defined
System should hold & give error Error Message for Wrong date At time of uploading web
System should hold & give error Error Message for Wrong date At time of uploading we
Error Message not clear I had taken fututre date which period is not open
Error Error Message not Clear
Refer Sheet "Transaction issues" for supporting. Billing
date is not as per date mentioned in Web Adi. System not auto
apply Credit note with Billing. Trade Receivables GL in Debit
Memo should be 121101 instead of 121600. System not proportnate unearned revene.
System not show amount on screen.
GST GL is also wrong. Sales office and Division are still blank.
System not give any error & also not genreted any transaction all case are ok
System not give any error & also not genreted any transaction all case are ok
System not give any error & also not genreted any transaction all case are ok
System not give any error & also not genreted any transaction all case are ok
System not give any error & also not genreted any transaction all case are ok
Suggestion for Error Msg
Amc Customer site inactive & ASP site is also inactive
Amc Customer site is inactive
AMC Customer code is blocked
AMC Customer code is blocked and ASP Code is Inactive
AMC Customer code have double primary
AMC Customer code have double primary and ASP code is Blocked
AMC Customer code is inactive
Amc code is inactive but ASP code have doubel primary
ASP Code is Blocked in Master
ASP Code is inactive in Master
ASP Code have double primary in Customer Master
Period not open
End Date is future date
Amc is inactive
System is picking up wrong date in webadi date is metioned is 28 Jan 23 but system is picking up 30 Jan 23
System is picking up Interium GL for GST & also not applying amount of unearned Reveune
System had not apply Credit memo with Ar
Reference is coming blank need to Pick up comments
Reference is coming blank need to Pick up comments
Receivable Gl is wrong
In this case system is applying on 01 Feb 23
Receivable Gl is wrong
Sales off & div are blank
Billing date is not as per date mentioned in Web Adi.
GST GL is also wrong
System not proportionate unearned revenue GL wise
System not show amount on screen
System not auto apply Credit note with Billing
Trade Receivables GL in Debit Memo should be 121101 instead of 121600
Sales Office and Division are blank
Apply date of Credit note with AR is different from effective date mentioned in Web Adi.
Billing date is not as per date mentioned in Web Adi. >>Webadi date is metioned is 28-Jan-23 but sy
System is picking up Interim GL for GST & also not applying amount of unearn
System not auto apply Credit note with Billing
Trade Receivables GL in Debit Memo should be 121100 instead of 121
Apply date of Credit note with AR is different from effective date mentioned in Web Adi. >> In this ca
In this case system is applying on 01 Feb 23
Sales off & Division are blank
metioned is 28-Jan-23 but system is picking 30-Jan-23
pplying amount of unearned Reveune
te with Billing
be 121100 instead of 121600
in Web Adi. >> In this case system is applying on 01 Feb 23
blank
