Activity
From 25/01/2024 to 23/02/2024
23/02/2024
- 07:16 PM Production Ticket(ST) #11037 (Ticket Resolved): DATANORY - housekeep this 4 table in Datanory production and trial
- select
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
CAST (Round(((... - 07:05 PM Production Ticket(ST) #11037 (Support In Progress): DATANORY - housekeep this 4 table in Datanory production and trial
- 12:31 PM Production Ticket(ST) #11037 (Ticket Resolved): DATANORY - housekeep this 4 table in Datanory production and trial
- - hi @Rashdan Hussin , please help to housekeep this 4 table in Datanory production and trial
- here is the script t... - 06:40 PM Production Ticket(ST) #11040 (Pending Client Verification): Snekku - hi @Azhar13 , please assist remove customer 10006_1, not exist in mysoft, thanks
- select * from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
selec... - 04:53 PM Production Ticket(ST) #11040 (Support In Progress): Snekku - hi @Azhar13 , please assist remove customer 10006_1, not exist in mysoft, thanks
- select * from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
selec... - 04:50 PM Production Ticket(ST) #11040 (Ticket Resolved): Snekku - hi @Azhar13 , please assist remove customer 10006_1, not exist in mysoft, thanks
- 06:39 PM Production Ticket(ST) #11032 (Support In Progress): SNEKKU - No catalogue can view in memo?
- 03:39 PM Production Ticket(ST) #11032 (Pending Client Feedback): SNEKKU - No catalogue can view in memo?
- 03:38 PM Production Ticket(ST) #11032 (Support In Progress): SNEKKU - No catalogue can view in memo?
- 11:28 AM Production Ticket(ST) #11035 (Ticket Resolved): DailyFresh - @~Jann Yap @Assyafiq MCC I'm at Kuantan branch now.. supervisor complained that the total amount is having varianceI calculated and i get rm1399.04.. system captured rm1417.10
- !WhatsApp%20Image%202024-02-23%20at%2010.20.53_a1cd4c72.jpg!
- 11:22 AM Production Ticket(ST) #11029 (Pending Client Verification): Snekku- Hi @Azhar13, promo set 3% discount Here is shown total amount discount instead of percent?
- 11:20 AM Production Ticket(ST) #11029 (Support In Progress): Snekku- Hi @Azhar13, promo set 3% discount Here is shown total amount discount instead of percent?
- 11:16 AM Production Ticket(ST) #11034 (Ticket Resolved): Daily Fresh - Hi guys, please help to check yesterday balance good stock is missing, supposed to have 5-6 item. Sorry I don't have yesterday printed EOD report cause salesman doesn't keep it.already uploaded DB, Urgent!
- !WhatsApp%20Image%202024-02-23%20at%2009.57.48_97a189ba.jpg!
!WhatsApp%20Image%202024-02-23%20at%2009.59.31_1fd18ab9...
22/02/2024
- 05:23 PM Datanory - SNEKKU Production Ticket(ST) #11033 (Pending Client Verification): Snekku- edit customer details photo / location - apps still both unable check back, web photo cannot check
- 05:21 PM Datanory - SNEKKU Production Ticket(ST) #11033 (Support In Progress): Snekku- edit customer details photo / location - apps still both unable check back, web photo cannot check
- 05:20 PM Datanory - SNEKKU Production Ticket(ST) #11033 (Ticket Resolved): Snekku- edit customer details photo / location - apps still both unable check back, web photo cannot check
- 04:54 PM Production Ticket(ST) #11032 (Ticket Resolved): SNEKKU - No catalogue can view in memo?
- No catalogue can view in memo?
!dad098d1-de9e-41db-8971-a08113293a45.jpg!
- 02:44 PM Datanory - SNEKKU Production Ticket(ST) #11030 (Ticket Resolved): Snekku- edit customer details photo / location - apps still both unable check back, web photo cannot check
- 02:40 PM Production Ticket(ST) #11029 (Ticket Resolved): Snekku- Hi @Azhar13, promo set 3% discount Here is shown total amount discount instead of percent?
- !WhatsApp%20Image%202024-02-20%20at%2008.38.57_5218f30e.jpg!
- 11:40 AM Production Ticket(ST) #11028 (Ticket Resolved): Gold Crest- VQWWX000016-240220 VQJNM000043-240221 VQJNL000058-240221 Hi, this 3 van goods request didn't reflect to autocount
- 11:31 AM Production Ticket(ST) #10922 (Pending Client Verification): SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- Release new version of datanory mobile apps: v3.2.16.2
- 11:03 AM Production Ticket(ST) #10973 (Pending Client Verification): GoldCrest- Hi, collection didn't reflect to datanory (Salesman Activity Report) and autocount
- 10:56 AM Production Ticket(ST) #11004 (Pending Client Verification): GoldCrest- and for customer 302k/141 should be no outstanding ady, but mobile keep showing outstanding inv (the yellow collection didn't update to mobile)
SELECT i.DocNo, CONVERT(VARCHAR, i.DocDate, 25) DocDate, i.DebtorCode, i.SalesAgent, i.SalesLocation, i.Cancelle...
21/02/2024
- 08:36 PM Production Ticket(ST) #11004 (Support In Progress): GoldCrest- and for customer 302k/141 should be no outstanding ady, but mobile keep showing outstanding inv (the yellow collection didn't update to mobile)
- 05:42 PM Production Ticket(ST) #11018 (Pending Client Feedback): Daily Fresh- @~Jann Yap @Assyafiq MCC i need some clarification from you guys on this particular outlet... outlet is being shift from mtk04 --> mtk06 on 1st feb...
- 05:24 PM Production Ticket(ST) #11018 (Support In Progress): Daily Fresh- @~Jann Yap @Assyafiq MCC i need some clarification from you guys on this particular outlet... outlet is being shift from mtk04 --> mtk06 on 1st feb...
- 05:19 PM Production Ticket(ST) #11018 (Ticket Resolved): Daily Fresh- @~Jann Yap @Assyafiq MCC i need some clarification from you guys on this particular outlet... outlet is being shift from mtk04 --> mtk06 on 1st feb...
- !WhatsApp%20Image%202024-02-21%20at%2014.24.47_5698c426.jpg!
!WhatsApp%20Image%202024-02-21%20at%2014.25.03_b5e1e541... - 04:35 PM Production Ticket(ST) #10998 (Ticket Resolved): Daily Fresh- @~Jann Yap no salesman details in the database
- 11:47 AM Production Ticket(ST) #10988 (Support In Progress): Gold Crest- and the sales order price still running for pre sales
- 10:59 AM Production Ticket(ST) #11008 (Pending Client Verification): Snekku- please check also MC6, MS5
- TXADMIN000046-240220
TXADMIN000045-240216
TXADMIN000032-240120
TXADMIN000030-240120
TXADMIN000028-240116
TXADMIN... - 10:30 AM Production Ticket(ST) #11008 (Support In Progress): Snekku- please check also MC6, MS5
- 10:29 AM Production Ticket(ST) #11008 (Ticket Resolved): Snekku- please check also MC6, MS5
- !WhatsApp%20Image%202024-02-21%20at%2009.52.24_b7c6d8ba.jpg!
!WhatsApp%20Image%202024-02-21%20at%2009.59.58_7d0e65e6... - 10:25 AM Production Ticket(ST) #11007 (Ticket Resolved): Snekku- Hi @Assyafiq MCC @Azhar13 Please advise why unable do it
- 10:18 AM Production Ticket(ST) #11007 (Support In Progress): Snekku- Hi @Assyafiq MCC @Azhar13 Please advise why unable do it
- 10:18 AM Production Ticket(ST) #11007 (Ticket Resolved): Snekku- Hi @Assyafiq MCC @Azhar13 Please advise why unable do it
- !WhatsApp%20Image%202024-02-21%20at%2008.38.24_c6e4d3c9.jpg!
!WhatsApp%20Image%202024-02-21%20at%2009.52.24_51fc854a... - 10:02 AM Production Ticket(ST) #11006 (Ticket Resolved): Gold Crest-autocount quantity all 0
- 09:43 AM Production Ticket(ST) #11006 (Support In Progress): Gold Crest-autocount quantity all 0
- 09:41 AM Production Ticket(ST) #11006 (Ticket Resolved): Gold Crest-autocount quantity all 0
- !WhatsApp%20Image%202024-02-20%20at%2010.08.01_12693864.jpg!
!WhatsApp%20Image%202024-02-20%20at%2010.08.15_996c218d... - 09:40 AM Production Ticket(ST) #10984 (Ticket Resolved): YUENTUNG - Lots of customer become inactive. Please check
- 09:33 AM Production Ticket(ST) #11005 (Ticket Resolved): GoldCrest- can help us check where these 14/2/24 transaction go? for user TCW
- 09:29 AM Production Ticket(ST) #11005 (Support In Progress): GoldCrest- can help us check where these 14/2/24 transaction go? for user TCW
- 09:28 AM Production Ticket(ST) #11005 (Ticket Resolved): GoldCrest- can help us check where these 14/2/24 transaction go? for user TCW
- !WhatsApp%20Image%202024-02-20%20at%2016.31.32_8fa9c20c.jpg!
!WhatsApp%20Image%202024-02-20%20at%2016.31.33_26305752...
20/02/2024
- 06:36 PM Production Ticket(ST) #10898 (Pending Client Verification): Goldcrest-Loading for a long time
- 06:25 PM Production Ticket(ST) #10898 (Support In Progress): Goldcrest-Loading for a long time
- Find out this query logic taking long time to run :
select * from #temp_mobile_txn_stock_count l1
left join #tem... - 06:08 PM Production Ticket(ST) #10992 (Ticket Resolved): YUENTUNG - Was issue few invoice for customer and suddenly can’t search any product
- select * from product_item where org_id = 'yuentung'
select * from mst_product_price where org_id = 'yuentung'
... - 10:47 AM Production Ticket(ST) #10992 (Support In Progress): YUENTUNG - Was issue few invoice for customer and suddenly can’t search any product
- 10:41 AM Production Ticket(ST) #10992 (Ticket Resolved): YUENTUNG - Was issue few invoice for customer and suddenly can’t search any product
- - Was issue few invoice for customer and suddenly can’t search any product
- Now product also lost??? - 04:11 PM Production Ticket(ST) #11004 (Ticket Resolved): GoldCrest- and for customer 302k/141 should be no outstanding ady, but mobile keep showing outstanding inv (the yellow collection didn't update to mobile)
- !WhatsApp%20Image%202024-02-20%20at%2011.44.00_cca5bc06.jpg!
- 11:59 AM Production Ticket(ST) #10998 (Support In Progress): Daily Fresh- @~Jann Yap no salesman details in the database
- 11:54 AM Production Ticket(ST) #10998 (Ticket Resolved): Daily Fresh- @~Jann Yap no salesman details in the database
- !WhatsApp%20Image%202024-02-20%20at%2011.06.43_ba4e74d0.jpg!
19/02/2024
- 06:21 PM Production Ticket(ST) #10988: Gold Crest- and the sales order price still running for pre sales
- !WhatsApp%20Image%202024-02-19%20at%2017.19.03_90b9d264.jpg!
!WhatsApp%20Image%202024-02-19%20at%2017.19.10_2c1f27cc... - 04:56 PM Production Ticket(ST) #10988 (Ticket Resolved): Gold Crest- and the sales order price still running for pre sales
- 06:14 PM Production Ticket(ST) #10989 (Pending Client Verification): Gold Crest- Geo Fencing Report got error
- 06:07 PM Production Ticket(ST) #10989 (Support In Progress): Gold Crest- Geo Fencing Report got error
- 06:06 PM Production Ticket(ST) #10989 (Ticket Resolved): Gold Crest- Geo Fencing Report got error
- !WhatsApp%20Image%202024-02-19%20at%2016.07.08_ae63c7ff.jpg!
- 03:56 PM Production Ticket(ST) #10970 (Pending Client Verification): goldcrest- morning, can help adj the setting as yesterday this sales order we was blank when we print out
- 03:51 PM Production Ticket(ST) #10983 (Ticket Resolved): GoldCrest-hi, user TCW unable upload data
- 03:42 PM Production Ticket(ST) #10983 (Support In Progress): GoldCrest-hi, user TCW unable upload data
- 09:24 AM Production Ticket(ST) #10983 (Ticket Resolved): GoldCrest-hi, user TCW unable upload data
- !WhatsApp%20Image%202024-02-17%20at%2012.51.31_af845918.jpg!
- 02:28 PM Production Ticket(ST) #10984 (Pending Client Verification): YUENTUNG - Lots of customer become inactive. Please check
- 10:31 AM Production Ticket(ST) #10984 (Support In Progress): YUENTUNG - Lots of customer become inactive. Please check
- 10:28 AM Production Ticket(ST) #10984 (Ticket Resolved): YUENTUNG - Lots of customer become inactive. Please check
- - Lots of customer become inactive. Please check
- Beacon mart
Evergreen
Ifruit
- All inactive
- I active back f...
16/02/2024
- 06:01 PM Production Ticket(ST) #10973 (Support In Progress): GoldCrest- Hi, collection didn't reflect to datanory (Salesman Activity Report) and autocount
- 11:37 AM Production Ticket(ST) #10973 (Ticket Resolved): GoldCrest- Hi, collection didn't reflect to datanory (Salesman Activity Report) and autocount
- !WhatsApp%20Image%202024-02-16%20at%2010.53.51_f49ddfb9.jpg!
!WhatsApp%20Image%202024-02-16%20at%2010.54.51_3cd6b3d2... - 05:58 PM Production Ticket(ST) #10970 (Support In Progress): goldcrest- morning, can help adj the setting as yesterday this sales order we was blank when we print out
- 09:53 AM Production Ticket(ST) #10970 (Ticket Resolved): goldcrest- morning, can help adj the setting as yesterday this sales order we was blank when we print out
- 05:04 PM Production Ticket(ST) #10878 (Ticket Resolved): Oromeo - Assistance Required: Data Update and Patching Requests
- 04:57 PM Production Ticket(ST) #10979 (Ticket Resolved): YUENTUNG - I search this customer code and no record
- select * from customer where org_id = 'yuentung' and customer_code = '300-D0022'
select * from mst_branch where br... - 04:49 PM Production Ticket(ST) #10979 (Support In Progress): YUENTUNG - I search this customer code and no record
- 04:03 PM Production Ticket(ST) #10979 (Ticket Resolved): YUENTUNG - I search this customer code and no record
- - 300-D0022 is not in system
- I want to use same code it is in SQL system but not in mcc system
- I search this cu...
15/02/2024
- 05:57 PM Production Ticket(ST) #10967 (Pending Client Feedback): DailyFresh- this 3 outlet we already transfer to JHB06, but why still appear in JHB04 plan call
- 05:55 PM Production Ticket(ST) #10967 (Support In Progress): DailyFresh- this 3 outlet we already transfer to JHB06, but why still appear in JHB04 plan call
- 05:54 PM Production Ticket(ST) #10967 (Ticket Resolved): DailyFresh- this 3 outlet we already transfer to JHB06, but why still appear in JHB04 plan call
- !Issue212.jpg!
- 03:15 PM Production Ticket(ST) #10965 (Ticket Resolved): DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
- 03:11 PM Production Ticket(ST) #10965 (Pending Client Verification): DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
- 02:41 PM Production Ticket(ST) #10965 (Escalated to Level 3): DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
- select login_id, password from member where org_id = 'A000003';
select* from customer where org_id = 'A000003';
... - 02:32 PM Production Ticket(ST) #10965 (Support In Progress): DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
- 02:32 PM Production Ticket(ST) #10965 (Ticket Resolved): DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
- !daily_fresh_issue.jpg!
14/02/2024
- 03:47 PM Datanory - GOLDCREST Production Ticket(ST) #10959 (Escalated to 3rd Party): Goldcrest- Hi, this 3 sales and collection didn't reflect to datanory and autocount
- 10:10 AM Datanory - GOLDCREST Production Ticket(ST) #10959 (Support In Progress): Goldcrest- Hi, this 3 sales and collection didn't reflect to datanory and autocount
- 10:09 AM Datanory - GOLDCREST Production Ticket(ST) #10959 (Ticket Resolved): Goldcrest- Hi, this 3 sales and collection didn't reflect to datanory and autocount
- !WhatsApp%20Image%202024-02-14%20at%2010.04.18_ed512a2e_today.jpg!
13/02/2024
- 10:43 AM Datanory - GOLDCREST Production Ticket(ST) #10954 (Escalated to Level 3): Gold Crest- this customer we ady approved in datanory, but autocount still unable see the SO and collection
- 10:41 AM Datanory - GOLDCREST Production Ticket(ST) #10954 (Escalated to 3rd Party): Gold Crest- this customer we ady approved in datanory, but autocount still unable see the SO and collection
- 10:13 AM Datanory - GOLDCREST Production Ticket(ST) #10954 (Support In Progress): Gold Crest- this customer we ady approved in datanory, but autocount still unable see the SO and collection
- 09:51 AM Datanory - GOLDCREST Production Ticket(ST) #10954 (Ticket Resolved): Gold Crest- this customer we ady approved in datanory, but autocount still unable see the SO and collection
- !WhatsApp%20Image%202024-02-13%20at%2009.40.55_9cd24818.jpg!
08/02/2024
- 05:33 PM Datanory - SNEKKU Production Ticket(ST) #10924 (Escalated to 3rd Party): Snekku- hi @Azhar13, got remark but SO in, remark disappear, please assist SOMS6000166
- 03:29 PM Production Ticket(ST) #10934 (Ticket Resolved): Gold Crest-hi jann, all the outlet latitude longitude my salesman set cant shown in report ;when we check back the customer details the location change back 0.0
- 03:13 PM Production Ticket(ST) #10934 (Support In Progress): Gold Crest-hi jann, all the outlet latitude longitude my salesman set cant shown in report ;when we check back the customer details the location change back 0.0
- 02:55 PM Production Ticket(ST) #10949 (Ticket Resolved): Snekku- Hi @Azhar13 ,add new compny announcement, but not exsit
- 11:45 AM Production Ticket(ST) #10949 (Pending Client Feedback): Snekku- Hi @Azhar13 ,add new compny announcement, but not exsit
- 11:43 AM Production Ticket(ST) #10949 (Support In Progress): Snekku- Hi @Azhar13 ,add new compny announcement, but not exsit
- 11:43 AM Production Ticket(ST) #10949 (Ticket Resolved): Snekku- Hi @Azhar13 ,add new compny announcement, but not exsit
- 02:35 PM Datanory - SNEKKU Production Ticket(ST) #10950 (Escalated to Level 3): Snekku-Hi, please assist as keep lag here ya
- 02:31 PM Datanory - SNEKKU Production Ticket(ST) #10950 (Support In Progress): Snekku-Hi, please assist as keep lag here ya
- 02:31 PM Datanory - SNEKKU Production Ticket(ST) #10950 (Ticket Resolved): Snekku-Hi, please assist as keep lag here ya
-
!WhatsApp%20Image%202024-02-07%20at%2020.36.57_9b647e71.jpg!
- 11:03 AM Production Ticket(ST) #10948 (Escalated to 3rd Party): PrimaAsia - Suggest Order Quantity Formula Issue
- 11:00 AM Production Ticket(ST) #10948 (Support In Progress): PrimaAsia - Suggest Order Quantity Formula Issue
- 10:51 AM Production Ticket(ST) #10948 (Ticket Resolved): PrimaAsia - Suggest Order Quantity Formula Issue
- 10:03 AM Production Ticket(ST) #10896 (Ticket Resolved): Daily fresh- @~Jann Yap my supervisor highlighted that can do negative invoice transaction I remember we discussed earlier to block this function But how come those salesman can still create the negative amount issue
07/02/2024
- 04:53 PM Production Ticket(ST) #10896 (Support In Progress): Daily fresh- @~Jann Yap my supervisor highlighted that can do negative invoice transaction I remember we discussed earlier to block this function But how come those salesman can still create the negative amount issue
- 03:20 PM Production Ticket(ST) #10935 (Ticket Resolved): Gold Crest- 301r/093 new customer create by customer, ady approved at datanory
- !WhatsApp%20Image%202024-02-07%20at%2014.14.52.jpeg!
- 03:02 PM Production Ticket(ST) #10935 (Support In Progress): Gold Crest- 301r/093 new customer create by customer, ady approved at datanory
- 02:40 PM Production Ticket(ST) #10935 (Ticket Resolved): Gold Crest- 301r/093 new customer create by customer, ady approved at datanory
- !WhatsApp%20Image%202024-02-07%20at%2013.22.45.jpeg!
!WhatsApp%20Image%202024-02-07%20at%2013.22.46%20%281%29.jpeg!
... - 02:43 PM Production Ticket(ST) #10923 (Ticket Resolved): Snekku- please assist as user MS, MS0 cannot on behalf MS9
- 11:48 AM Production Ticket(ST) #10923 (Support In Progress): Snekku- please assist as user MS, MS0 cannot on behalf MS9
- 12:39 PM Datanory - SNEKKU Production Ticket(ST) #10930 (Escalated to Level 3): Snekku- hi @Azhar13 @Assyafiq MCC please assist urgently, as some of sales order got double items
- SELECT * FROM txn_sales_order_header WHERE order_no LIKE '%SOMS6000173%'
-- b9dae08e-9058-484c-bb51-2cb0793c2edd (Or... - 10:24 AM Datanory - SNEKKU Production Ticket(ST) #10930 (Support In Progress): Snekku- hi @Azhar13 @Assyafiq MCC please assist urgently, as some of sales order got double items
- 10:23 AM Datanory - SNEKKU Production Ticket(ST) #10930 (Ticket Resolved): Snekku- hi @Azhar13 @Assyafiq MCC please assist urgently, as some of sales order got double items
- !WhatsApp Image 2024-02-07 at 08.46.18.jpeg!
- 11:21 AM Production Ticket(ST) #10934 (Ticket Resolved): Gold Crest-hi jann, all the outlet latitude longitude my salesman set cant shown in report ;when we check back the customer details the location change back 0.0
- !WhatsApp%20Image%202024-02-07%20at%2010.05.35.jpeg!
- 11:07 AM Datanory - SNEKKU Production Ticket(ST) #10924 (Escalated to Level 3): Snekku- hi @Azhar13, got remark but SO in, remark disappear, please assist SOMS6000166
- 10:57 AM Datanory - SNEKKU Production Ticket(ST) #10924 (Support In Progress): Snekku- hi @Azhar13, got remark but SO in, remark disappear, please assist SOMS6000166
06/02/2024
- 06:18 PM Production Ticket(ST) #10922: SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- https://mccrenergy.atlassian.net/browse/RP-419
- 06:09 PM Production Ticket(ST) #10922 (Escalated to Level 3): SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- 06:04 PM Production Ticket(ST) #10922 (Support In Progress): SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- 03:33 PM Production Ticket(ST) #10922: SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- !WhatsApp%20Image%202024-02-06%20at%2007.11.39.jpeg!
- 12:01 PM Production Ticket(ST) #10922 (Ticket Resolved): SNEKKU - Hi jann, done photo upload in customer edit, but unable view back
- !WhatsApp%20Image%202024-02-06%20at%2007.11.09.jpeg!
- 04:59 PM Production Ticket(ST) #10898 (Escalate to 2nd Level Support): Goldcrest-Loading for a long time
- 04:57 PM Production Ticket(ST) #10898 (Support In Progress): Goldcrest-Loading for a long time
- 03:46 PM Production Ticket(ST) #10921 (Escalated to Level 3): Snekku- History derail blank - MO
- 03:42 PM Production Ticket(ST) #10921 (Support In Progress): Snekku- History derail blank - MO
- 11:33 AM Production Ticket(ST) #10921 (Ticket Resolved): Snekku- History derail blank - MO
- !WhatsApp%20Image%202024-02-01%20at%2009.43.19%281%29.jpeg!
- 02:40 PM Datanory - SNEKKU Production Ticket(ST) #10924 (Ticket Resolved): Snekku- hi @Azhar13, got remark but SO in, remark disappear, please assist SOMS6000166
- !WhatsApp%20Image%202024-02-06%20at%2010.02.15.jpeg!
- 02:04 PM Production Ticket(ST) #10920 (Ticket Resolved): Goldcrest- price code cant choose
- 11:30 AM Production Ticket(ST) #10920 (Support In Progress): Goldcrest- price code cant choose
- 11:14 AM Production Ticket(ST) #10920 (Ticket Resolved): Goldcrest- price code cant choose
- 01:56 PM Production Ticket(ST) #10923 (Ticket Resolved): Snekku- please assist as user MS, MS0 cannot on behalf MS9
05/02/2024
- 05:19 PM Production Ticket(ST) #10896: Daily fresh- @~Jann Yap my supervisor highlighted that can do negative invoice transaction I remember we discussed earlier to block this function But how come those salesman can still create the negative amount issue
- !WhatsApp%20Image%202024-02-01%20at%2009.43.19%281%29.jpeg!
- 05:17 PM Production Ticket(ST) #10905 (Pending Client Verification): GoldCrest- And this debtor code didn't shown at datanory
- 05:14 PM Production Ticket(ST) #10905 (Support In Progress): GoldCrest- And this debtor code didn't shown at datanory
- 05:04 PM Production Ticket(ST) #10900 (Pending Client Verification): GoldCrest-this invoice same issue, they should no outstanding balance ady
- 04:54 PM Production Ticket(ST) #10900 (Support In Progress): GoldCrest-this invoice same issue, they should no outstanding balance ady
- 04:51 PM Datanory - GOLDCREST Production Ticket(ST) #10897 (Escalated to Level 3): Goldcrest- this collection rm202 didnt reflect to phone
- 12:32 PM Datanory - GOLDCREST Production Ticket(ST) #10897 (Support In Progress): Goldcrest- this collection rm202 didnt reflect to phone
- 04:46 PM Production Ticket(ST) #10904 (Escalated to Level 3): GoldCrest- this also, why the total amount will change when we generate into sales order?
- 03:34 PM Production Ticket(ST) #10904 (Support In Progress): GoldCrest- this also, why the total amount will change when we generate into sales order?
- 04:39 PM Production Ticket(ST) #10878 (Pending Client Verification): Oromeo - Assistance Required: Data Update and Patching Requests
- Remove customer Lotus”s double quotes and replace with 1 quotes only.
select *
from customer
where org_id = 'oro... - 03:33 PM Production Ticket(ST) #10899 (Pending Client Verification): goldcrest- for trial version, not allowed me change price code
- 03:14 PM Production Ticket(ST) #10899 (Support In Progress): goldcrest- for trial version, not allowed me change price code
- 03:08 PM Datanory - GOLDCREST Production Ticket(ST) #10913 (Pending Client Verification): GoldCrest-this debtor until now didnt shown in datanory, may i ask whats the reason?
- 03:05 PM Datanory - GOLDCREST Production Ticket(ST) #10913 (Support In Progress): GoldCrest-this debtor until now didnt shown in datanory, may i ask whats the reason?
- 11:50 AM Datanory - GOLDCREST Production Ticket(ST) #10913 (Ticket Resolved): GoldCrest-this debtor until now didnt shown in datanory, may i ask whats the reason?
- !WhatsApp%20Image%202024-02-05%20at%2010.09.56.jpeg!
- 12:40 PM Production Ticket(ST) #10869 (Escalate to 2nd Level Support): Snekku- Hi, got key in stock count for MR DIY, but report stock count history empty, please assist
- 10:49 AM Production Ticket(ST) #10869 (Support In Progress): Snekku- Hi, got key in stock count for MR DIY, but report stock count history empty, please assist
- 10:48 AM Production Ticket(ST) #10892 (Escalated to Level 3): Snekku- Hi @Assyafiq MCC ,please assist, as done upload, but system no exist
- Pending azhar to log into Jira for subject : "User able to edit their transactions after complete upload"
- 09:55 AM Production Ticket(ST) #10892 (Pending Client Verification): Snekku- Hi @Assyafiq MCC ,please assist, as done upload, but system no exist
- 10:40 AM Production Ticket(ST) #10861 (Pending Client Verification): Snekku- Hi @Assyafiq MCC, some outlets repeat in planned route, please assist, thanks
- 10:39 AM Datanory - SNEKKU Production Ticket(ST) #10895 (Pending Client Verification): Snekku- Hi, some of customers history empty
- select * from customer where org_id ='snekku' and customer_code like '%0T001%' order by customer_code
select b.custo... - 10:36 AM Datanory - SNEKKU Production Ticket(ST) #10895 (Support In Progress): Snekku- Hi, some of customers history empty
02/02/2024
- 06:16 PM Production Ticket(ST) #10905 (Ticket Resolved): GoldCrest- And this debtor code didn't shown at datanory
- !WhatsApp%20Image%202024-02-02%20at%2013.46.45.jpeg!
- 06:11 PM Production Ticket(ST) #10904 (Ticket Resolved): GoldCrest- this also, why the total amount will change when we generate into sales order?
- !WhatsApp%20Image%202024-02-02%20at%2016.31.59.jpeg!
!WhatsApp%20Image%202024-02-02%20at%2016.34.08.jpeg!
- 03:25 PM Production Ticket(ST) #10900 (Ticket Resolved): GoldCrest-this invoice same issue, they should no outstanding balance ady
- !WhatsApp%20Image%202024-02-02%20at%2011.13.17.jpeg!
- 03:23 PM Production Ticket(ST) #10899 (Ticket Resolved): goldcrest- for trial version, not allowed me change price code
- 03:20 PM Production Ticket(ST) #10898 (Ticket Resolved): Goldcrest-Loading for a long time
- !WhatsApp%20Image%202024-02-01%20at%2017.07.19.jpeg!
- 03:15 PM Datanory - GOLDCREST Production Ticket(ST) #10897 (Ticket Resolved): Goldcrest- this collection rm202 didnt reflect to phone
- !WhatsApp%20Image%202024-02-02%20at%2009.49.53.jpeg!
!WhatsApp%20Image%202024-02-02%20at%2009.49.53%20%281%29.jpeg!
- 03:06 PM Production Ticket(ST) #10896 (Ticket Resolved): Daily fresh- @~Jann Yap my supervisor highlighted that can do negative invoice transaction I remember we discussed earlier to block this function But how come those salesman can still create the negative amount issue
- !WhatsApp Image 2024-02-01 at 09.43.19.jpeg!
- 02:52 PM Datanory - SNEKKU Production Ticket(ST) #10895 (Ticket Resolved): Snekku- Hi, some of customers history empty
- 10:34 AM Production Ticket(ST) #10892 (Support In Progress): Snekku- Hi @Assyafiq MCC ,please assist, as done upload, but system no exist
- 10:32 AM Production Ticket(ST) #10892 (Ticket Resolved): Snekku- Hi @Assyafiq MCC ,please assist, as done upload, but system no exist
- !WhatsApp%20Image%202024-02-01%20at%2008.46.33.jpeg!
31/01/2024
- 06:37 PM Production Ticket(ST) #10878 (Support In Progress): Oromeo - Assistance Required: Data Update and Patching Requests
- 09:41 AM Production Ticket(ST) #10878 (Ticket Resolved): Oromeo - Assistance Required: Data Update and Patching Requests
- Dear Afiq,
Based on details shared by Grace, please assist to:
1. Remove customer Lotus”s double quotes and rep... - 12:18 PM Production Ticket(ST) #10848 (Ticket Resolved): SNEKKU - Unable upload photo
- 10:53 AM Production Ticket(ST) #10857 (Pending Client Verification): Goldcrest-and why the sku price will change when go to datanory? SO pricing 50.75, become 48.72
30/01/2024
- 04:21 PM Production Ticket(ST) #10874 (Pending Client Verification): Daily Fresh-Sel17 mobile , above transactions is not capture in the database.vwe had uploaded the database too for your checking. Kindly be reminded , any update version need to be informed in the main communication channel. I just had a surprise we nee
--Check if sales order and invoice total amount tally
select * from (
select h.ord_hdr_id, h.order_no, ROUND(h....- 04:08 PM Production Ticket(ST) #10874 (Support In Progress): Daily Fresh-Sel17 mobile , above transactions is not capture in the database.vwe had uploaded the database too for your checking. Kindly be reminded , any update version need to be informed in the main communication channel. I just had a surprise we nee
- 10:46 AM Production Ticket(ST) #10874 (Ticket Resolved): Daily Fresh-Sel17 mobile , above transactions is not capture in the database.vwe had uploaded the database too for your checking. Kindly be reminded , any update version need to be informed in the main communication channel. I just had a surprise we nee
- !WhatsApp%20Image%202024-01-30%20at%2008.08.45.jpeg!
!WhatsApp%20Image%202024-01-30%20at%2008.08.36.jpeg!
29/01/2024
- 06:20 PM Production Ticket(ST) #10869 (Ticket Resolved): Snekku- Hi, got key in stock count for MR DIY, but report stock count history empty, please assist
- !WhatsApp Image 2024-01-29 at 18.00.19.jpeg!
- 02:34 PM Production Ticket(ST) #10864 (Pending Client Verification): Hi @Assyafiq MCC ,tried but unable save due to legacy customer code, region, state compulsory fill in.
- 11:30 AM Production Ticket(ST) #10864 (Pending Client Feedback): Hi @Assyafiq MCC ,tried but unable save due to legacy customer code, region, state compulsory fill in.
- 11:23 AM Production Ticket(ST) #10864 (Support In Progress): Hi @Assyafiq MCC ,tried but unable save due to legacy customer code, region, state compulsory fill in.
- 09:40 AM Production Ticket(ST) #10864 (Ticket Resolved): Hi @Assyafiq MCC ,tried but unable save due to legacy customer code, region, state compulsory fill in.
- !WhatsApp Video 2024-01-27 at 16.23.01.mp4!
!WhatsApp Image 2024-01-27 at 16.23.13.jpeg! - 02:27 PM Production Ticket(ST) #10848 (Support In Progress): SNEKKU - Unable upload photo
- 02:26 PM Production Ticket(ST) #10857 (Pending Client Feedback): Goldcrest-and why the sku price will change when go to datanory? SO pricing 50.75, become 48.72
- 02:11 PM Production Ticket(ST) #10857 (Support In Progress): Goldcrest-and why the sku price will change when go to datanory? SO pricing 50.75, become 48.72
- 02:25 PM Production Ticket(ST) #10834 (Ticket Resolved): Daily Fresh - JHR03 - the transaction exist in database but the text file missing. given excel file for the transactions list
- 02:24 PM Production Ticket(ST) #10835 (Ticket Resolved): Daily Fresh - KJG06 - text contain header data but transaction detail is missing
- 11:25 AM Production Ticket(ST) #10842 (Ticket Resolved): GOLDCREST - and rmb help me check why these 2 collections didnt reflect to our autocount? what action we should do for this case
- 11:24 AM Production Ticket(ST) #10842 (Support In Progress): GOLDCREST - and rmb help me check why these 2 collections didnt reflect to our autocount? what action we should do for this case
26/01/2024
- 06:59 PM Production Ticket(ST) #10861 (Support In Progress): Snekku- Hi @Assyafiq MCC, some outlets repeat in planned route, please assist, thanks
- 04:40 PM Production Ticket(ST) #10861 (Ticket Resolved): Snekku- Hi @Assyafiq MCC, some outlets repeat in planned route, please assist, thanks
- !WhatsApp Image 2024-01-26 at 16.20.15 (1).jpeg!
- 03:46 PM Production Ticket(ST) #10857 (Ticket Resolved): Goldcrest-and why the sku price will change when go to datanory? SO pricing 50.75, become 48.72
- !WhatsApp Image 2024-01-26 at 14.53.00 (1).jpeg!
!WhatsApp Image 2024-01-26 at 14.53.00.jpeg! - 03:31 PM Production Ticket(ST) #10846 (Escalated to Level 3): SNEKKU - Unplanned route will shown unploaded everyday if got do transaction in 1 day?
- 03:05 PM Production Ticket(ST) #10846 (Support In Progress): SNEKKU - Unplanned route will shown unploaded everyday if got do transaction in 1 day?
- 09:27 AM Production Ticket(ST) #10846 (Ticket Resolved): SNEKKU - Unplanned route will shown unploaded everyday if got do transaction in 1 day?
- !WhatsApp%20Image%202024-01-11%20at%2017.50.20_bd861930.jpg!
!WhatsApp%20Image%202024-01-11%20at%2017.50.37_afc950db... - 03:14 PM Production Ticket(ST) #10856 (Escalated to Level 3): SNEKKU - check out time add in geo fencing report, thanks
- Escalated to product team : https://mccrenergy.atlassian.net/browse/RP-416?atlOrigin=eyJpIjoiY2NlNTUwZTJkNzhjNDdhODll...
- 03:03 PM Production Ticket(ST) #10856 (Support In Progress): SNEKKU - check out time add in geo fencing report, thanks
- 11:52 AM Production Ticket(ST) #10856: SNEKKU - check out time add in geo fencing report, thanks
- Hi Azhar, please log into Jira and let product team modify the report. Do update the status in issue list.
- 11:51 AM Production Ticket(ST) #10856 (Ticket Resolved): SNEKKU - check out time add in geo fencing report, thanks
- 11:48 AM Production Ticket(ST) #10847 (Escalated to Level 3): SNEKKU - Customer photo and location not update datanory when perform in mobile
- 11:15 AM Production Ticket(ST) #10847 (Support In Progress): SNEKKU - Customer photo and location not update datanory when perform in mobile
- 09:28 AM Production Ticket(ST) #10847 (Ticket Resolved): SNEKKU - Customer photo and location not update datanory when perform in mobile
- !WhatsApp%20Image%202024-01-25%20at%2011.22.21_61310b8a.jpg!
- 11:14 AM Production Ticket(ST) #10849 (Pending Client Verification): SNEKKU - please assist check as not the SO# SOMC3000041 - 46 - 47
- 10:04 AM Production Ticket(ST) #10849 (Support In Progress): SNEKKU - please assist check as not the SO# SOMC3000041 - 46 - 47
- 09:29 AM Production Ticket(ST) #10849 (Ticket Resolved): SNEKKU - please assist check as not the SO# SOMC3000041 - 46 - 47
- hi miss t, is it SO number jumping?. noted on this escalation, we will check
yes, unable find in web also - 11:03 AM Production Ticket(ST) #10848 (Pending Client Feedback): SNEKKU - Unable upload photo
- 11:02 AM Production Ticket(ST) #10848 (Support In Progress): SNEKKU - Unable upload photo
- 09:29 AM Production Ticket(ST) #10848 (Ticket Resolved): SNEKKU - Unable upload photo
- 10:37 AM Production Ticket(ST) #10850 (Pending Client Verification): SNEKKU - please remove this ya as mysoft just 1 only
Backup all four table has been done:
_customer_to_user_relation20240126_
_mst_customer_contact_address20240126_
...- 10:05 AM Production Ticket(ST) #10850 (Support In Progress): SNEKKU - please remove this ya as mysoft just 1 only
- 09:34 AM Production Ticket(ST) #10850: SNEKKU - please remove this ya as mysoft just 1 only
- Assign to Azhar to delete this 2 customer from datanory. Reason to delete, customer has remove in mysoft buy our inte...
- 09:31 AM Production Ticket(ST) #10850: SNEKKU - please remove this ya as mysoft just 1 only
- !WhatsApp%20Image%202024-01-25%20at%2014.42.32_cf8fc456.jpg!
- 09:31 AM Production Ticket(ST) #10850 (Ticket Resolved): SNEKKU - please remove this ya as mysoft just 1 only
- !WhatsApp%20Image%202024-01-25%20at%2014.24.32_4f3f0ffa.jpg!
Also available in: Atom