Inventory & Financial Management System for Distribution Business
CREATE & DEFINE:
- Area
- Sale Office
- Customer
- Supplier
- Main Products
- Group Products
- Product Specification
- Chart of Account Heads
- Sale Office Targets
MAINTAIN TRANSACTIONS & RECORDS :
- Sale Order
- Sale Invoice
- Sale Voucher
- Purchase Order
- Purchase Invoice
- Purchase Voucher
- Cash Received Voucher
- Cash Payment Voucher
- Bank Payment Voucher
- Bank Received Voucher
- Journal Voucher
- Cheque Book Record ( Cleared & Uncleared )
REPORTS :
ORDER PRINT, INVOICE PRINT, VOUCHER PRINT, INVENTORY REPORTS, ACCOUNTING REPORTS, ETC
USE [UMS202122]
ReplyDeleteGO
/****** Object: View [dbo].[vwOrderSheet_Print] Script Date: 29/03/2021 3:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER view [dbo].[vwOrderSheet_Print] as
Select SR, max(Code_01) Code_01 ,max(Name_01) Name_01,max(Rate_01) as Rate_01,max(Code_02) as Code_02,max(Name_02) as Name_02,max(Rate_02) as Rate_02,max(Code_03) as Code_03,max(Name_03) as Name_03,max(Rate_03) as Rate_03,max(Code_04) as Code_04,max(Name_04) as Name_04,max(Rate_04) as Rate_04
From
(
Select right({fn concat('0000000'+ cast( ROW_NUMBER() OVER(ORDER BY Code_01 ASC) as varchar (10)),'' )},3) AS SR, '01' as Link,Code_01,Name_01,Rate_01,Code_02,Name_02,Rate_02,Code_03,Name_03,Rate_03,Code_04,Name_04,Rate_04
From
(
select item_Code as Code_01,description as Name_01,sale_rate as Rate_01 ,'' Code_02,'' as Name_02,'' as Rate_02,'' Code_03,'' as Name_03,'' as Rate_03,'' Code_04,'' as Name_04,'' as Rate_04
from item order by item_code
OFFSET 0 ROWS FETCH NEXT 80 ROWS ONLY
) a1
UNION ALL
Select right({fn concat('0000000'+ cast( ROW_NUMBER() OVER(ORDER BY Code_01 ASC) as varchar (10)),'' )},3) AS SR,'01' as Link, Code_01,Name_01,Rate_01,Code_02,Name_02,Rate_02 ,Code_03,Name_03,Rate_03,Code_04,Name_04,Rate_04
From
(
select '' Code_01,'' Name_01,'' Rate_01,item_Code as Code_02,description as Name_02,sale_rate as rate_02 ,'' Code_03,'' as Name_03,'' as Rate_03,'' Code_04,'' as Name_04,'' as Rate_04
from item order by item_code
OFFSET 80 ROWS FETCH NEXT 80 ROWS ONLY
) as a2
UNION ALL
Select right({fn concat('0000000'+ cast( ROW_NUMBER() OVER(ORDER BY Code_01 ASC) as varchar (10)),'' )},3) AS SR,'01' as Link, Code_01,Name_01,Rate_01,Code_02,Name_02,Rate_02 ,Code_03,Name_03,Rate_03,Code_04,Name_04,Rate_04
From
(
select '' Code_01,'' Name_01,'' Rate_01 ,'' Code_02,'' as Name_02,'' as Rate_02,item_Code as Code_03,description as Name_03,sale_rate as rate_03,'' Code_04,'' as Name_04,'' as Rate_04
from item order by item_code
OFFSET 160 ROWS FETCH NEXT 80 ROWS ONLY
) as a3
union all
Select right({fn concat('0000000'+ cast( ROW_NUMBER() OVER(ORDER BY Code_01 ASC) as varchar (10)),'' )},3) AS SR,'01' as Link, Code_01,Name_01,Rate_01,Code_02,Name_02,Rate_02 ,Code_03,Name_03,Rate_03,Code_04,Name_04,Rate_04
From
(
select '' Code_01,'' Name_01,'' Rate_01 ,'' Code_02,'' as Name_02,'' as Rate_02,'' Code_03,'' as Name_03,'' as Rate_03,item_Code as Code_04,description as Name_04,sale_rate as rate_04
from item order by item_code
OFFSET 240 ROWS FETCH NEXT 80 ROWS ONLY
) as a4
) as a
group by SR
GO