Google Analytics Google Analytics est un service utilisé sur notre site Web qui permet de suivre, de signaler le trafic et de mesurer la manière dont les utilisateurs interagissent avec le contenu de notre site Web afin de l’améliorer et de fournir de meilleurs services. | |
Notre site Web vous permet d’aimer ou de partager son contenu sur le réseau social Facebook. En l'utilisant, vous acceptez les règles de confidentialité de Facebook: https://www.facebook.com/policy/cookies/ | |
Les tweets intégrés et les services de partage de Twitter sont utilisés sur notre site Web. En activant et utilisant ceux-ci, vous acceptez la politique de confidentialité de Twitter: https://help.twitter.com/fr/rules-and-policies/twitter-cookies |
![SELECT [ITEM].[Id], [ITEM].[Id_File], [ITEM].[ExpensesType], [ITEM].[IncomesType], [ITEM].[ActivityType], [ITEM].[ItemType], [ITEM].[Unit], [ITEM].[Resale], [ITEM].[Code], [ITEM].[Title], [ITEM].[Description], [ITEM].[SaleVatRate], [ITEM].[SalePrice], [ITEM].[PurchaseVatRate], [ITEM].[PurchasePrice], [ITEM].[Stock], [ITEM].[StockMini], [ITEM].[StockMaxi], [ITEM].[StockAlarm], [ITEM].[Archived], [ITEM].[Category], [ITEM].[Location], COALESCE(ROUND([ITEM].[PurchasePrice],2), 0.00) as ItemPurchaseAmountHT, COALESCE(ROUND(CAST(CAST([ITEM].[PurchasePrice] * (1 + ([ITEM].[PurchaseVatRate]/100)) * [ITEM].[PurchaseVatRound] as integer) as float)/[ITEM].[PurchaseVatRound], 2), 0.00) as ItemPurchaseAmountTTC, ROUND(COALESCE(COALESCE(ROUND(CAST(CAST([ITEM].[PurchasePrice] * (1 + ([ITEM].[PurchaseVatRate]/100)) * [ITEM].[PurchaseVatRound] as integer) as float)/[ITEM].[PurchaseVatRound], 2), 0.00) - COALESCE(ROUND([ITEM].[PurchasePrice],2), 0.00), 0.00), 2) as ItemPurchaseAmountTVA, ROUND(COALESCE(COALESCE((SELECT SUM([SUPPLIERORDERDETAIL].[Quantity]) FROM [SUPPLIERORDERDETAIL] LEFT JOIN [SUPPLIERORDER] ON ([SUPPLIERORDERDETAIL].[Id_Order] = [SUPPLIERORDER].[Id]) WHERE [SUPPLIERORDERDETAIL].[Id_Item]=[ITEM].[Id] AND [SUPPLIERORDER].[State]=0), 0.000), 0.00), 2) as ItemPurchaseOrderPrepareTotalQuantity, ROUND(COALESCE(COALESCE((SELECT SUM([SUPPLIERORDERDETAIL].[Quantity]) FROM [SUPPLIERORDERDETAIL] LEFT JOIN [SUPPLIERORDER] ON ([SUPPLIERORDERDETAIL].[Id_Order] = [SUPPLIERORDER].[Id]) WHERE [SUPPLIERORDERDETAIL].[Id_Item]=[ITEM].[Id] AND [SUPPLIERORDER].[State]=1), 0.000) - COALESCE((SELECT SUM([SUPPLIERORDERDETAIL].[Delivered]) FROM [SUPPLIERORDERDETAIL] LEFT JOIN [SUPPLIERORDER] ON ([SUPPLIERORDERDETAIL].[Id_Order] = [SUPPLIERORDER].[Id]) WHERE [SUPPLIERORDERDETAIL].[Id_Item]=[ITEM].[Id] AND [SUPPLIERORDER].[State]=1), 0.000), 0.00), 2) as ItemPurchaseOrderToDeliverTotalQuantity, COALESCE(ROUND([ITEM].[SalePrice],2), 0.00) as ItemSaleAmountHT, COALESCE(ROUND(CAST(CAST([ITEM].[SalePrice] * (1 + ([ITEM].[SaleVatRate]/100)) * [ITEM].[SaleVatRound] as integer) as float)/[ITEM].[SaleVatRound], 2), 0.00) as ItemSaleAmountTTC, ROUND(COALESCE(COALESCE(ROUND(CAST(CAST([ITEM].[SalePrice] * (1 + ([ITEM].[SaleVatRate]/100)) * [ITEM].[SaleVatRound] as integer) as float)/[ITEM].[SaleVatRound], 2), 0.00) - COALESCE(ROUND([ITEM].[SalePrice],2), 0.00), 0.00), 2) as ItemSaleAmountTVA, ROUND(COALESCE(COALESCE((SELECT SUM([BOOKDOCUMENTDETAIL].[Quantity]) FROM [BOOKDOCUMENTDETAIL] LEFT JOIN [BOOKDOCUMENT] ON [BOOKDOCUMENT].[Id] = [BOOKDOCUMENTDETAIL].[Id_BookDocument] WHERE [BOOKDOCUMENTDETAIL].[Id_Item]=[ITEM].[Id] AND [BOOKDOCUMENT].[Close]=0 AND [BOOKDOCUMENT].[DocumentType]=2), 0.000), 0.00), 2) as ItemSaleOrderPrepareTotalQuantity, ROUND(COALESCE(COALESCE((SELECT SUM([BOOKDOCUMENTDETAIL].[Quantity]) FROM [BOOKDOCUMENTDETAIL] LEFT JOIN [BOOKDOCUMENT] ON [BOOKDOCUMENT].[Id] = [BOOKDOCUMENTDETAIL].[Id_BookDocument] WHERE [BOOKDOCUMENTDETAIL].[Id_Item]=[ITEM].[Id] AND [BOOKDOCUMENT].[Close]=0 AND [BOOKDOCUMENT].[DocumentType]=4), 0.000), 0.00), 2) as ItemSaleOrderToDeliverTotalQuantity](_media/img/large/20180425-152446.jpg)
