Třídová akce

Popis:

Kontrola uzávěrky Porovná platby účtenek s platbami na souhrnné účtence. Když nevrátí nic, je test OK.

Kód:

6

Tělo:

SELECT
 max(PT.Code || ' ' || PT.Name) as PaymentType,
 sum(A.Payment) as PaymentDiff,
 max(CU.Code) as Currency,
 sum(PDPayments) as PDPayments,
 sum(PSPayments) as PSPayments 
FROM(
 select
  PD3.PaymentType_ID,
  PD3.Currency_ID,
  -(PD3.Payment - PD3.Refund) as Payment,
  (PD3.Payment - PD3.Refund) as PDPayments,
  0 as PSPayments
 FROM PosDocuments PD
 LEFT JOIN PosDocuments3 PD3 on PD3.Parent_ID = PD.ID
 WHERE PD.PosSummaredDocument_ID=:OID1
 UNION ALL
 SELECT
  PSD4.PaymentType_ID,
  PSD4.Currency_ID,
  PSD4.Payment,
  0 as PDPayments,
  PSD4.Payment as PSPayments
 FROM PosSummaredDocuments4 PSD4
 WHERE PSD4.Parent_ID=:OID2) A
JOIN PaymentTypes PT on PT.ID=A.PaymentType_ID
JOIN Currencies CU on CU.ID=A.Currency_ID
GROUP BY A.PaymentType_ID, A.Currency_ID
HAVING SUM(A.Payment)<>0

Generated by ABRA Software a.s. 27.10.2021 16:34:30