platformaerp.com

Snippety

proste zapytania faktury z pozycjami

SELECT
    dil.[invoiceLineID]
    ,di.invoicefullnr
    ,dil.[invoiceID]
    ,dil.[invoiceOrdinalNumber]
    ,dil.[itemID]
    ,wi.itemCode
    ,ISNULL(dil.[itemNameCommercialForeign], dil.[itemNameCommercial]) [itemName]
    ,dil.itemQuantity
    ,dil.netValue
    ,dil.grossValue
FROM
    [document].[invoiceLine] dil
    INNER JOIN document.invoice di on di.invoiceid = dil.invoiceid
    LEFT JOIN wms.item wi
    ON wi.itemid = dil.itemid
WHERE
    dil.status>-1
    and di.status>-1
    and di.invoiceFullNR = 'KFE00001/10/21'
ORDER BY
    dil.invoiceOrdinalNumber