Коллеги,
Добрый День,
пытаюсь сделать отчёт, в Visual Studio всё выглядит хорошо,
Но Когда добавляю в СРМ некоторые поля отсутствуют, может кто нибудь знает как поправить и где я накосячил?
SQL:
Код:
SELECT TOP 3000 CRMAF_SalesOrder.name AS OrderName, CRMAF_Invoice.name AS InvoiceName, CRMAF_Invoice.new_invoicetypename AS InvoiceType, CRMAF_Invoice.new_actdate AS ActDate,
CRMAF_Invoice.statuscodename AS Status, CRMAF_SalesOrderDetail.productidname AS Product, CRMAF_SalesOrder.customeridname AS Client, CRMAF_SalesOrderDetail.baseamount AS Income,
CRMAF_Product.be_royaltyfee AS Royalty, CRMAF_Product.be_printingcostrus AS PrintingCost,
(SELECT TOP 1 extendedamount
FROM FilteredSalesOrderDetail AS deliveryitem
WHERE (productidname = 'Delivery') AND (salesorderid = CRMAF_SalesOrderDetail.salesorderid)) AS DeliveryCost,
(SELECT COUNT(salesorderid) - 1 AS OrderItemCount
FROM FilteredSalesOrderDetail AS itemcount
WHERE (salesorderid = CRMAF_SalesOrderDetail.salesorderid)) AS OrderItemCount
FROM FilteredSalesOrderDetail AS CRMAF_SalesOrderDetail LEFT JOIN
FilteredSalesOrder AS CRMAF_SalesOrder ON CRMAF_SalesOrderDetail.salesorderid = CRMAF_SalesOrder.salesorderid LEFT JOIN
FilteredInvoice AS CRMAF_Invoice ON CRMAF_Invoice.salesorderid = CRMAF_SalesOrder.salesorderid LEFT JOIN
FilteredProduct AS CRMAF_Product ON CRMAF_SalesOrderDetail.productid = CRMAF_Product.productid
WHERE (CRMAF_SalesOrderDetail.productidname != 'Delivery')
Результат:
Из Visual Studio:
https://imgshare.io/image/jKTwl
Из CRM:
https://imgshare.io/image/jKhGx