Thank you for quick support.
I am a beginner in X++ coding. That's why using SP for data. My requirement is to print packing slip for a sales order . I need to pass sales id parameter to get the report.
I need to open the packing slip ssrs report on a button click in sales list(for selected sales order).
my SP
GO
/****** Object: StoredProcedure [dbo].[Rpt_Get_Packing_Slip] Script Date: 14/09/2018 4:50:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- =============================================
ALTER PROCEDURE [dbo].[Rpt_Get_Packing_Slip]
@saledID NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON;
SELECT a.CUSTACCOUNT, b.DATAAREAID, b.SALESID, d.STANDARDCONFIGID + ' ' + d.PRODUCTTYPECODE + ' ' + e.DESCRIPTION AS DESCRIPTION, d.PRODUCTTYPECODE, d.ARTICLE_CODE, d.STANDARDCONFIGID,
SUM(b.PDSCWQTY) AS PCS, SUM(b.SALESQTY) AS GROSSWT, SUM(c.QTY) AS NETWT, SUM(c.PUREQTY) AS PUREQTY, SUM(b.SALESQTY) - SUM(c.QTY) AS STONE, SUM(c.PUREQTY) / SUM(c.QTY) AS PURITY,
SUM(b.LINEAMOUNT) AS TOTALVALUE, SUM(b.MKVALUE) AS MAKINGVALUE, SUM(b.LINEAMOUNT) - SUM(b.MKVALUE) AS GOLDANDSTONEVALUE
FROM SALESLINEINGREDIENT AS c INNER JOIN
SALESLINE AS b ON c.SALESID = b.SALESID AND c.LINEITEMID = b.ITEMID AND c.DATAAREAID = b.DATAAREAID INNER JOIN
SALESTABLE AS a ON b.SALESID = a.SALESID AND b.DATAAREAID = a.DATAAREAID INNER JOIN
INVENTTABLE AS d ON b.ITEMID = d.ITEMID AND a.DATAAREAID = d.DATAAREAID INNER JOIN
ARTICLE_MASTER AS e ON d.ARTICLE_CODE = e.ARTICLE_CODE
WHERE (b.PARTITION = '5637144576') AND (c.PARTITION = '5637144576') AND (c.METALTYPE = 1) AND (b.SALESSTATUS IN (2, 3)) AND (a.PARTITION = '5637144576') AND (d.PARTITION = '5637144576') AND
(e.PARTITION = '5637144576')
GROUP BY b.DATAAREAID, b.SALESID, a.CUSTACCOUNT, d.ARTICLE_CODE, d.STANDARDCONFIGID, e.DESCRIPTION, d.PRODUCTTYPECODE
HAVING (b.SALESID = @saledID)
ORDER BY b.DATAAREAID, b.SALESID
END
