1 2 3 4 5 6 7 8 9 10
|
SELECT FilteredInvoiceDetail.invoiceid,
dbo.FN_DECIMAL_EN_CHIFFRE(ROUND(SUM(FilteredInvoiceDetail.quantity * FilteredInvoiceDetail.priceperunit * FilteredProduct.TVA_INT / 100),
2) + ROUND((FilteredInvoice.totalamount)-FilteredInvoice.A, 2), 'dinars', 'et', 'centimes') AS ttc_chiffre
FROM FilteredInvoiceDetail LEFT OUTER JOIN
FilteredProduct ON FilteredInvoiceDetail.productid = FilteredProduct.ProductId CROSS JOIN
FilteredInvoice
--WHERE (FilteredInvoiceDetail.invoiceid = @CRM_QuoteId)
GROUP BY FilteredInvoiceDetail.invoiceid, FilteredInvoice.DiscountPercentage, FilteredInvoice.TotalAmount, FilteredInvoice.A |
Partager