1. Issue Description (Current behaviour and expected behaviour):
This case is with reference to customer case 5925.
Users at XXXXX are facing difficulties in doing reconciliation of Payments between Link and Jiwa as these are created in Multiple Cash Book Receipt batches. We had given the below query for verification of batch numbers but this is too technical for the end users. They don't have access to database to run this for their reconciliation. Therefore need a report in Linksoft where users can identify these cash books receipt batches. The Report should have the following filters: Date From
Date To
Shift From
Shift To
Batch Number
Remit Number
---------------------- declare @shiftid varchar(50) = 'SVSH0000003440'
DECLARE @Results TABLE ( BatchNo VARCHAR(50) ,RemitNo VARCHAR(50) ,HomeAmount DECIMAL(12,2) ) DECLARE @SalesOrderNo VARCHAR(50)
INSERT INTO @Results(BatchNo,RemitNo,HomeAmount) select h.BatchNo, d.RemitNo, d.HomeAmount FROM CB_BatchTrans h JOIN CB_BatchTranLines d ON h.CBBatchID = d.CBBatchID where d.RemitNo like '%' + @shiftid + '%'
select @SalesOrderNo = m.InvoiceNo from SO_MAIN m WHERE m.OrderNo like '%' + @shiftid + '%'
INSERT INTO @Results(BatchNo,RemitNo,HomeAmount) select h.BatchNo, d.RemitNo, d.HomeAmount FROM CB_BatchTrans h JOIN CB_BatchTranLines d ON h.CBBatchID = d.CBBatchID where d.RemitNo like '%' + @SalesOrderNo + '%'
SELECT * FROM @Results
2. Environment Details: (Application version and Patch and any other information that will help identify the issue
Client Application version details:
LINKSOFT - 8.11 JIWA - 6.5.13 3. Next Step
- Customer support will assist with resolving the issue and will contact you within the next working day.
- If the issue requires immediate attention, please call our office on: 3382136.
4. TO BE COMPLETED CLOSING THE CASE Has the problem been solved?:
Has the final solution review been done with the customer? (Yes/No)
Notes from discussion with customer: |