Commercialinvoice

Report CommercialInvoice

• Filename: CommercialInvoice
• Title: Commercial invoice
• Sample: Unit215 (form215)

Synopsis

Commercial invoice.

SQL

With INVDATA AS (
     SELECT
       B.InvoiceNumber,
       B.ItemDescription,
       B.HSCode,
       B.COO,
       CAST (B.QUANTITY AS NUMERIC (18, 0)) AS QUANTITY,
       cast (RowValue as Numeric (18, 2)) as RowValue1,
       CAST (cast (B.QUANTITY as float) * isnull(X.WEIGHT, 0) AS float) as RWeight,
       isnull(A.BrWeight, 0) as BrWeight
     from
       NRW_CI A
       INNER JOIN NRW_CI_DET B ON (A.INVOICENUMBER = B.INVOICENUMBER)
       LEFT JOIN ARTICLE X ON (X.NAME = 'NW' + B.ITEMCODE)
     where
       A.INVOICENUMBER in (:IDS)
)

 Select
   InvoiceNumber,
   ItemDescription,
   HSCode,
   COO,
   sum(RowValue1) as RowValue1,
   sum(RWeight) as RWeight,
   SUM(QUANTITY) AS QUANTITY,
   BrWeight
 FROM
   INVDATA
 GROUP BY
   InvoiceNumber,
   ItemDescription,
   HSCode,
   COO,
   BrWeight
 ORDER BY
   InvoiceNumber,
   HSCode ASC

Parameters

• IDS Macro with comma separated list of IDs.

Accessible in forms

• PrintCommercialInvoice