| Název | Popis | Třída |
|---|
| VATSummaryPayments | Procedura vybere DPH údaje z plateb.
Placené doklady, které mají spočtenu DPH z platby, jsou 01,02,03,60,04,61,63,65.
Placené doklady, které nemají spočtenu DPH z plateb, DZV 62, DZP 63, JSD 12, DRC RC.
Pokladní doklady 05,06,07,08 nemohou mít platbu, stejně tak doklady POSu.
| Procedures |
BEGIN
SELECT Code FROM Countries WHERE ID = :AVATCountry_ID INTO :mVATCountryCode;
IF (mVATCountryCode is NULL) THEN
BEGIN
SELECT Min(C.Code) FROM Globdata G JOIN Countries C ON C.ID = G.Country_ID INTO :mVATCountryCode;
END
/* DPH z plateb je jen v SK a CH */
IF ((mVATCountryCode = 'SK') OR (mVATCountryCode = 'CH')) THEN
BEGIN
FOR
SELECT
A.VATIndex_ID,
SUM(A.LocalTAmountWithoutVAT),
SUM(A.LocalTAmount),
SUM(A.TAmountWithoutVAT),
SUM(A.TAmount)
FROM
VATSummaryPayments(:AFirmSelID, :ADivisionsSelID, :ABusOrdersSelID,
:ABusTransactionsSelID, :ABusProjectsSelID, :AVATDateFrom, :AVATDateTo, :ADivisionsWithChilds,
:ABusOrdersWithChilds, :ABusTransactionsWithChilds, :ABusProjectsWithChilds, :AVATCountry_ID, 'N') A
WHERE
A.VATIndex_ID IS NOT NULL
GROUP BY
A.VATIndex_ID
INTO
:VATIndex_ID, :TAmountWithoutVAT, :TAmount, :ForeignTAmountWithoutVAT, :ForeignTAmount
DO BEGIN
SUSPEND;
END
END
END;