Activity
From 12/05/2024 to 10/06/2024
10/06/2024
- 06:19 PM Production Ticket(ST) #11882 (Monitoring): GOLDCREST - Hi pls check, double inv no in mobile
- 06:18 PM Production Ticket(ST) #11882 (Support In Progress): GOLDCREST - Hi pls check, double inv no in mobile
- 09:41 AM Production Ticket(ST) #11940: Hi pls check, why stock 250ml Boboi boy lychee negative?
- As I checked today there is negative value in that particular product
09/06/2024
- 02:09 PM Production Ticket(ST) #11817 (Ticket Resolved): Hi pls help me to delete this 2 item, I think Daphne use for testing trial transaction
- 02:07 PM Production Ticket(ST) #11801 (Ticket Resolved): GOLDCREST - salesman activity report 23/5 why didn't come out anything?
08/06/2024
- 12:29 PM Production Ticket(ST) #11956 (Support In Progress): GOLDCREST - collection 301U/012 didn't reflect to autocount
- select * from txn_mobile_collection_header where col_no = 'CCJNL001853-240606'
select * from txn_mobile_collection... - 11:20 AM Production Ticket(ST) #11954 (Support In Progress): GOLDCREST - mobile didn't show this inwwx000798-230412
- select * from txn_invoice_history_header where invoice_no = 'inwwx000798-240412'
select * from txn_invoice_history_h...
07/06/2024
- 05:50 PM Production Ticket(ST) #11940: Hi pls check, why stock 250ml Boboi boy lychee negative?
- select a.eod_date,b.eod_date,a.product_id, a.stock_balance_qty,b.opening_qty from txn_mobile_eod a
inner join txn_m... - 03:35 PM Production Ticket(ST) #11954: GOLDCREST - mobile didn't show this inwwx000798-230412
* -- This is the customer reported that this particular invoice is not shown in the mobile
select * from txn_inv...- 09:30 AM Production Ticket(ST) #11954 (Ticket Resolved): GOLDCREST - mobile didn't show this inwwx000798-230412
- !WhatsApp%20Image%202024-06-07%20at%2009.28.39_4bc993b9.jpg!
!WhatsApp%20Image%202024-06-07%20at%2009.28.23_899bd6f1... - 02:18 PM Production Ticket(ST) #11944 (Ticket Resolved): Goldcrest- Hi, can help to add user code BRY to route planning?
- 11:49 AM Production Ticket(ST) #11956 (Ticket Resolved): GOLDCREST - collection 301U/012 didn't reflect to autocount
- !WhatsApp%20Image%202024-06-07%20at%2010.34.09_939c710a.jpg!
06/06/2024
- 06:21 PM Production Ticket(ST) #11944 (Pending Client Feedback): Goldcrest- Hi, can help to add user code BRY to route planning?
- 1) go to web_spMstRouteSummaryMasterDataRetriveList --> sp
2) select member_cd,* from mst_sales_team_member a
le... - 06:16 PM Production Ticket(ST) #11944 (Support In Progress): Goldcrest- Hi, can help to add user code BRY to route planning?
- 06:16 PM Production Ticket(ST) #11944 (Ticket Resolved): Goldcrest- Hi, can help to add user code BRY to route planning?
- !WhatsApp%20Image%202024-06-06%20at%2016.29.43_f0b8ca56.jpg!
- 02:55 PM Production Ticket(ST) #11940 (Ticket Resolved): Hi pls check, why stock 250ml Boboi boy lychee negative?
- !2.jpg!
!1.jpg!
05/06/2024
04/06/2024
- 06:32 PM Production Ticket(ST) #11882 (Pending Client Verification): GOLDCREST - Hi pls check, double inv no in mobile
- select * from member where member_cd = 'wwx'
select * from txn_invoice_history_header where invoice_no like '%INWW... - 05:30 PM Production Ticket(ST) #11902 (Pending Client Verification): GOLDCREST - K/332 not in this route, I want to unstick, can't do it
- 04:35 PM Production Ticket(ST) #11901: GOLDCREST - MCJ 30/05/24 closing stocks different for 31/05/25 opening
- https://app.clickup.com/t/86epgtvzr
- 04:32 PM Production Ticket(ST) #11901 (Escalated to Level 3): GOLDCREST - MCJ 30/05/24 closing stocks different for 31/05/25 opening
- 04:31 PM Production Ticket(ST) #11901 (Support In Progress): GOLDCREST - MCJ 30/05/24 closing stocks different for 31/05/25 opening
- select * from member where member_cd= 'mcj'
select a.eod_id,a.eod_date,b.eod_date,a.product_id,pro.item_name,a.stock... - 02:47 PM Production Ticket(ST) #11901: GOLDCREST - MCJ 30/05/24 closing stocks different for 31/05/25 opening
- select * from member where member_cd= 'mcj'
select a.eod_id,a.eod_date,b.eod_date,a.product_id,pro.item_name,a.stock... - 10:41 AM Production Ticket(ST) #11876 (Ticket Resolved): Goldcrest- Hi pls check still got this happen...
02/06/2024
- 03:00 AM Production Ticket(ST) #11882 (Support In Progress): GOLDCREST - Hi pls check, double inv no in mobile
- !Screenshot%202024-06-03%20030107.png!
- In mobile db, INWWX001398-240530 got double. INWWX001399 skipped.
- Got ...
01/06/2024
- 09:30 PM Production Ticket(ST) #11902 (Support In Progress): GOLDCREST - K/332 not in this route, I want to unstick, can't do it
- 09:30 PM Production Ticket(ST) #11902 (Ticket Resolved): GOLDCREST - K/332 not in this route, I want to unstick, can't do it
- Hi pls check, K/332 not in this route, I want to unstick, can't do it
!353c1b39-dd4a-453f-a17a-d4783e88be77.jpg!
... - 09:25 PM Production Ticket(ST) #11901 (Ticket Resolved): GOLDCREST - MCJ 30/05/24 closing stocks different for 31/05/25 opening
- Hi pls check, why the MCJ 30/05/24 closing stocks different for 31/05/25 opening?
!3312434f-9569-43f6-a426-be33c9e...
31/05/2024
- 06:08 PM Production Ticket(ST) #11882: GOLDCREST - Hi pls check, double inv no in mobile
- select * from txn_invoice_history_header where invoice_no= 'inwwx001398-240530'
select a.at_date,* from txn_invoice_... - 04:17 PM Production Ticket(ST) #11876 (Pending Client Verification): Goldcrest- Hi pls check still got this happen...
- 02:12 PM Production Ticket(ST) #11876: Goldcrest- Hi pls check still got this happen...
- https://app.clickup.com/t/86epfxfe9
- 11:07 AM Production Ticket(ST) #11876 (Escalated to Level 3): Goldcrest- Hi pls check still got this happen...
- 11:06 AM Production Ticket(ST) #11876 (Support In Progress): Goldcrest- Hi pls check still got this happen...
- 03:49 PM Production Ticket(ST) #11616 (Ticket Resolved): Hi, pls check. Outstanding balance didn't show at mobile
- 03:48 PM Production Ticket(ST) #11616 (Pending Client Verification): Hi, pls check. Outstanding balance didn't show at mobile
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.?
Also available in: Atom