Ask Your Question

Revision history  [back]

Revision 9
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2019-01-07 08:37:02 +0200

يمكنك استعمال الاستعلام التالي لحصر السندات التي بها فروقات 

select originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 8
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-07 04:02:15 +0200





يمكنك استعمال الاستعلام التالي لحصر السندات التي بها فروقات 

select elect originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 7
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-07 04:01:43 +0200





يمكنك مكنك استعمال الاستعلام التالي لحصر السندات التي بها فروقات 

elect originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 6
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-06 06:13:01 +0200





مكنك استعمال الاستعلام التالي لحصر السندات التي بها فروقات Please, refer to Reprocessing Transactions guide.
Use the following query

elect originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 5
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-06 06:12:20 +0200





Please, refer to Reprocessing Transactions guide.guide
Use the following query

elect originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 4
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-06 05:41:48 +0200





Please, refer to Reprocessing Transactions guide
 Use the following query

elect originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 3
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-06 05:41:08 +0200






Use the following query


elect select originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 2
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-01-06 05:40:47 +0200






Use the following query


select originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate
Revision 1
Eldabbas's avatar
9.1k
Eldabbas
answered 2019-01-06 05:40:16 +0200




Use the following query


select originType,originId,originCode,valueDate,SUM(creditLocalAmount) cr,SUM(debitLocalAmount) dr from LedgerTransLine group by originType,originId,originCode,valueDate
having ABS(SUM(creditLocalAmount)-SUM(debitLocalAmount))>0.0
order by valueDate