Zenman has built our reputation around developing and perfecting responsive web solutions for our clients. Responsive web design delivers a consistent experience across desktop and mobile devices which helps to keep branding and messaging consistent. Building a site that will respond regardless of device or screen size improves your business’s SEO immensely. In fact, Google now favorably ranks sites that are mobile-friendly. Zenman’s clients have all seen a marked improvement in both lead quality and conversion since upgrading to a responsive site.

At Zenman we work hard to be innovators in the world of web design and development. We keep informed about web trends and pitch innovative features to our clients based on their industry and the desired functionality they would like to see. Your website’s content matters not only for SEO purposes but also for your potential customers. Our content team works to capture the essence of your brand and the products or services you offer, crafting effective messaging that will captivate and convert your site’s visitors.


The Zen Mission
Zenman offers our clients a balance of left- and right-brain thinking, matching data-driven goals with intuitive designs that deliver rich experiences. We provide a wide range of digital services that will help you grow your business.

The Zenman team is a tight-knit creative crew that dedicates ourselves wholly to each and every client, and the results speak for themselves. Our vastly different backgrounds and experiences mix to create a truly unique experience for our clients and their customers.



SELECT     [SYS. No.], [PART NUMBERS], DESCRIPTION, [STOCK TYPE], UOM, WEIGHT, (ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'PURCHASE_RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'JOB_RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'RECEIVE_HO')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    address_book ON finish_head_2.vendor_id = address_book.id LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND 
                                                    (finish_head_2.book = 'ISSUE_BRANCH') AND (finish_head_2.final_close = '-') AND (finish_detail_2.grp_no = [SYS. No.])
                              GROUP BY address_book.a_c_group
                              HAVING      (address_book.a_c_group = 'COMPANY')), 0) + ISNULL
                          ((SELECT     SUM(Job_Detail.qty) AS Expr1
                              FROM         Job_Mst LEFT OUTER JOIN
                                                    Job_Detail ON Job_Mst.id = Job_Detail.mst_id
                              WHERE     (Job_Mst.gen_no = [SYS. No.]) AND
                                                        ((SELECT     COUNT(id) AS Expr1
                                                            FROM         Job_Complete
                                                            WHERE     (job_no = Job_Mst.no)) = 0) AND (Job_Detail.stage_no = 1) AND (Job_Mst.start_date >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (Job_Mst.start_date <= CONVERT(DATETIME, @old_end_dt, 103))), 0)) - (ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'ISSUE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'ISSUE_HO')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'JOB_ISSUE')), 0)) AS [STK.QTY.]
FROM         Stock_Entry_Grp_No
WHERE     (dt >= CONVERT(DATETIME, @start_dt, 103)) AND (dt <= CONVERT(DATETIME, @end_dt, 103))Zenman has built our reputation around developing and perfecting responsive web solutions for our clients. Responsive web design delivers a consistent experience across desktop and mobile devices which helps to keep branding and messaging consistent. Building a site that will respond regardless of device or screen size improves your business’s SEO immensely. In fact, Google now favorably ranks sites that are mobile-friendly. Zenman’s clients have all seen a marked improvement in both lead quality and conversion since upgrading to a responsive site.

At Zenman we work hard to be innovators in the world of web design and development. We keep informed about web trends and pitch innovative features to our clients based on their industry and the desired functionality they would like to see. Your website’s content matters not only for SEO purposes but also for your potential customers. Our content team works to capture the essence of your brand and the products or services you offer, crafting effective messaging that will captivate and convert your site’s visitors.


The Zen Mission
Zenman offers our clients a balance of left- and right-brain thinking, matching data-driven goals with intuitive designs that deliver rich experiences. We provide a wide range of digital services that will help you grow your business.

The Zenman team is a tight-knit creative crew that dedicates ourselves wholly to each and every client, and the results speak for themselves. Our vastly different backgrounds and experiences mix to create a truly unique experience for our clients and their customers.



SELECT     [SYS. No.], [PART NUMBERS], DESCRIPTION, [STOCK TYPE], UOM, WEIGHT, (ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'PURCHASE_RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'JOB_RECEIVE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'RECEIVE_HO')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    address_book ON finish_head_2.vendor_id = address_book.id LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND 
                                                    (finish_head_2.book = 'ISSUE_BRANCH') AND (finish_head_2.final_close = '-') AND (finish_detail_2.grp_no = [SYS. No.])
                              GROUP BY address_book.a_c_group
                              HAVING      (address_book.a_c_group = 'COMPANY')), 0) + ISNULL
                          ((SELECT     SUM(Job_Detail.qty) AS Expr1
                              FROM         Job_Mst LEFT OUTER JOIN
                                                    Job_Detail ON Job_Mst.id = Job_Detail.mst_id
                              WHERE     (Job_Mst.gen_no = [SYS. No.]) AND
                                                        ((SELECT     COUNT(id) AS Expr1
                                                            FROM         Job_Complete
                                                            WHERE     (job_no = Job_Mst.no)) = 0) AND (Job_Detail.stage_no = 1) AND (Job_Mst.start_date >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (Job_Mst.start_date <= CONVERT(DATETIME, @old_end_dt, 103))), 0)) - (ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'ISSUE')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'ISSUE_HO')), 0) + ISNULL
                          ((SELECT     SUM(finish_detail_2.qty) AS Expr1
                              FROM         finish_head AS finish_head_2 LEFT OUTER JOIN
                                                    finish_detail AS finish_detail_2 ON finish_head_2.id = finish_detail_2.finish_id
                              WHERE     (finish_detail_2.grp_no = [SYS. No.]) AND (finish_head_2.dt >= CONVERT(DATETIME, @old_start_dt, 103)) AND 
                                                    (finish_head_2.dt <= CONVERT(DATETIME, @old_end_dt, 103)) AND (finish_head_2.book = 'JOB_ISSUE')), 0)) AS [STK.QTY.]
FROM         Stock_Entry_Grp_No
WHERE     (dt >= CONVERT(DATETIME, @start_dt, 103)) AND (dt <= CONVERT(DATETIME, @end_dt, 103)