Production Ticket(ST) #11827
Goldcrest-Hi, 24/5/24 sales invoice report not able to generate
1) Checked the
2) run the store procedure
3) Checked the database mst_branch and member branch table
root cause- user enquiry
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Project changed from Datanory to Datanory - GOLDCREST
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
exec sp_rpt_sales_invoice_summary_report @start_date='2024-05-24 00:00:00',
@end_date='2024-05-24 00:00:00',@branch=N'45454bbc537340619b7860c58cfaf5ca,2492baa10aee4fc586582f08d5b1b97c',
@salesman=N'GOLDCREST-admin,afa9160a6eff4963b8a8bb53322f8d57,7f8c3d45b01d4b948c1372e2c5644762',@tenant_id=N'GOLDCREST',
@invoice_no=N'',@region=N'(Empty),FFCEF7F5C223420697AB2A5D098306F4',
@channel=N'(Empty),F1C729CFD20645B2A46EF476DF86984C',@customer=N''
-- as i check in the profiler the data is empty
#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
SELECT *
FROM txn_invoice_history_header
WHERE org_id = 'goldcrest'
AND created_date BETWEEN '2024-05-24 00:00:00' AND '2024-05-24 23:59:59'
and updated_by = 'afa9160a6eff4963b8a8bb53322f8d57'
there is 18 data but not shown in the report
#4 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Assigned To to Support In Progress
#5 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- File WhatsApp Image 2024-05-27 at 18.06.40_a04872c9.jpg WhatsApp Image 2024-05-27 at 18.06.40_a04872c9.jpg added
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
#6 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to User Enquiry & Clarification
- Actual Initial Response set to 28/05/2024