Activity
From 01/05/2024 to 30/05/2024
30/05/2024
- 06:28 PM Production Ticket(ST) #11882 (Ticket Resolved): GOLDCREST - Hi pls check, double inv no in mobile
- !WhatsApp%20Image%202024-05-30%20at%2017.14.55_51f35e99.jpg!
!WhatsApp%20Image%202024-05-30%20at%2017.14.47_07dd0cfe... - 01:56 PM Production Ticket(ST) #11876: Goldcrest- Hi pls check still got this happen...
- when the integrate from autocount to datanory app it will check the customer's details has been changed or not (in ...
- 01:51 PM Production Ticket(ST) #11876 (Ticket Resolved): Goldcrest- Hi pls check still got this happen...
- !IMG-20240530-WA0005.jpg!
!IMG-20240530-WA0006.jpg!
!IMG-20240530-WA0007.jpg!
!IMG-20240530-WA0004.jpg!
29/05/2024
- 02:05 PM Production Ticket(ST) #11627 (Ticket Resolved): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- 11:54 AM Production Ticket(ST) #11627 (Pending Client Verification): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- 12:37 PM Production Ticket(ST) #11723 (Ticket Resolved): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- Customer already verified this . It has been already foxed as yesterday already conducted .
- 12:26 PM Production Ticket(ST) #11723 (Monitoring): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- 10:33 AM Production Ticket(ST) #11851 (Ticket Resolved): Goldcrest- hi there, as we create a new user which is BRY, can help us add this new user as PIC as per this customer list? thanks
- 10:26 AM Production Ticket(ST) #11851 (Pending Client Verification): Goldcrest- hi there, as we create a new user which is BRY, can help us add this new user as PIC as per this customer list? thanks
- --create table #tempcustomeruser (
-- customer_code varchar(50),
-- user_code varchar(50)
--)
select * from mem... - 10:15 AM Production Ticket(ST) #11851 (Support In Progress): Goldcrest- hi there, as we create a new user which is BRY, can help us add this new user as PIC as per this customer list? thanks
- 09:59 AM Production Ticket(ST) #11585 (Ticket Resolved): hi, we want set up route plan jnl for user jnm, in customer side ady set PIC,but when we import it shown error
28/05/2024
- 04:24 PM Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
-
!WhatsApp%20Image%202024-05-28%20at%2016.24.41_f8cd4e7b.jpg!
As I test from my side it is able show all the SKU... - 02:37 PM Production Ticket(ST) #11851 (Ticket Resolved): Goldcrest- hi there, as we create a new user which is BRY, can help us add this new user as PIC as per this customer list? thanks
- 09:55 AM Production Ticket(ST) #11827 (Ticket Resolved): Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
27/05/2024
- 06:36 PM Production Ticket(ST) #11731 (Ticket Resolved): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- 06:35 PM Production Ticket(ST) #11731 (Pending Client Verification): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- 03:08 PM Production Ticket(ST) #11731: Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- Invoice has been paid, still show outstanding:
- http://124.217.245.100:90/redmine/issues/11741
- http://124.217.24... - 06:05 PM Production Ticket(ST) #11827 (Pending Client Verification): Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
- !WhatsApp%20Image%202024-05-27%20at%2018.06.40_a04872c9.jpg!
- 06:03 PM Production Ticket(ST) #11827 (Support In Progress): Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
- 02:48 PM Production Ticket(ST) #11827: Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
- SELECT *
FROM txn_invoice_history_header
WHERE org_id = 'goldcrest'
AND created_date BETWEEN '2024-05-24 00:00:... - 02:04 PM Production Ticket(ST) #11827: Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
- exec sp_rpt_sales_invoice_summary_report @start_date='2024-05-24 00:00:00',
@end_date='2024-05-24 00:00:00',@branch=... - 01:47 PM Production Ticket(ST) #11827 (Ticket Resolved): Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
- !WhatsApp%20Image%202024-05-27%20at%2013.46.38_0953a3ea.jpg!
- 03:36 PM Production Ticket(ST) #11788 (Ticket Resolved): GOLDCREST - SO didn't upload to sales order approval
- 02:50 PM Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- - Clickup status Deployed.
- But when testing, there is invoice that have issue to show foc item.
26/05/2024
- 11:04 PM Production Ticket(ST) #11763 (Ticket Resolved): GOLDCREST - didn't reflect to datonory SA report
- 11:04 PM Production Ticket(ST) #11774 (Ticket Resolved): GOLDCREST - Collection didn't reflect to autocount and datanory
- 11:01 PM Production Ticket(ST) #11797 (Ticket Resolved): GOLDCREST - why for branch V all end date change to 23/5/24
- 10:58 PM Production Ticket(ST) #11811 (Ticket Resolved): GOLDCREST - why the mobile showing this invoice
25/05/2024
- 03:22 PM Production Ticket(ST) #11781 (Escalated to Level 3): Goldcrest- hi, this 2 acc still got showing at salesman mobile
- 09:40 AM Production Ticket(ST) #11781: Goldcrest- hi, this 2 acc still got showing at salesman mobile
- - end shift.
- handover to arif.
- not yet further checking. - 03:06 PM Production Ticket(ST) #11801 (Pending Client Verification): GOLDCREST - salesman activity report 23/5 why didn't come out anything?
- 09:37 AM Production Ticket(ST) #11801: GOLDCREST - salesman activity report 23/5 why didn't come out anything?
- - end shift.
- handover to arif.
- this ticket already done. just need to inform user. - 03:02 PM Production Ticket(ST) #11788 (Pending Client Verification): GOLDCREST - SO didn't upload to sales order approval
select * from member where member_id='2750df1e9be7480da51f72dab18f8cd4'
select * from txn_sales_order_header whe...- 02:42 PM Production Ticket(ST) #11788 (Support In Progress): GOLDCREST - SO didn't upload to sales order approval
- 09:32 AM Production Ticket(ST) #11788: GOLDCREST - SO didn't upload to sales order approval
- select * from approval_flow where org_id = 'goldcrest'
select * from member where member_cd = 'evo'
select * fr... - 10:57 AM Production Ticket(ST) #11817 (Pending Client Verification): Hi pls help me to delete this 2 item, I think Daphne use for testing trial transaction
- 10:55 AM Production Ticket(ST) #11817 (Support In Progress): Hi pls help me to delete this 2 item, I think Daphne use for testing trial transaction
- 10:55 AM Production Ticket(ST) #11817 (Ticket Resolved): Hi pls help me to delete this 2 item, I think Daphne use for testing trial transaction
- !0db7737f-0185-49b0-a2d7-e307215ced06.jpg!
24/05/2024
- 02:06 AM Production Ticket(ST) #11801 (Support In Progress): GOLDCREST - salesman activity report 23/5 why didn't come out anything?
- select b.branch_code, * from mst_area a
inner join mst_branch b on b.branch_id = a.branch_id
where a.org_id = 'gold... - 06:28 PM Production Ticket(ST) #11801: GOLDCREST - salesman activity report 23/5 why didn't come out anything?
- !6f2256fa-d680-4ca7-a90d-66f99149a8bd.jpg!
Hi, can help to set branch code also? - 11:09 AM Production Ticket(ST) #11801 (Ticket Resolved): GOLDCREST - salesman activity report 23/5 why didn't come out anything?
- can help to check salesman activity report 23/5 why didn't come out anything?
but autocount got invoice and collecti... - 07:55 PM Production Ticket(ST) #11811 (Pending Client Verification): GOLDCREST - why the mobile showing this invoice
- select * from member where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725'
select * from txn_invoice_history_header... - 07:49 PM Production Ticket(ST) #11811 (Support In Progress): GOLDCREST - why the mobile showing this invoice
- 12:37 PM Production Ticket(ST) #11811 (Ticket Resolved): GOLDCREST - why the mobile showing this invoice
- Hi pls check for this, WWX started use mobile in Feb 2024, why the mobile showing this invoice
!5eae0ee2-0a03-4003... - 04:14 PM Production Ticket(ST) #11797 (Pending Client Verification): GOLDCREST - why for branch V all end date change to 23/5/24
- --select * into DMS_Ecosystem_Backup_Table.dbo._customer_to_user_relation_20240524
--from DMS_EcoSystem.dbo.customer... - 04:10 PM Production Ticket(ST) #11797 (Support In Progress): GOLDCREST - why for branch V all end date change to 23/5/24
- 10:14 AM Production Ticket(ST) #11797 (Ticket Resolved): GOLDCREST - why for branch V all end date change to 23/5/24
- may i check why for branch V all end date change to 23/5/24 ? as previouly all set to year 2099
sorry, is all custom... - 11:37 AM Production Ticket(ST) #11774 (Pending Client Verification): GOLDCREST - Collection didn't reflect to autocount and datanory
- Previously, invoice INMCJ000006-240318 already do collection CCMCJ000004-240318 but cancelled. But the invoice balanc...
- 11:00 AM Production Ticket(ST) #11763 (Pending Client Verification): GOLDCREST - didn't reflect to datonory SA report
- 10:30 AM Production Ticket(ST) #11784 (Ticket Resolved): Goldcrest-- Hi, can help to check why this SO didn't upload to sales order approval?
- 10:29 AM Production Ticket(ST) #11784 (Support In Progress): Goldcrest-- Hi, can help to check why this SO didn't upload to sales order approval?
23/05/2024
- 07:18 PM Production Ticket(ST) #11788 (Ticket Resolved): GOLDCREST - SO didn't upload to sales order approval
- Hi, can help to check why this SO didn't upload to sales order approval?
salesman ady upload database u can check it - 06:32 PM Production Ticket(ST) #11763 (Escalated to Level 3): GOLDCREST - didn't reflect to datonory SA report
- Hi pls check, didn't reflect to datonory SA report INWWX001257-240520
CCWWX001287-240520
Hi pls check, Invoice and ... - 01:57 PM Production Ticket(ST) #11763 (Pending Client Verification): GOLDCREST - didn't reflect to datonory SA report
- 11:31 AM Production Ticket(ST) #11763: GOLDCREST - didn't reflect to datonory SA report
- select * from mst_area where org_id = 'goldcrest' and branch_id = 'a263d06e9a504ebe9f52a430f298b1ad'
select * from m... - 10:05 AM Production Ticket(ST) #11763: GOLDCREST - didn't reflect to datonory SA report
- !c7cddc4c-0ce9-4681-ad8a-f9c9b39cd331.jpg!
- 06:06 PM Production Ticket(ST) #11774: GOLDCREST - Collection didn't reflect to autocount and datanory
- --Checking
select * from txn_mobile_collection_header where col_no = 'CCMCJ000359-240521'
select * from txn_mobile_... - 04:58 PM Production Ticket(ST) #11784 (Ticket Resolved): Goldcrest-- Hi, can help to check why this SO didn't upload to sales order approval?
- salesman ady upload database u can check it
- 01:51 PM Production Ticket(ST) #11764 (Ticket Resolved): GOLDCREST - Salesman inform me, he can't check out
- 11:43 AM Production Ticket(ST) #11781 (Support In Progress): Goldcrest- hi, this 2 acc still got showing at salesman mobile
- select * from txn_credit_note_history_header_at where credit_note_no= 'CNMCJ000002-240322' order by at_date desc
sel... - 11:30 AM Production Ticket(ST) #11781 (Ticket Resolved): Goldcrest- hi, this 2 acc still got showing at salesman mobile
- !WhatsApp%20Image%202024-05-23%20at%2010.13.48_e1303e15.jpg!
!WhatsApp%20Image%202024-05-23%20at%2010.13.48_f3807f36... - 10:00 AM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- As I checked with shu ern the next release will be 30/5/2024
22/05/2024
- 07:44 AM Production Ticket(ST) #11731: Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- follow up
- 07:40 AM Production Ticket(ST) #11763: GOLDCREST - didn't reflect to datonory SA report
- issue SA report:
1. branch tcw - should be under user tcw , but user WWX perform the txn, hence not match member id
... - 07:35 AM Production Ticket(ST) #11763 (Support In Progress): GOLDCREST - didn't reflect to datonory SA report
- 06:39 PM Production Ticket(ST) #11774: GOLDCREST - Collection didn't reflect to autocount and datanory
- Select ci.collection_invoices_id, Max(ci.collection_id), ci.invoice_id, '', Max(ihh.invoice_balance), Max(isnull(ci.p...
- 06:38 PM Production Ticket(ST) #11774 (Support In Progress): GOLDCREST - Collection didn't reflect to autocount and datanory
- select * from member where member_cd = 'mcj'
select * from txn_mobile_collection_header where col_no like '%CCMCJ0... - 03:58 PM Production Ticket(ST) #11774 (Ticket Resolved): GOLDCREST - Collection didn't reflect to autocount and datanory
- Hi pls check, Collection didn't reflect to autocount and datanory
CCMCJ000359-240521
CCMCJ000360-240521
!8cd8d1...
21/05/2024
- 09:46 PM Production Ticket(ST) #11748 (Ticket Resolved): GOLDCREST - why already settled the payment, still showing in mobile?
- Same issue as http://124.217.245.100:90/redmine/issues/11731
- 09:44 PM Production Ticket(ST) #11741 (Ticket Resolved): GOLDCREST - why already settled the payment, still showing in mobile?
- Same issue as http://124.217.245.100:90/redmine/issues/11731
- 09:42 PM Production Ticket(ST) #11750 (Ticket Resolved): GOLDCREST - So how to solve it? For this customer 302K/346 no more outstanding
- 04:15 PM Production Ticket(ST) #11764 (Pending Client Verification): GOLDCREST - Salesman inform me, he can't check out
- 04:12 PM Production Ticket(ST) #11764 (Support In Progress): GOLDCREST - Salesman inform me, he can't check out
- 10:48 AM Production Ticket(ST) #11764 (Ticket Resolved): GOLDCREST - Salesman inform me, he can't check out
- Salesman inform me, he can't check out, then he do like this only can check out
!73588c13-94e2-468f-8a3b-be62588b3... - 10:45 AM Production Ticket(ST) #11763 (Ticket Resolved): GOLDCREST - didn't reflect to datonory SA report
- Hi pls check, didn't reflect to datonory SA report INWWX001257-240520
CCWWX001287-240520 - 10:39 AM Production Ticket(ST) #11736 (Ticket Resolved): Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
- 10:37 AM Production Ticket(ST) #11731: Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- https://app.clickup.com/t/86epd0u9h
- 10:25 AM Production Ticket(ST) #11731 (Escalated to Level 3): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
20/05/2024
- 06:05 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- Clickup status: Current Sprint
- 05:26 PM Production Ticket(ST) #11750 (Support In Progress): GOLDCREST - So how to solve it? For this customer 302K/346 no more outstanding
- 10:15 AM Production Ticket(ST) #11750 (Ticket Resolved): GOLDCREST - So how to solve it? For this customer 302K/346 no more outstanding
- Hi pls check, I296886 already paid 27/04/24 (bcoz this inv showing in mobile, salesman issue collection and wrongly ...
- 05:16 PM Production Ticket(ST) #11740 (Ticket Resolved): GOLDCREST - pls check this issue
- 10:55 AM Production Ticket(ST) #11748 (Pending Client Verification): GOLDCREST - why already settled the payment, still showing in mobile?
- select * from customer where customer_code = '302M/170'
select * from member where member_id = '3285f21092ff4c4aa4b8... - 10:49 AM Production Ticket(ST) #11748 (Support In Progress): GOLDCREST - why already settled the payment, still showing in mobile?
- 10:04 AM Production Ticket(ST) #11748 (Ticket Resolved): GOLDCREST - why already settled the payment, still showing in mobile?
- Hi pls check, why already settled the payment, still showing in mobile?
Customer code: 302M/170
!457e1bba-38f9-...
18/05/2024
- 03:19 PM Production Ticket(ST) #11736 (Pending Client Feedback): Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
- Hi
Pls understand our office operating hours
Monday-Friday-8.30am to 5.30pm
Saturday-8.30am to 12.30pm
... - 10:53 AM Production Ticket(ST) #11736 (Support In Progress): Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
- in progress verify logic with tech team.
as first, i noticed that we integrate the mentioned invoice with PCS price,... - 03:12 PM Production Ticket(ST) #11731: Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- need further discussion with Goldcrest admin as got 2 collection for this invoice, 1 is backend collection (Autocount...
17/05/2024
- 06:55 PM Production Ticket(ST) #11740 (Pending Client Verification): GOLDCREST - pls check this issue
- select * from customer where customer_code = '302k/346'
select * from member where member_id = '2c9e40b5f5904775b711... - 06:52 PM Production Ticket(ST) #11740 (Support In Progress): GOLDCREST - pls check this issue
- 02:46 PM Production Ticket(ST) #11740 (Ticket Resolved): GOLDCREST - pls check this issue
- !6d1b2b10-8c72-4698-acbc-756394c497b0.jpg!
!ccb8ee38-f42d-4b75-96db-dbae4f2a5def.jpg!
!175551d6-8463-4470-ab3b-1b43... - 06:52 PM Production Ticket(ST) #11741 (Pending Client Verification): GOLDCREST - why already settled the payment, still showing in mobile?
- select * from customer where customer_code = '305p/009'
select * from member where member_id = '0d5eda133f2946f1aef0... - 06:42 PM Production Ticket(ST) #11741 (Support In Progress): GOLDCREST - why already settled the payment, still showing in mobile?
- 02:48 PM Production Ticket(ST) #11741 (Ticket Resolved): GOLDCREST - why already settled the payment, still showing in mobile?
- Hi pls check, why already settled the payment, still showing in mobile?
!8cd1a2d3-a946-420b-ba42-9e09616545f4.jpg!... - 06:13 PM Production Ticket(ST) #11731: Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
select * from txn_mobile_collection_invoice where col_id= '04d4dd14-409b-4f60-b391-83bd568a4545'
select * from ...- 05:15 PM Production Ticket(ST) #11736: Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
- SELECT
sod.base_uom_list_price,
pp.selling_price,
pt.item_name,
pt.item_code,
pp.sellin... - 12:24 PM Production Ticket(ST) #11736 (Ticket Resolved): Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
- !WhatsApp%20Image%202024-05-17%20at%2010.50.46_ab7b57a1.jpg!
- 12:03 PM Production Ticket(ST) #11723 (Escalated to Level 3): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- https://app.clickup.com/t/86epc9933
- 11:32 AM Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- select * from txn_invoice_history_header where invoice_no= 'INWWQ000613-240515'
select * from txn_invoice_history_de... - 11:16 AM Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- select * from txn_invoice_history_header where invoice_no= 'INWWQ000311-240417'
select * from txn_invoice_history_de...
16/05/2024
- 02:45 PM Production Ticket(ST) #11723 (Pending Client Feedback): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- Hi @~Suzanne , kindly help to request user WWQ to upload database for further checking.
- 02:44 PM Production Ticket(ST) #11723 (Support In Progress): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- 01:14 PM Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- Based on my finding, I suspect there is reciept issue ( it did not show complete SKUs in the list)
SELECT ptem.item_... - 02:44 PM Production Ticket(ST) #11731 (Pending Client Feedback): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- hi @~Suzanne , can we remote to your anydesk?
- 12:10 PM Production Ticket(ST) #11731 (Support In Progress): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- Hi @~Suzanne , noted on the escalation. We will check on it and revert back in soonest possible.
!2.jpg!
!1.jpg!
- 12:09 PM Production Ticket(ST) #11731 (Ticket Resolved): Hi pls check, CCMCJ000285-240515 didn't reflect to autocount
- 09:59 AM Production Ticket(ST) #11720 (Ticket Resolved): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
- 09:58 AM Production Ticket(ST) #11720 (Pending Client Verification): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
- Hi @~Goldcrest Hotline , the mentioned invoice and collection already appear in the salesman activity report. the roo...
15/05/2024
- 05:34 PM Production Ticket(ST) #11720 (Pending Client Feedback): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
- Hi,
"hi, INJNL001833-240514 didn't shown in salesman activity report"
check with you, this customer should be under... - 03:55 PM Production Ticket(ST) #11720 (Escalate to 2nd Level Support): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
- 11:30 AM Production Ticket(ST) #11720 (Support In Progress): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
select * from txn_mobile_collection_header where col_id like 'd264571c-4cff-478d-844d-0d5633733ab7'
select * from ...- 11:28 AM Production Ticket(ST) #11720 (Ticket Resolved): Goldcrest- hi, INJNL001833-240514 didn't shown in salesman activity report
- 02:18 PM Production Ticket(ST) #11723 (Ticket Resolved): Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.
- !WhatsApp%20Image%202024-05-15%20at%2013.36.52_f0ab5e80.jpg!
!WhatsApp%20Image%202024-05-15%20at%2013.37.23_78ea9128... - 11:36 AM Production Ticket(ST) #11702 (Ticket Resolved): goldcrest- Hi pls check, direction missing
14/05/2024
- 05:51 PM Production Ticket(ST) #11698 (Ticket Resolved): Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
- 05:46 PM Production Ticket(ST) #11698 (Pending Client Verification): Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
- 04:09 PM Production Ticket(ST) #11698: Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
-
select * into DMS_EcoSystem_backup_table.dbo.txn_mobile_collection_header_14052024
from DMS_EcoSystem.dbo.txn_... - 12:09 PM Production Ticket(ST) #11702 (Support In Progress): goldcrest- Hi pls check, direction missing
- 09:18 AM Production Ticket(ST) #11702 (Ticket Resolved): goldcrest- Hi pls check, direction missing
- !WhatsApp%20Image%202024-05-13%20at%2017.08.41_4e300fb7.jpg!
!WhatsApp%20Image%202024-05-13%20at%2017.08.41_430bb8bb... - 12:07 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- As I checked with shu ern this is already fixed and waiting for jann advise on production release.
- 11:37 AM Production Ticket(ST) #11676 (Ticket Resolved): Goldcrest- Hi pls check, this 2 collection number missing CCWWQ000575-240508, CCWWX001113-240508
13/05/2024
- 05:36 PM Production Ticket(ST) #11698: Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
- 1. Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
findings:
Collectio... - 05:34 PM Production Ticket(ST) #11698 (Support In Progress): Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
- 03:28 PM Production Ticket(ST) #11698 (Ticket Resolved): Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX001142-240510
- !2.jpg!
!5.jpg!
!3.jpg!
!1.jpg!
Hi pls check, invoice and collection number missing INWWX001117-240510 CCWWX00... - 03:27 PM Production Ticket(ST) #11539 (Ticket Resolved): GOLDCREST - Hi pls check, WWQ 19/04/24 stock bal.
- 11:35 AM Production Ticket(ST) #11539 (Pending Client Verification): GOLDCREST - Hi pls check, WWQ 19/04/24 stock bal.
- This is due to the cancelled foc items did not update the actual inventory. Same issue happened to WWX and WWQ.
W... - 02:30 PM Production Ticket(ST) #11604 (Ticket Resolved): can help to delete credit note for this 3 acc?
- 02:28 PM Production Ticket(ST) #11695 (Ticket Resolved): RE: Goldcrest Active User Start period
- 10:54 AM Production Ticket(ST) #11695 (Pending Client Verification): RE: Goldcrest Active User Start period
- 10:54 AM Production Ticket(ST) #11695 (Support In Progress): RE: Goldcrest Active User Start period
- 10:49 AM Production Ticket(ST) #11695 (Ticket Resolved): RE: Goldcrest Active User Start period
- Dear Arif,
Following up on our previous discussion, could you please help by checking all the active users for Gol... - 10:49 AM Production Ticket(ST) #11688 (Ticket Resolved): GOLDCREST - inv & collection didn't reflect to autocount
- 10:21 AM Production Ticket(ST) #11615 (Ticket Resolved): hi, just now check still got cn in this 3acc
- 09:38 AM Production Ticket(ST) #11596 (Ticket Resolved): can help to check it is jump sequence no.?
11/05/2024
- 01:12 PM Production Ticket(ST) #11688: GOLDCREST - inv & collection didn't reflect to autocount
- select * from member where member_cd = 'jnl'
select * from txn_mobile_collection_header where created_by = 'afa916... - 01:12 PM Production Ticket(ST) #11688 (Pending Client Feedback): GOLDCREST - inv & collection didn't reflect to autocount
- !6357e790-8f47-415c-876d-7e73a2a76de9.jpg!
!3afb8aa2-9a93-4b58-89f1-b1199aad0a74.jpg!
@~Goldcrest Hotline based o... - 01:10 PM Production Ticket(ST) #11688 (Support In Progress): GOLDCREST - inv & collection didn't reflect to autocount
- 12:36 PM Production Ticket(ST) #11688 (Ticket Resolved): GOLDCREST - inv & collection didn't reflect to autocount
- Morning, inv & collection didn't reflect to autocount
Invoice INJNL001796-240510 - INJNL001800-240510
Collection CC...
10/05/2024
- 02:27 PM Production Ticket(ST) #11676 (Pending Client Verification): Goldcrest- Hi pls check, this 2 collection number missing CCWWQ000575-240508, CCWWX001113-240508
- SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCWWQ000575%'
SELECT * FROM di_mobile_txn_co... - 02:24 PM Production Ticket(ST) #11676 (Support In Progress): Goldcrest- Hi pls check, this 2 collection number missing CCWWQ000575-240508, CCWWX001113-240508
- 11:55 AM Production Ticket(ST) #11676 (Ticket Resolved): Goldcrest- Hi pls check, this 2 collection number missing CCWWQ000575-240508, CCWWX001113-240508
- 10:29 AM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- https://app.clickup.com/t/86epa86v1--> due date May 13
- 10:28 AM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- https://app.clickup.com/t/86ep9na7q--> this issue has been solved
09/05/2024
- 07:52 PM Production Ticket(ST) #11648 (Ticket Resolved): GOLDCREST - Customer 301M/022 should be no outstanding ady, but mobile keep showing outstanding inv
- 10:54 AM Production Ticket(ST) #11648 (Pending Client Verification): GOLDCREST - Customer 301M/022 should be no outstanding ady, but mobile keep showing outstanding inv
- select * from txn_invoice_history_header where invoice_no = 'injnm000524-240403'
--update txn_invoice_history_head... - 10:18 AM Production Ticket(ST) #11648 (Support In Progress): GOLDCREST - Customer 301M/022 should be no outstanding ady, but mobile keep showing outstanding inv
- 02:36 PM Production Ticket(ST) #11665 (Ticket Resolved): GOLDCREST - Hi pls check S/078 didn't reflect datanory
- 11:00 AM Production Ticket(ST) #11665 (Pending Client Verification): GOLDCREST - Hi pls check S/078 didn't reflect datanory
- select * from customer where customer_code = '302S/078'
select * from mst_branch where branch_id = 'EF8905EFA8A3461E... - 10:57 AM Production Ticket(ST) #11665 (Support In Progress): GOLDCREST - Hi pls check S/078 didn't reflect datanory
- 10:57 AM Production Ticket(ST) #11665 (Ticket Resolved): GOLDCREST - Hi pls check S/078 didn't reflect datanory
- Hi pls check S/078 didn't reflect datanory
!9e5cdb83-c87b-4b47-9505-0a930ccb27e7.jpg!
!87e4c329-7c29-45e7-948e-64cc...
08/05/2024
- 07:26 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- https://app.clickup.com/t/86epa86v1
https://app.clickup.com/t/86ep9na7q
07/05/2024
- 05:02 PM Production Ticket(ST) #11627 (Escalated to Level 3): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- 01:56 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCWWQ000438-240424'
select * from txn_mobile_collectio... - 10:08 AM Production Ticket(ST) #11627 (Pending Client Verification): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- update txn_mobile_collection_detail set col_id = '4ab35302-fa52-4a2c-a10a-434b4b8a343a' where col_dtl_id = '5e1e015f-...
- 12:00 PM Production Ticket(ST) #11648 (Ticket Resolved): GOLDCREST - Customer 301M/022 should be no outstanding ady, but mobile keep showing outstanding inv
- !WhatsApp%20Image%202024-05-07%20at%2010.44.46_ba8d8627.jpg!
!WhatsApp%20Image%202024-05-07%20at%2011.47.52_506159a7...
06/05/2024
- 06:09 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCWWQ000438-240424'
select * from txn_mobile_col...- 05:48 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- patching has been done for temporary
has to verify with customer.
have to check tomorrow in the autocount
-- sc... - 02:49 PM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
-- three of them are not in the autocount
select * from ARPayment where DocNo like 'CCWWQ000438%'
select * from...- 11:59 AM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- SELECT
b.customer_code,
b.customer_name,
*
FROM
txn_invoice_history_header a
...
05/05/2024
- 10:21 AM Production Ticket(ST) #11627: GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- select * from member where member_cd = 'wwq'
select * from customer where customer_id in ('295E20FA57A14CDBA1572993D...
04/05/2024
- 11:18 AM Production Ticket(ST) #11627 (Support In Progress): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- 11:18 AM Production Ticket(ST) #11627 (Ticket Resolved): GOLDCREST - CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
- Hi, pls check CCWWQ000438, CCWWQ000439 and CCWWQ000440 didn't reflect to autocount
!20399f3c-de62-4e44-8e50-ec717f88...
03/05/2024
- 02:45 PM Production Ticket(ST) #11616 (Escalated to Level 3): Hi, pls check. Outstanding balance didn't show at mobile
- https://app.clickup.com/t/86ep93z91
Hi @Mcc Jann , CU is created for further checking on the outstanding amount no... - 02:43 PM Production Ticket(ST) #11616 (Support In Progress): Hi, pls check. Outstanding balance didn't show at mobile
- 02:43 PM Production Ticket(ST) #11616 (Ticket Resolved): Hi, pls check. Outstanding balance didn't show at mobile
- !6.jpg!
!7.jpg!
!4.jpg!
!5.jpg!
Hi, pls check. Outstanding balance didn't show at mobile
!9.jpg!
!8.jpg!
H... - 02:35 PM Production Ticket(ST) #11615 (Pending Client Verification): hi, just now check still got cn in this 3acc
- 02:35 PM Production Ticket(ST) #11615 (Support In Progress): hi, just now check still got cn in this 3acc
- 02:30 PM Production Ticket(ST) #11615 (Ticket Resolved): hi, just now check still got cn in this 3acc
- !2.jpg!
!3.jpg!
!1.jpg!
02/05/2024
- 03:16 PM Production Ticket(ST) #11596 (Pending Client Verification): can help to check it is jump sequence no.?
- 10:34 AM Production Ticket(ST) #11604 (Pending Client Verification): can help to delete credit note for this 3 acc?
select * into dms_ecosystem_backup_Table.dbo.txn_credit_note_history_header_20240502 from txn_credit_note_his...- 10:21 AM Production Ticket(ST) #11604 (Support In Progress): can help to delete credit note for this 3 acc?
- 10:19 AM Production Ticket(ST) #11604 (Ticket Resolved): can help to delete credit note for this 3 acc?
- !3.jpg!
!2.jpg!
!1.jpg!
- 10:07 AM Production Ticket(ST) #11595 (Ticket Resolved): Hi, INMCJ000116-240420 Invoice & collection didn't reflect in Salesman Activity Report
Also available in: Atom