Třídová akce

Popis:

Kontrola uzávěrky Kontrola existence vazby z řádku účtenky na řádek skladového dokladu. Když nevrátí nic, je test OK.

Kód:

8

Tělo:

SELECT *
FROM
(
 SELECT
  max(ST.Code || ' ' || ST.Name) as Store,
  max(SC.Code || ' ' || SC.Name) as StoreCard,
  sum(PD2.Quantity/PD2.UnitRate) as Quantity,
  max(PD2.QUnit) as QUnit
 FROM POSDocuments PD
 JOIN POSDocuments2 PD2 ON PD2.Parent_ID = PD.ID
 JOIN Stores ST ON ST.ID=PD2.Store_ID
 JOIN StoreCards SC ON SC.ID=PD2.StoreCard_ID
 WHERE
  PD.PosSummaredDocument_ID=:PSD_ID and
  PD.InventoryShortFall_ID is null and
  PD.InvOverPlus_ID is null and
  PD2.StoreDocumentRow_ID IS NULL AND
  PD.IsOnline = 'A' AND
  PD2.Quantity <> 0
 GROUP BY
  PD2.Store_ID, PD2.StoreCard_ID, PD2.QUnit
) A
WHERE
 A.Quantity <> 0

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